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