AKI

Tables (32)

auction_images

  • image_id — BIGINT — Primary key — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • display_order — TINYINT
  • is_receipt — BOOLEAN
  • created_at — DATETIME — NOT NULL

auctions

  • auction_id — BIGINT — Primary key — NOT NULL
  • seller_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • work_id — BIGINT — Foreign key → works.work_id
  • character_id — BIGINT — Foreign key → characters.character_id
  • type_id — BIGINT — Foreign key → product_types.type_id
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • item_condition — VARCHAR(20) — NOT NULL
  • purchase_store — VARCHAR(200)
  • starting_price — INT — NOT NULL
  • current_price — INT — NOT NULL
  • instant_price — INT
  • bid_unit — INT — NOT NULL
  • bid_count — INT
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • trade_method — VARCHAR(20) — NOT NULL
  • trade_region — VARCHAR(100)
  • winner_id — BIGINT — Foreign key → users.user_id
  • view_count — INT
  • favorite_count — INT
  • is_hot — BOOLEAN
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

authentication_votes

  • vote_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → community_posts.post_id — NOT NULL
  • voter_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • vote_type — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

banners

  • banner_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • link_url — VARCHAR(500)
  • link_type — VARCHAR(20)
  • link_target_id — BIGINT
  • display_order — TINYINT
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME — NOT NULL
  • is_active — BOOLEAN
  • created_at — DATETIME — NOT NULL

bids

  • bid_id — BIGINT — Primary key — NOT NULL
  • bidder_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • bid_amount — INT — NOT NULL
  • is_winning — BOOLEAN
  • created_at — DATETIME — NOT NULL

characters

  • character_id — BIGINT — Primary key — NOT NULL
  • work_id — BIGINT — Foreign key → works.work_id — NOT NULL
  • name_kr — VARCHAR(100) — NOT NULL
  • name_jp — VARCHAR(100)
  • thumbnail_url — VARCHAR(500)
  • is_active — BOOLEAN
  • created_at — DATETIME — NOT NULL

chat_messages

  • message_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → chat_rooms.room_id — NOT NULL
  • sender_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content — TEXT
  • image_url — VARCHAR(500)
  • is_read — BOOLEAN
  • created_at — DATETIME — NOT NULL

chat_room_settings

  • setting_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → chat_rooms.room_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • is_pinned — BOOLEAN
  • is_muted — BOOLEAN
  • is_blocked — BOOLEAN
  • updated_at — DATETIME

chat_rooms

  • room_id — BIGINT — Primary key — NOT NULL
  • user1_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • user2_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • related_type — VARCHAR(20)
  • related_id — BIGINT
  • last_message_at — DATETIME
  • created_at — DATETIME — NOT NULL

comment_likes

  • like_id — BIGINT — Primary key — NOT NULL
  • comment_id — BIGINT — Foreign key → comments.comment_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL

comments

  • comment_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → community_posts.post_id — NOT NULL
  • author_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • parent_comment_id — BIGINT — Foreign key → comments.comment_id
  • content — TEXT — NOT NULL
  • like_count — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME

community_boards

  • board_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(255)
  • display_order — TINYINT
  • is_active — BOOLEAN

community_posts

  • post_id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → community_boards.board_id — NOT NULL
  • author_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT
  • like_count — INT
  • comment_count — INT
  • is_popular — BOOLEAN
  • linked_product_id — BIGINT — Foreign key → products.product_id
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME

events

  • event_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • thumbnail_url — VARCHAR(500)
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME — NOT NULL
  • is_active — BOOLEAN
  • created_at — DATETIME — NOT NULL

favorites

  • favorite_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

notifications

  • notification_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • link_url — VARCHAR(500)
  • is_read — BOOLEAN
  • created_at — DATETIME — NOT NULL

post_images

  • image_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → community_posts.post_id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • display_order — TINYINT
  • created_at — DATETIME — NOT NULL

post_likes

  • like_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → community_posts.post_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL

product_images

  • image_id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → products.product_id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • display_order — TINYINT
  • is_receipt — BOOLEAN
  • created_at — DATETIME — NOT NULL

product_types

  • type_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(100)
  • is_active — BOOLEAN

products

  • product_id — BIGINT — Primary key — NOT NULL
  • seller_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • work_id — BIGINT — Foreign key → works.work_id
  • character_id — BIGINT — Foreign key → characters.character_id
  • type_id — BIGINT — Foreign key → product_types.type_id
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • price — INT — NOT NULL
  • item_condition — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • purchase_store — VARCHAR(200)
  • trade_method — VARCHAR(20) — NOT NULL
  • trade_region — VARCHAR(100)
  • view_count — INT
  • favorite_count — INT
  • is_special_edition — BOOLEAN
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME

recommended_tags

  • tag_id — BIGINT — Primary key — NOT NULL
  • tag_name — VARCHAR(50) — NOT NULL
  • display_order — TINYINT
  • is_active — BOOLEAN
  • created_at — DATETIME — NOT NULL

reports

  • report_id — BIGINT — Primary key — NOT NULL
  • reporter_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • reason — VARCHAR(100) — NOT NULL
  • description — TEXT
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • processed_at — DATETIME

reviews

  • review_id — BIGINT — Primary key — NOT NULL
  • reviewer_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • reviewee_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • transaction_type — VARCHAR(20) — NOT NULL
  • transaction_id — BIGINT — NOT NULL
  • rating — TINYINT — NOT NULL
  • content — TEXT
  • created_at — DATETIME — NOT NULL

search_keywords

  • keyword_id — BIGINT — Primary key — NOT NULL
  • keyword — VARCHAR(100) — NOT NULL
  • search_count — INT
  • is_popular — BOOLEAN
  • last_searched_at — DATETIME

user_blocks

  • block_id — BIGINT — Primary key — NOT NULL
  • blocker_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • blocked_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL

user_search_history

  • history_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • keyword — VARCHAR(100) — NOT NULL
  • searched_at — DATETIME — NOT NULL

user_settings

  • setting_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • push_notification — BOOLEAN
  • chat_notification — BOOLEAN
  • auction_notification — BOOLEAN
  • marketing_agree — BOOLEAN
  • updated_at — DATETIME

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • phone_number — VARCHAR(20)
  • introduction — TEXT
  • region — VARCHAR(100)
  • rating — DECIMAL(2,1)
  • review_count — INT
  • is_verified — BOOLEAN
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME

wanted_images

  • image_id — BIGINT — Primary key — NOT NULL
  • wanted_id — BIGINT — Foreign key → wanted_posts.wanted_id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • display_order — TINYINT
  • created_at — DATETIME — NOT NULL

wanted_posts

  • wanted_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • work_id — BIGINT — Foreign key → works.work_id
  • character_id — BIGINT — Foreign key → characters.character_id
  • type_id — BIGINT — Foreign key → product_types.type_id
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • desired_condition — VARCHAR(20) — NOT NULL
  • min_price — INT
  • max_price — INT
  • trade_method — VARCHAR(20) — NOT NULL
  • trade_region — VARCHAR(100)
  • additional_conditions — TEXT
  • status — VARCHAR(20) — NOT NULL
  • view_count — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME

works

  • work_id — BIGINT — Primary key — NOT NULL
  • title_kr — VARCHAR(255) — NOT NULL
  • title_jp — VARCHAR(255)
  • title_en — VARCHAR(255)
  • thumbnail_url — VARCHAR(500)
  • category — VARCHAR(50) — NOT NULL
  • is_active — BOOLEAN
  • created_at — DATETIME — NOT NULL