yanolja

Tables (17)

accommodation_amenities

  • id — BIGINT — Primary key — NOT NULL
  • accommodation_id — BIGINT — Foreign key → accommodations.id — NOT NULL
  • amentiy_id — BIGINT — Foreign key → amenities.id — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

accommodation_images

  • id — BIGINT — Primary key — NOT NULL
  • accommodation_id — BIGINT — Foreign key → accommodations.id — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • is_main — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)
  • Field

accommodations

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • address — VARCHAR(255) — NOT NULL
  • latitude — DECIMAL(10, 8)
  • longitude — DECIMAL(11, 8)
  • price_per_night — DECIMAL(10, 2) — NOT NULL
  • rating — DECIMAL(3, 2)
  • review_count — INT
  • status — VARCHAR(20)
  • deleted_yn — VARCHAR(1)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

amenities

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • icon_url — VARCHAR(255)
  • created_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

coupons

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • discount_type — VARCHAR(20) — NOT NULL
  • discount_value — DECIMAL(10, 2) — NOT NULL
  • min_purchase_amount — DECIMAL(10, 2)
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME — NOT NULL
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

payments

  • id — BIGINT — Primary key — NOT NULL
  • reservation_id — BIGINT — Foreign key → reservations.id — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • payment_method — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20)
  • transaction_id — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

reservation_options

  • id — BIGINT — Primary key — NOT NULL
  • reservation_id — BIGINT — Foreign key → reservations.id — NOT NULL
  • option_id — BIGINT — Foreign key → room_options.id — NOT NULL
  • quantity — INT — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • created_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

reservations

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • check_in_date — DATE — NOT NULL
  • check_out_date — DATE — NOT NULL
  • total_price — DECIMAL(10, 2) — NOT NULL
  • status — VARCHAR(20)
  • payment_status — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

review_images

  • id — BIGINT — Primary key — NOT NULL
  • review_id — BIGINT — Foreign key → reviews.id — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

reviews

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • accommodation_id — BIGINT — Foreign key → accommodations.id — NOT NULL
  • reservation_id — BIGINT — Foreign key → reservations.id — NOT NULL
  • rating — INT — NOT NULL
  • comment — TEXT — EX
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

room_images

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.id — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • is_main — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

room_option_mappings

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.id — NOT NULL
  • option_id — BIGINT — Foreign key → room_options.id — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

room_options

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • created_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

rooms

  • id — BIGINT — Primary key — NOT NULL
  • accommodation_id — BIGINT — Foreign key → accommodations.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • capacity — INT — NOT NULL
  • price_per_night — DECIMAL(10, 2) — NOT NULL
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

user_coupons

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • coupon_id — BIGINT — Foreign key → coupons.id — NOT NULL
  • is_used — BOOLEAN
  • used_at — TIMESTAMP
  • created_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • role — VARCHAR(20)
  • profile_image_url — VARCHAR(255)
  • social_provider — VARCHAR(20)
  • social_id — VARCHAR(255)
  • withdrawal_yn — VARCHAR(1)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

wishlists

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • accommodation_id — BIGINT — Foreign key → accommodations.id — NOT NULL
  • created_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)