todoList

Tables (3)

comment

  • id (Key) — bigint — Primary key — NOT NULL
  • post_id (Key2) — bigint — Foreign key → posts.id — NOT NULL
  • user_id (Key3) — bigint — Foreign key → user.id — NOT NULL
  • comment (Field3) — varchar

posts

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • content (Field2) — varchar
  • title (Field3) — varchar
  • create_at (Field4) — date
  • modified_at (Field5) — date

user

  • id (Key) — bigint — Primary key — NOT NULL
  • username (Field) — varchar
  • passowrd (Field2) — varchar