remark

The remark table contains comments. This table may be used to store free-form com­ments that embellish records of other tables. The commid type in many tables refers to a record in the remark table. If commid is NA (-1) in a record of any other table, no com­ments are stored for that record.

FIELD

COLUMN

STORAGE

EXTERNAL

CHARACTER

DESCRIPTION

NUMBER

TYPE

FORMAT

POSITION

1

commid

number(9)

i9

1-9

comment identifier

2

lineno

number(8)

i8

11-18

comment line number

3

remark

varchar2(80)

a80

20-99

free-format comment

4

Iddate

date

a19

101-119

load date







Keys:

Primary

commid, lineno

 

 

Data:

Descriptive

lineno, remark

 

 

 

Administrative

lddate