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