tff_dwxx_def.sql

行业应急系统 包括: 应急系统（待遇核发） 发放系统 开发环境:Delphi5 (sp1)+ Oracle 8.05 MultiExport是一个可以将数据按指定字段倒出

-- Start of DDL script for TFF_DWXX
-- Generated 24-十月-00  5:28:50 pm
-- from simc-SIDB2000:1

-- Table TFF_DWXX

CREATE TABLE tff_dwxx
 (
  dwid_ff                    CHAR(10) NOT NULL,
  ssdwid                     CHAR(10) NOT NULL,
  dwid                       CHAR(10),
  dwdm                       CHAR(10) NOT NULL,
  dwmc                       VARCHAR2(40) NOT NULL,
  sshy                       NUMBER(2) NOT NULL,
  frdb                       VARCHAR2(10),
  dwjbr                      VARCHAR2(30),
  zh                         VARCHAR2(60),
  khmc                       VARCHAR2(100),
  yzbm                       CHAR(6),
  dwdz                       VARCHAR2(100),
  lxdh                       VARCHAR2(20),
  shhffsj                    DATE NOT NULL,
  sjdwdm                     CHAR(10) NOT NULL,
  jbr                        VARCHAR2(10),
  jbrq                       DATE,
  shr                        VARCHAR2(10),
  shrq                       DATE
 )
 PCTFREE    10
 PCTUSED    40
 INITRANS   1
 MAXTRANS   255
/

-- Comments for TFF_DWXX

COMMENT ON TABLE tff_dwxx IS '社会化发放单位信息表'
/

-- Column Comments for TFF_DWXX

COMMENT ON COLUMN tff_dwxx.dwdm IS '单位代码'
/
COMMENT ON COLUMN tff_dwxx.dwdz IS '单位地址'
/
COMMENT ON COLUMN tff_dwxx.dwid IS '单位ID（关联离退休人员单位ID）'
/
COMMENT ON COLUMN tff_dwxx.dwid_ff IS '社会化发放单位或组ID'
/
COMMENT ON COLUMN tff_dwxx.dwjbr IS '单位经办人'
/
COMMENT ON COLUMN tff_dwxx.dwmc IS '单位名称'
/
COMMENT ON COLUMN tff_dwxx.frdb IS '法人代表'
/
COMMENT ON COLUMN tff_dwxx.jbr IS '经办人'
/
COMMENT ON COLUMN tff_dwxx.jbrq IS '经办日期'
/
COMMENT ON COLUMN tff_dwxx.khmc IS '开户名称'
/
COMMENT ON COLUMN tff_dwxx.lxdh IS '联系电话'
/
COMMENT ON COLUMN tff_dwxx.shhffsj IS '社会化发放时间'
/
COMMENT ON COLUMN tff_dwxx.shr IS '审核人'
/
COMMENT ON COLUMN tff_dwxx.shrq IS '审核日期'
/
COMMENT ON COLUMN tff_dwxx.sjdwdm IS '上级单位代码（0-单位；否则表示该组的上级组或单位代码）'
/
COMMENT ON COLUMN tff_dwxx.ssdwid IS '所属单位ID'
/
COMMENT ON COLUMN tff_dwxx.sshy IS '所属行业（1-民航；2-农行；3-交行；4-中保；5-石油；6-电力；7-建行；8-工行；9-交通；10-邮电；11-中行；12-有色；13-中建；14-铁路）'
/
COMMENT ON COLUMN tff_dwxx.yzbm IS '邮政编码'
/
COMMENT ON COLUMN tff_dwxx.zh IS '帐号'
/

-- Constraints for TFF_DWXX

ALTER TABLE tff_dwxx
 ADD CONSTRAINT pk1_1 PRIMARY KEY (dwid_ff)
 USING INDEX
  PCTFREE    10
  INITRANS   2
  MAXTRANS   255
/


-- End of DDL script for TFF_DWXX