Session3

Tables (5)

Category (Untitled3)

  • Category_id (Primary Key) — Primary key — NOT NULL
  • name (CharField)
  • description (Field2)

Comment (Untitled5)

  • Comment_id (Primary Key) — Primary key — NOT NULL
  • Post_id (ForeignKey) — Foreign key → Post.Post_id — NOT NULL
  • content (TextField)
  • createDate (DateTimeField)
  • updateDate (Field2)

Post (Untitled)

  • Post_id (Primary Key) — Primary key — NOT NULL
  • Category_id (ForeignKey) — Foreign key → Category.Category_id — NOT NULL
  • title (CharField)
  • description (Field3)
  • image (ImageField)
  • content (TextField)
  • createDate (DateTimeField)
  • updateField (Field7)
  • like (PositiveSamllIntegerField)

Post_Tag (Untitled6)

  • Post_id (Primary Key) — Foreign key → Post.Post_id — NOT NULL
  • tag_id (Primary Key2) — Foreign key → Tag.tag_id — NOT NULL

Tag (Untitled4)

  • tag_id (Primary Key) — Primary key — NOT NULL
  • name (CharField)