search

bachtiar-madya-p / IO_ASSET-V3.0

1 stars 1 forks source link

create CRUD building #53

Closed bachtiar-madya-p closed 4 years ago

bachtiar-madya-p commented 4 years ago

values 

CREATE TABLE `masterbuilding` (
  `buildingid` varchar(50) NOT NULL,
  `buildingname` varchar(30) NOT NULL,
  `description` varchar(50) NOT NULL,
  `cityid` varchar(50) NOT NULL,
  `isactive` tinyint(4) NOT NULL,
  PRIMARY KEY (`buildingid`),
  KEY `cityid` (`cityid`),
  CONSTRAINT `citid` FOREIGN KEY (`cityid`) REFERENCES `mastercity` (`cityid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1