-- SQL script for dropping the CERA Module DATA_ORGANIZATION

-- sequences
drop sequence SEQ_POINT;
drop sequence SEQ_POSITION;
drop sequence SEQ_MOMENT;
drop sequence SEQ_DIM_TYPE;
drop sequence SEQ_SCALE;
drop sequence SEQ_POINT_SET;
drop sequence SEQ_TIME;
drop sequence SEQ_SPACE;
drop sequence SEQ_DATA_ORG;

-- 3 relations
drop table POINT_CONNECT;
drop table SCALE_CONNECT;
drop table TIME_CONNECT;

-- 3 basic entities
drop table POINT;
drop table POSITION;
drop table MOMENT;

-- 2 structural entities
alter table PARAMETER drop constraint PARA_DORG;
update      PARAMETER set DATA_ORG_ID = NULL;
drop  table DATA_ORG;
drop  table SPACE;

-- 3 dimension entities and 1 LOV
drop synonym SCALE1;
drop synonym SCALE2;
drop table SCALE;
drop table POINT_SET;
drop table TIME;
drop table DIM_TYPE;


