4thStudy

Tables (10)

career

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

checkBook

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

lecture

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

lecture Type

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

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
  • LectureId — INTEGER — Foreign key → lectureContent.LectureId — NOT NULL
  • targetDate — DATE
  • isRest — TINYINT
  • isCompleted — TINYINT
  • completedAt — DATETIME
  • memo — VARCHAR(2000)
  • createdAt — DATETIME
  • updatedAt — DATETIME

major

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

notice

  • id — INTEGER — Primary key — NOT NULL
  • title — VARCHAR(300)
  • desripthion (discription) — TEXT
  • hit — INTEGER
  • Field

participants

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

user

  • id — INTEGER — Primary key — NOT NULL
  • userId — VARCHAR(100)
  • userPassword — VARCHAR(100)
  • useType — INTEGER
  • username — VARCHAR(50)
  • email — VARCHAR(100)
  • moblie (mobile) — VARCHAR(20)
  • birth — DATE
  • gender — TINYIN
  • loc — VARCHAR(100)
  • belongs — VARCHAR(100)
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • isExited — TINYINT
  • extiedAt — DATETIME