5.3.1 創建考勤管理表格kq
CREATE TABLE "KQ".kq 
(
emp_no VARCHAR2(6) Not NULL, 
qq_date DATE NULL, 
qq_daynumber NUMBER(2) NULL, 
qq_lb VARCHAR2(3) NULL, 
qq_reason VARCHAR2(10) NULL, 
CONSTRAINT  kq_emp_date_pk  PRIMARY KEY (emp_no, qq_date)
)
TABLESPACE "USER_DATA";
5.3.2 創建缺勤類型表格qqlb
CREATE TABLE "KQ".qqlb 
(
qq_lb VARCHAR2(3) Not NULL, 
qq_mc VARCHAR2(10) NULL, 
qq_ms VARCHAR2(10) NULL, 
CONSTRAINT  qq_lb_pk  PRIMARY KEY (qq_lb)
)
TABLESPACE "USER_DATA";
5.3.5 創建員工基本情況表yg
CREATE TABLE "KQ".yg 
(
emp_no VARCHAR2(6) NULL, 
emp_name VARCHAR2(10) NULL, 
emp_zw VARCHAR2(10) NULL, 
emp_department VARCHAR2(10) NULL,  
CONSTRAINT yg_emp_no_pk PRIMARY KEY (emp_no)
) 
TABLESPACE "USER_DATA";