--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'standard public schema';


--
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: 
--

;CREATE PROCEDURAL LANGUAGE plpgsql;


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: backup_voevents; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE backup_voevents (
    "eventKey" integer DEFAULT 0 NOT NULL,
    "eventId" character varying(128) DEFAULT NULL::character varying,
    date timestamp without time zone,
    "role" character varying(32) DEFAULT NULL::character varying,
    "eventType" integer,
    "obsId" character varying(128) DEFAULT NULL::character varying,
    "obsNum" character varying(32) DEFAULT NULL::character varying,
    "progVer" integer,
    "progNumber" integer,
    "jopId" character varying(32) DEFAULT NULL::character varying,
    loc character varying(255) DEFAULT NULL::character varying,
    "contactId" integer,
    observatory character varying(64) DEFAULT NULL::character varying,
    "telescopeId" integer,
    telescope character varying(64) DEFAULT NULL::character varying,
    "instrumentId" integer,
    instrument character varying(64) DEFAULT NULL::character varying,
    tohbans character varying(64) DEFAULT NULL::character varying,
    planners character varying(128) DEFAULT NULL::character varying,
    observers character varying(128) DEFAULT NULL::character varying,
    "obsTitle" character varying(255) DEFAULT NULL::character varying,
    category character varying(255) DEFAULT NULL::character varying,
    concept character varying(255) DEFAULT NULL::character varying,
    goal character varying(255) DEFAULT NULL::character varying,
    purpose character varying(255) DEFAULT NULL::character varying,
    "sciObjectives" character varying(255) DEFAULT NULL::character varying,
    "noaaNum" character varying(32) DEFAULT NULL::character varying,
    jop character varying(64) DEFAULT NULL::character varying,
    "joinSb" character varying(32) DEFAULT NULL::character varying,
    target character varying(64) DEFAULT NULL::character varying,
    objects character varying(255) DEFAULT NULL::character varying,
    "parentUrl" character varying(255) DEFAULT NULL::character varying,
    "coordinateSystem" character varying(32) DEFAULT NULL::character varying,
    "startTime" timestamp without time zone,
    "stopTime" timestamp without time zone,
    "position2D" character varying(64) DEFAULT NULL::character varying,
    "xCen" double precision,
    "yCen" double precision,
    "xFov" double precision,
    "yFov" double precision,
    "posX" double precision,
    "posY" double precision,
    "bboxLlX" double precision,
    "bboxLlY" double precision,
    "bboxUrX" double precision,
    "bboxUrY" double precision,
    "uModes" text,
    "waveIds" character varying(255) DEFAULT NULL::character varying,
    wavelengths character varying(255) DEFAULT NULL::character varying,
    cadences character varying(255) DEFAULT NULL::character varying,
    "minCadence" double precision,
    "maxCadence" double precision,
    "minImages" integer,
    "maxImages" integer,
    descriptions text,
    note text,
    "supercedeCount" integer,
    "viewCount" integer,
    "numRatings" integer,
    ranking double precision,
    "thumbPath" character varying(255) DEFAULT NULL::character varying,
    "fullResPath" character varying(255) DEFAULT NULL::character varying,
    "receiptTime" timestamp without time zone
);


ALTER TABLE public.backup_voevents OWNER TO sotkb;

--
-- Name: box_regions_boxId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "box_regions_boxId_seq"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."box_regions_boxId_seq" OWNER TO sotkb;

--
-- Name: box_regions; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE box_regions (
    "boxId" integer DEFAULT nextval('"box_regions_boxId_seq"'::regclass) NOT NULL,
    "eventKey" integer,
    x1 double precision,
    y1 double precision,
    z1 double precision,
    x2 double precision,
    y2 double precision,
    z2 double precision,
    "upperLeft" character varying(128) DEFAULT NULL::character varying,
    "lowerRight" character varying(128) DEFAULT NULL::character varying
);


ALTER TABLE public.box_regions OWNER TO sotkb;

--
-- Name: citations_citationId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "citations_citationId_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."citations_citationId_seq" OWNER TO sotkb;

--
-- Name: citations; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE citations (
    "citationId" integer DEFAULT nextval('"citations_citationId_seq"'::regclass) NOT NULL,
    "eventKey" integer,
    "citeType" integer,
    "citedVOEventId" character varying(128) DEFAULT NULL::character varying,
    "citingVOEventId" character varying(128) DEFAULT NULL::character varying,
    description text
);


ALTER TABLE public.citations OWNER TO sotkb;

--
-- Name: contacts_contactId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "contacts_contactId_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."contacts_contactId_seq" OWNER TO sotkb;

--
-- Name: contacts; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE contacts (
    "contactId" integer DEFAULT nextval('"contacts_contactId_seq"'::regclass) NOT NULL,
    "eventId" character varying(128) DEFAULT NULL::character varying,
    "contactName" character varying(128) DEFAULT NULL::character varying,
    "contactInstitution" character varying(255) DEFAULT NULL::character varying,
    "contactUri" character varying(255) DEFAULT NULL::character varying,
    "contactAddress" character varying(255) DEFAULT NULL::character varying,
    "contactTelephone" character varying(64) DEFAULT NULL::character varying,
    "contactEmail" character varying(64) DEFAULT NULL::character varying,
    "timeAdded" timestamp without time zone
);


