SchemaSpy - Table lawprod.MSCM.SYNC

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

SYNC_ID

number

20

USER_ID

number

22

USERS.USER_ID

SYS_C00913555 R

DATA

long

0

STATUS

char

1

SYNC_TYPE

number

22

TIMESTAMP

date

7

CHECKSUM

varchar2

30

√

null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
SYNC_ID	Primary key	Asc	SYS_C00913553
CHECKSUM	Must be unique	Asc	SYNC_CRC_IDX	This unique column is also nullable
SYNC_TYPE + STATUS	Performance	Asc/Asc	SYNC_STATUS_TYPE_IDX