ddd

Tables (19)

ai_logs

  • log_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • speaker_id — BIGINT — NOT NULL
  • original_text — TEXT
  • translated_text — TEXT
  • context_tag — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

ai_recommendations

  • recommendation_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • product_id — BIGINT
  • reason — VARCHAR(1000)
  • type — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

cart_items

  • cart_item_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • added_by_user_id — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • is_purchased — BOOLEAN — NOT NULL
  • is_alerted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

item_splits

  • split_id — BIGINT
  • settlement_item_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • is_excluded — BOOLEAN — NOT NULL
  • amount_to_pay — DECIMAL(15,2) — NOT NULL

pins

  • pin_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • comment — VARCHAR(500) — ARCHAR(500
  • position_x — DECIMAL(12,6)
  • position_y — DECIMAL(12,6)
  • created_at — DATETIME — NOT NULL

products

  • product_id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • category — VARCHAR(100)
  • price — DECIMAL(15,2) — NOT NULL
  • image_url — VARCHAR(2048)
  • origin_url — VARCHAR(2048)
  • multi_language_names — JSON

reactions

  • reaction_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • target_id — BIGINT — NOT NULL
  • target_type — VARCHAR(10) — NOT NULL
  • user_id — BIGINT — NOT NULL
  • reaction_code — VARCHAR(20) — NOT NULL

receipts

  • receipt_id — BIGINT
  • settlement_id — BIGINT — NOT NULL
  • image_url — VARCHAR(2048) — NOT NULL
  • ocr_status — VARCHAR(20) — NOT NULL
  • uploaded_at — DATETIME — NOT NULL

room_members

  • member_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • role — VARCHAR(10) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • is_camera_on — BOOLEAN — NOT NULL
  • current_cursor_x — DECIMAL(12,6)
  • current_cursor_y — DECIMAL(12,6)
  • joined_at — DATETIME — NOT NULL

rooms

  • room_id — BIGINT
  • host_user_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • room_code — VARCHAR(64) — NOT NULL
  • type — VARCHAR(10) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • budget_goal — DECIMAL(15,2)
  • sync_mode — VARCHAR(10)
  • current_url — VARCHAR(2048)
  • created_at — DATETIME — NOT NULL
  • closed_at — DATETIME

settlement_items

  • item_id — BIGINT
  • receipt_id — BIGINT — NOT NULL
  • item_name — VARCHAR(255) — NOT NULL
  • unit_price — DECIMAL(15,2) — NOT NULL
  • quantity — INT — NOT NULL
  • total_price — DECIMAL(15,2) — NOT NULL

settlements

  • settlement_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • total_amount — DECIMAL(15,2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

shopping_reports

  • report_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • summary_content — TEXT
  • report_type — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL

transfer_status

  • transfer_id — BIGINT
  • settlement_id — BIGINT — NOT NULL
  • from_user_id — BIGINT — NOT NULL
  • to_user_id — BIGINT — NOT NULL
  • amount — DECIMAL(15,2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • user_id — BIGINT
  • nickname — VARCHAR(50) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • profile_image — VARCHAR(1024)
  • language_code — VARCHAR(10)
  • bank_name — VARCHAR(50)
  • account_number — VARCHAR(50)
  • qr_code_url — VARCHAR(1024)

vote_options

  • option_id — BIGINT
  • vote_id — BIGINT — NOT NULL
  • content — VARCHAR(255) — NOT NULL

vote_participants

  • vote_part_id — BIGINT
  • option_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL

votes

  • vote_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • closed_at — DATETIME

wishlist_items

  • wishlist_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • added_by_user_id — BIGINT — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • note — VARCHAR(500)
  • created_at — DATETIME — NOT NULL