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);