lecture evaluation

Tables (4)

CommentsReplies (강의 대댓글)

  • PK (CommentsReplies_id) — Primary key — NOT NULL
  • PK (User) — Foreign key → users.PK — NOT NULL
  • PK (lectureComments_Id) — Foreign key → lectureComments.PK — NOT NULL
  • KEY (Comment)
  • KEY (Created_Date)

courseReview (강의 평가)

  • PK (courseReview_Id) — Primary key — NOT NULL
  • PK (User) — Foreign key → users.PK — NOT NULL
  • KEY (Score)
  • KEY (Comment)
  • KEY (Created_Date)

lectureComments (강의 댓글)

  • PK (lectureComments_Id) — Primary key — NOT NULL
  • PK (User) — Foreign key → users.PK — NOT NULL
  • KEY (Comment)
  • KEY (Created_Date)

users (수강생)

  • PK (User) — Primary key — NOT NULL
  • KEY (Name)
  • KEY (Phone)
  • KEY (Email)
  • KEY (Secret_Code)