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