CORE-POS/IS4C

View on GitHub
documentation/Reference Code/Wedge/installation/mysql/is4c_op/tables/UNFI.table

Summary

Maintainability
Test Coverage
use is4c_op;

DROP TABLE IF EXISTS `UNFI`;
CREATE TABLE `UNFI` (
  `brand` varchar(30) default NULL,
  `sku` int(6) default NULL,
  `size` varchar(25) default NULL,
  `upc` bigint(13) unsigned zerofill NOT NULL default '0000000000000',
  `units` int(3) default NULL,
  `cost` decimal(9,2) default NULL,
  `description` varchar(35) default NULL,
  `depart` varchar(15) default NULL,
  PRIMARY KEY  (`upc`),
  KEY `newindex` (`upc`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;