Fandom-k

Tables (10)

User (Untitled2)

  • user_id (Key) — INT — Primary key — NOT NULL
  • credit_id (Field) — INT
  • user_name (Field2) — VARCHAR(10)
  • user_img (Field3) — TEXT

advertisement (Untitled6)

  • advertisement_id (Key) — INT — Primary key — NOT NULL
  • advertisement _name (Field) — VARCHAR(25)
  • advertisement_loction (Field2) — VARCHAR(25)

follow (CopyOf관심있는아이돌)

  • follow_id (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — INT — Foreign key → User.user_id — NOT NULL
  • idol_id (Key3) — INT — Foreign key → idol.idol_id — NOT NULL
  • follow_date (Field3) — DATE
  • unfollow_date (Field4) — DATE

idol (Untitled3)

  • idol_id (Key) — INT — Primary key — NOT NULL
  • idol_name (Field) — VARCHAR(10)
  • idol_img (Field2) — TEXT
  • gender (Field4) — BOOL
  • Field3
  • group_id (Key2) — INT — Foreign key → idol_group.group_id — NOT NULL

idol_group (Untitled7)

  • group_id (Key) — INT — Primary key — NOT NULL
  • group_name (Field) — VARCHAR(25)

project (이벤트)

  • project_id (Key) — INT — Primary key — NOT NULL
  • idol_id (Key2) — INT — Foreign key → idol.idol_id — NOT NULL
  • advertisement_id (Key3) — INT — Foreign key → advertisement.advertisement_id — NOT NULL
  • project_title (Field) — VARCHAR(30)
  • project_total_credit (Field2) — INT
  • project_start_date (Field3) — DATE
  • project_end_date (Field4) — DATE
  • project_cur_credit (Field5) — INT

user_credit

  • credit_id (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — INT — Foreign key → User.user_id — NOT NULL
  • my_credit (Field) — INT

user_credit_log (Untitled)

  • credit_log_id (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — INT — Foreign key → User.user_id — NOT NULL
  • charge_date (Field) — DATE
  • credit_ amount (Field3) — INT

vote (Untitled4)

  • vote_id (Key) — INT — Primary key — NOT NULL
  • idol_id (Key2) — INT — Foreign key → idol.idol_id — NOT NULL
  • total_vote (Field2) — INT

vote_log (Untitled5)

  • vote_log_id (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — INT — Foreign key → User.user_id — NOT NULL
  • idol_id (Key3) — INT — Foreign key → idol.idol_id — NOT NULL
  • vote_date (Field) — DATE