www.gusucode.com > 智软JSP表单引擎实例源码源码程序 > 智软JSP表单引擎实例源码/自定义表单引擎/自定义表单引擎/数据库建表语句及示例数据/oracle数据库/自定义表单引擎建表语句.txt

    create table COLL_CONFIG_OPERATE_FIELD
(
  ID         VARCHAR2(8) not null,
  FID        VARCHAR2(10),
  FIELD      VARCHAR2(50),
  ISDISPLAY  VARCHAR2(1) default 0,
  ISEDIT     VARCHAR2(1) default 0,
  ISMUSTFILL VARCHAR2(1) default 0,
  DEFAULT1   VARCHAR2(1000),
  ISFORCE    CHAR(1) default 0
)
;
alter table COLL_CONFIG_OPERATE_FIELD
  add constraint PK_FLOW_CONFIG_OPERATE_FIELD primary key (ID);


create table COLL_DOC_CONFIG
(
  ID         VARCHAR2(8) not null,
  DOCNAME    VARCHAR2(100),
  TEMPLAET   VARCHAR2(80),
  OTHERFIELD VARCHAR2(8),
  MAINTABLE  VARCHAR2(4),
  DOCTYPE    VARCHAR2(1),
  DCODE      VARCHAR2(64)
)
;
alter table COLL_DOC_CONFIG
  add constraint PK_COLL_DOC_CONFIG primary key (ID);


create table COLL_DOC_PRINT
(
  ID       VARCHAR2(8) not null,
  DOCID    VARCHAR2(8),
  TEMPLAET VARCHAR2(80),
  PAGE     NUMBER(2)
)
;
alter table COLL_DOC_PRINT
  add constraint PK_COLL_DOC_PRINT primary key (ID);