boysplanet

Tables (4)

boys (연습생정보)

  • boys_id (연습생고유번호) — int — Primary key — NOT NULL
  • boys_k_name (연습생한국명) — varchar
  • boys_e_name (연습생영어명) — varchar
  • boys_c_name (연습생한자명) — varchar
  • boys_j_name (연습생일어명) — varchar
  • boys_type (연습생타입) — tinyint
  • boys_is_dead (연습생생존여부) — tinyint
  • boys_dead_date (연습생탈락일) — date

survey_info (투표정보)

  • si_id (투표정보고유번호) — int — Primary key — NOT NULL
  • st_id (팀투표고유번호) — int
  • so_id (개인투표고유번호) — int
  • si_date (투표시간) — datetime
  • si_ip (투표자 IP) — varchar

survey_one (원픽투표)

  • so_id (개인투표고유번호) — int — Primary key — NOT NULL
  • so_boys (연습생번호) — int

survey_team (팀투표)

  • st_id (팀투표고유번호) — int — Primary key — NOT NULL
  • st_boys_1 (1번연습생) — int
  • st_boys_9 (9번연습생) — int