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 | Â | Â | Â |
Â
Â