prs_phones
- Benn Oshrin
Owned by Benn Oshrin
Mar 11, 2013
1 min read
Loading data...
| Title | prs_phones |
|---|---|
| Type | Standardized |
| Description | Telephone numbers |
| Column | Format | Nullable? | Description | Definition | Comments |
|---|---|---|---|---|---|
| id | integer, primary key | No | Â | Â | Â |
| area_code | varchar(5) | No | Area code | Â | Â |
| country_code | varchar(5) | No | Country code | Â | Â |
| extension | varchar(5) | Â | Extension | Â | Â |
| phone_number | varchar(10) | No | Phone number | Â | Â |
| phone_line_order | integer | No | Â | Â | Â |
| update_date | datetime | No | Â | Â | Â |
| address_t | integer, foreign key | No | Address type of this phone number | ctx_data_types:id | data_type=ADDRESS |
| phone_t | integer, foreign key | No | Type of this phone number | ctx_data_types:id | data_type=PHONE |
| role_record_id | integer, foreign key | No | SOR Role Record this phone number is attached to | prs_role_records:id | Â |