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