My_codingtest

Tables (3)

Users_info (나의 텔레봇 이용자 정보)

  • ChatID (Key) — VARCHAR(20) — Primary key — NOT NULL
  • User_ID (Field) — VARCHAR(255)
  • User_PW (Field2) — VARCHAR(100)
  • Status (Field3) — VARCHAR(100)

Users_solved (유저들의 해결한 문제 정보)

  • id (Key) — INT(11) — Primary key — NOT NULL
  • ChatID (Key2) — VARCHAR(20) — Foreign key → Users_info.ChatID — NOT NULL
  • QuizID (Key3) — VARCHAR(50) — Foreign key → python_quizs.QuizID — NOT NULL
  • ChatID (Field) — VARCHAR(20)
  • Solved (Field2) — VARCHAR(50)

python_quizs (프로그래머스 문제 정보)

  • QuizID (Key) — VARCHAR(50) — Primary key — NOT NULL
  • Name (Field) — VARCHAR(50)
  • level (Field2) — VARCHAR(10)
  • Quiz_finishedCount (Field3) — MEDIUMINT(7)
  • Rate (Field5) — VARCHAR(100)