yanolja

Tables (20)

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)

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 — VARCHAR(500)
  • discount_type — VARCHAR(20) — NOT NULL
  • discount_value — DECIMAL(12, 2) — NOT NULL
  • max_discount_amount — DECIMAL(12, 2)
  • min_order_amount — DECIMAL(12, 2)
  • issue_count — INT — NOT NULL
  • used_count — INT — NOT NULL
  • issue_start_at — TIMESTAMP — NOT NULL
  • issue_end_at — TIMESTAMP — NOT NULL
  • valid_from — TIMESTAMP — NOT NULL
  • valid_until — TIMESTAMP — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • issue_type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

order_coupons

  • id — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL
  • user_coupon_id — BIGINT — Foreign key → user_coupons.id — NOT NULL
  • discount_amount — DECIMAL(12, 2) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

orders

  • id (Key) — BIGINT — Primary key — NOT NULL
  • order_number — VARCHAR(50) — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • reservation_id — BIGINT — Foreign key → reservations.id — NOT NULL
  • original_amount — DECIMAL(12, 2) — NOT NULL
  • discount_amount — DECIMAL(12, 2)
  • points_used — INT
  • final_amount — DECIMAL(12, 2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • expired_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

payments

  • id — BIGINT — Primary key — NOT NULL
  • payment_key — VARCHAR(100) — NOT NULL
  • order_id (Key) — BIGINT — Foreign key → orders.id — NOT NULL
  • payment_method — VARCHAR(20) — NOT NULL
  • amount — DECIMAL(12, 2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • pg_provider — VARCHAR(50)
  • pg_transaction_id — VARCHAR(200)
  • approval_number — VARCHAR(100)
  • card_number — VARCHAR(20)
  • card_type — VARCHAR(50)
  • installment_months — INT
  • paid_at — TIMESTAMP
  • failure_reason — VARCHAR(500)
  • receipt_url — VARCHAR(500)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

points

  • id — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • transaction_type — VARCHAR(20) — NOT NULL
  • amount — INT — NOT NULL
  • balance — INT — NOT NULL
  • description — VARCHAR(500)
  • order_id — BIGINT
  • expired_at — TIMESTAMP
  • status — VARCHAR(20) — NOT NULL
  • 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
  • status — VARCHAR(20) — NOT NULL
  • used_at — TIMESTAMP
  • order_id — BIGINT
  • created_at — TIMESTAMP
  • updated_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)