SchemaSpy - Table lawprod.MSCM.TL_ITEM

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

TL_ITEM_ID

number

22

TS_INST_TK_DATA.TL_ITEM_ID	SYS_C00914197 R
TS_ITEM_EXCEPTION.TL_ITEM_ID	Implied Constraint R

TL_ITEM_NO

varchar2

6

ITEM_ID

number

22

ITEM.ITEM_ID

SYS_C00913935 R

TL_GRP_ID

number

22

TL_GROUP.TL_GRP_ID

SYS_C00913936 R

SEQ

number

22

COMMENTS

varchar2

200

√

null

QTY

number

22

DISPLAYMFR

number

1

√

null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
TL_ITEM_ID	Primary key	Asc	SYS_C00913934
TL_GRP_ID + ITEM_ID + SEQ	Must be unique	Asc/Asc/Asc	TL_ITEM_UK