Table Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDB.RMA
RMA Module Header

 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 Sat Mar 01 08:31 PST 2014

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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.