-- requires: schema-1
-- requires: table-Name

BEGIN;
--
-- Name: Pronunciation; Type: TABLE; Schema: 1; Owner: knowsme_master; Tablespace: 
--

CREATE TABLE "Pronunciation" (
    "NameId" integer NOT NULL,
    "PhoneticForm" "text" NOT NULL,
    "PronunciationId" integer NOT NULL
);

ALTER TABLE "Pronunciation" OWNER TO "knowsme_master";


--
-- Name: Pronunciation_PronunciationId_seq; Type: SEQUENCE; Schema: 1; Owner: knowsme_master
--

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


ALTER TABLE "Pronunciation_PronunciationId_seq" OWNER TO "knowsme_master";

--
-- Name: Pronunciation_PronunciationId_seq; Type: SEQUENCE OWNED BY; Schema: 1; Owner: knowsme_master
--

ALTER SEQUENCE "Pronunciation_PronunciationId_seq" OWNED BY "Pronunciation"."PronunciationId";

--
-- Name: PronunciationId; Type: DEFAULT; Schema: 1; Owner: knowsme_master
--

ALTER TABLE ONLY "Pronunciation" ALTER COLUMN "PronunciationId" SET DEFAULT "nextval"('"Pronunciation_PronunciationId_seq"'::"regclass");


--
-- Name: Pronunciation_NameId_PhoneticForm_key; Type: CONSTRAINT; Schema: 1; Owner: knowsme_master; Tablespace: 
--

ALTER TABLE ONLY "Pronunciation"
    ADD CONSTRAINT "Pronunciation_NameId_PhoneticForm_key" UNIQUE ("NameId", "PhoneticForm");


--
-- Name: Pronunciation_pkey; Type: CONSTRAINT; Schema: 1; Owner: knowsme_master; Tablespace: 
--

ALTER TABLE ONLY "Pronunciation"
    ADD CONSTRAINT "Pronunciation_pkey" PRIMARY KEY ("PronunciationId");


--
-- Name: Pronunciation_NameId_fkey; Type: FK CONSTRAINT; Schema: 1; Owner: knowsme_master
--

ALTER TABLE ONLY "Pronunciation"
    ADD CONSTRAINT "Pronunciation_NameId_fkey" FOREIGN KEY ("NameId") REFERENCES "Name"("NameId") ON UPDATE CASCADE ON DELETE CASCADE;



COMMIT;
