prs_addresses

Titleprs_addresses
TypeStandardized
DescriptionPhysical addresses
ColumnFormatNullable?DescriptionDefinitionComments
idinteger, primary keyNo   
role_record_idinteger, foreign keyNoSOR Role Record this address is attached toprs_role_records:id 
bldg_novarchar(10)    
room_novarchar(11) Room number  
cityvarchar(100)NoCity  
line1varchar(100)NoAddress line 1  
line2varchar(100) Address line 2  
line3varchar(100) Address line 3  
region_idinteger, foreign key Region (state, province, etc)ctd_regions:id 
postal_codevarchar(9) Postal code  
country_idinteger, foreign keyNoCountryctd_countries:id 
address_tinteger, foreign keyNoType of this addressctx_data_types:iddata_type=ADDRESS
update_datedatetimeNo