at_last
Tables (7)
ACCOUNT_TEA (강사_회원가입)
- Key (TEA_ID) — BIGINT — Primary key — NOT NULL
- Field (TEA_NICKNAME) — VARCHAR
- Field (TEA_PW) — VARCHAR
- (TEA_NAME) — VARCHAR
- Field (TEA_BIRTH) — VARCHAR
- Field (TEA_EMAIL) — VARCHAR
- Field (TEA_SCHOOL) — VARCHAR
- Field (TEA_CREATE) — LOCALDATETIME
- Field
Account_STU (학생_회원가입)
- 구분값 (STU_ID) — BIGINT — Primary key — NOT NULL
- 성명 (STU_NAME) — VARCHAR
- Field (STU_BIRTH) — VARCHAR
- Field (STU_EMAIL) — VARCHAR
- Field (STU_NICKNAME) — VARCHAR
- Field (STU_GRADE) — INT
- Field (STU_SCHOOL) — VARCHAR
CHOOSE (담기)
- Key (CHO_ID) — BIGINT — Primary key — NOT NULL
- Key (Q_ID) — BIGINT — Foreign key → QUESTION.Key — NOT NULL
- 구분값 (STU_ID) — BIGINT — Foreign key → Account_STU.구분값 — NOT NULL
- Field (CHO_DATE) — LOCALDATETIME
- Field
CLASS (분반)
- Key (CLASS_ID) — BIGINT — Primary key — NOT NULL
- Key (TEA_ID) — BIGINT — Foreign key → ACCOUNT_TEA.Key — NOT NULL
- 구분값 (STU_ID) — BIGINT — Foreign key → Account_STU.구분값 — NOT NULL
- Field (CLASS_DATE) — LOCALDATETIME
QUESTION (문제)
- Key (Q_ID) — BIGINT — Primary key — NOT NULL
- Key (TEA_ID) — BIGINT — Foreign key → ACCOUNT_TEA.Key — NOT NULL
- Field (Q_TITLE) — VARCHAR
- Field (Q_SUBJECT) — VARCHAR
- Field (Q_CONTENT) — VARCHAR
- Field (Q_IMAGE) — VARCHAR
- Field (Q_CHOICE_1) — VARCHAR
- Field (Q_CHOICE_2) — VARCHAR
- Field (Q_CHOICE_3) — VARCHAR
- Field (Q_CHOICE_4) — VARCHAR
- Field (Q_CHOICE_5) — VARCHAR
- (Q_ANSWER) — VARCHAR
- Field (Q_TIMER) — TIME
- Field (Q_VIEW) — BIGINT
- Field (Q_CORRECT) — BIGINT
- Field (Q_SCORE) — INT
SOLUTE (푼 문제)
- Key (SOL_ID) — BIGINT — Primary key — NOT NULL
- 구분값 (STU_ID) — BIGINT — Foreign key → Account_STU.구분값 — NOT NULL
- Field (SOL_ANSWER) — VARCHAR
- Field (SOL_DATE) — LOCALDATE
STU_SUBTEST (학생_모의고사_점수)
- Key (SUB_ID) — BIGINT — Primary key — NOT NULL
- 구분값 (STU_ID) — BIGINT — Foreign key → Account_STU.구분값 — NOT NULL
- Field (SUB_KOR) — INT
- Field (SUB_MATH) — INT
- Field (SUB_ENG) — INT
- Field (SUB_HISTORY) — INT
- Field (SUB_EX_1) — INT
- Field (SUB_EX_2) — INT
- Field (SUB_NAME_1) — CHAR
- (SUB_NAME_2) — CHAR
- Field (SUB_CODE) — VARCHAR