ddl

--外派信息

DROP TABLE IF EXISTS t_outsourcing;

CREATE TABLE t_outsourcing

(

  outsourcingid integer NOT NULL,

  employeeid integer,

  outtype VARCHAR,

  startdate timestamp,

  enddate timestamp,

  destination VARCHAR(50),

  deptno VARCHAR(20),

  groupname character varying,

  createuserid integer NOT NULL,

  createdate timestamp NOT NULL,

  updateuserid integer NOT NULL,

  updatedate timestamp NOT NULL,

  CONSTRAINT t_outsourcing_pk PRIMARY KEY (outsourcingid)

);

--支援部门辅助输入

insert into S_INPUTHELPER (INPUTHELPERID, INPUTHELPERNAME)values('OutSourcing', '支援部门');

insert into S_INPUTHELPER_CONDITION (INPUTHELPERID, CONDITIONID, CONDITIONNAME)values('OutSourcing','groupname', '组织名称');

insert into S_INPUTHELPER_CONDITION (INPUTHELPERID, CONDITIONID, CONDITIONNAME)values('OutSourcing','deptname', '部门名称');

insert into S_INPUTHELPER_HEADER (INPUTHELPERID, HEADERID, HEADERNAME, HEADERWIDTH, HEADERSHOW)values('OutSourcing', 'groupname', '组织名称', '100', true);

insert into S_INPUTHELPER_HEADER (INPUTHELPERID, HEADERID, HEADERNAME, HEADERWIDTH, HEADERSHOW)values('OutSourcing', 'deptno', '部门名称', '100', true);

insert into S_INPUTHELPER_BACKER (INPUTHELPERID, BACKERID, BACKPOSITION)values('OutSourcing', 'groupname', 1);

insert into S_INPUTHELPER_BACKER (INPUTHELPERID, BACKERID, BACKPOSITION)values('OutSourcing', 'deptno', 2);