CORE-POS/IS4C

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

Summary

Maintainability
Test Coverage
USE `is4c_op`;
DROP TABLE IF EXISTS `is4c_op`.`batchHeaders`;
CREATE TABLE `is4c_op`.`batchHeaders` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
    `name` VARCHAR( 50 ) NULL ,
    `start` DATETIME NULL ,
    `end` DATETIME NULL ,
    `batchType_id` SMALLINT UNSIGNED NOT NULL ,
    `modified` DATETIME NOT NULL ,
    `whomodified` VARCHAR( 50 ) NULL ,
     `active` TINYINT UNSIGNED NOT NULL ,
    PRIMARY KEY ( `id` ) ,
    INDEX ( `active` )
) ENGINE = MYISAM ;