prs_addresses
- Benn Oshrin
Owned by Benn Oshrin
| Title | prs_addresses |
|---|---|
| Type | Standardized |
| Description | Physical addresses |
| Column | Format | Nullable? | Description | Definition | Comments |
|---|---|---|---|---|---|
| id | integer, primary key | No | |||
| role_record_id | integer, foreign key | No | SOR Role Record this address is attached to | prs_role_records:id | |
| bldg_no | varchar(10) | ||||
| room_no | varchar(11) | Room number | |||
| city | varchar(100) | No | City | ||
| line1 | varchar(100) | No | Address line 1 | ||
| line2 | varchar(100) | Address line 2 | |||
| line3 | varchar(100) | Address line 3 | |||
| region_id | integer, foreign key | Region (state, province, etc) | ctd_regions:id | ||
| postal_code | varchar(9) | Postal code | |||
| country_id | integer, foreign key | No | Country | ctd_countries:id | |
| address_t | integer, foreign key | No | Type of this address | ctx_data_types:id | data_type=ADDRESS |
| update_date | datetime | No |