创建表格sql.txt

数据库pb语言的一些程序示例,给pb学习者参考使用,希望能给大家带来帮助!

8.3.1 创建员工基本状况表格PERSONNEL
CREATE TABLE "NBXW".PERSONNEL 
(
EMP_NO  VARCHAR2(10)  NOT NULL, 
EMP_NAME  VARCHAR2(20)  NULL,
DEPT_ID  VARCHAR2(10)  NULL,
EMP_GENDER  VARCHAR2(2)  NULL, 
EMP_TELENO  NUMBER(10,0)  NULL, 
EMP_EMAIL  VARCHAR2(20)  NULL, 
CONSTRAINT  PERSONNEL_EMP_NO_PK  PRIMARY KEY (EMP_NO),
CONSTRAINT   PERSONNEL_DEPT_ID _FK  FOREIGN KEY (DEPT_ID) 
               REFERENCES  "NBXW"."DEPT"( DEPT_ID),
)
TABLESPACE "USER_DATA";
8.3.2 创建用户口令表USER_PSWD。
CREATE  TABLE  "NBXW".USER_PSWD 
(
NBXW_USER  VARCHAR2(20)  NULL, 
NBXW_PSWD  VARCHAR2(10)  NULL,  
CONSTRAINT  NBXW_USER_PK  PRIMARY KEY (NBXW_USER)
)
TABLESPACE "USER_DATA";
8.3.3 创建部门信息表DEPT
CREATE  TABLE  "NBXW".DEPT
(
DEPT_ID  ARCHAR2(10)  NOT NULL,
DEPT_NAME  VARCHAR2(20)  NULL, 
DEPT_MANAGER  VARCHAR2(10)  NULL, 
DEPT_VICEMANAGER  VARCHAR2(10)  NULL,
CONSTRAINT  DEPT_DEPT_ID_PK  PRIMARY KEY (DEPT_ID),
CONSTRAINT  DEPT_MANAGER_FK  FOREIGN KEY (DEPT_MANAGER) 
               REFERENCES  "NBXW"."PERSONNEL"(EMP_NO),
CONSTRAINT  DEPT_VICEMANAGER_FK FOREIGN KEY 
               (DEPT_VICEMANAGER) 
               REFERENCES  "NBXW"."PERSONNEL"(EMP_NO)
)  
TABLESPACE "USER_DATA";
8.3.4 创建内部行文信息表XW
CREATE  TABLE  "NBXW".XW  
(
XW_ID  VARCHAR2(20)  NULL, 
XW_NAME  VARCHAR2(20)  NULL, 
XW_AUTHER  VARCHAR2(10)  NULL, 
XW_CONTEXT  VARCHAR2(50)  NULL,
XW_FLAG NUMBER(2) NULL, 
XW_DATE DATE NULL,
CONSTRAINT  XW_XW_ID_PK  
               PRIMARY KEY (XW_ID)
)
TABLESPACE "USER_DATA";
8.3.5 创建内部行文处理信息表XWCL
CREATE  TABLE  "NBXW".XWCL
 (
XW_ID  VARCHAR2(20)  NULL, 
XW_NAME  VARCHAR2(20)  NULL, 
XW_AUTHER  VARCHAR2(10)  NULL, 
XW_RECEIVER  VARCHAR2(10)  NULL, 
XW_CONTEXT  VARCHAR2(50)  NULL, 
XW_REMARK  VARCHAR2(50)  NULL, 
XW_DATE DATE NULL,
CONSTRAINT  XWCL_ID_RECEIVER_PK  
               PRIMARY KEY (XW_ID,XW_RECEIVER)
)
TABLESPACE "USER_DATA";