dbo.contact_phone_numbers
| Documentation | CRM |
| Schema | dbo |
| Name | contact_phone_numbers |
| Module | Contacts |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | Sensitive | Information type | ||
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | contact_phone_number_id | int | Identity | Confidential - GDPR | Contact Info | |||||
| Identity Sensitive: Confidential - GDPR Information type: Contact Info |
||||||||||
| 2 | contact_id | int | ||||||||
| 3 | phone_number_no | int | Default: 1 | Confidential - GDPR | Contact Info | |||||
|
Default:
1 Sensitive: Confidential - GDPR Information type: Contact Info |
||||||||||
| 4 | phone_number | nvarchar(50) | Confidential - GDPR | Contact Info | ||||||
| 5 | phone_number_type_code | nvarchar(50) | Confidential - GDPR | Contact Info | ||||||
| 6 | deleted | bit | Default: 0 | |||||||
|
Default:
0 |
||||||||||
| 7 | created_by | nvarchar(100) | Login of user who created row | |||||||
| Login of user who created row |
||||||||||
| 8 | creation_date | datetime | Default: getdate() | Row creation date time | ||||||
| Row creation date time Default: getdate() |
||||||||||
| 9 | modified_by | nvarchar(100) | Login of user who last modified row | |||||||
| Login of user who last modified row |
||||||||||
| 10 | modification_date | datetime | Default: getdate() | Date and time of row last modification | ||||||
| Date and time of row last modification Default: getdate() |
||||||||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_contact_phone_numbers_tab | contact_phone_number_id | ||
Exported: 2019-02-04 23:17, Last imported: 2018-02-28 01:29
