CHECK PLUS RI rules tables
CHECK PLUS BMCRELS table
Column name | Data type | Description |
|---|---|---|
CREATOR | VARCHAR(128) | Creator of the table 1 |
TBNAME | VARCHAR(128) | Table name 1 |
RELNAME | VARCHAR(128) | Constraint name 1 |
REFTBCREATOR | VARCHAR(128) | Creator of the referenced table |
REFTBNAME | VARCHAR(128) | Name of the referenced table |
COLCOUNT | SMALLINT | Number of key columns |
TIMESTAMP | TIMESTAMP | Timestamp of when the row was inserted |
1 The first three columns make up the primary key.
CHECK PLUS BMCFOREIGNKEYS table
Column name | Data type | Description |
|---|---|---|
CREATOR | VARCHAR(128) | creator of the table 1 |
TBNAME | VARCHAR(128) | table name 1 |
RELNAME | VARCHAR(128) | constraint name 1 |
COLNAME | VARCHAR(128) | name of the key column |
COLNO | SMALLINT | column number in the table |
COLSEQ | SMALLINT | column sequence in the key |
1 The first three columns make up the foreign key.
CHECK PLUS BMCPRIMARYKEYS table
Column name | Data type | Description |
|---|---|---|
TBCREATOR | VARCHAR(128) | Creator of the table 1 |
TBNAME | VARCHAR(128) | Table name 1 |
COLCOUNT | SMALLINT | Number of key columns |
TIMESTAMP | TIMESTAMP | Timestamp of when the row was inserted |
1 The first two columns make up the primary key.
CHECK PLUS BMCKEYS table
Column name | Data type | Description |
|---|---|---|
TBCREATOR | VARCHAR(128) | Creator of the table 1 |
TBNAME | VARCHAR(128) | Table name 1 |
COLNAME | VARCHAR(128) | Column name |
COLSEQ | SMALLINT | Column sequence in the key |
1 The first two columns make up the foreign key.