Specifications

173
APPENDIX C • DATABASE TABLE CONFIGURATION
TECHNICAL SUPPORT 978-486-0086 • [e-mail] • 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
Name Type Size
SiteNetworkNumber Number (Integer) 2
AllowZeroLength: False
Attributes: Fixed Size
Collating Order: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 2055
Decimal Places: Auto
DisplayControl: Text Box
Ordinal Position: 2
Required: True
Source Field: SiteNetworkNumber
Source Table: Site_T
HeaderText Text 50
AllowZeroLength: True
Attributes: Variable Length
Collating Order: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 3285
DisplayControl: Text Box
Ordinal Position: 3
Required: False
Source Field: HeaderText
Source Table: Site_T
Relationships
Site_TUnit_T Site_T Unit_T ID 1 • SiteID
Attributes: Enforced, Cascade Updates, Cascade Deletes
Attributes: One-To-Many