multi-cloud
Tables (4)
Candidate
- exam_id — INT(10)
- email — VARCHAR(255) — NOT NULL
- user_name — VARCHAR(100) — NOT NULL
- exam_code — CHAR(12)
- score — INT
- Pass_Fail — ENUM('합격', '불합격')
- test_date — DATE
- test_date — DATE — NOT NULL
Exam_q
- question_id — VARCHAR(12)
- exam_code — VARCHAR(12) — NOT NULL
- content — VARCHAR(400) — NOT NULL
- A — CHAR(200) — NOT NULL
- B — CHAR(200) — NOT NULL
- C — CHAR(200) — NOT NULL
- D — CHAR(200) — NOT NULL
- answer — CHAR(1) — NOT NULL
Subject
- exam_code — CHAR(12)
- subject_name — VARCHAR(100) — NOT NULL
- application_start — DATE — NOT NULL
- application_end — DATE — NOT NULL
- test_date — DATE — NOT NULL
User
- email — VARCHAR(255)
- user_name — VARCHAR(100) — NOT NULL
- user_password — VARCHAR(255) — NOT NULL
- sudscription_date — DATE — NOT NULL