2004727233741.sql

来自「这是一个采用ASP技术的物业管理系统」· SQL 代码 · 共 18 行

CREATE TABLE `t2112lujfbzjl` (
`building_name` VARCHAR( 50 ) NOT NULL ,
`building_addr` VARCHAR( 255 ) NOT NULL ,
`expense_name` VARCHAR( 50 ) NOT NULL ,
`expense_type` VARCHAR( 50 ) NOT NULL ,
`expense_circle` INT NOT NULL ,
`out_plan_amount1` INT NOT NULL ,
`out_plan_amount2` INT NOT NULL ,
`out_plan_amount3` INT NOT NULL ,
`in_plan_price` FLOAT( 10, 2 ) NOT NULL ,
`out_plan_price1` FLOAT( 10, 2 ) NOT NULL ,
`out_plan_price2` FLOAT( 10, 2 ) NOT NULL ,
`out_plan_price3` FLOAT( 10, 2 ) NOT NULL ,
`dirty_expense` FLOAT( 10, 2 ) NOT NULL ,
`status` VARCHAR( 50 ) NOT NULL 
) COMMENT = '楼宇记费标准计量表';