Hi All, Here is my situation for writing xsd's had 3 c

Hi All,

Here is my situation for writing xsd's

had 3 cdt's

1. client - xsd created - table created
2. employee - xsd created - table created

3. pay

in this pay cdt PK of client and PK of employee are the foreign keys and they are mapped with "many to one" relationship with those 2 (means many records in pay can have single client or employee )

I already have referred forum.appian.com/.../Defining_a_Custom_Data_Type

and written xsd for pay with following annotations.

<?xml version="1.0" encoding="utf-8" ?>
<xsd:schema xmlns="urn:appian:example:assocations:many-to-one" elementFormDefault="qualified" targetNamespace="urn:appian:example:assocations:many-to-one" xmlns:xsd="www.w3.org/.../XMLSchema">

<xsd:complexType name="pay">
--
<xsd:element minOccurs="0" nillable="false" maxOccurs="unbounded" name="clientId" type="client">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@ManyToOne
                     ...

OriginalPostID-77431

OriginalPostID-77431

  Discussion posts and replies are publicly visible

Parents
  • Now i have placed
    <xsd:element name="payId_Integer" nillable="false" type="xsd:int">
    in place of integer
    <xsd:element name="payId_Integer" nillable="false" type="xsd:integer">

    and now all the 3 tables are created no problems.

    But still left with the issue,
    why
    [clientidinteger] numeric(19,0) null unique,
    [employeeidinteger] numeric(19,0) null unique,
    instead it should be
    [clientidinteger] numeric(19,0) not null unique,
    [employeeidinteger] numeric(19,0) not null unique,

    As i have given nillable false for element tag and nullable false for @Column
Reply
  • Now i have placed
    <xsd:element name="payId_Integer" nillable="false" type="xsd:int">
    in place of integer
    <xsd:element name="payId_Integer" nillable="false" type="xsd:integer">

    and now all the 3 tables are created no problems.

    But still left with the issue,
    why
    [clientidinteger] numeric(19,0) null unique,
    [employeeidinteger] numeric(19,0) null unique,
    instead it should be
    [clientidinteger] numeric(19,0) not null unique,
    [employeeidinteger] numeric(19,0) not null unique,

    As i have given nillable false for element tag and nullable false for @Column
Children
No Data