ad
Tables (6)
Challenge_ref_video (Untitled)
- Challenge_ref_video_id — int — Primary key — NOT NULL
- title — singer
- singer — varchar
- video_file — path/ varchar
- img — path/ varchar
Challenge_video (Dance competition)
- Challenge_video_idChallenge_video_id (Key) — int — Primary key — NOT NULL
- ref_id — int — Foreign key → Challenge_ref_video.Challenge_ref_video_id — NOT NULL
- video_file — path/ varchar
User (회원가입)
- User_id — int — Primary key — NOT NULL
- password — varchar(50)_encryption
- last_login — datetime
- username — varchar(200)
- email — varchar(50)
- nickname — varchar(50)
- is_active — int
- is_admin — int
challenge_score (Board 게시판 및 Ranking 게시판)
- challenge_score_id — int — Primary key — NOT NULL
- nickname — varchar — Foreign key → User.User_id — NOT NULL
- ref_id — int — Foreign key → Challenge_video.Challenge_video_idChallenge_video_id — NOT NULL
- score — int
- video_file — int
- create_at — datetime
- text — varchar
making_transformedimage (Untitled3)
- making_transformedimage_id — int — Primary key — NOT NULL
- nickname — varchar — Foreign key → User.User_id — NOT NULL
- image — path/ varchar
- style — categorical
- post_image — varchar
making_transformedlog (Untitled4)
- making_transformedlog_id — int — Primary key — NOT NULL
- nickname — varchar — Foreign key → User.User_id — NOT NULL
- image_url — path. varchar
- date — datetime