codeitmission8

Tables (8)

charges (Untitled8)

  • charge_id (Key) — INT — Primary key — NOT NULL
  • change_amount (Field) — ENUM('100','500',1000') — NOT NULL
  • charge_time (Field2) — DATETIME — NOT NULL
  • user_id (Key2) — INT — Foreign key → users.user_id — NOT NULL

credit_ledger (Untitled)

  • ledger_id — BIGINT — Primary key
  • user_id (유저아이디) — INT
  • action_type (행동 종류 (충전, 투표, 조공 등)) — ENUM('vote','jogong','charge')
  • delta_credits (변동 크레딧 (+/-)) — INT — NOT NULL
  • ref_id (action_type의 ID) — INT — NOT NULL
  • ledger_time (Field) — TIMESTAMP

credit_wallet (Untitled2)

  • user_id (Key2) — INT — Foreign key → users.user_id — NOT NULL
  • balance_credits (Field) — INT — NOT NULL

follows (Untitled5)

  • follow_id (Key) — INT — Primary key — NOT NULL
  • follow_time (Field) — DATETIME
  • user_id (Key2) — INT — Foreign key → users.user_id — NOT NULL
  • idol_id (Key3) — INT — Foreign key → idols.idol_id — NOT NULL

idols (Untitled6)

  • idol_id (Key) — INT — Primary key — NOT NULL
  • idol_name (Field) — VARCHAR(45) — NOT NULL
  • group_name (Field2) — VARCHAR(45) — NOT NULL
  • idol_gender (Field3) — ENMU('M','F') — NOT NULL

jogongs (Untitled7)

  • jogong_id (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR(45)
  • want_credit (Field2) — INT — NOT NULL
  • current_credit (Field3) — INT — NOT NULL
  • last_day (Field4) — DATE — NOT NULL
  • start_day (Field5) — DATE — NOT NULL
  • idol_id (Key2) — INT — Foreign key → idols.idol_id — NOT NULL

users (Untitled3)

  • user_id (Key) — INT — Primary key — NOT NULL
  • user_name (Field) — VARCHAR(45) — NOT NULL
  • user_email (Field2) — VARCHAR(45) — NOT NULL

votes (Untitled4)

  • vote_id (Key) — INT — Primary key — NOT NULL
  • vote_time (Field) — DATETIME
  • user_id (Key2) — INT — Foreign key → users.user_id — NOT NULL
  • idol_id (Key3) — INT — Foreign key → idols.idol_id — NOT NULL