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 origin	Identifying	One To Zero or More					NO	NO	YES

remark Check Constraints

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