cap
테이블 (5)
답안
- prob_num — INT
- prob_ans — INT
문제지
- work_seq — BIGINT — NOT NULL
- work_nm — VARCHAR(50)
- work_type — enum('MATH','ENGLISH','KOREAN','HISTORY')
- work_cnt — INT
성적
- score_seq — BIGINT — NOT NULL
- mbr_seq — BIGINT — NOT NULL
- work_seq — BIGINT — NOT NULL
- score_yes — INT
- score_no — INT
- wrong_cnt — INT
학원
- edu_seq — BIGINT — NOT NULL
- edu_nm — VARCHAR(50)
회원
- mbr_seq — BIGINT — NOT NULL
- mbr_email — VARCHAR(100)
- mbr_nm — VARCHAR(50)
- mbr_type — enum('TEACHER','STUDENT')
- mbr_pwd — VARCHAR(100)
- mbr_edu_seq — BIGINT