SchemaSpy - Table lawprod.MSCM.CARRIER_TRACKING_FORMAT

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

CARRIER_TRACKING_FORMAT_ID

number

22

VENDOR_BUSINESS_RULES.CARRIER_TRACKING_FORMAT_ID	SYS_C00914247 R
VENDOR_CARRIER_MAP.CARRIER_TRACKING_FORMAT_ID	SYS_C00913754 R

BARCODE_LENGTH

number

2

TRACKING_NO_LENGTH

number

2

STARTS_WITH

varchar2

20

√

null

START_POSITION

number

2

END_POSITION

number

2

SUPPLIER_START_POSITION

number

2

√

null

SUPPLIER_END_POSITION

number

2

√

null

MAPTYPE

char

1

√

null

NAME

varchar2

30

√

null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
CARRIER_TRACKING_FORMAT_ID	Primary key	Asc	SYS_C00913744