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

Unknown

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

REPORTTOMODULE.MODULEID

INTEG_853 R

NAME

varchar

41

ISMODULE

smallint

5

REPORTID

integer

10

√

null

REPORT.ID

INTEG_826 R

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
	Performance		MOITEMBOMID
	Performance		MOITEMBOMITEMID
	Performance		MOITEMDATESCHEDULED
	Performance		MOITEMMOID
	Performance		MOITEMPARENTID
	Performance		MOITEMPARTID
	Performance		MOITEMQBCLASSID
	Performance		MOITEMSTATUSID
	Performance		MOITEMTYPEID
	Performance		MOITEMUOMID
	Performance		RDB$FOREIGN108
	Performance		RDB$FOREIGN110
	Performance		RDB$FOREIGN113
	Performance		RDB$FOREIGN114
	Performance		RDB$FOREIGN115
	Performance		RDB$FOREIGN118
	Performance		RDB$FOREIGN119
	Performance		RDB$FOREIGN121
	Performance		RDB$FOREIGN122
	Performance		RDB$FOREIGN125
ID	Must be unique	Asc	RDB$PRIMARY109