dbo.activity_threads
| Documentation | CRM |
| Schema | dbo |
| Name | activity_threads |
| Module | Activities |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | activity_thread_id | int | Identity | |||||
| Identity |
||||||||
| 2 | title | nvarchar(50) | ||||||
| 3 | last_activity_date | datetime | Default: getdate() | |||||
|
Default:
getdate() |
||||||||
| 4 | created_by | nvarchar(50) | Login of user who created row | |||||
| Login of user who created row |
||||||||
| 5 | creation_date | datetime | Default: getdate() | Row creation date time | ||||
| Row creation date time Default: getdate() |
||||||||
| 6 | modified_by | nvarchar(50) | 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_activity_threads_tab | activity_thread_id | ||
Exported: 2019-02-04 23:17, Last imported: 2018-02-28 01:29
