btrack-week6

Tables (3)

Comment (Untitled3)

  • Key (id) — int — Primary key — NOT NULL
  • Key (member_id) — int — Foreign key → Member.Key — NOT NULL
  • Field (contents) — text
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Member (Untitled)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(20)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Post (Untitled2)

  • Key (id) — int — Primary key — NOT NULL
  • Key (member_id) — int — Foreign key → Member.Key — NOT NULL
  • Field (title) — varchar(30)
  • Field (body) — text
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)