步骤:
1.先建立1收入,1支出表,后续可优化为人员1张表,类型表1张
====================================================
CREATE TABLE expenses
(
id
int(18) NOT NULL AUTO_INCREMENT COMMENT ‘id’,
out_name
varchar(30) NOT NULL COMMENT ‘支出名’,
out_type
varchar(50) DEFAULT NULL COMMENT ‘支出类型’,
out_money
varchar(50) DEFAULT ‘0’ COMMENT ‘支出金额’,
create_time
datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
update_time
datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘最后修改时间’,
remark
varchar(30) NOT NULL COMMENT ‘备注’,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=2111421734 DEFAULT