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)