Fishbowl
Tables
(current)
Columns
Constraints
Orphan Tables
Routines
soitemtype
Columns
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
INT
10
null
kititem
.soItemTypeId
FKjvl5i0ij32utt7baciv7nsfym
R
product
.defaultSoItemType
FKmpt7wmnpasu4xm9htvlx4tk2o
R
soitem
.typeId
FKsirq6y6w6ot38v5kxv8uwbt8n
R
name
VARCHAR
30
null
Indexes
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
id
UKndljurqymyhpi4thb526513h7
Must be unique
Asc
name
Relationships
Close relationships within degrees of separation
One
Two degrees
One implied
Two implied