Airbnb Calendar Table

calendar.sql

BEGIN;
CREATE TABLE "airdata"."calendar"
(
    "listing_id"     BIGINT NOT NULL,
    "date"           timestamptz,
    "available"      BOOLEAN,
    "price"          DECIMAL,
    "adjusted_price" DECIMAL,
    "minimum_nights" INTEGER,
    "maximum_nights" INTEGER,
    CONSTRAINT "PK_calendar_01" PRIMARY KEY ("listing_id", "date")
);

CREATE INDEX "IDX_calendar_listing_id" ON "airdata"."calendar" ("listing_id");
CREATE INDEX "IDX_calendar_date" ON "airdata"."calendar" ("date");
CREATE INDEX "IDX_calendar_price" ON "airdata"."calendar" ("price");

COMMIT;