dbo.company_role_types
| Documentation | CRM |
| Schema | dbo |
| Name | company_role_types |
| Module | Companies |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | role_code | nvarchar(50) | ||||||
| 2 | name | nvarchar(50) | ||||||
| 3 | sort | int | Default: 99 | |||||
|
Default:
99 |
||||||||
| 4 | created_by | nvarchar(100) | Login of user who created row | |||||
| Login of user who created row |
||||||||
| 5 | created_date | datetime | Default: getdate() | |||||
|
Default:
getdate() |
||||||||
| 6 | modified_by | nvarchar(100) | Login of user who last modified row | |||||
| Login of user who last modified row |
||||||||
| 7 | 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_company_role_types_tab | role_code | ||
Exported: 2019-02-04 23:17, Last imported: 2018-02-28 01:29