Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
HActivityID | INT | 10 | √ | null |
|
|
||||
ActivityID | INT | 10 | null |
|
|
|||||
ClientID | INT | 10 | null |
|
|
|||||
LocationID | INT | 10 | null |
|
|
|||||
TargetType | INT | 10 | null |
|
|
|||||
TargetID | INT | 10 | null |
|
|
|||||
ActivityChecked | DATETIME | 19 | null |
|
|
|||||
ActivityValue | INT | 10 | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | HActivityID |