SchemaSpy - Table lawprod.MSCM.DELIVERY_UNIT

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

DELIVERY_TICKET_ID

varchar2

40

DISTRIB_LINE.DELIVERY_TICKET_ID

SYS_C00914525 R

DELIVERY_TICKET.DELIVERY_TICKET_ID

SYS_C00914387 R

DELIVERY_UNIT_NO

number

4

DISTRIB_LINE.DELIVERY_UNIT_NO

SYS_C00914525 R

TRACKING_NO

varchar2

50

√

null

NUM_LABELS

number

7

NOTE_ID

number

20

√

null

NOTE.NOTE_ID

SYS_C00914388 R

IS_ACTIVE

char

1

√

'T'

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
DELIVERY_TICKET_ID + DELIVERY_UNIT_NO	Primary key	Asc/Asc	SYS_C00914386
TRACKING_NO	Performance	Asc	TRACKNO_IDX