search

bachtiar-madya-p / IO_ASSET-V3.0

1 stars 1 forks source link

Create CRUD Department #50

Closed bachtiar-madya-p closed 4 years ago

bachtiar-madya-p commented 4 years ago

Values

CREATE TABLE `department` (
  `departmentid` varchar(50) NOT NULL,
  `departmentcode` varchar(20) DEFAULT NULL,
  `departmentname` varchar(50) DEFAULT NULL,
  `description` text,
  `isactive` tinyint(4) NOT NULL,
  PRIMARY KEY (`departmentid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1