oa的一个小项目，可以供研究学习使用

CREATE TABLE task( task_ID NUMBER PRIMARY KEY, task_name VARCHAR2(20) NOT NULL); CREATE SEQUENCE seq_task; CREATE OR REPLACE TRIGGER tri_task BEFORE INSERT ON task FOR EACH ROW DECLARE v_num INT; BEGIN SELECT seq_task.NEXTVAL INTO v_num FROM dual; :NEW.task_id:=v_num; END; / CREATE TABLE WorkFlowType( type_id NUMBER PRIMARY KEY, type_name VARCHAR2(20) NOT NULL); CREATE SEQUENCE seq_type; CREATE OR REPLACE TRIGGER tri_type BEFORE INSERT ON WorkFlowType FOR EACH ROW DECLARE v_num INT; BEGIN SELECT seq_type.NEXTVAL INTO v_num FROM dual; :NEW.type_id:=v_num; END; / CREATE TABLE WorkFlowBean( auto_id NUMBER PRIMARY KEY, processName VARCHAR2(20) NOT NULL, content VARCHAR2(100), EXPIRE NUMBER NOT NULL, haveRole NUMBER NOT NULL, type_id NUMBER REFERENCES workflowtype(type_id)); CREATE SEQUENCE seq_workflowBean; CREATE OR REPLACE TRIGGER tri_workflowBean BEFORE INSERT ON WorkFlowBean FOR EACH ROW DECLARE v_num INT; BEGIN SELECT seq_workflowBean.NEXTVAL INTO v_num FROM dual; :NEW.auto_id:=v_num; END; / create table WorkFlowInstance( auto_id number primary key, workFlow_id number references WorkFlowBean (auto_id) not null, instanceName varchar2(20), beginDate Date default sysdate, endDate Date , finished number , content varchar2(100) not null, applicatPerson number references employee(employeeId) not null); CREATE SEQUENCE seq_workflowInstance; CREATE OR REPLACE TRIGGER tri_workflowInstance BEFORE INSERT ON WorkFlowInstance FOR EACH ROW DECLARE v_num INT; BEGIN SELECT seq_workflowInstance.NEXTVAL INTO v_num FROM dual; :NEW.auto_id:=v_num; END; / CREATE TABLE WorkFlowNodeBean( auto_id NUMBER PRIMARY KEY, indexOrder NUMBER NOT NULL, nodeName VARCHAR2(20) NOT NULL, workFlowId NUMBER REFERENCES workflowbean(auto_id ) not null, DESCRIPTION VARCHAR2(20), task_id NUMBER REFERENCES task(task_ID ) not null, employee_id NUMBER REFERENCES employee(employeeId) not null); CREATE SEQUENCE seq_workflownodebean; CREATE OR REPLACE TRIGGER tri_workflownodeBean BEFORE INSERT ON WorkFlowNodeBean FOR EACH ROW DECLARE v_num INT; BEGIN SELECT seq_workflownodebean.NEXTVAL INTO v_num FROM dual; :NEW.auto_id:=v_num; END; / create table workFlowInstanceNode( auto_id number primary key, instanceId number references WorkFlowInstance(auto_id) not null, indexOrder number not null, nodeId number references WorkFlowNodeBean(auto_id) not null, status number, task_id number not null, employee_id number not null); CREATE SEQUENCE seq_workFlowInstanceNode; CREATE OR REPLACE TRIGGER tri_workFlowInstanceNode BEFORE INSERT ON workFlowInstanceNode FOR EACH ROW DECLARE v_num INT; BEGIN SELECT seq_workFlowInstanceNode.NEXTVAL INTO v_num FROM dual; :NEW.auto_id:=v_num; END; / INSERT INTO task (task_name ) VALUES('校验'); INSERT INTO task (task_name ) VALUES('初审'); insert into workFlowType(type_name) values('婚假'); insert into workFlowType(type_name) values('病假'); commit;