建立数据库表格的一些例子

宿舍表格记录

CREATA TABLE Room(

DorNo   CHAR(2) PRIMARY KEY,

RNo   CHAR(3)PRIMARY KEY ,

Rtel  CHAR(12),

Hold_all   CHAR(2),

Hold_now   CHAR(2),

Accommodation_fee  CHAR(10));

 

 

学生表格住宿记录

CREATA TABLE Student(

StuNo   CHAR(8) PRIMARY KEY,

StuName  VARCHAR(10),

Sex  CHAR(2),

Stumajor  VARCHAR(20),

StuTel  CHAR(11),

StuTime  CHAR(9),

DorNo CHAR(3),

RNo CHAR(2),

Class CHAR(15)

 

);

 

 

 

报修表格记录

 

 

CREATA TABLE  Repair(

DorNo CHAR(6),

 RNo  CHAR(6) PRIMARY KEY,

FitName  CHAR(8),

 Repair_reason  CHAR(50),

react_time CHAR(10),

reactman CHAR(10),

 

);

 

 

 

 

水电费表格记录

CREATA TABLE  Water_Electricr(

DorNo CHAR(2),

RNo  CHAR(3) PRIMARY KEY,

Months  VARCHAR(4),

Elect DECIMAL(5,2),

Eprice DECIMAL(5,2),

Water DECIMAL(5,2),

 

);