学生.sql

来自「这是我自己做的系统 很不完善 不足之处请多多指教！」· SQL 代码 · 共 21 行

CREATE TABLE Students
  (Student_Id		Int Primary Key,
   Student_Name    	Varchar(50) NOT NULL,
   Photo		Image,
   Sex			Char(2),
   Nationality		Varchar(40),
   Birth		Varchar(20),
   Political_Party	Varchar(40),
   Family_Place		Varchar(60),
   Id_Card		Varchar(20),
   BadgeID		Varchar(40),
   Home_phone		Varchar(30),
   Residence		Varchar(100),
   Postcode		Varchar(10),
   InDate		Varchar(20),
   Class_Id		SmallInt,
   Title		Varchar(20),
   Memo			Varchar(200),
   Fillin_Time		Varchar(20)
  )