DbWrench Documentation: nrtb |
Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
ObjectRelations | (Table) |
Columns | |||||||
PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
parent | BigInt | Parent of this relationship |
|
||||
child | BigInt | child of this relationship |
|
||||
linkStart | BigInt | QuantaEvent when link was created. |
|
||||
linkEnd | BigInt | QuantaEvent when link was terminated |
|
Indexes | ||||
Name | Table | Columns | Unique | Clustered |
ObjectRelations_child_Idx | ObjectRelations | child | ||
ObjectRelations_linkEnd_Idx | ObjectRelations | linkEnd | ||
ObjectRelations_linkStart_Idx | ObjectRelations | linkStart | ||
ObjectRelations_parent_Idx | ObjectRelations | parent |
Foreign Keys | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_ObjectRelations_ObjectData_child | ObjectData | ObjectRelations | uid | child |
fk_ObjectRelations_ObjectData_parent | ObjectData | ObjectRelations | uid | parent |
fk_ObjectRelations_QuantaEvents_end | QuantaEvents | ObjectRelations | uid | linkEnd |
fk_ObjectRelations_QuantaEvents_start | QuantaEvents | ObjectRelations | uid | linkStart |
Parent Relations (none) |
Used in Diagrams |
Diagram Name |
diagramA |