ALTER TABLE public.contacts OWNER TO sotkb;

--
-- Name: coords; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE coords (
    "coordId" integer NOT NULL,
    "eventKey" integer,
    "coordName" character varying(64),
    coord1 character varying(64),
    coord2 character varying(64),
    coord3 character varying(64)
);


ALTER TABLE public.coords OWNER TO sotkb;

--
-- Name: descriptions_descriptionId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "descriptions_descriptionId_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."descriptions_descriptionId_seq" OWNER TO sotkb;

--
-- Name: descriptions; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE descriptions (
    "descriptionId" integer DEFAULT nextval('"descriptions_descriptionId_seq"'::regclass) NOT NULL,
    "eventKey" integer,
    "tagPath" character varying(255) DEFAULT NULL::character varying,
    description text
);


ALTER TABLE public.descriptions OWNER TO sotkb;

--
-- Name: ellipse_regions_ellipseId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "ellipse_regions_ellipseId_seq"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."ellipse_regions_ellipseId_seq" OWNER TO sotkb;

--
-- Name: ellipse_regions; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE ellipse_regions (
    "ellipseId" integer DEFAULT nextval('"ellipse_regions_ellipseId_seq"'::regclass) NOT NULL,
    "eventKey" integer,
    x1 double precision,
    y1 double precision,
    x2 double precision,
    y2 double precision,
    eccentricity double precision
);


ALTER TABLE public.ellipse_regions OWNER TO sotkb;

--
-- Name: event_types; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE event_types (
    "eventType" integer,
    "role" character varying(255) DEFAULT NULL::character varying,
    description character varying(255) DEFAULT NULL::character varying
);


ALTER TABLE public.event_types OWNER TO sotkb;

--
-- Name: field_descriptions; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE field_descriptions (
    "fieldName" character varying(128) DEFAULT NULL::character varying,
    "tableName" character varying(128) DEFAULT NULL::character varying,
    "humanName" character varying(128) DEFAULT NULL::character varying,
    "shortDescription" text,
    "longDescription" text
);


ALTER TABLE public.field_descriptions OWNER TO sotkb;

--
-- Name: groups_groupId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "groups_groupId_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."groups_groupId_seq" OWNER TO sotkb;

--
-- Name: groups; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE groups (
    "groupId" integer DEFAULT nextval('"groups_groupId_seq"'::regclass) NOT NULL,
    "eventKey" integer,
    "groupName" character varying(64) DEFAULT NULL::character varying,
    nesting character varying(255) DEFAULT NULL::character varying
);


ALTER TABLE public.groups OWNER TO sotkb;

--
-- Name: instruments_instrumentId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "instruments_instrumentId_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."instruments_instrumentId_seq" OWNER TO sotkb;

--
-- Name: instruments; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE instruments (
    "instrumentId" integer DEFAULT nextval('"instruments_instrumentId_seq"'::regclass) NOT NULL,
    "instrumentName" character varying(255) DEFAULT NULL::character varying,
    "dateAdded" timestamp without time zone,
    note text,
    "eventId" character varying(128) DEFAULT NULL::character varying
);


ALTER TABLE public.instruments OWNER TO sotkb;

--
-- Name: observation_notes_observationId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "observation_notes_observationId_seq"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."observation_notes_observationId_seq" OWNER TO sotkb;

--
-- Name: observation_notes; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE observation_notes (
    "observationId" integer DEFAULT nextval('"observation_notes_observationId_seq"'::regclass) NOT NULL,
    "eventKey" integer,
    "userId" character varying(128) DEFAULT NULL::character varying,
    note text,
    "receiptTime" timestamp without time zone
);


ALTER TABLE public.observation_notes OWNER TO sotkb;

--
-- Name: observation_ratings_ratingId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "observation_ratings_ratingId_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."observation_ratings_ratingId_seq" OWNER TO sotkb;

--
-- Name: observation_ratings; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE observation_ratings (
    "ratingId" integer DEFAULT nextval('"observation_ratings_ratingId_seq"'::regclass) NOT NULL,
    "eventKey" integer,
    "userId" character varying(128) DEFAULT NULL::character varying,
    rating double precision,
    notes text,
    "receiptTime" timestamp without time zone
);


ALTER TABLE public.observation_ratings OWNER TO sotkb;

--
-- Name: old_groups; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE old_groups (
    "groupId" integer DEFAULT 0 NOT NULL,
    "eventKey" integer,
    "groupName" character varying(64) DEFAULT NULL::character varying,
    nesting character varying(255) DEFAULT NULL::character varying
);


ALTER TABLE public.old_groups OWNER TO sotkb;

--
-- Name: old_params; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE old_params (
    "paramId" integer DEFAULT 0 NOT NULL,
    "eventKey" integer,
    "groupId" integer,
    "paramName" character varying(128) DEFAULT NULL::character varying,
    "paramValue" character varying(255) DEFAULT NULL::character varying
);


