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, in Oracle date datatype

remark Primary and Unique Keys

Key Name | Key Type | Keys
remkey01 | PrimaryKey | commid, lineno

remark Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred

remark Check Constraints

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