DVDPrime

Tables (8)

Category (Untitled3)

  • category2Id (Key) — Primary key — NOT NULL
  • categoryId (Field)
  • categoryName (Field2)
  • category2Name (Field4)

Comment (Untitled5)

  • commentId (Key) — Primary key — NOT NULL
  • postId (Key2) — Foreign key → Post.postId — NOT NULL
  • userId (Key3) — Foreign key → Post.userId — NOT NULL
  • counter (Key32) — Foreign key → Post.counter — NOT NULL
  • category2Id (Key4) — Foreign key → Post.category2Id — NOT NULL
  • createdAt (Key5) — Foreign key → Post.createdAt — NOT NULL
  • content (Field2)
  • createdAt (Field3)
  • parentCommentId (Field6)

Count (Untitled6)

  • counter (Key) — Primary key — NOT NULL

CreatedAt (Untitled8)

  • createdAt (Key) — Primary key — NOT NULL

Post (Untitled4)

  • postId (Key2) — Primary key — NOT NULL
  • userId (Key) — Foreign key → User.userId — NOT NULL
  • counter (Key3) — Foreign key → Count.counter — NOT NULL
  • category2Id (Key4) — Foreign key → Category.category2Id — NOT NULL
  • createdAt (Key5) — Foreign key → CreatedAt.createdAt — NOT NULL
  • title (Field2)
  • content (Field3)
  • createdAt (Field4)
  • commentId (Field8)

Rank (Untitled7)

  • counter (Key) — Foreign key → Count.counter — NOT NULL
  • userId (Key2) — Foreign key → User.userId — NOT NULL
  • rank (Field)
  • userId (Field2)

User (Untitled)

  • userId (Key) — Primary key — NOT NULL
  • userPassword (Field2)

View (Untitled2)

  • viewId (Key3) — Primary key — NOT NULL
  • counter (Key) — Foreign key → Count.counter — NOT NULL
  • userId (Key2) — Foreign key → User.userId — NOT NULL
  • createdAt (Key4) — Foreign key → CreatedAt.createdAt — NOT NULL
  • postId (Field)
  • title (Field2)