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

BEGIN;
--
-- Name: NamesByTagKey; Type: VIEW; Schema: 1; Owner: knowsme_master
--

CREATE VIEW "NamesByTagKey" AS
 SELECT "Name"."NameId",
    "Name"."TextualForm",
    "Name"."Popularity",
    "Tag"."Key"
   FROM ("Name"
     JOIN "Tag" USING ("NameId"));


ALTER TABLE "NamesByTagKey" OWNER TO "knowsme_master";

COMMIT;
