Subdir Columns

ColumnName	Domain	Datatype	NULL	Definition
subdirid		NUMBER(15, 0)	NO	Directory identifier. The key field is a unique identifier for a directory name on a disk
subdirname		VARCHAR2(64)	NO	Path name. This is the name of a disk-based directory
lddate		DATE	NO	Load date. Date and time that the record was created or last modified

Subdir Primary and Unique Keys

Key Name	Key Type	Keys
Sub00	PrimaryKey	subdirid

Subdir 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
Filename	Non-Identifying	One To Zero or More	Filename_PartialPath				NO	NO	NO

Subdir Check Constraints

Check Constraint Name

CheckConstraint