| Table /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.FDB.POTYPE X
|
Generated by SchemaSpy |
| |||||||||||||||||||||||||||||
Analyzed at Mon Jul 01 09:44 PDT 2013 | |||||||||||||||||||||||||||||
Indexes:
| Column(s) | Type | Sort | Constraint Name | Anomalies |
|---|---|---|---|---|
| Performance | FB_PRODUCT_PARTID | |||
| Performance | IDX_14 | |||
| Performance | IDX_15 | |||
| Performance | PRODUCTDISPLAYTYPEID | |||
| Performance | PRODUCTINCOMEACCOUNTID | |||
| Performance | PRODUCTPARTID | |||
| Performance | PRODUCTQBCLASSID | |||
| Performance | PRODUCTSHOWSOCOMBOFLAG_IDX | |||
| Performance | PRODUCTSIZEUOMID | |||
| Performance | PRODUCTSKU | |||
| Performance | PRODUCTUOMID | |||
| Performance | PRODUCTUPC | |||
| Performance | PRODUCTWEIGHTUOMID | |||
| Must be unique | RDB$172 | These unique columns are also nullable | ||
| Performance | RDB$FOREIGN1 | |||
| Performance | RDB$FOREIGN171 | |||
| Performance | RDB$FOREIGN173 | |||
| Performance | RDB$FOREIGN410 | |||
| Performance | RDB$FOREIGN411 | |||
| Performance | RDB$FOREIGN412 | |||
| Performance | RDB$FOREIGN649 | |||
| Performance | RDB$FOREIGN680 | |||
| Performance | RDB$FOREIGN7 | |||
| ID | Must be unique | Asc | RDB$PRIMARY170 |
|