infinite

Tables (14)

ARTISTS

  • id — BIGINT
  • name — varchar(255)
  • slug — varchar(255)
  • Role — varchar(255)
  • profile_image_url — varchar(255)
  • cover_image_url — varchar(255)
  • intro — text
  • status — varchar(255)
  • create_at — datetime
  • update_at — datetime

ArtistPOSTS

  • id — BIGINT
  • artist_id — BIGINT — Foreign key → ARTISTS.id — NOT NULL
  • writer_id — BIGINT — Foreign key → artist_members.id — NOT NULL
  • visibility — varchar(255) — NOT NULL
  • title — varchar(255)
  • contents — text — NOT NULL
  • like_count — BIGINT — NOT NULL
  • comment_count — BIGINT — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

DM_MESSAGES

  • id — BIGINT
  • dm_room_id — BIGINT — Foreign key → DM_ROOMS.id
  • sender_type — varchar(255)
  • content — text
  • sent_at — timestamp

DM_ROOMS

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USERS.id
  • artist_id — BIGINT — Foreign key → ARTISTS.id
  • updated_at — timestamp

FanPOSTS

  • id — BIGINT
  • artist_id — BIGINT — Foreign key → ARTISTS.id — NOT NULL
  • writer_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • visibility — varchar(255) — NOT NULL
  • contents — text — NOT NULL
  • like_count — BIGINT — NOT NULL
  • comment_count — BIGINT — NOT NULL
  • media_count — int — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

Moments

  • id — BIGINT
  • artist_id — BIGINT — Foreign key → ARTISTS.id — NOT NULL
  • writer_id — BIGINT — Foreign key → artist_members.id — NOT NULL
  • contents — text — NOT NULL
  • expires_at — timestamp — NOT NULL
  • like_count — BIGINT — NOT NULL
  • comment_count — BIGINT — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

RAFFLES

  • id — BIGINT
  • artist_id — BIGINT — Foreign key → ARTISTS.id — NOT NULL
  • title — varchar(255) — NOT NULL
  • eligibility — varchar(255) — NOT NULL
  • reward_type — varchar(255) — NOT NULL
  • total_winners — integer — NOT NULL
  • duration_minutes — integer — NOT NULL
  • status — varchar(255) — NOT NULL
  • started_at — timestamp
  • ended_at — timestamp
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

RAFFLE_ENTRIES

  • id — BIGINT
  • raffle_id — BIGINT — Foreign key → RAFFLES.id — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • slot_index — integer — NOT NULL
  • entry_order — integer — NOT NULL
  • entered_at — timestamp — NOT NULL

USERS

  • id — BIGINT
  • email — varchar(255)
  • phone_number — varchar(255)
  • role — varchar(255)
  • status — varchar(255)
  • nickname — varchar(255)
  • created_at — timestamp
  • subscriptionStatus — varchar(255)

artist_follows

  • id — BIGINT
  • artist_id — BIGINT — Foreign key → ARTISTS.id — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • status — varchar(255) — NOT NULL
  • followed_at — datetime — NOT NULL
  • created_at — datetime — NOT NULL

artist_members

  • id — BIGINT
  • artist_id — BIGINT — Foreign key → ARTISTS.id — NOT NULL
  • stage_name — varchar(255)
  • profile_image_url — varchar(255)
  • sort_order — int
  • create_at — datetime

comments

  • id — BIGINT
  • target_type — varchar(255) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • parent_id — BIGINT
  • depth — int — NOT NULL
  • writer_type — varchar(255) — NOT NULL
  • writer_id — BIGINT — NOT NULL
  • contents — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

jelly_transaction

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • type — varchar(255) — NOT NULL
  • amount — int — NOT NULL
  • balance — int — NOT NULL
  • reference_id — BIGINT
  • reference_type — varchar(255)
  • created_at — datetime — NOT NULL

jelly_wallet

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • balance — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL