Specifications

176
APPENDIX C • DATABASE TABLE CONFIGURATION
7 Beaver Brook Road, Littleton, MA 01460 • 978-486-0086 • www.burk.com
Table Indexes
Name Number of Fields
ID 1
Clustered: False
Distinct Count: 0
Foreign: False
Ignore Nulls: False
Name: ID
Primary: False
Required: False
Unique: False
Fields: ID, Ascending
PrimaryKey 1
Clustered: False
Distinct Count: 0
Foreign: False
Ignore Nulls: False
Name: PrimaryKey
Primary: True
Required: True
Unique: True
Fields: ID, Ascending
Site_TUnit_T 1
Clustered: False
Distinct Count: 0
Foreign: True
Ignore Nulls: False
Name: Site_TUnit_T
Primary: False
Required: False
Unique: False
Fields: SiteID, Ascending
Relationships
Site_TUnit_T Site_T Unit_T ID 1 SiteID
Attributes: Enforced, Cascade Updates, Cascade Deletes
Attributes: One-To-Many
Unit_TUnitRevC_T Unit_T UnitRevC_T ID 1 UnitID
Attributes: Enforced, Cascade Updates, Cascade Deletes
Attributes: One-To-Many
TABLE: UNIT_T
Unit_TUnitRevM_T Unit_T UnitRevM_T ID 1 UnitID
Attributes: Enforced, Cascade Updates, Cascade Deletes
Attributes: One-To-Many
Unit_TUnitRevS_T Unit_T UnitRevS_T ID 1 UnitID
Attributes: Enforced, Cascade Updates, Cascade Deletes
Attributes: One-To-Many