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

Item Adjust Information

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

KITITEM.DISCOUNTID

INTEG_1360 R

NAME

varchar

31

TYPEID

integer

10

ITEMADJUSTTYPE.ID

INTEG_559 R

TAXABLEFLAG

smallint

5

√

1

DESCRIPTION

varchar

256

√

null

INCOMEASACCOUNTID

integer

10

√

0

INTEG_156 R

EXPENSEASACCOUNTID

integer

10

√

0

INTEG_157 R

ACTIVEFLAG

smallint

5

1

PERCENTAGE

double precision

15

√

0

AMOUNT

double precision

15

√

0

TAXRATEID

integer

10

√

null

TAXRATE.ID

INTEG_861 R

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
TYPEID	Performance	Asc	IDX_22
NAME	Must be unique	Asc	RDB$271
INCOMEASACCOUNTID	Performance	Asc	RDB$FOREIGN24
EXPENSEASACCOUNTID	Performance	Asc	RDB$FOREIGN25
TYPEID	Performance	Asc	RDB$FOREIGN272
TAXRATEID	Performance	Asc	RDB$FOREIGN29
ID	Must be unique	Asc	RDB$PRIMARY270