LMS

Tables (3)

LESSON_JOIN_STUDENT (Untitled2)

  • LS_SEQ — INT(11) — Primary key — NOT NULL
  • LP_SEQ (LP_SEQ2) — INT(11) — Foreign key → LESSON_PLAN.LP_SEQ — NOT NULL
  • USER_SEQ (Key) — INT(11) — Foreign key → USER.USER_SEQ — NOT NULL
  • USER_SEQ — INT(11)
  • USE_FLAG — CHAR(1)

LESSON_PLAN (\)

  • LP_SEQ — INT(11) — Primary key — NOT NULL
  • LESSON_CODE — VARCHAR(20)
  • LESSON_SUBJECT — VARCHAR(100)
  • START_DATE (START_dATE) — TIME
  • END_DATE (END_dATE) — TIME
  • USE_FLAG — CHAR(1)
  • REG_dATE (REG_DATE) — TIMESTAMP
  • UDT_DATE (UDE_dATE) — TIMESTAMP
  • USER_SEQ — INT(11)

USER (Untitled)

  • USER_SEQ (Key) — INT(11) — Primary key — NOT NULL
  • ID — VARCHAR(50)
  • PASSWORD — VARCHAR(300)
  • NAME — VARCHAR(50)
  • TEL — VARCHAR(20)
  • USE_FLAG — CHAR(1)
  • REG_DATE — TIMESTAMP
  • UDT_DATE — TIMESTAMP
  • USER_LEVEL — INT(4)