-- dropping all CERA Core views, tables, and sequences

-- dropping views
-- -- views for convenience: CONTACTs
drop view INVESTIGATOR;
drop view ORIGINATOR;
drop view DISTRIBUTOR;
drop view TECHNICAL_CON;
drop view METADATA_CON;
drop view COPYRIGHT_CON;
drop view OWNER;
drop view INHOUSE_CON;
-- -- views for convenience: COVERAGEs
drop view SPATI_COVER;
drop view TEMPO_COVER;
-- -- views for convenience: other
drop view CITAT;
drop view INSTI;
drop view PERSO;
-- -- views for data read access: open data (foreign visible)
drop view GETF_CAMPA;
drop view GETF_CONNE;
drop view GETF_CONTA;
drop view GETF_COVER;
drop view GETF_DACCE;
drop view GETF_DISTR;
drop view GETF_ENTRY;
drop view GETF_KEY_C;
drop view GETF_PARAM;
drop view GETF_PROCE;
drop view GETF_REFER;
drop view GETF_SPATI;
-- -- views for data read access: all data (inhouse visible)
drop view GET_CAMPA;
drop view GET_CONNE;
drop view GET_CONTA;
drop view GET_COVER;
drop view GET_DACCE;
drop view GET_DISTR;
drop view GET_ENTRY;
drop view GET_KEY_C;
drop view GET_LOCAT;
drop view GET_PARAM;
drop view GET_PROCE;
drop view GET_REFER;
drop view GET_SPATI;

-- dropping sequences
drop sequence SEQ_ENTRY;
drop sequence SEQ_SUMMARY;
drop sequence SEQ_QUALITY;
drop sequence SEQ_SPATIAL_COVERAGE;
drop sequence SEQ_TEMPORAL_COVERAGE;
drop sequence SEQ_CITATION;
drop sequence SEQ_INSTITUTE;
drop sequence SEQ_PERSON;

drop sequence SEQ_ACCESS_CONSTRAINT;
drop sequence SEQ_ACCESS_TYPE;
drop sequence SEQ_AGGREGATION;
drop sequence SEQ_CITATION_TYPE;
drop sequence SEQ_CONNECT_TYPE;
drop sequence SEQ_CONTACT_TYPE;
drop sequence SEQ_CURRENTNESS_REF;
drop sequence SEQ_ENTRY_TYPE;
drop sequence SEQ_FEES;
drop sequence SEQ_FORMAT;
drop sequence SEQ_HOR_COORD_SYS;
drop sequence SEQ_LOCATION;
drop sequence SEQ_PRESENTATION;
drop sequence SEQ_PROGRESS;
drop sequence SEQ_REF_TYPE;
drop sequence SEQ_SPATIAL_DATA_ORG;
drop sequence SEQ_TOPIC;
drop sequence SEQ_USE_CONSTRAINT;
drop sequence SEQ_VER_COORD_SYS;
drop sequence SEQ_GENERAL_KEY;
drop sequence SEQ_PROJECT;
drop sequence SEQ_UNIT;

-- dropping relations
drop table CAMPAIGN;
drop table KEY_CONNECT;
drop table ENTRY_CONNECT;
drop table CONTACT;
drop table LOCATION_CONNECT;
drop table PROCESS_STEP;
drop table DISTRIBUTION;
drop table COVERAGE;
drop table PARAMETER;
drop table REFERENCE;
drop table SPATIAL_REFERENCE;

-- dropping entities
drop table CITATION;
drop table SPATIAL_COVERAGE;
drop table TEMPORAL_COVERAGE;
drop table ENTRY;
drop table SUMMARY;
drop table QUALITY;
drop table PERSON;
drop table INSTITUTE;

-- dropping some synonyms
drop synonym ENTRY1;
drop synonym DISTRIBUTION1;
drop synonym INSTITUTE1;
drop synonym LOCATION1;
drop synonym LOCATION2;
drop synonym LOCATION3;
drop synonym TOPIC1;
drop synonym TOPIC2;
drop synonym TOPIC3;
drop synonym UNIT1;
drop synonym UNIT2;

-- dropping general value lists
drop table ACCESS_CONSTRAINT;
drop table ACCESS_TYPE;
drop table AGGREGATION;
drop table CITATION_TYPE;
drop table CONNECT_TYPE;
drop table CONTACT_TYPE;
drop table CURRENTNESS_REF;
drop table ENTRY_TYPE;
drop table FEES;
drop table FORMAT;
drop table GENERAL_KEY;
drop table HOR_COORD_SYS;
drop table LOCATION;
drop table PRESENTATION;
drop table PROGRESS;
drop table PROJECT;
drop table REF_TYPE;
drop table SPATIAL_DATA_ORG;
drop table TOPIC;
drop table UNIT;
drop table USE_CONSTRAINT;
drop table VER_COORD_SYS;

