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