/
prs_phones
prs_phones
- Benn Oshrin
Owned by Benn Oshrin
| 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.)