remark

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

remark Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
commid |  | NUMERIC(15, 0) | NO | Comment Identifier
lineno |  | NUMERIC(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 |  | VARCHAR(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 Keys

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

remark Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
assoccom | Non-Specific |  |  |  |  |  | NO
assoccoo | Non-Specific |  |  |  |  |  | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
assocamm | Non-Specific |  |  |  |  |  | NO
assocaro | Non-Specific |  |  |  |  |  | NO
assocamo | Non-Specific |  |  |  |  |  | NO
amp | Non-Specific |  |  |  |  |  | NO
arrival | Non-Specific |  |  |  |  |  | NO
coda | Non-Specific |  |  |  |  |  | NO
event | Non-Specific |  |  |  |  |  | NO
mec | Non-Specific |  |  |  |  |  | NO
netmag | Non-Specific |  |  |  |  |  | NO
origin | Non-Specific |  |  |  |  |  | NO

remark Check Constraints

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