dbo.contact_relationships_types
Documentation | CRM |
Schema | dbo |
Name | contact_relationships_types |
Module | Contacts |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | relationship_type_code | nvarchar(50) | ||||||
2 | name | nvarchar(50) | ||||||
3 | reverse_name | nvarchar(50) | ||||||
4 | sort | int | Default: 99 | |||||
Default:
99 |
||||||||
5 | status | char(1) | Default: 'A' | |||||
Default:
'A' |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
dbo.contact_relationships | dbo.contact_relationships_types | dbo.contact_relationships.relationship_type_code = dbo.contact_relationships_types.relationship_type_code | FK_contact_relationships_type |
|
dbo.contact_relationships.relationship_type_code = dbo.contact_relationships_types.relationship_type_code Name: FK_contact_relationships_type |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_contact_relationships_types_tab | relationship_type_code | ||
Used by
Name |
---|
dbo.contact_relationships_types
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-28 01:29