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