teamPr
Tables (6)
Category (카테고리)
- categoryId (Key) — Primary key — NOT NULL
- info (Field)
Genre (장르)
- genreId (Key) — Primary key — NOT NULL
- 이름 (Field)
- Field2
- videoId (Key2) — Foreign key → Video.videoId — NOT NULL
Mark (찜)
- userId (Key2) — Foreign key → User.userId — NOT NULL
- videoId (Key) — Foreign key → Video.videoId — NOT NULL
Review (리뷰)
- reviewId (Key) — Primary key — NOT NULL
- comment (Field)
- userRate (Field2)
- date (Field3)
- isSpoiler (Field4)
- videoId (Key2) — Foreign key → Video.videoId — NOT NULL
- userId (Key3) — Foreign key → User.userId — NOT NULL
User (회원)
- userId (Key) — Primary key — NOT NULL
- pw (Field)
- name (Field2)
- email (Field3)
- birth (Field4)
- phone (Field5)
- gender (Field6)
- sub (Field7)
- subDate (Field8)
Video (영상)
- videoId (Key) — Primary key — NOT NULL
- title (Field)
- info (Field2)
- url (Field3)
- rate (Field4)
- Field5
- genreId (Key2) — Foreign key → Genre.genreId — NOT NULL
- categoryId (Key3) — Foreign key → Category.categoryId — NOT NULL