公寓管理系统
公寓管理系统mysql数据库创建语句
公寓管理系统oracle数据库创建语句
公寓管理系统sqlserver数据库创建语句
公寓管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
公寓管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
高质量编程视频:shangyepingtai.xin
公寓管理系统mysql数据库版本源码:
超级管理员表创建语句如下:
create table t_admin(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘超级管理员账号’,
password varchar(100) comment ‘超级管理员密码’
) comment ‘超级管理员’;
insert into t_admin(username,password) values(‘admin’,‘123456’);
SQLCopy
宿舍报修表创建语句如下:
create table t_baoxiu(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
ssId int comment ‘宿舍’,
insertDate datetime comment ‘报修时间’,
v1 varchar(100) comment ‘简单说明’,
v2 varchar(100) comment ‘详细问题’,
v3 varchar(100) comment ‘图片’,
status varchar(100) comment ‘状态’,
back varchar(100) comment ‘维修说明’
) comment ‘宿舍报修’;
SQLCopy
用户表创建语句如下:
create table t_customer(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
customerName varchar(100) comment ‘姓名’,
headPic varchar(100) comment ‘头像’,
phone varchar(100) comment ‘电话’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’,
ssId int comment ‘宿舍’,
status varchar(100) comment ‘状态’
) comment ‘用户’;
SQLCopy
公寓设备表创建语句如下:
create table t_gysb(
id int primary key auto_increment comment ‘主键’,
v1 varchar(100) comment ‘设备名称’,
v2 varchar(100) comment ‘设备位置’,
v3 varchar(100) comment ‘设备作用’,
v4 varchar(100) comment ‘负责人’,
status varchar(100) comment ‘状态’
) comment ‘公寓设备’;
SQLCopy
宿舍检查表创建语句如下:
create table t_jiancha(
id int primary key auto_increment comment ‘主键’,
ssId int comment ‘宿舍’,
jianchaDate datetime comment ‘检查时间’,
v1 varchar(100) comment ‘检查人’,
v2 varchar(100) comment ‘备注’,
status varchar(100) comment ‘是否违规’
) comment ‘宿舍检查’;
SQLCopy
宿舍缴费表创建语句如下:
create table t_jiaofei(
id int primary key auto_increment comment ‘主键’,
ssId int comment ‘宿舍’,
types varchar(100) comment ‘缴费类型’,
fee int comment ‘缴费金额’,
content varchar(100) comment ‘费用说明’,
showDate varchar(100) comment ‘缴费月份’,
status varchar(100) comment ‘状态’
) comment ‘宿舍缴费’;
SQLCopy
来访登记表创建语句如下:
create table t_lfdj(
id int primary key auto_increment comment ‘主键’,
customerName varchar(100) comment ‘姓名’,
phone varchar(100) comment ‘电话’,
sex varchar(100) comment ‘性别’,
ssId int comment ‘到访宿舍’,
beginDate datetime comment ‘到访时间’,
endDate datetime comment ‘结束时间’,
remark varchar(100) comment ‘备注’
) comment ‘来访登记’;
SQLCopy
公寓设备保养表创建语句如下:
create table t_sbby(
id int primary key auto_increment comment ‘主键’,
gysbId int comment ‘设备’,
a1 varchar(100) comment ‘保养编号’,
a2 varchar(100) comment ‘保养人’,
a3 datetime comment ‘保养时间’,
a4 varchar(100) comment ‘备注’
) comment ‘公寓设备保养’;
SQLCopy
宿舍表创建语句如下:
create table t_ss(
id int primary key auto_increment comment ‘主键’,
ssName varchar(100) comment ‘宿舍编号’,
ssWz varchar(100) comment ‘宿舍位置’
) comment ‘宿舍’;
SQLCopy
公寓通知表创建语句如下:
create table t_tongzhi(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘标题’,
pic varchar(100) comment ‘图片’,
content varchar(100) comment ‘说明’,
showDate datetime comment ‘时间’
) comment ‘公寓通知’;
SQLCopy
退宿调宿表创建语句如下:
create table t_tsts(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
v1 varchar(100) comment ‘退宿调宿说明’,
v2 varchar(100) comment ‘原有宿舍编号’,
v3 varchar(100) comment ‘当前宿舍编号’,
showDate datetime comment ‘操作时间’
) comment ‘退宿调宿’;
SQLCopy
维修管理员表创建语句如下:
create table t_wxadmin(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
wxadminName varchar(100) comment ‘姓名’,
headPic varchar(100) comment ‘头像’,
phone varchar(100) comment ‘电话’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’
) comment ‘维修管理员’;
SQLCopy
公寓管理系统oracle数据库版本源码:
超级管理员表创建语句如下:
create table t_admin(
id integer,
username varchar(100),
password varchar(100)
);
insert into t_admin(id,username,password) values(1,‘admin’,‘123456’);
–超级管理员字段加注释
comment on column t_admin.id is ‘主键’;
comment on column t_admin.username is ‘超级管理员账号’;
comment on column t_admin.password is ‘超级管理员密码’;
–超级管理员表加注释
comment on table t_admin is ‘超级管理员’;
SQLCopy
宿舍报修表创建语句如下:
create table t_baoxiu(
id integer,
customerId int,
ssId int,
insertDate datetime,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
status varchar(100),
back varchar(100)
);
–宿舍报修字段加注释
comment on column t_baoxiu.id is ‘主键’;
comment on column t_baoxiu.customerId is ‘用户’;
comment on column t_baoxiu.ssId is ‘宿舍’;
comment on column t_baoxiu.insertDate is ‘报修时间’;
comment on column t_baoxiu.v1 is ‘简单说明’;
comment on column t_baoxiu.v2 is ‘详细问题’;
comment on column t_baoxiu.v3 is ‘图片’;
comment on column t_baoxiu.status is ‘状态’;
comment on column t_baoxiu.back is ‘维修说明’;
–宿舍报修表加注释
comment on table t_baoxiu is ‘宿舍报修’;
SQLCopy
用户表创建语句如下:
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
ssId int,
status varchar(100)
);
–用户字段加注释
comment on column t_customer.id is ‘主键’;
comment on column t_customer.username is ‘账号’;
comment on column t_customer.password is ‘密码’;
comment on column t_customer.customerName is ‘姓名’;
comment on column t_customer.headPic is ‘头像’;
comment on column t_customer.phone is ‘电话’;
comment on column t_customer.age is ‘年龄’;
comment on column t_customer.sex is ‘性别’;
comment on column t_customer.ssId is ‘宿舍’;
comment on column t_customer.status is ‘状态’;
–用户表加注释
comment on table t_customer is ‘用户’;
SQLCopy
公寓设备表创建语句如下:
create table t_gysb(
id integer,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
status varchar(100)
);
–公寓设备字段加注释
comment on column t_gysb.id is ‘主键’;
comment on column t_gysb.v1 is ‘设备名称’;
comment on column t_gysb.v2 is ‘设备位置’;
comment on column t_gysb.v3 is ‘设备作用’;
comment on column t_gysb.v4 is ‘负责人’;
comment on column t_gysb.status is ‘状态’;
–公寓设备表加注释
comment on table t_gysb is ‘公寓设备’;
SQLCopy
宿舍检查表创建语句如下:
create table t_jiancha(
id integer,
ssId int,
jianchaDate datetime,
v1 varchar(100),
v2 varchar(100),
status varchar(100)
);
–宿舍检查字段加注释
comment on column t_jiancha.id is ‘主键’;
comment on column t_jiancha.ssId is ‘宿舍’;
comment on column t_jiancha.jianchaDate is ‘检查时间’;
comment on column t_jiancha.v1 is ‘检查人’;
comment on column t_jiancha.v2 is ‘备注’;
comment on column t_jiancha.status is ‘是否违规’;
–宿舍检查表加注释
comment on table t_jiancha is ‘宿舍检查’;
SQLCopy
宿舍缴费表创建语句如下:
create table t_jiaofei(
id integer,
ssId int,
types varchar(100),
fee int,
content varchar(100),
showDate varchar(100),
status varchar(100)
);
–宿舍缴费字段加注释
comment on column t_jiaofei.id is ‘主键’;
comment on column t_jiaofei.ssId is ‘宿舍’;
comment on column t_jiaofei.types is ‘缴费类型’;
comment on column t_jiaofei.fee is ‘缴费金额’;
comment on column t_jiaofei.content is ‘费用说明’;
comment on column t_jiaofei.showDate is ‘缴费月份’;
comment on column t_jiaofei.status is ‘状态’;
–宿舍缴费表加注释
comment on table t_jiaofei is ‘宿舍缴费’;
SQLCopy
来访登记表创建语句如下:
create table t_lfdj(
id integer,
customerName varchar(100),
phone varchar(100),
sex varchar(100),
ssId int,
beginDate datetime,
endDate datetime,
remark varchar(100)
);
–来访登记字段加注释
comment on column t_lfdj.id is ‘主键’;
comment on column t_lfdj.customerName is ‘姓名’;
comment on column t_lfdj.phone is ‘电话’;
comment on column t_lfdj.sex is ‘性别’;
comment on column t_lfdj.ssId is ‘到访宿舍’;
comment on column t_lfdj.beginDate is ‘到访时间’;
comment on column t_lfdj.endDate is ‘结束时间’;
comment on column t_lfdj.remark is ‘备注’;
–来访登记表加注释
comment on table t_lfdj is ‘来访登记’;
SQLCopy
公寓设备保养表创建语句如下:
create table t_sbby(
id integer,
gysbId int,
a1 varchar(100),
a2 varchar(100),
a3 datetime,
a4 varchar(100)
);
–公寓设备保养字段加注释
comment on column t_sbby.id i