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

remark Relationships

Parent Entity | Child Entity | Type | Foreign Keys
assoccom | remark | Non-Specific |
assoccoo | remark | Non-Specific |
remark | assocamm | Non-Specific |
remark | assocaro | Non-Specific |
remark | assocamo | Non-Specific |
remark | amp | Non-Specific |
remark | arrival | Non-Specific |
remark | coda | Non-Specific |
remark | event | Non-Specific |
remark | mec | Non-Specific |
remark | netmag | Non-Specific |
remark | origin | Non-Specific |

remark Check Constraints

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