SchemaSpy - Table lawprod.MSCM.TL_GROUP

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_GRP_ID

number

22

TL_ITEM.TL_GRP_ID

SYS_C00913936 R

TL_GRP_NO

varchar2

10

TL_ID

number

22

TRAY_LIST.TL_ID

SYS_C00913925 R

HEADER

varchar2

200

√

null

FOOTER

varchar2

200

√

null

SEQ

number

22

TS_GRP_NO

number

4

TRAY_GROUP.TS_GRP_NO

SYS_C00913926 R

SUB_TOTAL

number

22

√

null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
TL_GRP_ID	Primary key	Asc	SYS_C00913924
TL_ID + TL_GRP_NO + SEQ	Must be unique	Asc/Asc/Asc	TL_GROUP_UK
TS_GRP_NO + TL_ID	Performance	Asc/Asc	TLGRP_GRPNO_IDX