Filename Columns

ColumnName	Domain	Datatype	NULL	Definition
fileid		NUMBER(15, 0)	NO	Filename identifier. The key field is a unique identifier for a physical file on a disk
dfile		VARCHAR2(32)	NO	Data file. This is the file name of a disk-based waveform file
datetime_on		NUMBER(25, 10)	YES	Time of first sample in the waveform file
datetime_off		NUMBER(25, 10)	YES	Time of last sample in the waveform file
nbytes		NUMBER(10, 0)	YES	Number of bytes. This quantity is the number of bytes in a waveform segment or a file
subdirid		NUMBER(15, 0)	NO	Directory identifier. The key field is a unique identifier for a directory name on a disk
lddate		DATE	NO	Load date. Date and time that the record was created or last modified

Filename Primary and Unique Keys

Key Name	Key Type	Keys
Fil00	PrimaryKey	fileid

Filename Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable	Initially Deferred
Subdir	Non-Identifying	One To Zero or More	Filename_PartialPath			subdirid	NO	NO	NO

Child Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype	Deferrable	Initially Deferred
Waveform	Non-Identifying	One To Zero or More	Waveform_Filename				NO	NO	NO

Filename Check Constraints

Check Constraint Name	CheckConstraint
FN01	(nbytes >=0)