booking
Tables (6)
accommodations
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
bookings
- id — BIGINT — Primary key — NOT NULL
- idempotency_key — VARCHAR(64) — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- product_id — BIGINT — Foreign key → products.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- total_amount — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
payments
- id — BIGINT — Primary key — NOT NULL
- booking_id — BIGINT — Foreign key → bookings.id — NOT NULL
- payment_type — VARCHAR(20) — NOT NULL
- amount — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- pg_transaction_id — VARCHAR(100)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
products
- id — BIGINT — Primary key — NOT NULL
- room_type_id — BIGINT — Foreign key → room_types.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- price — INT — NOT NULL
- check_in_at — TIME — NOT NULL
- check_out_at — TIME — NOT NULL
- total_stock — INT — NOT NULL
- open_at — DATETIME — NOT NULL
- close_at — DATETIME — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
room_types
- id — BIGINT — Primary key — NOT NULL
- accommodation_id — BIGINT — Foreign key → accommodations.id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- description — VARCHAR(255)
- base_price — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- point_balance — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL