数据库中表的相关配置.md

本项目数据库名称是system_db,一共有5张表

1.admin_reservation

create table admin_reservation
(
    classroomId varchar(30) not null,
    teacherId   varchar(10) not null,
    teacherName varchar(30) not null,
    submitTime  varchar(50) not null,
    reserveTime varchar(50) not null,
    state       varchar(5)  not null
);

2.classroom

create table classroom
(
    id            varchar(30) not null,
    className     varchar(30) not null,
    classroomType varchar(30) not null,
    maxPeople     int         not null,
    aircondition  int         not null,
    camera        int         not null,
    reserveTime   varchar(30) not null,
    state         varchar(5)  not null
);

3.teacher

create table teacher
(
    id        varchar(10) not null,
    name      varchar(20) not null,
    gender    char        not null,
    age       int         not null,
    telephone varchar(20) not null,
    academy   varchar(30) not null,
    office    varchar(30) not null,
    position  varchar(30) not null,
    constraint teacher_telephone_uindex
        unique (telephone)
);

4.user_admin

create table user_admin
(
    username varchar(10)                  not null,
    password varchar(30) default '123456' not null
);

5.user_teacher

create table user_teacher
(
    username varchar(10) not null,
    password varchar(50) not null
);