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