Rank: Member
Joined: 10/5/2016 Posts: 16
|
Hi I have my XSD. I am trying to convert it to tables, but the SQL code generated, does not include any key for the tables. For example:
Purchase Order is the parent node. It has it's on attributes\fields. It also has sequence of Line Items (which also as it's own attributes\fields)
When convert it to sql - the Line Items table doesn't include any reference to the parent (PO) table.
chen@segment.co.il attached the following image(s):
|
Rank: Advanced Member
Joined: 2/27/2009 Posts: 564
|
If the XML Schema from which the DB structure is generated has relationships defined in the form of identity constraints, then these relationships are automatically created in the generated DB structure and displayed in the Table Structure. Tables with relationships are listed under the sections: Tables with ForeignKeys and Tables used by ForeignKeys. Tables without relationships are listed in the Independent Tables section.
If the schema does not have relationships defined, then you, you can create and modify table relationships in the Relationships tab. The tab lists all possible primary-key/foreign-key relationships.
Please refer to the XMLSpy documentation on the Create DB Structure from XML Schema command for more.
|
Rank: Member
Joined: 10/5/2016 Posts: 16
|
thanks!
|