person.sql

来自「一个招聘管理系统」· SQL 代码 · 共 23 行

USE Job
GO
CREATE TABLE Person (
UserName 	Varchar (20) PRIMARY KEY,
Pwd 	Varchar (20) NOT NULL ,
RealName 	Varchar (50) NOT NULL ,
Sex 	Bit NOT NULL ,
Birth 	Varchar (50),
IDCard 	Varchar (20),
Nature 	Varchar (20),
Married 	Varchar (10) ,
HuKou 	Varchar (20) ,
Location 	Varchar (20) ,
Education 	Varchar (20),
College 	Varchar (50),
Telephone 	Varchar (50),
Mobile 	Varchar (50),
Email 	Varchar (50),
Address 	Varchar (200),
PostTime 	Datetime
)
GO