tmdb
Tables (6)
Content
- contentUnique — int — Primary key — NOT NULL — 컨텐츠 고유값
- contentType — String — 컨텐츠 타입
- contentId — int — 컨텐츠 아이디
- scoreAvg — double — 별점 평균
ContentLike
- username — String — Foreign key → Member.username — NOT NULL — 닉네임
- contentUnique — int — Foreign key → Content.contentUnique — NOT NULL — 컨텐츠 고유값
Member
- username — String — Primary key — NOT NULL — 닉네임
- gender — String — 성별
- password — String — NOT NULL — 비밀번호
- regidentNumber — int
- email — email — NOT NULL — 이메일
- sns — String — sns
- img — String — 이미지
Reply
- rno — int — Primary key — NOT NULL — 댓글 번호
- contentUnique — int — Foreign key → Content.contentUnique — NOT NULL — 컨텐츠 고유값
- username (username2) — String — Foreign key → Member.username — NOT NULL — 닉네임
- reply — String — 댓글
- replyDate — Date — 댓글 등록 날짜
- Field
ReplyLike
- rno — int — Foreign key → Reply.rno — NOT NULL — 댓글 번호
- username — String — Foreign key → Member.username — NOT NULL — 닉네임
star (start)
- contentUnique — int — Foreign key → Content.contentUnique — NOT NULL — 컨텐츠 고유값
- username — String — Foreign key → Member.username — NOT NULL — 닉네임
- score — int — 점수