test

Tables (49)

artist

  • artist_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • artist_type — VARCHAR(20) — SOLO, GROUP, BAND
  • profile_image — VARCHAR(500)
  • debut_date — DATE
  • genre — VARCHAR(50)
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

badge

  • badge_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • condition_type — VARCHAR(50)
  • condition_value — VARCHAR(100)
  • badge_image — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

chat_message

  • message_id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → chat_session.session_id — NOT NULL
  • sender — VARCHAR(10) — NOT NULL — USER, AI
  • message — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

chat_session

  • session_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • created_at — DATETIME — NOT NULL

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • parent_id — BIGINT — Foreign key → comment.comment_id
  • content — VARCHAR(1000) — NOT NULL
  • created_at — DATETIME — NOT NULL

donation

  • donation_id — BIGINT — Primary key — NOT NULL
  • stream_id — BIGINT — Foreign key → live_stream.stream_id — NOT NULL
  • donor_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • amount — DECIMAL(10, 0) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PENDING, SUCCESS, FAIL
  • created_at — DATETIME — NOT NULL

donation_payment

  • donation_payment_id — BIGINT — Primary key — NOT NULL
  • donation_id — BIGINT — Foreign key → donation.donation_id — NOT NULL
  • payment_key — VARCHAR(100) — NOT NULL
  • payment_method — VARCHAR(30) — NOT NULL
  • amount — DECIMAL(10, 0) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — SUCCESS, FAIL, CANCELED
  • paid_at — DATETIME
  • created_at — DATETIME — NOT NULL

event

  • event_id — BIGINT — Primary key — NOT NULL
  • venue_id — BIGINT — Foreign key → venue.venue_id — NOT NULL
  • event_type — VARCHAR(20) — NOT NULL — FESTIVAL, CONCERT
  • name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • poster_image — VARCHAR(500)
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • ticket_open_at — DATETIME
  • status — VARCHAR(20) — NOT NULL — UPCOMING, ONGOING, ENDED, CANCELED
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

event_artist

  • event_artist_id — BIGINT — Primary key — NOT NULL
  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • artist_id — BIGINT — Foreign key → artist.artist_id — NOT NULL

event_genre

  • genre_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL

event_genre_map

  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • genre_id — BIGINT — Foreign key → event_genre.genre_id — NOT NULL

event_interaction

  • interaction_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • interaction_type — VARCHAR(20) — NOT NULL — VIEW, SEARCH, LIKE, INTEREST
  • created_at — DATETIME — NOT NULL

event_schedule

  • schedule_id — BIGINT — Primary key — NOT NULL
  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • artist_id — BIGINT — Foreign key → artist.artist_id — NOT NULL
  • stage_name — VARCHAR(100)
  • schedule_date — DATE
  • performance_start — DATETIME
  • performance_end — DATETIME
  • title — VARCHAR(200)
  • lineup_order — INT
  • created_at — DATETIME — NOT NULL

event_visit

  • visit_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • visited_at — DATETIME — NOT NULL
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • verified — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

festival_record

  • record_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • title — VARCHAR(200)
  • content — TEXT
  • ai_diary — TEXT
  • ai_summary — VARCHAR(1000)
  • mood — VARCHAR(30)
  • rating — TINYINT — 1 ~ 5
  • one_line_review — VARCHAR(200)
  • memo — VARCHAR(500)
  • hashtag — VARCHAR(300)
  • is_shared — BOOLEAN — NOT NULL
  • ai_regenerated_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

live_chat_message

  • chat_id — BIGINT — Primary key — NOT NULL
  • stream_id — BIGINT — Foreign key → live_stream.stream_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • message — VARCHAR(1000) — NOT NULL
  • created_at — DATETIME — NOT NULL

live_stream

  • stream_id — BIGINT — Primary key — NOT NULL
  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — VARCHAR(1000)
  • thumbnail_url — VARCHAR(500)
  • stream_url — VARCHAR(500)
  • start_at — DATETIME
  • end_at — DATETIME
  • is_paid — BOOLEAN — NOT NULL
  • ad_enabled — BOOLEAN — NOT NULL
  • status — VARCHAR(20) — NOT NULL — SCHEDULED, LIVE, ENDED
  • created_at — DATETIME — NOT NULL

md_category

  • category_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • parent_id — BIGINT — Foreign key → md_category.category_id

md_order

  • order_id — BIGINT — Primary key — NOT NULL
  • preorder_id — BIGINT — Foreign key → md_preorder.preorder_id — NOT NULL
  • order_number — VARCHAR(50) — NOT NULL
  • total_price — DECIMAL(10, 0) — NOT NULL
  • shipping_name — VARCHAR(50) — NOT NULL
  • shipping_address — VARCHAR(300) — NOT NULL
  • shipping_phone — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PAYMENT_WAIT, PAID, SHIPPED, COMPLETED, CANCELED
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

md_preorder

  • preorder_id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → md_product.product_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • quantity — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PENDING, PAID, CANCELED
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

md_product

  • product_id — BIGINT — Primary key — NOT NULL
  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • category_id — BIGINT — Foreign key → md_category.category_id — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10, 0) — NOT NULL
  • stock — INT — NOT NULL
  • image_url — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL — PREORDER, ON_SALE, SOLD_OUT
  • preorder_deadline — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member

  • member_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image — VARCHAR(500)
  • introduction — VARCHAR(500)
  • role — VARCHAR(20) — NOT NULL — USER, ADMIN
  • status — VARCHAR(20) — NOT NULL — ACTIVE, SUSPENDED, WITHDRAWN
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member_artist

  • member_artist_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • artist_id — BIGINT — Foreign key → artist.artist_id — NOT NULL
  • created_at — DATETIME — NOT NULL

