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)