消防安全培训系统
消防安全培训系统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_contact(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
phone varchar(100) comment ‘联系方式’,
content varchar(100) comment ‘内容’,
insertDate datetime comment ‘日期’
) comment ‘建议’;
SQLCopy
客户表创建语句如下:
create table t_customer(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
name varchar(100) comment ‘姓名’,
sex varchar(100) comment ‘性别’,
address varchar(100) comment ‘地址’,
mobile varchar(100) comment ‘手机’
) comment ‘客户’;
SQLCopy
试卷表创建语句如下:
create table t_exam(
id int primary key auto_increment comment ‘主键’,
examName varchar(100) comment ‘名称’,
showDate varchar(100) comment ‘日期’,
status varchar(100) comment ‘状态’,
ny varchar(100) comment ‘’
) comment ‘试卷’;
SQLCopy
答案表创建语句如下:
create table t_examanswer(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
examName varchar(100) comment ‘试卷名称’,
insertDate datetime comment ‘日期’,
tm varchar(100) comment ‘题目’,
da varchar(100) comment ‘客户答案’,
answer varchar(100) comment ‘正确答案’,
batchId varchar(100) comment ‘’,
df varchar(100) comment ‘’,
v1 int comment ‘’,
v2 int comment ‘’,
v3 int comment ‘’,
isdl varchar(100) comment ‘’
) comment ‘答案’;
SQLCopy
试卷题目表创建语句如下:
create table t_examlist(
id int primary key auto_increment comment ‘主键’,
examId int comment ‘试卷’,
examtmId int comment ‘题目’
) comment ‘试卷题目’;
SQLCopy
考试题目表创建语句如下:
create table t_examtm(
id int primary key auto_increment comment ‘主键’,
types int comment ‘类型’,
v1 varchar(100) comment ‘题目标题’,
v2 varchar(100) comment ‘选项A’,
v3 varchar(100) comment ‘选项B’,
v4 varchar(100) comment ‘选项C’,
v5 varchar(100) comment ‘选项D’,
v6 varchar(100) comment ‘答案’,
v7 varchar(100) comment ‘题目’,
v8 varchar(100) comment ‘答案’,
v9 varchar(100) comment ‘题目’,
v10 varchar(100) comment ‘答案’
) comment ‘考试题目’;
SQLCopy
老师表创建语句如下:
create table t_jky(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
jkyName varchar(100) comment ‘姓名’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’,
phone varchar(100) comment ‘电话’
) comment ‘老师’;
SQLCopy
学习计划表创建语句如下:
create table t_ljyy(
id int primary key auto_increment comment ‘主键’,
v1 varchar(100) comment ‘标题’,
v2 varchar(100) comment ‘内容’,
v3 varchar(100) comment ‘备注’,
customerId int comment ‘’
) comment ‘学习计划’;
SQLCopy
帖子表创建语句如下:
create table t_luntan(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘标题’,
pic varchar(100) comment ‘图片’,
content varchar(100) comment ‘描述’
) comment ‘帖子’;
SQLCopy
评论表创建语句如下:
create table t_pinglun(
id int primary key auto_increment comment ‘主键’,
name varchar(100) comment ‘姓名’,
content varchar(100) comment ‘内容’,
insertDate datetime comment ‘日期’,
luntanId int comment ‘帖子’
) comment ‘评论’;
SQLCopy
消防安全知识管理表创建语句如下:
create table t_sjyy(
id int primary key auto_increment comment ‘主键’,
v1 varchar(100) comment ‘标题’,
v2 varchar(100) comment ‘内容’,
v3 varchar(100) comment ‘备注’
) comment ‘消防安全知识管理’;
SQLCopy
在线答疑表创建语句如下:
create table t_zxdy(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘学生’,
content varchar(100) comment ‘内容’,
insertDate datetime comment ‘发起日期’,
jkyId int comment ‘’,
back varchar(100) comment ‘回复’,
backDate datetime comment ‘回复日期’,
status 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_contact(
id integer,
customerId int,
phone varchar(100),
content varchar(100),
insertDate datetime
);
–建议字段加注释
comment on column t_contact.id is ‘主键’;
comment on column t_contact.customerId is ‘用户’;
comment on column t_contact.phone is ‘联系方式’;
comment on column t_contact.content is ‘内容’;
comment on column t_contact.insertDate is ‘日期’;
–建议表加注释
comment on table t_contact is ‘建议’;
SQLCopy
客户表创建语句如下:
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
name varchar(100),
sex varchar(100),
address varchar(100),
mobile 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.name is ‘姓名’;
comment on column t_customer.sex is ‘性别’;
comment on column t_customer.address is ‘地址’;
comment on column t_customer.mobile is ‘手机’;
–客户表加注释
comment on table t_customer is ‘客户’;
SQLCopy
试卷表创建语句如下:
create table t_exam(
id integer,
examName varchar(100),
showDate varchar(100),
status varchar(100),
ny varchar(100)
);
–试卷字段加注释
comment on column t_exam.id is ‘主键’;
comment on column t_exam.examName is ‘名称’;
comment on column t_exam.showDate is ‘日期’;
comment on column t_exam.status is ‘状态’;
comment on column t_exam.ny is ‘’;
–试卷表加注释
comment on table t_exam is ‘试卷’;
SQLCopy
答案表创建语句如下:
create table t_examanswer(
id integer,
customerId int,
examName varchar(100),
insertDate datetime,
tm varchar(100),
da varchar(100),
answer varchar(100),
batchId varchar(100),
df varchar(100),
v1 int,
v2 int,
v3 int,
isdl varchar(100)
);
–答案字段加注释
comment on column t_examanswer.id is ‘主键’;
comment on column t_examanswer.customerId is ‘用户’;
comment on column t_examanswer.examName is ‘试卷名称’;
comment on column t_examanswer.insertDate is ‘日期’;
comment on column t_examanswer.tm is ‘题目’;
comment on column t_examanswer.da is ‘客户答案’;
comment on column t_examanswer.answer is ‘正确答案’;
comment on column t_examanswer.batchId is ‘’;
comment on column t_examanswer.df is ‘’;
comment on column t_examanswer.v1 is ‘’;
comment on column t_examanswer.v2 is ‘’;
comment on column t_examanswer.v3 is ‘’;
comment on column t_examanswer.isdl is ‘’;
–答案表加注释
comment on table t_examanswer is ‘答案’;
SQLCopy
试卷题目表创建语句如下:
create table t_examlist(
id integer,
examId int,
examtmId int
);
–试卷题目字段加注释
comment on column t_examlist.id is ‘主键’;
comment on column t_examlist.examId is ‘试卷’;
comment on column t_examlist.examtmId is ‘题目’;
–试卷题目表加注释
comment on table t_examlist is ‘试卷题目’;
SQLCopy
考试题目表创建语句如下:
create table t_examtm(
id integer,
types int,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
v6 varchar(100),
v7 varchar(100),
v8 varchar(100),
v9 varchar(100),
v10 varchar(100)
);
–考试题目字段加注释
comment on column t_examtm.id is ‘主键’;
comment on column t_examtm.types is ‘类型’;
comment on column t_examtm.v1 is ‘题目标题’;
comment on column t_examtm.v2 is ‘选项A’;
comment on column t_examtm.v3 is ‘选项B’;
comment on column t_examtm.v4 is ‘选项C’;
comment on column t_examtm.v5 is ‘选项D’;
comment on column t_examtm.v6 is ‘答案’;
comment on column t_examtm.v7 is ‘题目’;
comment on column t_examtm.v8 is ‘答案’;
comment on column t_examtm.v9 is ‘题目’;
comment on column t_examtm.v10 is ‘答案’;
–考试题目表加注释
comment on table t_examtm is ‘考试题目’;
SQLCopy
老师表创建语句如下:
create table t_jky(
id integer,
username varchar(100),
password varchar(100),
jkyName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100)
);
–老师字段加注释
comment on column t_jky.id is ‘主键’;
comment on column t_jky.username is ‘账号’;
comment on column t_jky.password is ‘密码’;
comment on column t_jky.jkyName is ‘姓名’;
comment on column t_jky.age is ‘年龄’;
comment on column t_jky.sex is ‘性别’;
comment on column t_jky.phone is ‘电话’;
–老师表加注释
comment on table t_jky is ‘老师’;
SQLCopy
学习计划表创建语句如下:
cre