/*==============================================================*/
/* DBMS name:      ORACLE Version 9i                            */
/* Created on:     10/23/2006 11:02:26 AM                       */
/*==============================================================*/


drop table APP_MAIN cascade constraints;

drop table APP_ROLE cascade constraints;

drop table GROUP_MAIN cascade constraints;

drop table GROUP_USER cascade constraints;

drop table ROLE_GROUP cascade constraints;

drop table ROLE_MAIN cascade constraints;

drop table USER_MAIN cascade constraints;

drop sequence APM_APP_MAIN_ID_SEQPK;

drop sequence APR_APP_ROLE_ID_SEQPK;

drop sequence GRM_GROUP_MAIN_ID_SEQPK;

drop sequence GRU_GROUP_USER_ID_SEQPK;

drop sequence RLG_ROLE_GROUP_ID_SEQPK;

drop sequence RLM_ROLE_MAIN_ID_SEQPK;

drop sequence USM_USER_MAIN_ID_SEQPK;

create sequence APM_APP_MAIN_ID_SEQPK;

create sequence APR_APP_ROLE_ID_SEQPK;

create sequence GRM_GROUP_MAIN_ID_SEQPK;

create sequence GRU_GROUP_USER_ID_SEQPK;

create sequence RLG_ROLE_GROUP_ID_SEQPK;

create sequence RLM_ROLE_MAIN_ID_SEQPK;

create sequence USM_USER_MAIN_ID_SEQPK;

/*==============================================================*/
/* Table: APP_MAIN                                              */
/*==============================================================*/
create table APP_MAIN  (
   APM_APP_MAIN_ID      INT                             not null,
   APM_APP_NAME         NVARCHAR2(25),
   APM_COLUMN_2         NVARCHAR2(25),
   APM_COLUMN_3         NVARCHAR2(25),
   APM_COLUMN_4         NVARCHAR2(25),
   constraint PK_APP_MAIN primary key (APM_APP_MAIN_ID)
);

/*==============================================================*/
/* Table: APP_ROLE                                              */
/*==============================================================*/
create table APP_ROLE  (
   APR_APP_ROLE_ID      INT                             not null,
   APR_APP_MAIN_ID      INT,
   APR_ROLE_MAIN_ID     INT,
   constraint PK_APP_ROLE primary key (APR_APP_ROLE_ID)
);

/*==============================================================*/
/* Table: GROUP_MAIN                                            */
/*==============================================================*/
create table GROUP_MAIN  (
   GRM_GROUP_MAIN_ID    INT                             not null,
   GRM_GROUP_NAME       NVARCHAR2(25),
   constraint PK_GROUP_MAIN primary key (GRM_GROUP_MAIN_ID)
);

/*==============================================================*/
/* Table: GROUP_USER                                            */
/*==============================================================*/
create table GROUP_USER  (
   GRU_GROUP_USER_ID    INT                             not null,
   GRU_GROUP_MAIN_ID    INT,
   GRU_USER_MAIN_ID     INT,
   constraint PK_GROUP_USER primary key (GRU_GROUP_USER_ID)
);

/*==============================================================*/
/* Table: ROLE_GROUP                                            */
/*==============================================================*/
create table ROLE_GROUP  (
   RLG_ROLE_GROUP_ID    INT                             not null,
   RLG_ROLE_MAIN_ID     INT,
   RLG_GROUP_MAIN_ID    INT,
   constraint PK_ROLE_GROUP primary key (RLG_ROLE_GROUP_ID)
);

/*==============================================================*/
/* Table: ROLE_MAIN                                             */
/*==============================================================*/
create table ROLE_MAIN  (
   RLM_ROLE_MAIN_ID     INT                             not null,
   RLM_ROLE_NAME        NVARCHAR2(25),
   constraint PK_ROLE_MAIN primary key (RLM_ROLE_MAIN_ID)
);

/*==============================================================*/
/* Table: USER_MAIN                                             */
/*==============================================================*/
create table USER_MAIN  (
   USM_USER_MAIN_ID     INT                             not null,
   USM_USER_LOGIN       NVARCHAR2(25),
   constraint PK_USER_MAIN primary key (USM_USER_MAIN_ID)
);

alter table APP_ROLE
   add constraint FK_APP_APP_MAIN foreign key (APR_APP_MAIN_ID)
      references APP_MAIN (APM_APP_MAIN_ID);

alter table APP_ROLE
   add constraint FK_APP_ROLE_MAI foreign key (APR_ROLE_MAIN_ID)
      references ROLE_MAIN (RLM_ROLE_MAIN_ID);

alter table GROUP_USER
   add constraint FK_GRO_GROUP_MA foreign key (GRU_GROUP_MAIN_ID)
      references GROUP_MAIN (GRM_GROUP_MAIN_ID);

alter table GROUP_USER
   add constraint FK_GRO_USER_MAI foreign key (GRU_USER_MAIN_ID)
      references USER_MAIN (USM_USER_MAIN_ID);

alter table ROLE_GROUP
   add constraint FK_ROL_GROUP_MA foreign key (RLG_GROUP_MAIN_ID)
      references GROUP_MAIN (GRM_GROUP_MAIN_ID);

alter table ROLE_GROUP
   add constraint FK_ROL_ROLE_MAI foreign key (RLG_ROLE_MAIN_ID)
      references ROLE_MAIN (RLM_ROLE_MAIN_ID);