schema-export.sql

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

drop table BUSINESS_ASSEMBLY;
drop table BUSINESS_ASSEMBLY_INFO;
drop table BUSINESS_ASSEMBLY_PERMISSION;
drop table BUSINESS_ASSEMBLY_PERSON;
drop table BUSINESS_ASSEMBLY_ROOM;
drop table BUSINESS_ASSEMBLY_ROOM_INFO;
drop table BUSINESS_ASSEMBLY_ROOM_INFO_P;
drop sequence SQE_ASSEMBLYPERMISSION restrict;
drop sequence SQE_ASSEMBLYROOM restrict;
drop sequence SQE_ASSEMBLYROOMINFO restrict;
drop sequence SQE_ASSEMBLY_INFO restrict;
create table BUSINESS_ASSEMBLY (ID varchar(255) not null, ASS_INFO_ID bigint, OPERATETIME timestamp, OPERATOR varchar(20), STATUS bigint, OWNERID bigint, REMOVED bigint, primary key (ID));
create table BUSINESS_ASSEMBLY_INFO (ID bigint not null, CONTEXT varchar(255), COUNT bigint, END_TIME timestamp, MODERATOR_REL bigint, MODERATOR varchar(255), MONEY double, START_TIME timestamp, TITLE varchar(50), OPERATETIME timestamp, OPERATOR varchar(20), PERSON varchar(255), REMARK varchar(255), POSITION bigint, SERVICEPEOPLE varchar(50), SERVICEPID varchar(50), REMOVED integer, primary key (ID));
create table BUSINESS_ASSEMBLY_PERMISSION (ID bigint not null, COMMENTS varchar(255), ASS_ID varchar(255), OPERATETIME timestamp, OPERATOR varchar(255), PERSON bigint, STATUS bigint, REMOVED integer, primary key (ID));
create table BUSINESS_ASSEMBLY_PERSON (ASS_INFO_ID bigint not null, PERSONID bigint not null, primary key (ASS_INFO_ID, PERSONID));
create table BUSINESS_ASSEMBLY_ROOM (ID bigint not null, OPERATETIME timestamp, OPERATOR varchar(255), ASS_RO_INF bigint, REMOVED integer, primary key (ID));
create table BUSINESS_ASSEMBLY_ROOM_INFO (ID bigint not null, CAPABILITY bigint, EQUIPMENT varchar(255), NAME varchar(50), PERSON varchar(255), POSITION varchar(255), REMARK varchar(255), STATUS bigint, STATUS_R varchar(255), OPERATETIME timestamp, OPERATOR varchar(255), REMOVED integer, primary key (ID));
create table BUSINESS_ASSEMBLY_ROOM_INFO_P (INFO_ID bigint not null, PERSONID bigint not null, primary key (INFO_ID, PERSONID));
alter table BUSINESS_ASSEMBLY add constraint FK922867852B546D8C foreign key (ASS_INFO_ID) references BUSINESS_ASSEMBLY_INFO;
alter table BUSINESS_ASSEMBLY_INFO add constraint FK3251992895036C54 foreign key (POSITION) references BUSINESS_ASSEMBLY_ROOM;
alter table BUSINESS_ASSEMBLY_PERMISSION add constraint FKBC9A2AC97AE0D1C9 foreign key (ASS_ID) references BUSINESS_ASSEMBLY;
alter table BUSINESS_ASSEMBLY_PERSON add constraint FKEFC8954F2B546D8C foreign key (ASS_INFO_ID) references BUSINESS_ASSEMBLY_INFO;
alter table BUSINESS_ASSEMBLY_ROOM add constraint FK3255B5558F4A6CD6 foreign key (ASS_RO_INF) references BUSINESS_ASSEMBLY_ROOM_INFO;
alter table BUSINESS_ASSEMBLY_ROOM_INFO_P add constraint FK48F68329C444C4C5 foreign key (INFO_ID) references BUSINESS_ASSEMBLY_ROOM_INFO;
create sequence SQE_ASSEMBLYPERMISSION;
create sequence SQE_ASSEMBLYROOM;
create sequence SQE_ASSEMBLYROOMINFO;
create sequence SQE_ASSEMBLY_INFO;