Filename Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
fileid		NUMERIC(15, 0)	NO	Filename identifier. The key field is a unique identifier for a physical file on a disk
dfile		VARCHAR(32)	NO	Data file. This is the file name of a disk-based waveform file
datetime_on		NUMERIC(25, 10)	YES	Time of first sample in the waveform file
datetime_off		NUMERIC(25, 10)	YES	Time of last sample in the waveform file
nbytes		NUMERIC(10, 0)	YES	Number of bytes. This quantity is the number of bytes in a waveform segment or a file
subdirid		NUMERIC(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 Keys

Key Name	Key Type	Keys
Fil00	PrimaryKey	fileid

Filename Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Subdir	Non-Identifying	One To Zero or More				subdirid	NO

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Waveform	Non-Identifying	One To Zero or More					NO

Filename Check Constraints

Check Constraint Name	CheckConstraint
FN01	(nbytes >=0)