prac_erd

Tables (3)

article (Untitled2)

  • Key — Primary key — NOT NULL
  • author (Key2) — Foreign key → author.Key — NOT NULL
  • title (Field) — VARCHAR
  • content (Field2) — VARCHAR
  • created_at (Field3) — DATETIME

author (Untitled)

  • Key — Primary key — NOT NULL
  • name (Field) — VARCHAR
  • intro (Field2) — VARCHAR
  • join_date (Field3) — DATETIME

comment (Untitled3)

  • Key — Primary key — NOT NULL
  • article (Key2) — Foreign key → article.Key — NOT NULL
  • author (Key3) — Foreign key → author.Key — NOT NULL
  • comment (Field) — VARCHAR
  • created_at (Field2) — DATETIME