member_badge

  • member_badge_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • badge_id — BIGINT — Foreign key → badge.badge_id — NOT NULL
  • acquired_at — DATETIME — NOT NULL

member_event

  • member_event_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL — INTERESTED, PLANNED
  • created_at — DATETIME — NOT NULL

notification

  • notification_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • event_id — BIGINT — Foreign key → event.event_id
  • type — VARCHAR(30) — NOT NULL — TICKET_OPEN, ARTIST_EVENT, EVENT_UPCOMING, WEATHER, RECOMMENDATION, COMMUNITY, TRADE, ORDER, NOTICE
  • title — VARCHAR(200) — NOT NULL
  • content — VARCHAR(500)
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

notification_setting

  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • push_enabled — BOOLEAN — NOT NULL
  • email_enabled — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

open_chat_member

  • room_id — BIGINT — Foreign key → open_chat_room.room_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • joined_at — DATETIME — NOT NULL
  • left_at — DATETIME
  • is_mute — BOOLEAN — NOT NULL
  • is_blocked — BOOLEAN — NOT NULL

open_chat_message

  • message_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → open_chat_room.room_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • message — VARCHAR(1000) — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

open_chat_room

  • room_id — BIGINT — Primary key — NOT NULL
  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL

payment

  • payment_id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → md_order.order_id — NOT NULL
  • payment_key — VARCHAR(100) — NOT NULL
  • payment_method — VARCHAR(30) — NOT NULL
  • amount — DECIMAL(10, 0) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — SUCCESS, FAIL, CANCELED
  • paid_at — DATETIME

post

  • post_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • category_id — BIGINT — Foreign key → post_category.category_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • image_url — VARCHAR(500)
  • view_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

post_category

  • category_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(300)

post_like

  • post_like_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • created_at — DATETIME — NOT NULL

recommendation

  • recommendation_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • event_id — BIGINT — Foreign key → event.event_id — NOT NULL
  • score — DECIMAL(5,2)
  • reason — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

record_food

  • food_id — BIGINT — Primary key — NOT NULL
  • record_id — BIGINT — Foreign key → festival_record.record_id — NOT NULL
  • food_name — VARCHAR(200) — NOT NULL

record_image

  • image_id — BIGINT — Primary key — NOT NULL
  • record_id — BIGINT — Foreign key → festival_record.record_id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • created_at — DATETIME — NOT NULL

record_share

  • share_id — BIGINT — Primary key — NOT NULL
  • record_id — BIGINT — Foreign key → festival_record.record_id — NOT NULL
  • platform — VARCHAR(20) — NOT NULL — INSTAGRAM, TWITTER, ETC
  • share_url — VARCHAR(500)
  • shared_at — DATETIME — NOT NULL

record_song

  • song_id — BIGINT — Primary key — NOT NULL
  • record_id — BIGINT — Foreign key → festival_record.record_id — NOT NULL
  • song_title — VARCHAR(200) — NOT NULL
  • artist_name — VARCHAR(100)

report

  • report_id — BIGINT — Primary key — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL — POST, COMMENT, USER, LISTING, MESSAGE
  • target_id — BIGINT — NOT NULL
  • reporter_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • reason — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL — PENDING, REVIEWED, REJECTED
  • created_at — DATETIME — NOT NULL

social_account

  • social_account_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL — GOOGLE, KAKAO, NAVER
  • provider_id — VARCHAR(255) — NOT NULL

stamp

  • stamp_id — BIGINT — Primary key — NOT NULL
  • visit_id — BIGINT — Foreign key → event_visit.visit_id — NOT NULL
  • acquired_at — DATETIME — NOT NULL

trade_chat_message

  • message_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → trade_chat_room.room_id — NOT NULL
  • sender_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • message — VARCHAR(1000) — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

trade_chat_room

  • room_id — BIGINT — Primary key — NOT NULL
  • transaction_id — BIGINT — Foreign key → used_transaction.transaction_id — NOT NULL
  • created_at — DATETIME — NOT NULL

used_like

  • used_like_id — BIGINT — Primary key — NOT NULL
  • listing_id — BIGINT — Foreign key → used_listing.listing_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • created_at — DATETIME — NOT NULL

used_listing

  • listing_id — BIGINT — Primary key — NOT NULL
  • seller_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10, 0) — NOT NULL
  • condition — VARCHAR(20)
  • trade_method — VARCHAR(20)
  • region — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL — ON_SALE, RESERVED, SOLD
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

used_transaction

  • transaction_id — BIGINT — Primary key — NOT NULL
  • listing_id — BIGINT — Foreign key → used_listing.listing_id — NOT NULL
  • buyer_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • price — DECIMAL(10, 0) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — REQUEST, APPROVED, COMPLETED, CANCELED
  • created_at — DATETIME — NOT NULL
  • completed_at — DATETIME

user_setting

  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • dark_mode — BOOLEAN — NOT NULL
  • notification_enabled — BOOLEAN — NOT NULL
  • marketing_agree — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

venue

  • venue_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • address — VARCHAR(300)
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • capacity — INT
  • created_at — DATETIME — NOT NULL