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