-- requires: schema-1
-- requires: table-Pronunciation
-- requires: table-Tag

BEGIN;


--
-- Name: PronunciationsByTagKey; Type: VIEW; Schema: 1; Owner: knowsme_master
--

CREATE VIEW "PronunciationsByTagKey" WITH (security_barrier=true) AS
 SELECT "Pronunciation"."NameId",
    "Pronunciation"."PhoneticForm",
    "Pronunciation"."PronunciationId",
    "Tag"."Key"
   FROM ("Pronunciation"
     JOIN "Tag" USING ("PronunciationId"));


ALTER TABLE "PronunciationsByTagKey" OWNER TO "knowsme_master";

COMMIT;
