8-20.sql

石志国著《JSP应用教程》

Create Table sm_BasicInfo
(
	stu_ID Number Constraint sm_BIPK Primary Key,
	stu_Name Varchar(10) not null,
	stu_Sex Varchar(1) Constraint sm_CHK Check(stu_Sex in ('M', 'F'))
);
Create Table sm_History
(
	stu_HID Number Constraint sm_HPK Primary Key,
	stu_ID Number not null,
	Constraint sm_FK Foreign Key(stu_ID) References sm_BasicInfo
);