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