schema-export-sys.sql

一段很有意义的源码,看了就知道,不信试一试啊!

create table SC_ACL_RESOURCE (ID bigint not null, NAME varchar(255), NATIVE_RESOURCE_ID varchar(255) not null, DESCRIPTION varchar(255), PARENT_ACL_RES_ID bigint, ACL_RES_TYPE_ID bigint, primary key (ID));
create table SC_ACL_RES_TYPE (ID bigint not null, APP_NODE_ID bigint, CATALOG integer, CODE varchar(100), DESCRIPTION varchar(255), NAME varchar(100) not null unique, CLASS_NAME varchar(100), OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, primary key (ID));
create table SC_EXT_PROPERTY (ID bigint not null, name varchar(50) not null, value varchar(50), SECURITY_USER_ID bigint, primary key (ID));
create table SC_GROUP (ID bigint not null, DYNAACCESSCLASS varchar(255), DYANPARAMS varchar(255), DYNA integer, OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, CODE varchar(100), NAME varchar(255) not null, DESCRIPTION varchar(255), primary key (ID));
create table SC_GROUP_ROLE (SECURITY_GROUP_ID bigint not null, SECURITY_ROLE_ID bigint not null, primary key (SECURITY_GROUP_ID, SECURITY_ROLE_ID));
create table SC_PROXY_USER (ID bigint not null, DESCRIPTION varchar(255), END_TIME timestamp, START_TIME timestamp, PROXY_ID bigint, USER_ID bigint, primary key (ID));
create table SC_PUB_PERMISSION (ACL_PERMISSION_ID bigint not null, SECURITY_ROLE_ID bigint not null, primary key (SECURITY_ROLE_ID, ACL_PERMISSION_ID));
create table SC_REV_PERMISSION (ACL_PERMISSION_ID bigint not null, SECURITY_ROLE_ID bigint not null, primary key (SECURITY_ROLE_ID, ACL_PERMISSION_ID));
create table SC_ROLE (ID bigint not null, NAME varchar(100) not null unique, TYPE varchar(1) not null, DESCRIPTION varchar(255), PARENT_ROLE_ID bigint, OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, primary key (ID));
create table SC_USER (ID bigint not null, ORGAN_ID bigint, AUTHENTIC_TYPE integer, CERTIFICATE varchar(255), STATUS bigint, LOGIN_NAME varchar(100) not null unique, NAME varchar(100), SEX varchar(255), PASSWORD varchar(100) not null, OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, primary key (ID));
create table SC_USER_GROUP (SECURITY_GROUP_ID bigint not null, SECURITY_USER_ID bigint not null, primary key (SECURITY_USER_ID, SECURITY_GROUP_ID));
create table SC_USER_ROLE (SECURITY_USER_ID bigint not null, SECURITY_ROLE_ID bigint not null, primary key (SECURITY_USER_ID, SECURITY_ROLE_ID));
create table TREE_RESOURCE (ID bigint generated by default as identity, DESCRIPTION varchar(255), RESOURCE_NAME varchar(255), PARENT_RESOURCE_ID bigint, primary key (ID));
create table URL_RESOURCE (ID bigint generated by default as identity, RESOURCE_NAME varchar(255), DESCRIPTION varchar(255), primary key (ID));
create table WORKSPACE_ARCHIVE (WORKITEM_ID bigint generated by default as identity, ACTIVITY_ID varchar(255), ACTIVITY_NAME varchar(255), AINSTANCE_ID varchar(255), DEADLINE varchar(255), OUTER_ID varchar(255), PINSTANCE_ID varchar(255), PMODEL_ID varchar(255), WORK_DESC varchar(255), WORK_STATE integer, primary key (WORKITEM_ID));
create table WORKSPACE_PERSON (ID bigint generated by default as identity, EXECUTE_TIME date, IS_SHOW bigint, PERSON_ID varchar(255), WORKITEM_ID bigint, WORKITEM_INDEX bigint, primary key (ID));
alter table ACTION_RESOURCE add constraint FKE3128FF7187E4413 foreign key (PARENT_RESOURCE_ID) references ACTION_RESOURCE;
alter table APP_NODE add constraint FK7601F980A4F1A4E6 foreign key (CENTRAL_NODE_ID) references APP_NODE;
alter table APP_NODE_USER add constraint FKE920932A66D19017 foreign key (USER_ID) references SC_USER;
alter table APP_NODE_USER add constraint FKE920932A8DFAC592 foreign key (APP_NODE_ID) references APP_NODE;
alter table CODE_INFO add constraint FK64A91BC060178CDA foreign key (TYPE_ID) references CODE_TYPE;
alter table CODE_INFO add constraint FK64A91BC07FC4008 foreign key (CODE_INFO_ID) references CODE_INFO;
alter table CUSTOM_RESOURCE add constraint FKEA37351CB9E31D81 foreign key (ACL_RES_TYPE_ID) references SC_ACL_RES_TYPE;
alter table CUSTOM_RESOURCE add constraint FKEA37351C9D2D1261 foreign key (PARENT_RESOURCE_ID) references CUSTOM_RESOURCE;
alter table DIR_RESOURCE add constraint FKDFA407A0E597F867 foreign key (PARENT_RESOURCE_ID) references DIR_RESOURCE;
alter table FILE_RESOURCE add constraint FK94E363718BB6F94C foreign key (PARENT_RESOURCE_ID) references FILE_RESOURCE;
alter table MENU_RESOURCE add constraint FK6A1272EE73120231 foreign key (SMALL_IMAGE) references CODE_INFO;
alter table MENU_RESOURCE add constraint FK6A1272EEE1324B6A foreign key (BIG_IMAGE) references CODE_INFO;
alter table MENU_RESOURCE add constraint FK6A1272EEE757E160 foreign key (PARENT_RESOURCE_ID) references MENU_RESOURCE;
alter table NODE_USER add constraint FKC39F67E8C05442D foreign key (ORGAN_NODE_ID) references ORGAN_NODE;
alter table NODE_USER add constraint FKC39F67E85AA86E18 foreign key (SECURITY_USER_ID) references SC_USER;
alter table ORGAN_MODEL add constraint FK75E5073B6F356C38 foreign key (CHILD_NODE_ID) references ORGAN_NODE;
alter table ORGAN_MODEL add constraint FK75E5073B192920F7 foreign key (ORGAN_REALTION_ID) references ORGAN_RELATION;
alter table ORGAN_MODEL add constraint FK75E5073B896F11C6 foreign key (PARENT_NODE_ID) references ORGAN_NODE;
alter table ORGAN_NODE add constraint FKA8F75390931CBE87 foreign key (ICON) references CODE_INFO;
alter table ORGAN_NODE add constraint FKA8F7539083B9D492 foreign key (ORG_TYPE) references ORG_TYPE;
alter table ORG_DEPARTMENT add constraint FKCC04AFAD46D6AF12 foreign key (PARENT_ID) references ORG_DEPARTMENT;
alter table ORG_POSITIONS add constraint FKFDD248F28190F97 foreign key (DEPT_ID) references ORG_DEPARTMENT;
alter table ORG_POSITIONS add constraint FKFDD248F2EED00E9 foreign key (PARENT_ID) references ORG_POSITIONS;
alter table ORG_POST_USER add constraint FK2342F84F66D19017 foreign key (USER_ID) references SC_USER;
alter table ORG_POST_USER add constraint FK2342F84F9C34E533 foreign key (POST_ID) references ORG_POSITIONS;
alter table PORTLET_RESOURCE add constraint FK868520D345607254 foreign key (PARENT_RESOURCE_ID) references PORTLET_RESOURCE;
alter table RESOURCE_GROUP add constraint FKC5FD52EEB9E31D81 foreign key (ACL_RES_TYPE_ID) references SC_ACL_RES_TYPE;
alter table SC_ACC_PERMISSION add constraint FK90B3AE3CB57DAA38 foreign key (SECURITY_ROLE_ID) references SC_ROLE;
alter table SC_ACC_PERMISSION add constraint FK90B3AE3CCD109952 foreign key (ACL_PERMISSION_ID) references SC_ACL_PERMISSION;
alter table SC_ACL_OPERATION add constraint FKEF217003B9E31D81 foreign key (ACL_RES_TYPE_ID) references SC_ACL_RES_TYPE;
alter table SC_ACL_PERMISSION add constraint FKD5F27E9375E75762 foreign key (ACL_OPERATION_ID) references SC_ACL_OPERATION;
alter table SC_ACL_PERMISSION add constraint FKD5F27E9346E79AF2 foreign key (ACL_RESOURCE_ID) references SC_ACL_RESOURCE;
alter table SC_ACL_RESOURCE add constraint FK5348E1D2B9E31D81 foreign key (ACL_RES_TYPE_ID) references SC_ACL_RES_TYPE;
alter table SC_ACL_RESOURCE add constraint FK5348E1D25DB4015F foreign key (PARENT_ACL_RES_ID) references SC_ACL_RESOURCE;
alter table SC_ACL_RES_TYPE add constraint FK542A015D8DFAC592 foreign key (APP_NODE_ID) references APP_NODE;
alter table SC_EXT_PROPERTY add constraint FK243FC3E25AA86E18 foreign key (SECURITY_USER_ID) references SC_USER;
alter table SC_GROUP_ROLE add constraint FK3F50FA527AB60DC foreign key (SECURITY_GROUP_ID) references SC_GROUP;
alter table SC_GROUP_ROLE add constraint FK3F50FA5B57DAA38 foreign key (SECURITY_ROLE_ID) references SC_ROLE;
alter table SC_PROXY_USER add constraint FK4899C46B66D19017 foreign key (USER_ID) references SC_USER;
alter table SC_PROXY_USER add constraint FK4899C46B34DE0A94 foreign key (PROXY_ID) references SC_USER;
alter table SC_PUB_PERMISSION add constraint FK8A374E40B57DAA38 foreign key (SECURITY_ROLE_ID) references SC_ROLE;
alter table SC_PUB_PERMISSION add constraint FK8A374E40CD109952 foreign key (ACL_PERMISSION_ID) references SC_ACL_PERMISSION;
alter table SC_REV_PERMISSION add constraint FKFFA364DAB57DAA38 foreign key (SECURITY_ROLE_ID) references SC_ROLE;
alter table SC_REV_PERMISSION add constraint FKFFA364DACD109952 foreign key (ACL_PERMISSION_ID) references SC_ACL_PERMISSION;
alter table SC_ROLE add constraint FK9E5B1905D0CB31A2 foreign key (PARENT_ROLE_ID) references SC_ROLE;
alter table SC_USER_GROUP add constraint FK5F05BA3A27AB60DC foreign key (SECURITY_GROUP_ID) references SC_GROUP;
alter table SC_USER_GROUP add constraint FK5F05BA3A5AA86E18 foreign key (SECURITY_USER_ID) references SC_USER;
alter table SC_USER_ROLE add constraint FKD9CB553B5AA86E18 foreign key (SECURITY_USER_ID) references SC_USER;
alter table SC_USER_ROLE add constraint FKD9CB553BB57DAA38 foreign key (SECURITY_ROLE_ID) references SC_ROLE;
alter table TREE_RESOURCE add constraint FKD30BAB8F8576356E foreign key (PARENT_RESOURCE_ID) references TREE_RESOURCE;