徐进做的房屋租赁管理系统

CREATE TABLE `employee` ( `employee_name` CHAR(20) NOT NULL PRIMARY KEY, `employee_pass` CHAR(100) NOT NULL, `employee_level` CHAR(20) NOT NULL, `employee_can` CHAR(10) NOT NULL ); CREATE TABLE `owner` ( `owner_name` CHAR(20) NOT NULL PRIMARY KEY, `owner_idcard` CHAR(20), `owner_age` CHAR(2), `owner_sex` CHAR(2), `owner_telphone` CHAR(20), `owner_mobile` CHAR(20), `owner_address` CHAR(50), `owner_email` CHAR(20), `owner_company` CHAR(50), `owner_oicq` CHAR(20), `owner_msn` CHAR(20) ); CREATE TABLE `customer` ( `customer_name` CHAR(20) NOT NULL PRIMARY KEY, `customer_idcard` CHAR(20), `customer_age` CHAR(2), `customer_sex` CHAR(2), `customer_telphone` CHAR(20), `customer_mobile` CHAR(20), `customer_address` CHAR(50), `customer_email` CHAR(20), `customer_company` CHAR(50), `customer_oicq` CHAR(10), `customer_msn` CHAR(10) ); CREATE TABLE `house` ( `house_id` CHAR(20) NOT NULL, `house_qu` CHAR(10) NOT NULL, `house_huan` CHAR(20) NOT NULL, `house_jian` CHAR(20) NOT NULL, `house_ceng` CHAR(20) NOT NULL, `house_louping` CHAR(10) NOT NULL, `house_size` INT(10) NOT NULL, `house_zumai` CHAR(10) NOT NULL, `house_zuprice` int(10) NOT NULL, `house_maiprice` int(10) NOT NULL, `owner_name` CHAR(20) NOT NULL, `house_memo` CHAR(200) NOT NULL, PRIMARY KEY (`house_id`) ); CREATE TABLE `trade` ( `trade_id` CHAR(20) NOT NULL, `customer_name` CHAR(20) NOT NULL, `house_id` CHAR(20) NOT NULL, `trade_time` CHAR(20) NOT NULL, `employee_name` CHAR(20) NOT NULL, `trade_zumai` CHAR(10) NOT NULL, `trade_can` CHAR(10) NOT NULL, `trade_memo` CHAR(100) NOT NULL, PRIMARY KEY (`trade_id`) ); CREATE TABLE `ofee` ( `ofee_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `ofee_num` INT(10) NOT NULL, `ofee_time` CHAR(20) NOT NULL, `ofee_mem` CHAR(100), `house_id` CHAR(10) NOT NULL ); CREATE TABLE `tfee` ( `tfee_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `tfee_num` INT(10) NOT NULL, `tfee_time` CHAR(20) NOT NULL, `tfee_mem` CHAR(100), `trade_id` CHAR(20) NOT NULL );