 ALTER TABLE ONLY extrinsicobject
     ADD CONSTRAINT extrinsicobject_pkey PRIMARY KEY (id);
 
-
---
--- TOC entry 1926 (class 2606 OID 78646)
--- Dependencies: 1577 1577
--- Name: federation_pkey; Type: CONSTRAINT; Schema: public; Owner: omar; Tablespace: 
---
-
-ALTER TABLE ONLY federation
-    ADD CONSTRAINT federation_pkey PRIMARY KEY (id);
-
-
 --
 -- TOC entry 1953 (class 2606 OID 80294)
 -- Dependencies: 1589 1589

ALTER TABLE public.name_ OWNER TO omar;

--
-- TOC entry 1590 (class 1259 OID 78558)
-- Dependencies: 1887 6
-- Name: notification; Type: TABLE; Schema: public; Owner: omar; Tablespace: 
--

CREATE TABLE notification (
    id character varying(256) NOT NULL,
    home character varying(256),
    lid character varying(256) NOT NULL,
    objecttype character varying(256),
    status character varying(256) NOT NULL,
    versionname character varying(16),
    comment_ character varying(256),
    subscription character varying(256) NOT NULL,
    CONSTRAINT notification_objecttype_check CHECK (((objecttype)::text = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Notification'::text))
);


ALTER TABLE public.notification OWNER TO omar;

--
-- TOC entry 1591 (class 1259 OID 78567)
-- Dependencies: 6
-- Name: notificationobject; Type: TABLE; Schema: public; Owner: omar; Tablespace: 
--

CREATE TABLE notificationobject (
    notificationid character varying(256) NOT NULL,
    registryobjectid character varying(256) NOT NULL
);


ALTER TABLE public.notificationobject OWNER TO omar;

--
-- TOC entry 1592 (class 1259 OID 78573)
-- Dependencies: 6
-- Name: notifyaction; Type: TABLE; Schema: public; Owner: omar; Tablespace: 
--

CREATE TABLE notifyaction (
    notificationoption character varying(256) NOT NULL,
    endpoint character varying(256) NOT NULL,
    parent character varying(256) NOT NULL
);


ALTER TABLE public.notifyaction OWNER TO omar;

--
-- TOC entry 1593 (class 1259 OID 78579)
-- Dependencies: 6
-- Name: postaladdress; Type: TABLE; Schema: public; Owner: omar; Tablespace: 
--

CREATE TABLE postaladdress (
    city character varying(64),
    country character varying(64),
    postalcode character varying(64),
    state character varying(64),
    street character varying(64),
    streetnumber character varying(32),
    parent character varying(256) NOT NULL
);


ALTER TABLE public.postaladdress OWNER TO omar;

--
-- TOC entry 1594 (class 1259 OID 78585)
-- Dependencies: 6
-- Name: registryobject; Type: TABLE; Schema: public; Owner: omar; Tablespace: 
--

--CREATE TABLE registryobject (
--    id character varying(256) NOT NULL,
--    home character varying(256),
--    lid character varying(256) NOT NULL,
--    objecttype character varying(256) NOT NULL,
--    status character varying(256) NOT NULL,
--    versionname character varying(16),
--    comment_ character varying(256)
--);


--ALTER TABLE public.registryobject OWNER TO omar;

--
-- TOC entry 1595 (class 1259 OID 78591)
-- Dependencies: 6
-- Name: repositoryitem; Type: TABLE; Schema: public; Owner: omar; Tablespace: 
--

CREATE TABLE repositoryitem (
    lid character varying(256) NOT NULL,
    versionname character varying(16) NOT NULL,
    content bytea
);


ALTER TABLE public.repositoryitem OWNER TO omar;

--
-- TOC entry 1596 (class 1259 OID 78597)
-- Dependencies: 6
-- Name: slot; Type: TABLE; Schema: public; Owner: omar; Tablespace: 


CREATE TABLE externalidentifier (
    id character varying(64) NOT NULL,
    lid character varying(64) NOT NULL,
    objecttype char(2),
    status char(1) NOT NULL,
    versionname character varying(16),
    registryobject character varying(64) NOT NULL,
    identificationscheme char(2) NOT NULL,
    value character varying(128) NOT NULL,
    CONSTRAINT externalidentifier_objecttype_check CHECK (((objecttype)::text = 'EI'::text))
);


ALTER TABLE public.externalidentifier OWNER TO omar;


--
-- TOC entry 1576 (class 1259 OID 78460)
