CORE-POS/IS4C

View on GitHub
documentation/Reference Code/Wedge/installation/mysql/opdata/tables/departments.table

Summary

Maintainability
Test Coverage
use opdata;

DROP TABLE IF EXISTS `departments`;
CREATE TABLE `departments` (
  `dept_no` smallint(6) default NULL,
  `dept_name` varchar(30) default NULL,
  `dept_tax` tinyint(4) default NULL,
  `dept_fs` tinyint(4) default NULL,
  `dept_limit` double default NULL,
  `dept_minimum` double default NULL,
  `dept_discount` tinyint(4) default NULL,
  `modified` datetime default NULL,
  `modifiedby` int(11) default NULL,
  KEY `dept_no` (`dept_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;