ALTER TABLE public.old_params OWNER TO sotkb;

--
-- Name: orphan_groups; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE orphan_groups (
    "groupId" integer DEFAULT 0 NOT NULL,
    "eventKey" integer,
    "groupName" character varying(64) DEFAULT NULL::character varying,
    nesting character varying(255) DEFAULT NULL::character varying
);


ALTER TABLE public.orphan_groups OWNER TO sotkb;

--
-- Name: orphan_params; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE orphan_params (
    "paramId" integer DEFAULT 0 NOT NULL,
    "eventKey" integer,
    "groupId" integer,
    "paramName" character varying(128) DEFAULT NULL::character varying,
    "paramValue" character varying(255) DEFAULT NULL::character varying
);


ALTER TABLE public.orphan_params OWNER TO sotkb;

--
-- Name: panorama_views_panoViewId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "panorama_views_panoViewId_seq"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."panorama_views_panoViewId_seq" OWNER TO sotkb;

--
-- Name: panorama_views; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE panorama_views (
    "panoViewId" integer DEFAULT nextval('"panorama_views_panoViewId_seq"'::regclass) NOT NULL,
    "eventKey" integer,
    "eventId" character varying(255) DEFAULT NULL::character varying,
    "viewCount" integer,
    "movieCount" integer,
    channels character varying(255) DEFAULT NULL::character varying,
    "fitsFiles" text,
    "cmdLine" text
);


ALTER TABLE public.panorama_views OWNER TO sotkb;

--
-- Name: params_paramId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "params_paramId_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."params_paramId_seq" OWNER TO sotkb;

--
-- Name: params; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE params (
    "paramId" integer DEFAULT nextval('"params_paramId_seq"'::regclass) NOT NULL,
    "eventKey" integer,
    "groupId" integer,
    "paramName" character varying(128) DEFAULT NULL::character varying,
    "paramValue" character varying(255) DEFAULT NULL::character varying
);


ALTER TABLE public.params OWNER TO sotkb;

--
-- Name: pod_podId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "pod_podId_seq"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."pod_podId_seq" OWNER TO sotkb;

--
-- Name: pod; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE pod (
    "podId" integer DEFAULT nextval('"pod_podId_seq"'::regclass) NOT NULL,
    "assignedId" character varying(200) DEFAULT NULL::character varying,
    "eventId" character varying(128) DEFAULT NULL::character varying,
    "contactId" integer,
    category character varying(255) DEFAULT NULL::character varying,
    importance double precision,
    title character varying(255) DEFAULT NULL::character varying,
    synopsis text,
    article text,
    "articleUrl" character varying(255) DEFAULT NULL::character varying,
    "thumbUrl" character varying(255) DEFAULT NULL::character varying,
    "startTime" timestamp without time zone,
    "stopTime" timestamp without time zone,
    "viewCount" integer,
    "numRatings" integer,
    ranking double precision,
    "receiptTime" timestamp without time zone,
    note text
);


ALTER TABLE public.pod OWNER TO sotkb;

--
-- Name: pod_ratings_ratingId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "pod_ratings_ratingId_seq"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."pod_ratings_ratingId_seq" OWNER TO sotkb;

--
-- Name: pod_ratings; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE pod_ratings (
    "ratingId" integer DEFAULT nextval('"pod_ratings_ratingId_seq"'::regclass) NOT NULL,
    "podId" integer,
    "assignedId" character varying(128) DEFAULT NULL::character varying,
    "userId" character varying(128) DEFAULT NULL::character varying,
    rating double precision,
    notes text,
    "receiptTime" timestamp without time zone
);


ALTER TABLE public.pod_ratings OWNER TO sotkb;

--
-- Name: pod_refs; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE pod_refs (
    "podId" integer,
    reference character varying(255) DEFAULT NULL::character varying,
    "refSynopsis" character varying(255) DEFAULT NULL::character varying,
    note text
);


ALTER TABLE public.pod_refs OWNER TO sotkb;

--
-- Name: pointings_pointingId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "pointings_pointingId_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."pointings_pointingId_seq" OWNER TO sotkb;

--
-- Name: pointings; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE pointings (
    "pointingId" integer DEFAULT nextval('"pointings_pointingId_seq"'::regclass) NOT NULL,
    "eventKey" integer,
    "xCen" double precision,
    "yCen" double precision,
    "xFov" double precision,
    "yFov" double precision
);


ALTER TABLE public.pointings OWNER TO sotkb;

--
-- Name: polygon_regions_polygonId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "polygon_regions_polygonId_seq"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."polygon_regions_polygonId_seq" OWNER TO sotkb;

--
-- Name: polygon_regions; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE polygon_regions (
    "polygonId" integer DEFAULT nextval('"polygon_regions_polygonId_seq"'::regclass) NOT NULL,
    "eventKey" integer,
    "upperLeft" character varying(128) DEFAULT NULL::character varying,
    "lowerRight" character varying(128) DEFAULT NULL::character varying
);


ALTER TABLE public.polygon_regions OWNER TO sotkb;

--
-- Name: ql_thumbs_qlId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "ql_thumbs_qlId_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."ql_thumbs_qlId_seq" OWNER TO sotkb;

--
-- Name: ql_thumbs; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE ql_thumbs (
    "qlId" integer DEFAULT nextval('"ql_thumbs_qlId_seq"'::regclass) NOT NULL,
    "startTime" timestamp without time zone,
    "stopTime" timestamp without time zone,
    instrument character varying(64) DEFAULT NULL::character varying,
    keywords character varying(128) DEFAULT NULL::character varying,
    band character varying(64) DEFAULT NULL::character varying,
    "thumbPath" character varying(255) DEFAULT NULL::character varying,
    "fullResPath" character varying(255) DEFAULT NULL::character varying,
    "receiptTime" timestamp without time zone
);


ALTER TABLE public.ql_thumbs OWNER TO sotkb;

--
-- Name: rankings; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE rankings (
    "eventId" character varying(128) DEFAULT NULL::character varying,
    "eventKey" integer DEFAULT 0 NOT NULL,
    ranking double precision,
    "numRatings" integer,
    "viewCount" integer
);


ALTER TABLE public.rankings OWNER TO sotkb;

--
-- Name: refs_referenceId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "refs_referenceId_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."refs_referenceId_seq" OWNER TO sotkb;

--
-- Name: refs; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE refs (
    "referenceId" integer DEFAULT nextval('"refs_referenceId_seq"'::regclass) NOT NULL,
    "eventKey" integer,
    "refUri" character varying(255) DEFAULT NULL::character varying,
    "refType" character varying(64) DEFAULT NULL::character varying,
    "refName" character varying(255) DEFAULT NULL::character varying,
    "tagPath" character varying(255) DEFAULT NULL::character varying,
    description text
);


ALTER TABLE public.refs OWNER TO sotkb;

--
-- Name: search_terms; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE search_terms (
    aka character varying(128) DEFAULT NULL::character varying,
    "fieldName" character varying(128) DEFAULT NULL::character varying,
    "tableName" character varying(128) DEFAULT NULL::character varying,
    family integer
);


ALTER TABLE public.search_terms OWNER TO sotkb;

--
-- Name: telescopes_telescopeId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "telescopes_telescopeId_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."telescopes_telescopeId_seq" OWNER TO sotkb;

--
-- Name: telescopes; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE telescopes (
    "telescopeId" integer DEFAULT nextval('"telescopes_telescopeId_seq"'::regclass) NOT NULL,
    "telescopeName" character varying(255) DEFAULT NULL::character varying,
    "dateAdded" timestamp without time zone,
    note text,
    "eventId" character varying(128) DEFAULT NULL::character varying
);


ALTER TABLE public.telescopes OWNER TO sotkb;

--
-- Name: trace_groups_backup; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE trace_groups_backup (
    "groupId" integer DEFAULT 0 NOT NULL,
    "eventKey" integer,
    "groupName" character varying(64) DEFAULT NULL::character varying,
    nesting character varying(255) DEFAULT NULL::character varying
);


ALTER TABLE public.trace_groups_backup OWNER TO sotkb;

--
-- Name: trace_params_backup; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE trace_params_backup (
    "paramId" integer DEFAULT 0 NOT NULL,
    "eventKey" integer,
    "groupId" integer,
    "paramName" character varying(128) DEFAULT NULL::character varying,
    "paramValue" character varying(255) DEFAULT NULL::character varying
);


ALTER TABLE public.trace_params_backup OWNER TO sotkb;

