remark

Logical Entity Name | remark
Default Table Name | remark
Definition | Comments

remark Columns

ColumnName | Domain | Datatype | NULL | Definition
commid |  | NUMBER(15, 0) | NO | Comment Identifier
lineno |  | NUMBER(15, 0) | NO | Comment line number. This integer attribute is assigned as a sequence number for multiple line comments. The combination of commid and lineno is unique
remark |  | VARCHAR2(80) | YES | Descriptive text. This single line of text is an arbitrary comment about a record in the database. The comment is linked to its parent relation only by forward reference from commid in the tuple of the relation of interest
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

remark Foreign Keys

Parent Table | Child Table | Type | Foreign Keys

remark Check Constraints

Check Constraint Name | CheckConstraint
remark01 | commid > 0
remark02 | lineno > 0