AftabDolon

CREATE TABLE `L_DESIGNATION` ( 
  `DESIGNATION_ID` bigint NOT NULL AUTO_INCREMENT, 
  `DESIGNATION` varchar(200) NOT NULL, 
  `DESIGNATION_BNG` varchar(3000) DEFAULT NULL, 
  `DEPARTMENT_ID` bigint NOT NULL, 
  `ORDER_NO` bigint NOT NULL, 
  `ACTIVE_YN` varchar(1) DEFAULT 'Y', 
  `SHORT_NAME` varchar(100) DEFAULT NULL, 
  `INSERT_BY` bigint DEFAULT NULL, 
  `INSERT_DATE` datetime DEFAULT NULL,