hidp3.0 sql-阿里云开发者社区

hidp3.0 sql

2016-05-17 1134

版权

本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

简介：

/*==============================================================*/
/* 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");

hidp3.0 sql

热门文章

最新文章

相关课程

相关电子书

相关实验场景