创建表格的sql.txt

为中小企业考勤管理所写。PB开发

REM user: kq 建立用户
create user kq
identified by ok
default tablespace USER_DATA
temporary tablespace temp_USER_DATA
quota unlimited on USER_DATA
quota unlimited on Temp_USER_DATA
quota unlimited on Index_USER_DATA;
REM 授给用户kq的权限
grant connect,resource,DBA to kq;
REM 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";
REM 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";
REM 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";