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