小区停车管理系统
小区停车管理系统mysql数据库创建语句
小区停车管理系统oracle数据库创建语句
小区停车管理系统sqlserver数据库创建语句
小区停车管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
小区停车管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
小区停车管理系统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_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 ‘性别’,
types varchar(100) comment ‘用户类型’
) comment ‘用户’;
SQLCopy
车位表创建语句如下:
create table t_cw(
id int primary key auto_increment comment ‘主键’,
cwName varchar(100) comment ‘车位编号’,
qw varchar(100) comment ‘区位’,
status varchar(100) comment ‘状态’,
mqcp varchar(100) comment ‘目前车牌’
) comment ‘车位’;
SQLCopy
物业公告表创建语句如下:
create table t_gonggao(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘标题’,
pic varchar(100) comment ‘图片’,
content varchar(100) comment ‘内容’,
showDate datetime comment ‘日期’
) comment ‘物业公告’;
SQLCopy
ic卡表创建语句如下:
create table t_ick(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
ickName varchar(100) comment ‘ic卡号’,
cp varchar(100) comment ‘车牌’,
fee varchar(100) comment ‘余额’
) comment ‘ic卡’;
SQLCopy
进入记录表创建语句如下:
create table t_jilu(
id int primary key auto_increment comment ‘主键’,
cp varchar(100) comment ‘车牌’,
beginDate datetime comment ‘进入时间’,
endDate datetime comment ‘出去时间’
) comment ‘进入记录’;
SQLCopy
通知表创建语句如下:
create table t_tongzhi(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
title varchar(100) comment ‘标题’,
content varchar(100) comment ‘内容’,
insertDate datetime 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_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
types 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.types is ‘用户类型’;
–用户表加注释
comment on table t_customer is ‘用户’;
SQLCopy
车位表创建语句如下:
create table t_cw(
id integer,
cwName varchar(100),
qw varchar(100),
status varchar(100),
mqcp varchar(100)
);
–车位字段加注释
comment on column t_cw.id is ‘主键’;
comment on column t_cw.cwName is ‘车位编号’;
comment on column t_cw.qw is ‘区位’;
comment on column t_cw.status is ‘状态’;
comment on column t_cw.mqcp is ‘目前车牌’;
–车位表加注释
comment on table t_cw is ‘车位’;
SQLCopy
物业公告表创建语句如下:
create table t_gonggao(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100),
showDate datetime
);
–物业公告字段加注释
comment on column t_gonggao.id is ‘主键’;
comment on column t_gonggao.title is ‘标题’;
comment on column t_gonggao.pic is ‘图片’;
comment on column t_gonggao.content is ‘内容’;
comment on column t_gonggao.showDate is ‘日期’;<