📄 table_sql.sql
字号:
CREATE TABLE SFCHR.C_CLASS_DESC_T
(
CLASS_NO VARCHAR2(25 BYTE) NOT NULL,
CLASS_NAME VARCHAR2(25 BYTE) NOT NULL,
START_TIME VARCHAR2(20 BYTE),
END_TIME VARCHAR2(20 BYTE),
CLASS_DESC VARCHAR2(40 BYTE),
DEPART VARCHAR2(25 BYTE)
)
TABLESPACE D_SFIS1_DATA_01
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 256K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL
MONITORING;
CREATE TABLE SFCHR.C_DEPARTMENT_DESC_T
(
DEPARTMENT_NO VARCHAR2(20 BYTE) NOT NULL,
DEPARTMENT_NAME VARCHAR2(40 BYTE) NOT NULL,
FEE_NO VARCHAR2(20 BYTE),
MANAGER_NO VARCHAR2(20 BYTE),
DEPARTMENT_DESC VARCHAR2(40 BYTE)
)
TABLESPACE D_SFIS1_DATA_01
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 256K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL
MONITORING;
CREATE TABLE SFCHR.C_EMP_DESC_T
(
EMP_NO VARCHAR2(25 BYTE) NOT NULL,
EMP_NAME VARCHAR2(20 BYTE) NOT NULL,
DEPARTMENT_NO VARCHAR2(10 BYTE),
LINE_NAME VARCHAR2(20 BYTE),
CLASS_NAME VARCHAR2(10 BYTE),
EMP_RANK VARCHAR2(10 BYTE),
QUIT_DATE DATE
)
TABLESPACE D_SFIS1_DATA_01
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 256K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL
MONITORING;
CREATE TABLE SFCHR.HRB_FILE
(
HRB01 VARCHAR2(8 BYTE),
HRB02 VARCHAR2(8 BYTE),
HRB03 VARCHAR2(8 BYTE),
HRB04 VARCHAR2(12 BYTE),
HRB05 VARCHAR2(8 BYTE),
HRB06 VARCHAR2(4 BYTE),
HRB07 VARCHAR2(10 BYTE),
HRB08 VARCHAR2(4 BYTE),
HRB09 VARCHAR2(16 BYTE),
HRB10 VARCHAR2(1 BYTE),
HRBACTI VARCHAR2(1 BYTE),
FLAG NUMBER DEFAULT 0
)
TABLESPACE D_SFISM4_DATA_01
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 256K
NEXT 128K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL
MONITORING;
CREATE TABLE SFCHR.HRD_FILE
(
HRD01 VARCHAR2(4 BYTE) NOT NULL,
HRD02 VARCHAR2(16 BYTE),
HRD03 VARCHAR2(1 BYTE),
HRD04 VARCHAR2(4 BYTE),
HRD04SS VARCHAR2(4 BYTE),
HRD04SX VARCHAR2(4 BYTE),
HRD05 VARCHAR2(4 BYTE),
HRD05XS VARCHAR2(4 BYTE),
HRD05XX VARCHAR2(4 BYTE),
HRD06 NUMBER(5),
HRD07 NUMBER(5),
HRD08 VARCHAR2(4 BYTE),
HRDACTI VARCHAR2(1 BYTE),
HRDUSER VARCHAR2(10 BYTE),
HRDGRUP VARCHAR2(6 BYTE),
HRDMODU VARCHAR2(10 BYTE),
HRDDATE DATE
)
TABLESPACE D_SFIS1_DATA_01
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL
MONITORING;
CREATE TABLE SFCHR.R_SCANE_ERRORLOG_T
(
WORK_DATE VARCHAR2(20 BYTE) NOT NULL,
EMP_NO VARCHAR2(25 BYTE) NOT NULL,
EMP_NAME VARCHAR2(20 BYTE),
ERROR_LOG VARCHAR2(100 BYTE),
ERRORDATE DATE,
ERROR_CODE VARCHAR2(4 BYTE) NOT NULL
)
TABLESPACE D_SFISM4_DATA_01
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 256K
NEXT 128K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL
MONITORING;
CREATE TABLE SFCHR.R_TEMP_RECORD_T
(
RD1 VARCHAR2(25 BYTE),
RD2 VARCHAR2(25 BYTE),
RD3 VARCHAR2(25 BYTE),
RD4 VARCHAR2(25 BYTE),
RD5 VARCHAR2(25 BYTE),
RD6 VARCHAR2(25 BYTE),
RD7 VARCHAR2(25 BYTE),
RD8 VARCHAR2(25 BYTE),
RD9 VARCHAR2(25 BYTE)
)
TABLESPACE D_SFIS1_DATA_01
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 256K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL
MONITORING;
CREATE TABLE SFCHR.R_WORK_SCANERECORD_T
(
WORK_DATE VARCHAR2(20 BYTE) NOT NULL,
EMP_NO VARCHAR2(25 BYTE) NOT NULL,
LINE_NAME VARCHAR2(20 BYTE),
CLASS_NAME VARCHAR2(10 BYTE),
IN_WORK_TIME DATE,
OUT_WORK_TIME DATE
)
TABLESPACE D_SFISM4_DATA_01
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 256K
NEXT 128K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL
MONITORING;
CREATE INDEX SFCHR.HRBFILE_HRB01 ON SFCHR.HRB_FILE
(HRB01)
LOGGING
TABLESPACE I_SFISM4_INDEX_01
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 192K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE UNIQUE INDEX SFCHR.PK_DEPARTMENT_DESC ON SFCHR.C_DEPARTMENT_DESC_T
(DEPARTMENT_NO)
LOGGING
TABLESPACE I_SFIS1_INDEX_01
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 192K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE UNIQUE INDEX SFCHR.PK_EMPDATE_DESC ON SFCHR.R_WORK_SCANERECORD_T
(WORK_DATE, EMP_NO)
LOGGING
TABLESPACE I_SFISM4_INDEX_01
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 192K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE UNIQUE INDEX SFCHR.PK_EMP_DESC ON SFCHR.C_EMP_DESC_T
(EMP_NO)
LOGGING
TABLESPACE I_SFIS1_INDEX_01
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 192K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE INDEX SFCHR.SCANELOG_WORKDATE ON SFCHR.R_SCANE_ERRORLOG_T
(WORK_DATE)
LOGGING
TABLESPACE I_SFISM4_INDEX_01
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 192K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE INDEX SFCHR.SCANERECORD_WORKDATE ON SFCHR.R_WORK_SCANERECORD_T
(WORK_DATE)
LOGGING
TABLESPACE I_SFISM4_INDEX_01
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 192K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
ALTER TABLE SFCHR.C_CLASS_DESC_T ADD (
CONSTRAINT PK_CLASS_DESC PRIMARY KEY (CLASS_NO) DISABLE);
ALTER TABLE SFCHR.C_DEPARTMENT_DESC_T ADD (
CONSTRAINT PK_DEPARTMENT_DESC PRIMARY KEY (DEPARTMENT_NO)
USING INDEX
TABLESPACE I_SFIS1_INDEX_01
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 192K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
));
ALTER TABLE SFCHR.C_EMP_DESC_T ADD (
CONSTRAINT PK_EMP_DESC PRIMARY KEY (EMP_NO)
USING INDEX
TABLESPACE I_SFIS1_INDEX_01
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 192K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
));
ALTER TABLE SFCHR.R_WORK_SCANERECORD_T ADD (
CONSTRAINT PK_EMPDATE_DESC PRIMARY KEY (WORK_DATE, EMP_NO)
USING INDEX
TABLESPACE I_SFISM4_INDEX_01
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 192K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
));
ALTER TABLE SFCHR.C_EMP_DESC_T ADD (
CONSTRAINT FK_DEPARTMENTNO FOREIGN KEY (DEPARTMENT_NO)
REFERENCES SFCHR.C_DEPARTMENT_DESC_T (DEPARTMENT_NO)
ON DELETE SET NULL);
GRANT SELECT ON SFCHR.C_CLASS_DESC_T TO PUBLIC;
GRANT SELECT ON SFCHR.C_CLASS_DESC_T TO SFIS1;
GRANT SELECT ON SFCHR.C_DEPARTMENT_DESC_T TO PUBLIC;
GRANT INSERT, UPDATE ON SFCHR.C_DEPARTMENT_DESC_T TO SFIS1;
GRANT SELECT ON SFCHR.C_EMP_DESC_T TO PUBLIC;
GRANT DELETE, INSERT, UPDATE ON SFCHR.C_EMP_DESC_T TO SFIS1;
GRANT DELETE, INSERT, UPDATE ON SFCHR.HRB_FILE TO F3400487;
GRANT SELECT ON SFCHR.HRB_FILE TO PUBLIC;
GRANT DELETE, INSERT, SELECT, UPDATE ON SFCHR.HRB_FILE TO SFIS1;
GRANT DELETE, INSERT, UPDATE ON SFCHR.HRD_FILE TO F3400487;
GRANT SELECT ON SFCHR.R_SCANE_ERRORLOG_T TO PUBLIC;
GRANT INSERT, SELECT ON SFCHR.R_SCANE_ERRORLOG_T TO SFIS1;
GRANT DELETE, INSERT, SELECT, UPDATE ON SFCHR.R_TEMP_RECORD_T TO SFIS1;
GRANT DELETE, INSERT, UPDATE ON SFCHR.R_WORK_SCANERECORD_T TO F3400487;
GRANT SELECT ON SFCHR.R_WORK_SCANERECORD_T TO PUBLIC;
GRANT INSERT, UPDATE ON SFCHR.R_WORK_SCANERECORD_T TO SFIS1;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -