CREATE TABLE listing (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  title VARCHAR(128) NOT NULL,
  city VARCHAR(64) NOT NULL,
  rating DECIMAL(3, 2) DEFAULT 5.0,
  nightly_rate INT NOT NULL CHECK (nightly_rate > 0),
  category VARCHAR(32) NOT NULL
);

CREATE TABLE booking (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  listing_id UUID REFERENCES listing(id),
  nights INT NOT NULL CHECK (nights > 0),
  total_price INT NOT NULL
);