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