--
-- Name: trace_voevents_backup; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE trace_voevents_backup (
    "eventKey" integer DEFAULT 0 NOT NULL,
    "eventId" character varying(128) DEFAULT NULL::character varying,
    date timestamp without time zone,
    "role" character varying(32) DEFAULT NULL::character varying,
    "eventType" integer,
    "obsId" character varying(128) DEFAULT NULL::character varying,
    "obsNum" character varying(32) DEFAULT NULL::character varying,
    "progVer" character varying(64) DEFAULT NULL::character varying,
    "progNumber" character varying(64) DEFAULT NULL::character varying,
    "jopId" character varying(32) DEFAULT NULL::character varying,
    loc character varying(255) DEFAULT NULL::character varying,
    "contactId" integer,
    observatory character varying(64) DEFAULT NULL::character varying,
    "telescopeId" integer,
    telescope character varying(64) DEFAULT NULL::character varying,
    "instrumentId" integer,
    instrument character varying(64) DEFAULT NULL::character varying,
    tohbans character varying(64) DEFAULT NULL::character varying,
    planners character varying(128) DEFAULT NULL::character varying,
    observers character varying(128) DEFAULT NULL::character varying,
    "obsTitle" character varying(255) DEFAULT NULL::character varying,
    category character varying(255) DEFAULT NULL::character varying,
    concept character varying(255) DEFAULT NULL::character varying,
    goal character varying(255) DEFAULT NULL::character varying,
    purpose character varying(255) DEFAULT NULL::character varying,
    "sciObjectives" character varying(255) DEFAULT NULL::character varying,
    "noaaNum" character varying(32) DEFAULT NULL::character varying,
    jop character varying(64) DEFAULT NULL::character varying,
    "joinSb" character varying(32) DEFAULT NULL::character varying,
    target character varying(64) DEFAULT NULL::character varying,
    objects character varying(255) DEFAULT NULL::character varying,
    "parentUrl" character varying(255) DEFAULT NULL::character varying,
    "coordinateSystem" character varying(32) DEFAULT NULL::character varying,
    "startTime" timestamp without time zone,
    "stopTime" timestamp without time zone,
    "position2D" character varying(64) DEFAULT NULL::character varying,
    "xCen" double precision,
    "yCen" double precision,
    "xFov" double precision,
    "yFov" double precision,
    "posX" double precision,
    "posY" double precision,
    "bboxLlX" double precision,
    "bboxLlY" double precision,
    "bboxUrX" double precision,
    "bboxUrY" double precision,
    "uModes" text,
    "waveIds" character varying(255) DEFAULT NULL::character varying,
    wavelengths character varying(255) DEFAULT NULL::character varying,
    cadences character varying(255) DEFAULT NULL::character varying,
    "minCadence" double precision,
    "maxCadence" double precision,
    "minImages" integer,
    "maxImages" integer,
    tags character varying(255) DEFAULT NULL::character varying,
    descriptions text,
    note text,
    "supercedeCount" integer,
    "viewCount" integer,
    "numRatings" integer,
    ranking double precision,
    "thumbPath" character varying(255) DEFAULT NULL::character varying,
    "fullResPath" character varying(255) DEFAULT NULL::character varying,
    "receiptTime" timestamp without time zone,
    "movieUrl" character varying(255) DEFAULT NULL::character varying,
    "galleryId" character varying(255) DEFAULT NULL::character varying
);


ALTER TABLE public.trace_voevents_backup OWNER TO sotkb;

--
-- Name: vertices_vertexId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "vertices_vertexId_seq"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."vertices_vertexId_seq" OWNER TO sotkb;

--
-- Name: vertices; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE vertices (
    "vertexId" integer DEFAULT nextval('"vertices_vertexId_seq"'::regclass) NOT NULL,
    "polygonId" integer,
    x double precision,
    y double precision
);


ALTER TABLE public.vertices OWNER TO sotkb;

--
-- Name: voevent_annotations_annotationId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "voevent_annotations_annotationId_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."voevent_annotations_annotationId_seq" OWNER TO sotkb;

--
-- Name: voevent_annotations; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE voevent_annotations (
    "annotationId" integer DEFAULT nextval('"voevent_annotations_annotationId_seq"'::regclass) NOT NULL,
    "voeventId" character varying(128) DEFAULT NULL::character varying,
    "eventKey" integer,
    author character varying(255) DEFAULT NULL::character varying,
    institution character varying(255) DEFAULT NULL::character varying,
    "emailAddr" character varying(128) DEFAULT NULL::character varying,
    title character varying(255) DEFAULT NULL::character varying,
    "featuresFound" character varying(255) DEFAULT NULL::character varying,
    description text,
    "refUrl" character varying(255) DEFAULT NULL::character varying,
    "xCen" double precision,
    "yCen" double precision,
    "fovX" double precision,
    "fovY" double precision,
    "startTime" timestamp without time zone,
    "endTime" timestamp without time zone,
    "receiptTime" timestamp without time zone
);


ALTER TABLE public.voevent_annotations OWNER TO sotkb;

--
-- Name: voevents_eventKey_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "voevents_eventKey_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."voevents_eventKey_seq" OWNER TO sotkb;

--
-- Name: voevents; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE voevents (
    "eventKey" integer DEFAULT nextval('"voevents_eventKey_seq"'::regclass) NOT NULL,
    "eventId" character varying(128) DEFAULT NULL::character varying,
    date timestamp without time zone,
    "role" character varying(32) DEFAULT NULL::character varying,
    "eventType" integer,
    "obsId" character varying(128) DEFAULT NULL::character varying,
    "obsNum" character varying(128) DEFAULT NULL::character varying,
    "progVer" character varying(64) DEFAULT NULL::character varying,
    "progNumber" character varying(64) DEFAULT NULL::character varying,
    "jopId" character varying(32) DEFAULT NULL::character varying,
    loc character varying(512) DEFAULT NULL::character varying,
    "contactId" integer,
    observatory character varying(64) DEFAULT NULL::character varying,
    "telescopeId" integer,
    telescope character varying(64) DEFAULT NULL::character varying,
    "instrumentId" integer,
    instrument character varying(64) DEFAULT NULL::character varying,
    tohbans character varying(64) DEFAULT NULL::character varying,
    planners character varying(128) DEFAULT NULL::character varying,
    observers character varying(128) DEFAULT NULL::character varying,
    "obsTitle" character varying(512) DEFAULT NULL::character varying,
    category character varying(512) DEFAULT NULL::character varying,
    concept character varying(512) DEFAULT NULL::character varying,
    goal character varying(512) DEFAULT NULL::character varying,
    purpose character varying(512) DEFAULT NULL::character varying,
    "sciObjectives" character varying(512) DEFAULT NULL::character varying,
    "noaaNum" character varying(32) DEFAULT NULL::character varying,
    jop character varying(64) DEFAULT NULL::character varying,
    "joinSb" character varying(32) DEFAULT NULL::character varying,
    target character varying(64) DEFAULT NULL::character varying,
    objects character varying(512) DEFAULT NULL::character varying,
    "parentUrl" character varying(512) DEFAULT NULL::character varying,
    "coordinateSystem" character varying(32) DEFAULT NULL::character varying,
    "startTime" timestamp without time zone,
    "stopTime" timestamp without time zone,
    "position2D" character varying(64) DEFAULT NULL::character varying,
    "xCen" double precision,
    "yCen" double precision,
    "xFov" double precision,
    "yFov" double precision,
    "posX" double precision,
    "posY" double precision,
    "bboxLlX" double precision,
    "bboxLlY" double precision,
    "bboxUrX" double precision,
    "bboxUrY" double precision,
    "uModes" text,
    "waveIds" character varying(512) DEFAULT NULL::character varying,
    wavelengths character varying(512) DEFAULT NULL::character varying,
    cadences character varying(512) DEFAULT NULL::character varying,
    "minCadence" double precision,
    "maxCadence" double precision,
    "minImages" integer,
    "maxImages" integer,
    tags character varying(512) DEFAULT NULL::character varying,
    descriptions text,
    note text,
    "supercedeCount" integer,
    "viewCount" integer,
    "numRatings" integer,
    ranking double precision,
    "thumbPath" character varying(512) DEFAULT NULL::character varying,
    "fullResPath" character varying(512) DEFAULT NULL::character varying,
    "receiptTime" timestamp without time zone,
    "movieUrl" character varying(512) DEFAULT NULL::character varying,
    "galleryId" character varying(512) DEFAULT NULL::character varying,
    expires timestamp without time zone,
    username character varying(64)
);


ALTER TABLE public.voevents OWNER TO sotkb;

--
-- Name: voevents_backup; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE voevents_backup (
    "eventKey" integer DEFAULT 0 NOT NULL,
    "eventId" character varying(128) DEFAULT NULL::character varying,
    date timestamp without time zone,
    "role" character varying(32) DEFAULT NULL::character varying,
    "eventType" integer,
    "obsId" character varying(128) DEFAULT NULL::character varying,
    "obsNum" character varying(32) DEFAULT NULL::character varying,
    "progVer" integer,
    "progNumber" integer,
    "jopId" character varying(32) DEFAULT NULL::character varying,
    loc character varying(255) DEFAULT NULL::character varying,
    "contactId" integer,
    observatory character varying(64) DEFAULT NULL::character varying,
    "telescopeId" integer,
    telescope character varying(64) DEFAULT NULL::character varying,
    "instrumentId" integer,
    instrument character varying(64) DEFAULT NULL::character varying,
    tohbans character varying(64) DEFAULT NULL::character varying,
    planners character varying(128) DEFAULT NULL::character varying,
    observers character varying(128) DEFAULT NULL::character varying,
    "obsTitle" character varying(255) DEFAULT NULL::character varying,
    category character varying(255) DEFAULT NULL::character varying,
    concept character varying(255) DEFAULT NULL::character varying,
    goal character varying(255) DEFAULT NULL::character varying,
    purpose character varying(255) DEFAULT NULL::character varying,
    "sciObjectives" character varying(255) DEFAULT NULL::character varying,
    "noaaNum" character varying(32) DEFAULT NULL::character varying,
    jop character varying(64) DEFAULT NULL::character varying,
    "joinSb" character varying(32) DEFAULT NULL::character varying,
    target character varying(64) DEFAULT NULL::character varying,
    objects character varying(255) DEFAULT NULL::character varying,
    "parentUrl" character varying(255) DEFAULT NULL::character varying,
    "coordinateSystem" character varying(32) DEFAULT NULL::character varying,
    "startTime" timestamp without time zone,
    "stopTime" timestamp without time zone,
    "position2D" character varying(64) DEFAULT NULL::character varying,
    "xCen" double precision,
    "yCen" double precision,
    "xFov" double precision,
    "yFov" double precision,
    "posX" double precision,
    "posY" double precision,
    "bboxLlX" double precision,
    "bboxLlY" double precision,
    "bboxUrX" double precision,
    "bboxUrY" double precision,
    "uModes" text,
    "waveIds" character varying(255) DEFAULT NULL::character varying,
    wavelengths character varying(255) DEFAULT NULL::character varying,
    cadences character varying(255) DEFAULT NULL::character varying,
    "minCadence" double precision,
    "maxCadence" double precision,
    "minImages" integer,
    "maxImages" integer,
    tags character varying(255) DEFAULT NULL::character varying,
    descriptions text,
    note text,
    "supercedeCount" integer,
    "viewCount" integer,
    "numRatings" integer,
    ranking double precision,
    "thumbPath" character varying(255) DEFAULT NULL::character varying,
    "fullResPath" character varying(255) DEFAULT NULL::character varying,
    "receiptTime" timestamp without time zone
);


ALTER TABLE public.voevents_backup OWNER TO sotkb;

--
-- Name: voevents_xml_eventKey_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "voevents_xml_eventKey_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."voevents_xml_eventKey_seq" OWNER TO sotkb;

--
-- Name: voevents_xml; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE voevents_xml (
    "eventKey" integer DEFAULT nextval('"voevents_xml_eventKey_seq"'::regclass) NOT NULL,
    "eventId" character varying(128) DEFAULT NULL::character varying,
    "role" character varying(32) DEFAULT NULL::character varying,
    "eventType" integer,
    "obsId" character varying(128) DEFAULT NULL::character varying,
    "obsNum" character varying(128) DEFAULT NULL::character varying,
    "progVer" character varying(64) DEFAULT NULL::character varying,
    "progNumber" character varying(64) DEFAULT NULL::character varying,
    loc character varying(255) DEFAULT NULL::character varying,
    "receiptTime" timestamp without time zone,
    xml text,
    instrument character varying(128) DEFAULT NULL::character varying
);


ALTER TABLE public.voevents_xml OWNER TO sotkb;

--
-- Name: xml_backup; Type: TABLE; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE TABLE xml_backup (
    "eventKey" integer DEFAULT 0 NOT NULL,
    "eventId" character varying(128) DEFAULT NULL::character varying,
    "role" character varying(32) DEFAULT NULL::character varying,
    "eventType" integer,
    "obsId" character varying(128) DEFAULT NULL::character varying,
    "obsNum" character varying(32) DEFAULT NULL::character varying,
    "progVer" integer,
    "progNumber" integer,
    loc character varying(255) DEFAULT NULL::character varying,
    "receiptTime" timestamp without time zone,
    xml text
);


ALTER TABLE public.xml_backup OWNER TO sotkb;

--
-- Name: box_regions_boxId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "box_regions_boxId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."box_regions_boxId_seq1" OWNER TO sotkb;

--
-- Name: citations_    citationId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "citations_    citationId_seq"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."citations_    citationId_seq" OWNER TO sotkb;

--
-- Name: citations_citationId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "citations_citationId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."citations_citationId_seq1" OWNER TO sotkb;

--
-- Name: contacts_contactId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "contacts_contactId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."contacts_contactId_seq1" OWNER TO sotkb;

--
-- Name: coords_coordId_seq; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "coords_coordId_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."coords_coordId_seq" OWNER TO sotkb;

--
-- Name: descriptions_descriptionId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "descriptions_descriptionId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."descriptions_descriptionId_seq1" OWNER TO sotkb;

--
-- Name: ellipse_regions_ellipseId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "ellipse_regions_ellipseId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."ellipse_regions_ellipseId_seq1" OWNER TO sotkb;

--
-- Name: groups_groupId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "groups_groupId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."groups_groupId_seq1" OWNER TO sotkb;

--
-- Name: instruments_instrumentId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "instruments_instrumentId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."instruments_instrumentId_seq1" OWNER TO sotkb;

--
-- Name: observation_notes_observationId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "observation_notes_observationId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."observation_notes_observationId_seq1" OWNER TO sotkb;

--
-- Name: observation_ratings_ratingId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "observation_ratings_ratingId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."observation_ratings_ratingId_seq1" OWNER TO sotkb;

--
-- Name: panorama_views_panoViewId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "panorama_views_panoViewId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."panorama_views_panoViewId_seq1" OWNER TO sotkb;

--
-- Name: params_paramId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "params_paramId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."params_paramId_seq1" OWNER TO sotkb;

--
-- Name: pod_podId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "pod_podId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."pod_podId_seq1" OWNER TO sotkb;

--
-- Name: pod_ratings_ratingId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "pod_ratings_ratingId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."pod_ratings_ratingId_seq1" OWNER TO sotkb;

--
-- Name: pointings_pointingId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "pointings_pointingId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."pointings_pointingId_seq1" OWNER TO sotkb;

--
-- Name: polygon_regions_polygonId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "polygon_regions_polygonId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."polygon_regions_polygonId_seq1" OWNER TO sotkb;

--
-- Name: ql_thumbs_qlId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "ql_thumbs_qlId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."ql_thumbs_qlId_seq1" OWNER TO sotkb;

--
-- Name: refs_referenceId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "refs_referenceId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."refs_referenceId_seq1" OWNER TO sotkb;

--
-- Name: telescopes_telescopeId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "telescopes_telescopeId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."telescopes_telescopeId_seq1" OWNER TO sotkb;

--
-- Name: vertices_vertexId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "vertices_vertexId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."vertices_vertexId_seq1" OWNER TO sotkb;

