/ * Create management user table * /
Create Teble User (user_id char (6) Not null,
Passwd char (16) Not null,
ConsTRAINT Userid Primary Key (User_ID));
/ * Create an employee information table * /
Create Table Empinfo (ID Char (6) NOT NULL,
Name char (8) Not null,
Sex char (1),
Birthday Date,
DEPA_ID Char (6) Not null,
Job char (8),
Nation char (4),
ZZMM Char (8),
B_salary float not null,
Work_time float,
Memo varchar (200),
ConsTRAINT Empinfo_ID Primary Key (ID));
/ * Create an employee payable * /
Create Table Empsalary (ID Char (6) Not Null,
Name char (8) Not null,
Sex char (1),
DEPA_ID Char (6) Not null,
B_salary float not null,
Workday Integer,
Add Integer,
Butie float,
Fuli float,
TEX FLOAT,
Kouchu float,
JJ Float,
SJ Integer,
BJ Integer,
R_salary float,
ConsTRAINT Empsalary_ID Primary Key (ID));
/ * Create a department table * /
Create Table Depainfo (DEPA_ID CHAR (6) Not Null,
DEPA_NAME CHAR (12) Not null,
ConsTRAINT Depinfo_id Primary Key (dep_id));
/ * Create a recruitment schedule * /
Create Table Zpinfo (zp_id char (6) Not null,
Time Date,
DEPA_NAME CHAR (12),
Man INTEGER,
Require varchar (200),
ConsTRAINT ZPINFO_ID PRIMARY Key (ZP_ID));
/ * Create training plan * /
Create Table Pxinfo (PX_ID Char (6) Not NULL,
Time Date,
WHERE CHAR (20),
Object Cher (16),
DEPA_NAME CHAR (12),
Man INTEGER,
ConsTRAINT PXINFO_ID PRIMARY Key (PX_ID));
