用sql创建一个有身份,用户名,密码,学号,姓名,高数,c语言,java,英语,高数考场,c语言考场,java考场,英语考场的学生表与一个有身份,用户名,密码,教工号,姓名,性别,工资,职称,年龄,科目的教师表
时间: 2024-05-03 15:23:02 浏览: 36
创建学生表:
```
CREATE TABLE student (
id INT NOT NULL AUTO_INCREMENT,
identity VARCHAR(10) NOT NULL,
username VARCHAR(20) NOT NULL,
password VARCHAR(20) NOT NULL,
student_id VARCHAR(10) NOT NULL,
name VARCHAR(20) NOT NULL,
math_grade INT DEFAULT 0,
c_grade INT DEFAULT 0,
java_grade INT DEFAULT 0,
english_grade INT DEFAULT 0,
math_exam VARCHAR(20) DEFAULT NULL,
c_exam VARCHAR(20) DEFAULT NULL,
java_exam VARCHAR(20) DEFAULT NULL,
english_exam VARCHAR(20) DEFAULT NULL,
PRIMARY KEY (id)
);
```
创建教师表:
```
CREATE TABLE teacher (
id INT NOT NULL AUTO_INCREMENT,
identity VARCHAR(10) NOT NULL,
username VARCHAR(20) NOT NULL,
password VARCHAR(20) NOT NULL,
teacher_id VARCHAR(10) NOT NULL,
name VARCHAR(20) NOT NULL,
gender VARCHAR(10) NOT NULL,
salary DECIMAL(10,2) NOT NULL,
title VARCHAR(20) NOT NULL,
age INT NOT NULL,
subject VARCHAR(20) NOT NULL,
PRIMARY KEY (id)
);
```