SchemaSpy - Table lawprod.MSCM.MANIFEST_LINE

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

MANIFEST_ID

number

22

MANIFEST.MANIFEST_ID

SYS_C00914555 R

DELIVERY_TICKET_ID

varchar2

40

DISTRIB_LINE.DELIVERY_TICKET_ID

SYS_C00914556 R

DELIVERY_UNIT_NO

number

4

DISTRIB_LINE.DELIVERY_UNIT_NO

SYS_C00914556 R

DISTRIB_LINE_NO

number

5

DISTRIB_LINE.DISTRIB_LINE_NO

SYS_C00914556 R

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
MANIFEST_ID + DELIVERY_TICKET_ID + DELIVERY_UNIT_NO + DISTRIB_LINE_NO	Primary key	Asc/Asc/Asc/Asc	SYS_C00914554