SchemaSpy - Table lawprod.MSCM.TRAY_LIST

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_ID

number

22

ITEM_ON_TRAY_LIST_HELP.TL_ID	Implied Constraint R
TL_GROUP.TL_ID	SYS_C00913925 R
TRAY_LIST_CURRENT_VIEW.TL_ID	Implied Constraint R
TRAY_ROTATION_TIME_VW.TL_ID	Implied Constraint R
TRAYSET.TL_ID	Implied Constraint R
TRAYSET_CURRENT_VW.TL_ID	Implied Constraint R
TRAYSET_TRAY.TL_ID	Implied Constraint R

TL_NO

varchar2

6

TL_EXT_NO

varchar2

15

√

null

TL_TYPE

number

22

DESCR

varchar2

100

HEADER

varchar2

200

√

null

FOOTER

varchar2

200

√

null

USER_ID

number

22

USERS.USER_ID

SYS_C00913916 R

SERV_NO

number

4

√

null

SERVICE.SERV_NO

Implied Constraint R

STER_NO

number

4

√

null

STERILIZATION_TYPE.STER_NO

Implied Constraint R

COLOR_NO

number

4

√

null

COLOR.COLOR_NO

Implied Constraint R

CREATED

date

7

VERSION

number

22

STATUS

number

1

IMGLNK

varchar2

255

√

null

CHARGE_CODE

varchar2

50

√

null

TOTAL

number

22

STORAGE_LOCATION_NO

number

22

√

null

LOCATION.LOCATION_ID

SYS_C00913917 R

STORAGE_BIN

varchar2

7

√

null

SOURCE_LOCATION_NO

number

22

√

null

LOCATION.LOCATION_ID

SYS_C00913918 R

DISPLAYMFR

number

1

√

null

HOT_IND

char

1

BIO_TEST_REQD

varchar2

1

'N'

DECONTAM_ID

number

4

√

null

DECONTAMINATION_UNIT.DECONTAM_ID

Implied Constraint R

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
TL_ID	Primary key	Asc	SYS_C00913915
TL_NO + VERSION	Must be unique	Asc/Asc	TRAY_LIST_UK