Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
ContactID | INT | 10 | √ | null |
|
|
||||
LocationID | INT | 10 | null |
|
|
|||||
ClientID | INT | 10 | null |
|
|
|||||
Firstname | VARCHAR | 50 | null |
|
|
|||||
LastName | VARCHAR | 50 | null |
|
|
|||||
Address1 | VARCHAR | 50 | null |
|
|
|||||
Address2 | VARCHAR | 50 | null |
|
|
|||||
City | VARCHAR | 30 | null |
|
|
|||||
State | VARCHAR | 30 | null |
|
|
|||||
Zip | VARCHAR | 10 | null |
|
|
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
Cell | Performance | Asc | Cell |
ClientID | Performance | Asc | ClientID |
ContactID | Must be unique | Asc | ContactID |
Performance | Asc | ||
ExternalID | Performance | Asc | ExternalID |
Firstname | Performance | Asc | Firstname |
GUID | Performance | Asc | GUID |
LastName | Performance | Asc | LastName |
LocationID | Performance | Asc | LocationID |
Phone | Performance | Asc | Phone |