bangbang

Tables (3)

accommodations

  • id — SERIAL — Primary key
  • name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE — NOT NULL
  • price_per_night — INT — NOT NULL
  • description — TEXT
  • image_url — VARCHAR(500)
  • rating — FLOAT
  • review_count — INT
  • max_capacity — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

bookings

  • id — SERIAL — Primary key
  • user_id (id2) — SERIAL — Foreign key → users.id
  • accommodation_id (id3) — SERIAL — Foreign key → accommodations.id
  • check_in — DATE — NOT NULL
  • check_out — DATE — NOT NULL
  • total_count — INT — NOT NULL
  • total_price — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

users

  • id — SERIAL — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL