SchemaSpy - Table lawprod.MSCM.CASECART_ASSEMBLY_LOG

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

CARTSET_ASSM_LOGID

number

22

CARTSET_ASSM_LOGNO

varchar2

20

CARTSET_ASSM_NO

varchar2

10

CASECART_ASSEMBLY.CARTSET_ASSM_NO

SYS_C00914100 R

USER_ID

number

22

USERS.USER_ID

SYS_C00914101 R

ASSM_DATE

date

7

LOC_NO

number

22

LOCATION.LOCATION_ID

SYS_C00914102 R

ACTIVITY

number

22

TOTAL

number

22

√

null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
CARTSET_ASSM_LOGNO	Primary key	Asc	SYS_C00914099