dd
Tables (31)
artist_members
- id — BIGINT — Primary key — NOT NULL
- artist_id — BIGINT — Foreign key → artists.id — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- stage_name — VARCHAR(100) — NOT NULL
- profile_image_url — VARCHAR(500)
- status — VARCHAR(30) — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
artist_posts
- id — BIGINT — Primary key — NOT NULL
- artist_id — BIGINT — Foreign key → artists.id — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- visibility — VARCHAR(30) — NOT NULL
- content — TEXT — NOT NULL
- like_count — BIGINT — NOT NULL
- comment_count — BIGINT — NOT NULL
- media_count — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
artist_youtube_videos
- id — BIGINT — Primary key — NOT NULL
- artist_id — BIGINT — Foreign key → artists.id — NOT NULL
- writer_member_id — BIGINT — Foreign key → members.id — NOT NULL
- writer_display_name — VARCHAR(100) — NOT NULL
- writer_profile_image_url — VARCHAR(500)
- youtube_video_id — VARCHAR(30) — NOT NULL
- youtube_url — VARCHAR(500) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- thumbnail_url — VARCHAR(500) — NOT NULL
- duration_seconds — BIGINT — NOT NULL
- published_at — DATETIME — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
artists
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100)
- slug — VARCHAR(100)
- profile_image_url — VARCHAR(500)
- cover_image_url — VARCHAR(500)
- intro — TEXT
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
auto_charge_histories
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → members.id — NOT NULL
- billing_key_id — BIGINT — Foreign key → billing_keys.id — NOT NULL
- jelly_amount — INT — NOT NULL
- success — BOOLEAN — NOT NULL
- fail_reason — VARCHAR(255)
- port_one_payment_id — VARCHAR(255)
- refunded — BOOLEAN — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
auto_charge_settings
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → members.id — NOT NULL
- billing_key_id — BIGINT — Foreign key → billing_keys.id — NOT NULL
- jelly_amount — INT — NOT NULL
- threshold_balance — INT — NOT NULL
- enabled — BOOLEAN — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
billing_keys
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → members.id — NOT NULL
- billing_key — VARCHAR(255) — NOT NULL
- card_name — VARCHAR(20) — NOT NULL
- card_last4 — VARCHAR(10) — NOT NULL
- default_card — BOOLEAN — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
comment_mentions
- id — BIGINT — Primary key — NOT NULL
- comment_id — BIGINT — Foreign key → comments.id — NOT NULL
- mentioned_member_id — BIGINT — Foreign key → members.id — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
comments
- id — BIGINT — Primary key — NOT NULL
- target_type — VARCHAR(30) — NOT NULL
- target_id — BIGINT — NOT NULL
- parent_id — BIGINT — Foreign key → comments.id
- depth — INT — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- content — TEXT — NOT NULL
- like_count — BIGINT — NOT NULL
- command_request_id — VARCHAR(64)
- deleted_placeholder — BOOLEAN — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
content_hashtags
- id — BIGINT — Primary key — NOT NULL
- target_type — VARCHAR(30) — NOT NULL
- target_id — BIGINT — NOT NULL
- hashtag_id — BIGINT — Foreign key → hashtags.id — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
dm_messages
- id — BIGINT — Primary key — NOT NULL
- dm_room_id — BIGINT — Foreign key → dm_rooms.id — NOT NULL
- sender_type — VARCHAR(10) — NOT NULL
- content — TEXT — NOT NULL
- sent_at — DATETIME — NOT NULL
- deleted_at — DATETIME
dm_rooms
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → members.id — NOT NULL
- artist_id — BIGINT — Foreign key → artists.id — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
dm_subscriptions
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → members.id — NOT NULL
- artist_id — BIGINT — Foreign key → artists.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- started_at — DATETIME — NOT NULL
- expired_at — DATETIME — NOT NULL
- jelly_amount — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
fan_letter
- id — BIGINT — Primary key — NOT NULL
- artist_id — BIGINT — Foreign key → artists.id — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- recipient_type — VARCHAR(30) — NOT NULL
- recipient_artist_member_id — BIGINT — Foreign key → artist_members.id
- like_count — BIGINT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
fan_memberships
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → members.id — NOT NULL
- artist_id — BIGINT — Foreign key → artists.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- started_at — DATETIME — NOT NULL
- expired_at — DATETIME — NOT NULL
- jelly_amount — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
fan_posts
- id — BIGINT — Primary key — NOT NULL
- artist_id — BIGINT — Foreign key → artists.id — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- visibility — VARCHAR(30) — NOT NULL
- content — TEXT — NOT NULL
- like_count — BIGINT — NOT NULL
- comment_count — BIGINT — NOT NULL
- media_count — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
follows
- id — BIGINT — Primary key — NOT NULL
- follower_member_id — BIGINT — Foreign key → members.id — NOT NULL
- target_artist_member_id — BIGINT — Foreign key → artist_members.id — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
hashtags
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- usage_count — BIGINT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
jelly_transactions
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → members.id — NOT NULL
- type — VARCHAR(20) — NOT NULL
- reference_type — VARCHAR(20) — NOT NULL
- related_id — BIGINT
- amount — INT — NOT NULL
- balance_after — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
live_chat_messages
- id — BIGINT — Primary key — NOT NULL
- live_stream_id — BIGINT — Foreign key → realtime_lives.id — NOT NULL
- sender_user_id — BIGINT — Foreign key → members.id — NOT NULL
- message — VARCHAR(500) — NOT NULL
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME
media_files
- id — BIGINT — Primary key — NOT NULL
- target_type — VARCHAR(30) — NOT NULL
- target_id — BIGINT — NOT NULL
- media_type — VARCHAR(30) — NOT NULL
- storage_key — VARCHAR(500) — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- thumbnail_url — VARCHAR(500)
- original_file_name — VARCHAR(255) — NOT NULL
- content_type — VARCHAR(100) — NOT NULL
- file_size — BIGINT — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
members
- id — BIGINT — Primary key — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(13)
- password — VARCHAR(255) — NOT NULL
- role — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- profile_image_url — VARCHAR(500)
- cover_image_url — VARCHAR(500)
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
payment_orders
- id — BIGINT — Primary key — NOT NULL
- payment_id — VARCHAR(255) — NOT NULL
- user_id — BIGINT — Foreign key → members.id — NOT NULL
- jelly_product — VARCHAR(50) — NOT NULL
- amount — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- paid_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
raffle_audit_logs
- id — BIGINT — Primary key — NOT NULL
- raffle_id — BIGINT — Foreign key → raffles.id — NOT NULL
- user_id — BIGINT — Foreign key → members.id — NOT NULL
- slot_index — INT — NOT NULL
- entry_order — INT — NOT NULL
- replaced — BOOLEAN — NOT NULL
- event_timestamp — TIMESTAMP — NOT NULL
raffle_entries
- id — BIGINT — Primary key — NOT NULL
- raffle_id — BIGINT — Foreign key → raffles.id — NOT NULL
- user_id — BIGINT — Foreign key → members.id — NOT NULL
- slot_index — INT — NOT NULL
- entry_order — INT — NOT NULL
- entered_at — DATETIME — NOT NULL
raffle_slot_winners
- id — BIGINT — Primary key — NOT NULL
- raffle_id — BIGINT — Foreign key → raffles.id — NOT NULL
- slot_id — BIGINT — Foreign key → raffle_slots.id — NOT NULL
- user_id — BIGINT — Foreign key → members.id — NOT NULL
- confirmed_at — DATETIME — NOT NULL
- reward_status — VARCHAR(20) — NOT NULL
- granted_at — DATETIME
raffle_slots
- id — BIGINT — Primary key — NOT NULL
- raffle_id — BIGINT — Foreign key → raffles.id — NOT NULL
- slot_index — INT — NOT NULL
- slot_start_at — DATETIME
- slot_end_at — DATETIME
- target_winner_count — INT — NOT NULL
- carry_over_count — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
raffles
- id — BIGINT — Primary key — NOT NULL
- artist_id — BIGINT — Foreign key → artists.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- entry_condition — VARCHAR(30) — NOT NULL
- reward_type — VARCHAR(30) — NOT NULL
- total_winners — INT — NOT NULL
- duration_minutes — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- started_at — DATETIME
- ended_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
reactions
- id — BIGINT — Primary key — NOT NULL
- target_type — VARCHAR(30) — NOT NULL
- target_id — BIGINT — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- reaction_type — VARCHAR(30) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
realtime_lives
- id — BIGINT — Primary key — NOT NULL
- artist_id — BIGINT — Foreign key → artists.id — NOT NULL
- host_member_id — BIGINT — Foreign key → members.id — NOT NULL
- host_display_name — VARCHAR(100) — NOT NULL
- host_profile_image_url — VARCHAR(500)
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- live_status — VARCHAR(20) — NOT NULL
- thumbnail_url — VARCHAR(500)
- started_at — DATETIME
- ended_at — DATETIME
- replay_url — VARCHAR(500)
- replay_published_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
user_jelly_wallet
- user_id — BIGINT — Foreign key → members.id — NOT NULL
- current_balance — INT — NOT NULL
- version — INT