[OSM-talk-nl] XAPI maar dan beter [schema]

[Stefan de Konink]

Op verzoek van Roeland:

CREATE TABLE "sys"."nodes_legacy" (
         "id" int NOT NULL DEFAULT next value for "sys"."s_nodes",
         "long" double,
         "lat" double,
         "uid" int,
         "timestamp" timestamptz(7),
         "zcurve" bigint,
         CONSTRAINT "pk_nodes_id" PRIMARY KEY ("id")
);
CREATE TABLE "sys"."node_tags" (
         "node" int,
         "k" varchar(255),
         "v" varchar(1024)
);
CREATE TABLE "sys"."ways" (
         "id" int NOT NULL DEFAULT next value for "sys"."s_ways",
         "uid" int,
         "timestamp" timestamptz(7),
         CONSTRAINT "pk_ways_id" PRIMARY KEY ("id")
);
CREATE TABLE "sys"."way_tags" (
         "way" int,
         "k" varchar(255),
         "v" varchar(1024)
);
CREATE TABLE "sys"."way_nds" (
         "way" int,
         "idx" int,
         "to_node" int
);
CREATE TABLE "sys"."relations" (
         "id" int NOT NULL DEFAULT next value for "sys"."s_relations",
         "uid" int,
         "timestamp" timestamptz(7),
         CONSTRAINT "pk_relations_id" PRIMARY KEY ("id")
);
CREATE TABLE "sys"."relation_members_node" (
         "relation" int NOT NULL,
         "idx" int NOT NULL,
         "to_node" int,
         "role" varchar(255),
         CONSTRAINT "pk_relation_members_node" PRIMARY KEY ("relation", 
"idx")
);
CREATE TABLE "sys"."relation_members_relation" (
         "relation" int NOT NULL,
         "idx" int NOT NULL,
         "to_relation" int,
         "role" varchar(255),
         CONSTRAINT "pk_relation_members_relation" PRIMARY KEY 
("relation", "idx")
);
CREATE TABLE "sys"."relation_members_way" (
         "relation" int NOT NULL,
         "idx" int NOT NULL,
         "to_way" int,
         "role" varchar(255),
         CONSTRAINT "pk_relation_members_way" PRIMARY KEY ("relation", 
"idx")
);
CREATE TABLE "sys"."relation_tags" (
         "relation" int,
         "k" varchar(255),
         "v" varchar(1024)
);