SchemaSpy - Table /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.FDB.MO

Manufacture Order

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

ID

integer

10

NUM

varchar

25

TYPEID

integer

10

√

null

STATUSID

integer

10

MOSTATUS.ID

INTEG_644 R

REVISION

integer

10

1

NOTE

blob sub_type 1

0

√

null

LOCATIONGROUPID

integer

10

LOCATIONGROUP.ID

INTEG_666 R

DATELASTMODIFIED

timestamp

19

√

null

DATECREATED

timestamp

19

√

null

DATEISSUED

timestamp

19

√

null

DATECOMPLETED

timestamp

19

√

null

DATESCHEDULED

timestamp

19

√

null

USERID

integer

10

1

SYSUSER.ID

INTEG_668 R

QBCLASSID

integer

10

√

1

QBCLASS.ID

INTEG_669 R

SOID

integer

10

√

null

SO.ID

INTEG_777 R

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
DATECOMPLETED	Performance	Asc	MODATECOMPLETED
DATECREATED	Performance	Asc	MODATECREATED
DATEISSUED	Performance	Asc	MODATEISSUED
DATESCHEDULED	Performance	Asc	MODATESCHEDULED
LOCATIONGROUPID	Performance	Asc	MOLOCATIONGROUPID
NUM	Performance	Asc	MONUM_IDX
QBCLASSID	Performance	Asc	MOQBCLASSID
SOID	Performance	Asc	MOSOID
STATUSID	Performance	Asc	MOSTATUSID
USERID	Performance	Asc	MOUSERID
NUM	Must be unique	Asc	RDB$98
LOCATIONGROUPID	Performance	Asc	RDB$FOREIGN100
USERID	Performance	Asc	RDB$FOREIGN102
QBCLASSID	Performance	Asc	RDB$FOREIGN105
SOID	Performance	Asc	RDB$FOREIGN169
STATUSID	Performance	Asc	RDB$FOREIGN99
ID	Must be unique	Asc	RDB$PRIMARY97