表设计

create table Staff_Info
(
 ID int primary key identity(1,1),
 Staff_NO varchar(10),
 Staff_Password varchar(50),
 Staff_Name  varchar(20),
 Staff_Sex varchar(2),
 Staff_ID_Card varchar(20),
 Staff_Status int,
 Staff_Work_Dept_id int,
 Work_Dept_Name varchar(50),
 Staff_Birthday  date,
 Staff_Left_Date date,
)

create table Department_Info(
 ID int primary key identity(1,1),
 Dept_NO varchar(20),
 Dept_Name varchar(50),
 Dept_Leader_ID  int,
 Dept_Seq int,
 Dept_Parent_ID int,
 Dept_Build_Date date,
 Dept_Cancel_Date date,
 Dept_Status int,
 Dept_Second_Leader_ID int,
 Dept_Update_User  varchar(50),
 Dept_Status_Time date,
)