mydb.sql

来自「delphi的学习资料」· SQL 代码 · 共 32 行

Create DataBase "D:\MyD\MyDatB\MyDB.gdb"
   	User "My"  	PassWord "123";

/*  Table: Basic */
Create Table Basic (
        sNo	Integer  Not Null,
  	Name 	Char(10) Default '?' Not Null,
  	Sex 	Char(1)  Default '?',
    	Birth 	Char(4),
  	High 	SmallInt,
  	Weight 	SmallInt,
Constraint Basic_PKey Primary Key(sNo) 
);


/*  Table: Study */
Create Table Study (
        sNo	Integer  Not Null,
  	Sub1 	real  Default 0,
  	Sub2 	real  Default 0,
  	Sub3 	real  Default 0,
  	SumM 	real  Default 0,
  	Mean 	real  Default 0,
    	Stage 	Char(2),
CHECK (sub1>=0 and sub1<=100),
CHECK (sub2>=0 and sub2<=100),
Constraint CC_Sub3 CHECK (sub3>=0 and sub3<=100),
Constraint Study_PKey Primary Key(sNo), 
Foreign Key (sNO) References Basic(sNO)
);