post ERD

Tables (3)

Client (Untitled)

  • username (Key) — varchar(10) — Primary key — NOT NULL
  • password (Field) — varchar(15)

Database (Untitled2)

  • clientList (Field) — List

Post (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • title (Field) — varchar(100)
  • contents (Field2) — varchar(150)
  • date (Field5) — DATE
  • username (Key2) — varchar(10) — Foreign key → Client.username — NOT NULL
  • password (Field4) — varchar(15)