IPS
Tables (17)
ai_analysis_logs
- id — BIGINT
- target_type — VARCHAR(50)
- target_id — BIGINT
- analysis_type — VARCHAR(50)
- result — TEXT
- confidence — DECIMAL(5, 2)
- created_at — DATETIME
albums
- id — BIGINT
- idol_id — BIGINT — Foreign key → idols.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- image_url — VARCHAR(255)
- release_date — DATE
- created_at — DATETIME
chat_participants
- id — BIGINT
- chatroom_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
chat_rooms
- id — BIGINT
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- created_at — DATETIME
comments
- id — BIGINT
- community_post_id (post_id) — BIGINT — Foreign key → community_posts.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- content — TEXT
- created_at — DATETIME
community_posts
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- category — VARCHAR(50)
- created_at — DATETIME
idol_members
- id — BIGINT
- idol_id — BIGINT — Foreign key → idols.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- created_at — DATETIME
idols
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- created_at — DATETIME
member_items
- id — BIGINT
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- member_id — BIGINT — Foreign key → idol_members.id — NOT NULL
- price — INT
- status — VARCHAR(50)
- buyer_id — BIGINT — Foreign key → users.id
message_recipients
- id — BIGINT
- message_id — BIGINT — Foreign key → messages.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
messages
- id — BIGINT
- chatroom_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
- sender_id — BIGINT — Foreign key → users.id — NOT NULL
- content — TEXT
- message_type — VARCHAR(50)
- visibility — VARCHAR(50)
- created_at — DATETIME
posts
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- idol_id — BIGINT — Foreign key → idols.id — NOT NULL
- album_id — BIGINT — Foreign key → albums.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- total_price — INT
- shipping_fee — INT
- status — VARCHAR(50)
- created_at — DATETIME
price_histories
- id — BIGINT
- idol_id — BIGINT — Foreign key → idols.id — NOT NULL
- album_id — BIGINT — Foreign key → albums.id — NOT NULL
- member_id — BIGINT — Foreign key → idol_members.id — NOT NULL
- transaction_id — BIGINT — Foreign key → transactions.id
- price — INT
- created_at — DATETIME
recommendation_logs
- id — BIGINT
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- member_id — BIGINT — Foreign key → idol_members.id — NOT NULL
- min_price — INT
- max_price — INT
- avg_price — INT
- recommended_price — INT
- source_count — INT
- created_at — DATETIME
reports
- id — BIGINT
- reporter_id — BIGINT — Foreign key → users.id — NOT NULL
- target_user_id — BIGINT — Foreign key → users.id — NOT NULL
- post_id — BIGINT — Foreign key → posts.id
- reason — VARCHAR(255)
- evidence_image — VARCHAR(255)
- status — VARCHAR(50)
- created_at — DATETIME
transactions
- id — BIGINT
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- buyer_id — BIGINT — Foreign key → users.id — NOT NULL
- total_amount — INT
- status — VARCHAR(50)
- created_at — DATETIME
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- profile_image — VARCHAR(255)
- favorite_idol_id — BIGINT — Foreign key → idols.id
- is_minor — BOOLEAN
- trust_score — INT
- created_at — DATETIME