prs_phones
Title | prs_phones |
---|---|
Type | Standardized |
Description | Standardized telephone numbers |
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 | ||
country_code | varchar(5) | Country code | Should address lines 1-3 be consolidated? | ||
area_code | varchar(5) | Area code | |||
phone_number | varchar(10) | Phone number | |||
extension | varchar(5) | Extension | |||
address_t | integer, foreign key | Address type of this phone number |
| ||
phone_t | integer, foreign key | Type of this phone number | ctx_data_types:id | data_type=PHONE | |
verified | boolean | Whether this phone has been verified by the SOR |
Migration Notes From OR 1
- Dropped phone_line_order and update_date pending requirements
- Added
verified
(Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.)