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