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