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