Title | prs_addresses |
---|---|
Type | Standardized |
Description | Standardized physical addresses |
Column | Format | Nullable | Description | Definition | Comments |
---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | ||
role_record_id | integer, foreign key | SOR Person this address is attached to | prs_sor_persons:id | ||
line1 | varchar(100) | Address line 1 | Should address lines 1-3 be consolidated? | ||
line2 | varchar(100) | Address line 2 | |||
line3 | varchar(100) | Address line 3 | |||
building | integer, foreign key | Building | drd_buildings:id | ||
room | varchar(20) | Room | |||
city | varchar(100) | City | |||
region_id | integer, foreign key | State / Region | ctd_regions:id | ||
country_id | integer, foreign key | Country | ctd_countries:id | ||
postal_code | varchar(20) | Postal / ZIP Code | |||
address_t | integer, foreign key | Type of this address |
| ||
verified | boolean | Whether this address has been verified by the SOR |
Migration Notes From OR 1
bldg_no
renamedbuilding
and made a foreign key ()room_no
renamedroom
()postal_code
resized ()- Most fields no longer required ()
- Added
verified
()