Hanghae Lv4

Tables (5)

Comment (댓글)

  • commentId (댓글식별번호) — BigInt — Primary key — NOT NULL
  • lecureId (강의식별번호) — BigInt — Foreign key → Lecture.lecureId — NOT NULL
  • userId (유저식별번호) — BigInt — Foreign key → User.userId — NOT NULL
  • comment (댓글내용) — varchar
  • commentCreatedAt (댓글 생성시간) — Date

Lecture (강의)

  • lecureId (강의식별번호) — BigInt — Primary key — NOT NULL
  • tutorId (강사식별번호) — BigInt — Foreign key → Tutor.tutorId — NOT NULL
  • lecturePrice (가격) — number
  • lectureInfo (강의소개) — varchar
  • lectureCategory (카테고리) — varchar
  • lectureUpdate (등록일) — Date
  • lectureLike (좋아요수) — Number

Like (좋아요)

  • likeId (좋아요식별번호) — BigInt — Primary key — NOT NULL
  • userId (유저식별번호) — BigInt — Foreign key → User.userId — NOT NULL
  • lecureId (강의식별번호) — BigInt — Foreign key → Lecture.lecureId — NOT NULL

Tutor (강사)

  • tutorId (강사식별번호) — BigInt — Primary key — NOT NULL
  • tutorName (강사 이름) — varchar
  • tutorCareer (경력) — number
  • tutorCompany (회사) — varchar
  • tutorPhone (전화번호) — varchar
  • tutorInfo (소개) — varchar

User (유저)

  • userId (유저식별번호) — BigInt — Primary key — NOT NULL
  • UserEmail (이메일) — varchar
  • UserPwd (패스워드) — varchar
  • UserGender (성별) — varchar
  • UserPhone (전화번호) — varchar
  • UserAddress (주소) — varchar
  • Authorization (권한) — varchar