dbo.dqr_comment_history

 

Object Type

Table

Datasource

IPMA

Database

icsa

 

This table contains the data quality comment assignement history for each observation.
See the DQR entity for further information.

Use and RelatedData

See DQR table.

Population

Ongoing. An entry is added to this table each time a data quality comment associated to with an observation is modified.
Columns
Name Datatype Null
date datetime No
username varchar(16) No
obsno int No
comment varchar(255) Yes
action varchar(7) No


column date

The date of the comment modification.
column username

          The user who modified the comment.

column obsno

          The number of the effected observation.

column comment

          The comment text added or set.

column action

          The action performed - this is one of INITIAL, ADD, SET


Table Usage (MB)

Distribution of Table Space

 

Data

2.64

Data

47.91 %

Indexes

2.82

Indexes

51.10 %

Unused

0.05

Unused

0.99 %

Total

5.52

Number of Rows

31595

Dependencies
Referencing Objects
Object Name Object Type
dbo.dqr_comment_history.dqr_comment_history_ix1 INDEX
dbo.dqr_comment_history.dqr_comment_history_ix2 INDEX
dbo.dqr_comment_history.dqr_comment_history_ix3 INDEX
Referenced Objects
Object Name Object Type

DDL 

CREATE TABLE dbo.dqr_comment_history 
(
    date     datetime     NOT NULL,
    username varchar(16)  NOT NULL,
    obsno    int          NOT NULL,
    comment  varchar(255) NULL,
    action   varchar(7)   NOT NULL
)
LOCK ALLPAGES
go