Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Airbnb Review Table
BEGIN;
CREATE TABLE "airdata"."review"
(
"listing_id" BIGINT NOT NULL,
"id" BIGINT NOT NULL,
"date" timestamptz,
"reviewer_id" BIGINT,
"reviewer_name" TEXT,
"comments" TEXT,
CONSTRAINT "PK_review_01" PRIMARY KEY ("id")
);
CREATE INDEX "IDX_review_listing_id" ON "airdata"."review" ("listing_id");
CREATE INDEX "IDX_review_reviewer_id" ON "airdata"."review" ("reviewer_id");
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment