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

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
RMAID integer 10
RMA.ID INTEG_1227 R
LINENUM integer 10
PRODUCTID integer 10
PRODUCT.ID INTEG_1230 R
UOMID integer 10
UOM.ID INTEG_1232 R
ISSUEID integer 10  √  null
TYPEID integer 10
RMAITEMTYPE.ID INTEG_1234 R
RESOLUTIONID integer 10  √  null
PRODUCTSUBID integer 10  √  null
PRODUCT.ID INTEG_1235 R
CROSSSHIPFLAG smallint 5  √  0
SHIPFLAG smallint 5  √  0
RETURNFLAG smallint 5  √  0
VENDORID integer 10  √  null
VENDOR.ID INTEG_1236 R
VENDORRMA varchar 25  √  null
DATERESOLVED timestamp 19  √  null
NOTE blob sub_type 1 0  √  null
QTY double precision 15  √  0

Analyzed at Sat Mar 01 08:31 PST 2014

Indexes:
Column(s) Type Sort Constraint Name
RMAID Performance Asc RDB$FOREIGN599
PRODUCTID Performance Asc RDB$FOREIGN600
UOMID Performance Asc RDB$FOREIGN601
TYPEID Performance Asc RDB$FOREIGN602
PRODUCTSUBID Performance Asc RDB$FOREIGN603
VENDORID Performance Asc RDB$FOREIGN604
ID Must be unique Asc RDB$PRIMARY598
DATERESOLVED Performance Asc RMAITEMDATERESOLVED
PRODUCTID Performance Asc RMAITEMPRODUCTID
PRODUCTSUBID Performance Asc RMAITEMPRODUCTSUBID
RMAID Performance Asc RMAITEMRMAID
TYPEID Performance Asc RMAITEMTYPEID
UOMID Performance Asc RMAITEMUOMID
VENDORID Performance Asc RMAITEMVENDORID


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.