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)