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