Table /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.FDB.RMA
X

Generated by
SchemaSpy
Legend: SourceForge.net
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
RMAITEM.RMAID INTEG_1227 R
NUM varchar 25
CUSTOMERID integer 10
CUSTOMER.ID INTEG_1217 R
STATUSID integer 10 10
RMASTATUS.ID INTEG_1219 R
DATECREATED timestamp 19  √  null
DATELASTMODIFIED timestamp 19  √  null
DATEEXPIRES timestamp 19  √  null
USERID integer 10 1
SYSUSER.ID INTEG_1221 R
LOCATIONGROUPID integer 10
LOCATIONGROUP.ID INTEG_1223 R

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:
Column(s) Type Sort Constraint Name
NUM Must be unique Asc INTEG_1215
CUSTOMERID Performance Asc RDB$FOREIGN594
STATUSID Performance Asc RDB$FOREIGN595
USERID Performance Asc RDB$FOREIGN596
LOCATIONGROUPID Performance Asc RDB$FOREIGN597
ID Must be unique Asc RDB$PRIMARY592
CUSTOMERID Performance Asc RMACUSTOMERID
DATECREATED Performance Asc RMADATECREATED
DATEEXPIRES Performance Asc RMADATEEXPIRES
LOCATIONGROUPID Performance Asc RMALOCATIONGROUPID
NUM Performance Asc RMANUM
STATUSID Performance Asc RMASTATUSID
USERID Performance Asc RMAUSERID

Close relationships  within of separation: