MySimpleBlog

Tables (9)

Category (blog_category)

  • id — Primary Key — Primary key — NOT NULL
  • name — VARCHAR(50)
  • slug — VARCHAR(100)

Category (0)

    Comment (blog_comment)

    • id — Primary Key — Primary key — NOT NULL
    • author_id — Foreign Key — Foreign key → User.id — NOT NULL
    • post_id — Foreign Key — Foreign key → Post.id — NOT NULL
    • content — TEXT
    • created_at — DATETIME
    • modified_at — DATETIME

    Comment (Untitled4)

      MainIngredient (blog_mainingredient)

      • id — Primary Key — Primary key — NOT NULL
      • post_id — Foreign Key — Foreign key → Post.id — NOT NULL
      • name — VARCHAR(100)
      • quantity — INTEGER
      • serviing_size (serving_size) — INTEGER

      MainIngredient (Untitled3)

        Post (blog_post)

        • id (Auto-increment) — Primary Key — Primary key — NOT NULL
        • category_id — Foreign Key — Foreign key → Category.id — NOT NULL
        • author_id — Foreign Key — Foreign key → User.id — NOT NULL
        • title — VARCHAR(30)
        • created_at — DATETIME
        • updated_at — DATETIME
        • head_image — ImageField
        • file_uplaod — FileField
        • content — Markdown

        Post (Untitled)

        • Field
        • Field2
        • Field3
        • Field4
        • Field5
        • Field6

        User (auth_user)

        • id — Primary Key — Primary key — NOT NULL