hidp3.0 sql

最新推荐文章于 2024-09-15 08:03:51 发布

weixin_33985679

最新推荐文章于 2024-09-15 08:03:51 发布

阅读量83

点赞数

文章标签：数据库

原文链接：https://yq.aliyun.com/articles/46691

版权

/*==============================================================*/
/* DBMS name:      ORACLE Version 10g                           */
/* Created on:     2010-10-13 14:56:47                          */
/*==============================================================*/

alter table "F_FormData"
   drop constraint FK_F_FORMDA_RELATIONS_F_CUSTOM;

alter table "F_Opinion"
   drop constraint FK_F_OPINIO_RELATIONS_F_CUSTOM;

alter table "F_WorkFlowForm"
   drop constraint FK_F_WORKFL_RELATIONS_F_CUSTOM;

drop table "F_CustomForm" cascade constraints;

drop index "Relationship_2_FK";

drop table "F_FormData" cascade constraints;

drop index "Relationship_1_FK";

drop table "F_Opinion" cascade constraints;

drop table "F_ProcessFile" cascade constraints;

drop index "Relationship_3_FK";

drop table "F_WorkFlowForm" cascade constraints;

/*==============================================================*/
/* Table: "F_CustomForm"                                        */
/*==============================================================*/
create table "F_CustomForm" (
   "fid"                VARCHAR2(32)                    not null,
   "formname"           VARCHAR2(20)                    not null,
   "formpath"           VARCHAR2(100)                   not null,
   "createtime"         DATE                            not null,
   "creater"            VARCHAR2(20)                    not null,
   "formcontent"        VARCHAR2(200)                   not null,
   constraint PK_F_CUSTOMFORM primary key ("fid")
);

/*==============================================================*/
/* Table: "F_FormData"                                          */
/*==============================================================*/
create table "F_FormData" (
   "did"                VARCHAR2(32)                    not null,
   "fid"                VARCHAR2(32),
   "datatype"           VARCHAR2(100)                   not null,
   "dataname"           VARCHAR2(20)                    not null,
   "datavalue"          VARCHAR2(20),
   "piid"               VARCHAR2(32)                    not null,
   constraint PK_F_FORMDATA primary key ("did")
);

/*==============================================================*/
/* Index: "Relationship_2_FK"                                   */
/*==============================================================*/
create index "Relationship_2_FK" on "F_FormData" (
   "fid" ASC
);

/*==============================================================*/
/* Table: "F_Opinion"                                           */
/*==============================================================*/
create table "F_Opinion" (
   "oid"                VARCHAR2(32)                    not null,
   "fid"                VARCHAR2(32),
   "creater"            VARCHAR2(20)                    not null,
   "createtime"         DATE                            not null,
   "context"            VARCHAR2(200),
   "piId"               VARCHAR2(32),
   constraint PK_F_OPINION primary key ("oid")
);

/*==============================================================*/
/* Index: "Relationship_1_FK"                                   */
/*==============================================================*/
create index "Relationship_1_FK" on "F_Opinion" (
   "fid" ASC
);

/*==============================================================*/
/* Table: "F_ProcessFile"                                       */
/*==============================================================*/
create table "F_ProcessFile" (
   "id"                 VARCHAR2(32)                    not null,
   "processfielname"    VARCHAR2(20)                    not null,
   "path"               VARCHAR2(100),
   "processfilesate"    VARCHAR2(2)                     not null,
   "workflowid"         VARCHAR2(32),
   constraint PK_F_PROCESSFILE primary key ("id")
);

/*==============================================================*/
/* Table: "F_WorkFlowForm"                                      */
/*==============================================================*/
create table "F_WorkFlowForm" (
   "wfid"               VARCHAR2(32)                    not null,
   "fid"                VARCHAR2(32),
   "workflowid"         VARCHAR2(32)                    not null,
   constraint PK_F_WORKFLOWFORM primary key ("wfid")
);

/*==============================================================*/
/* Index: "Relationship_3_FK"                                   */
/*==============================================================*/
create index "Relationship_3_FK" on "F_WorkFlowForm" (
   "fid" ASC
);

alter table "F_FormData"
   add constraint FK_F_FORMDA_RELATIONS_F_CUSTOM foreign key ("fid")
      references "F_CustomForm" ("fid");

alter table "F_Opinion"
   add constraint FK_F_OPINIO_RELATIONS_F_CUSTOM foreign key ("fid")
      references "F_CustomForm" ("fid");

alter table "F_WorkFlowForm"
   add constraint FK_F_WORKFL_RELATIONS_F_CUSTOM foreign key ("fid")
      references "F_CustomForm" ("fid");