ryankim homepage

Tables (3)

categories (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • title (Field) — string

posts (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • category_id (Key2) — int — Foreign key → categories.id — NOT NULL
  • sub_category_id (Key3) — int — Foreign key → sub_categories.id — NOT NULL
  • markdown (Field3) — text
  • createdAt (Field) — datetime
  • updatedAt (Field2) — datetime
  • title (Field4) — varchar(255)

sub_categories (Untitled3)

  • id (Key) — number — Primary key — NOT NULL
  • category_id (Key2) — int — Foreign key → categories.id — NOT NULL
  • title (Field) — string