selectinfo.sql

来自「学生选课系统无数据库」· SQL 代码 · 共 42 行

create database SelectInfo;
use System;

create table BaseInfo(
studentUID     char(10)  primary key,
studentname    char(8)   not null,
studentgender  char(1)   not null check(sex='F' or sex='M'),
age            int       not null,
dept           char(20)  default 'Computer' ,
studentCode    int,
studentclass   char(20)    not null,

);

create table Techer(
teachername char(8)   primary key, teachergender char(1)   not null  check(sex='F' or sex='M'),
age  int       not null   ,
tech char(20)  not null,
password  char(20)      not null
);

create table Lib(
name   char(8)   primary key,
sex    char(1)   not null check(sex='F' or sex='M'),
age    int       not null,
user  char(20)   not null,
password  char(20)      not null
);

create table ClassInfo
(
classUID char(4),
className char(10),
classTeacher char(10),
classTime char(18),
classRoom char(4),
classCredit char(12),
);