Option 1 seems like the bare minimum and something scriptable if there's a template file to work from similar to the emlassemblyline templates. Option 2 is probably good practice though too, since it's more human-readable.
- Define Relationships with attribute and attributeReference
To describe relationships between tables:
Use the attribute element to define the primary key in one table.
Use the attributeReference element in the related table to reference the foreign key.
For example:
Table1
Table1_id
Primary key
Table2
Table1_id
Foreign key referencing Table1_id in Table1
Table1_id
Table1_id
Table1
Table1_id
- Document Relationships in additionalMetadata
If the relationships are complex or not easily captured in the schema, use the additionalMetadata section to provide a narrative description of the relationships between tables.
Example:
Table A contains primary keys that are referenced by foreign keys in Table B.
Option 1 seems like the bare minimum and something scriptable if there's a template file to work from similar to the emlassemblyline templates. Option 2 is probably good practice though too, since it's more human-readable.
To describe relationships between tables:
Use the attribute element to define the primary key in one table.
Use the attributeReference element in the related table to reference the foreign key.
For example:
Table2 Table1_id Foreign key referencing Table1_id in Table1 Table1_id Table1_id Table1 Table1_idTable1
Table1_id
Primary key
- Document Relationships in additionalMetadata
Table A contains primary keys that are referenced by foreign keys in Table B.If the relationships are complex or not easily captured in the schema, use the additionalMetadata section to provide a narrative description of the relationships between tables.
Example: