| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ofcs_id | int identity | 4 | √ | null |
|
|
||||||
| orgs_id | int | 4 | √ | null |
|
|
||||||
| ofc_name | nvarchar | 200 | null |
|
|
|||||||
| ofc_org_name | nvarchar | 200 | null |
|
|
|||||||
| ofc_street_addr | nvarchar | 200 | null |
|
|
|||||||
| ofc_postl_addr | nvarchar | 200 | √ | null |
|
|
||||||
| ofc_postl_code | nvarchar | 200 | √ | null |
|
|
||||||
| ofc_postl_city | nvarchar | 200 | √ | null |
|
|
||||||
| ofc_postl_c | nvarchar | 20 | √ | null |
|
|
||||||
| ofc_mail_addr | nvarchar | 200 | √ | null |
|
|