--
-- Name: voevent_annotations_annotationId_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "voevent_annotations_annotationId_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."voevent_annotations_annotationId_seq1" OWNER TO sotkb;

--
-- Name: voevents_eventKey_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "voevents_eventKey_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."voevents_eventKey_seq1" OWNER TO sotkb;

--
-- Name: voevents_xml_eventKey_seq1; Type: SEQUENCE; Schema: public; Owner: sotkb
--

CREATE SEQUENCE "voevents_xml_eventKey_seq1"
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."voevents_xml_eventKey_seq1" OWNER TO sotkb;

--
-- Name: coordId; Type: DEFAULT; Schema: public; Owner: sotkb
--

ALTER TABLE coords ALTER COLUMN "coordId" SET DEFAULT nextval('"coords_coordId_seq"'::regclass);


--
-- Name: box_regions_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY box_regions
    ADD CONSTRAINT box_regions_pkey PRIMARY KEY ("boxId");


--
-- Name: citations_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY citations
    ADD CONSTRAINT citations_pkey PRIMARY KEY ("citationId");


--
-- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY contacts
    ADD CONSTRAINT contacts_pkey PRIMARY KEY ("contactId");


--
-- Name: coords_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY coords
    ADD CONSTRAINT coords_pkey PRIMARY KEY ("coordId");


--
-- Name: descriptions_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY descriptions
    ADD CONSTRAINT descriptions_pkey PRIMARY KEY ("descriptionId");


--
-- Name: ellipse_regions_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY ellipse_regions
    ADD CONSTRAINT ellipse_regions_pkey PRIMARY KEY ("ellipseId");


--
-- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY groups
    ADD CONSTRAINT groups_pkey PRIMARY KEY ("groupId");


--
-- Name: instruments_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY instruments
    ADD CONSTRAINT instruments_pkey PRIMARY KEY ("instrumentId");


--
-- Name: observation_notes_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY observation_notes
    ADD CONSTRAINT observation_notes_pkey PRIMARY KEY ("observationId");


--
-- Name: observation_ratings_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY observation_ratings
    ADD CONSTRAINT observation_ratings_pkey PRIMARY KEY ("ratingId");


--
-- Name: panorama_views_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY panorama_views
    ADD CONSTRAINT panorama_views_pkey PRIMARY KEY ("panoViewId");


--
-- Name: params_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY params
    ADD CONSTRAINT params_pkey PRIMARY KEY ("paramId");


--
-- Name: pod_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY pod
    ADD CONSTRAINT pod_pkey PRIMARY KEY ("podId");


--
-- Name: pod_ratings_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY pod_ratings
    ADD CONSTRAINT pod_ratings_pkey PRIMARY KEY ("ratingId");


--
-- Name: pointings_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY pointings
    ADD CONSTRAINT pointings_pkey PRIMARY KEY ("pointingId");


--
-- Name: polygon_regions_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY polygon_regions
    ADD CONSTRAINT polygon_regions_pkey PRIMARY KEY ("polygonId");


--
-- Name: ql_thumbs_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY ql_thumbs
    ADD CONSTRAINT ql_thumbs_pkey PRIMARY KEY ("qlId");


--
-- Name: refs_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY refs
    ADD CONSTRAINT refs_pkey PRIMARY KEY ("referenceId");


--
-- Name: telescopes_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY telescopes
    ADD CONSTRAINT telescopes_pkey PRIMARY KEY ("telescopeId");


--
-- Name: vertices_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY vertices
    ADD CONSTRAINT vertices_pkey PRIMARY KEY ("vertexId");


--
-- Name: voevent_annotations_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY voevent_annotations
    ADD CONSTRAINT voevent_annotations_pkey PRIMARY KEY ("annotationId");


--
-- Name: voevents_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY voevents
    ADD CONSTRAINT voevents_pkey PRIMARY KEY ("eventKey");


--
-- Name: voevents_xml_pkey; Type: CONSTRAINT; Schema: public; Owner: sotkb; Tablespace: 
--

ALTER TABLE ONLY voevents_xml
    ADD CONSTRAINT voevents_xml_pkey PRIMARY KEY ("eventKey");


--
-- Name: event_key; Type: INDEX; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE INDEX event_key ON groups USING btree ("eventKey");


--
-- Name: group_id; Type: INDEX; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE INDEX group_id ON params USING btree ("groupId");


--
-- Name: pevent_key; Type: INDEX; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE INDEX pevent_key ON params USING btree ("eventKey");


--
-- Name: ranking_type; Type: INDEX; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE INDEX ranking_type ON voevents USING btree ("eventKey", "eventType");


--
-- Name: type_date; Type: INDEX; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE INDEX type_date ON voevents USING btree ("eventKey", date);


--
-- Name: type_times; Type: INDEX; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE INDEX type_times ON voevents USING btree ("eventKey", "startTime");


--
-- Name: viewcount_type; Type: INDEX; Schema: public; Owner: sotkb; Tablespace: 
--

CREATE INDEX viewcount_type ON voevents USING btree ("eventKey", "eventType");


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--

