SchemaSpy - Table lawprod.MSCM.VENDOR

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

VENDOR_SYSTEM_ID

number

22

DELIVERY_TICKET.VENDOR_SYSTEM_ID	SYS_C00914381 R
DOCKLOG.CARRIER_VENDOR_SYSTEM_ID	SYS_C00914248 R
RECEIPT_HEADER.CARRIER_VENDOR_SYSTEM_ID	SYS_C00914249 R
RECEIPT_HEADER.VENDOR_SYSTEM_ID	SYS_C00914250 R
RECEIPT_LOG_VW.VENDOR_SYSTEM_ID	Implied Constraint R
VENDOR_BUSINESS_RULES.VENDOR_SYSTEM_ID	SYS_C00914246 R
VENDOR_CARRIER_MAP.VENDOR_SYSTEM_ID	SYS_C00914252 R

VENDOR_ID

varchar2

9

VENDOR_NAME

varchar2

30

GROUP_ID

varchar2

4

VENDOR_GROUP.GROUP_ID

SYS_C00914239 R

IS_MISC_RECEIVING

char

1

IS_CARRIER

char

1

IS_PO_RECEIVING

char

1

EXT_DATA_IND

char

1

INTERNAL_STATUS

char

1

EXTERNAL_STATUS

char

1

POOL_OPTION

char

1

'0'

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
VENDOR_SYSTEM_ID	Primary key	Asc	SYS_C00914237
VENDOR_ID + GROUP_ID	Must be unique	Asc/Asc	SYS_C00914238
IS_CARRIER	Performance	Asc	VEN_ISCARRIER_IDX
VENDOR_ID	Performance	Asc	VEN_VENID_IDX