SchemaSpy - Table lawprod.MSCM.TS_ITEM_EXCEPTION

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

TS_ITEM_ID

number

22

TS_ITEM_NO

varchar2

10

TS_ID

number

22

TL_ITEM_ID

number

22

TL_ITEM.TL_ITEM_ID

Implied Constraint R

REPL_ITEM_NO

number

22

√

null

REPL_QTY

number

22

√

null

DESCR

varchar2

200

√

null

REPL_DESCR

varchar2

200

√

null

EX_NO

number

4

√

null

QTY

number

22

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
TS_ITEM_NO	Primary key	Asc	SYS_C00913959
TS_ID	Performance	Asc	DT_TS_ITEM_EXCEPTION_TS_ID