4thStudy

Tables (9)

career

  • id — INTEGER — Primary key — NOT NULL
  • UserId — INTEGER — Foreign key → user.id — NOT NULL
  • title — VARCHAR(200)
  • createdAt — DATETIME
  • updateAt — DATETIME

checkBook

  • id — INTEGER — Primary key — NOT NULL
  • LectureSchId — INTEGER — Foreign key → lectureSch.id — NOT NULL
  • StudentId — INTEGER — Foreign key → user.id — NOT NULL
  • checktime — DATETIME
  • createdAt — DATETIME
  • updatedAt — DATETIME

lecture

  • id — INTEGER — Primary key — NOT NULL
  • LectureTypeId — INTEGER — Foreign key → lectureType.id — NOT NULL
  • TeacherId — INTEGER — Foreign key → user.id — NOT NULL
  • title — VARCHAR(200)
  • subject — VARCHAR(100)
  • description — VARCHAR(2000)
  • thumbnail — VARCHAR(3000)
  • isTop — TINYINT
  • priceOfMonth — INTEGER
  • discount — INTEGER
  • location — VARCHAR(300)
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • isDelete — TINYINT
  • deletedAt — DATETIME
  • startDate — DATE
  • endDate — DATE
  • isMon — TINYINT
  • isTue — TINYINT
  • isWed — TINYINT
  • isTur — TINYINT
  • isFri — TINYINT
  • isSat — TINYINT
  • isSun — TINYINT
  • time — DATE

lectureContent

  • id — INTEGER — Primary key — NOT NULL
  • LectureId — INTEGER — Foreign key → lecture.id — NOT NULL
  • LectureTypeId — INTEGER — Foreign key → lecture.LectureTypeId — NOT NULL
  • TeacherId — INTEGER — Foreign key → lecture.TeacherId — NOT NULL
  • value — VARCHAR(100)
  • createdAt — DATETIME
  • updatedAt — DATETIME

lectureSch

  • id — INTEGER — Primary key — NOT NULL
  • targetDate — DATE
  • isRest — TINYINT
  • isCompleted — TINYINT
  • completedAt — DATETIME
  • memo — VARCHAR(2000)
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • LectureId — INTEGER — Foreign key → lecture.TeacherId — NOT NULL

lectureType

  • id — INTEGER — Primary key — NOT NULL
  • value — VARCHAR(100)
  • isDelete — TINYINT
  • deletedAt — DATETIME

major

  • id — INTEGER — Primary key — NOT NULL
  • UserId — INTEGER — Foreign key → user.id — NOT NULL
  • title — VARCHAR(200)
  • createdAt — DATETIME
  • updatedAt — DATETIME

participants

  • id — INTEGER — Primary key — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • LectureId — INTEGER — Foreign key → lecture.id — NOT NULL
  • StudentId — INTEGER — Foreign key → user.id — NOT NULL

user

  • id — INTEGER — Primary key — NOT NULL
  • userId — VARCHAR(100)
  • userPassword — VARCHAR(100)
  • userType — INTEGER
  • username — VARCHAR(50)
  • email — VARCHAR(100)
  • mobile — VARCHAR(20)
  • birth — DATE
  • gender — TINYINT
  • loc — VARCHAR(100)
  • belongs — VARCHAR(100)
  • createdAt — DATETIME
  • updateAt — DATETIME
  • isExited — TINYINT
  • Field