Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| UserName | VARCHAR | 15 |
|
|
||||||
| UserID | INT | 10 | null |
|
|
|||||
| ReportCompanyName | MEDIUMTEXT | 16777215 | √ | null |
|
|
||||
| ClientID | INT | 10 | 0 |
|
|
|||||
| ClientName | VARCHAR | 50 |
|
|
||||||
| ClientCompanyName | VARCHAR | 100 | null |
|
|
|||||
| ClientPhone | VARCHAR | 30 | null |
|
|
|||||
| ClientFax | VARCHAR | 30 | null |
|
|
|||||
| ClientAddress | VARCHAR | 102 | √ | null |
|
|
||||
| ClientLocation | VARCHAR | 52 | √ | null |
|
|
||||
| ClientZip | VARCHAR | 10 | null |
|
|
|||||
| ClientCountry | VARCHAR | 20 | null |
|
|
Relationships
Close relationships within degrees of separation
