This table contains information about key events and activities in the CCGS.
| name | value |
|---|---|
| name | [dbo].[DATA_HISTORY] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 154 |
| Size of data | 24 kb |
| Size of indexes | 32 kb |
| Maximum size of a single row | 198 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| action_performed | varchar | 75 | 75 | no | composite PK | no | What the significant action was. | |||
| significant | char | 1 | 1 | yes | no | Was it an important action? | ||||
| expansion | char | 1 | 1 | yes | no | Was it primarily related to the expansion process? | ||||
| system | char | 1 | 1 | yes | no | Was it primarily related to hardware or software? | ||||
| sampling | char | 1 | 1 | yes | no | Did the action primarily affect how sampling was done? | ||||
| data_update | char | 1 | 1 | yes | no | Was it primarily an update of the data? | ||||
| date_performed | datetime | 23 | 8 | no | composite PK | no | ||||
| who_did_it | char | 10 | 10 | no | no | |||||
| comments | varchar | 100 | 100 | yes | no |