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