todoProject

Tables (6)

comment (CopyOfUntitled2)

  • pk (id) — bigint — Primary key — NOT NULL
  • fk (users_id) — bigint — Foreign key → user.pk — NOT NULL
  • Key (todo_id) — bigint — Foreign key → todo.Key — NOT NULL
  • Field (title) — varchar(255)
  • Field (created_at) — datetime(6)
  • Field2 (modified_at) — datetime(6)

image_data (Untitled2)

  • Key (image_data_id) — bigint — Primary key — NOT NULL
  • Key (todo_id) — bigint — Foreign key → todo.Key — NOT NULL
  • Field (imagedata) — blob
  • Field2 (name) — varchar(255)
  • Field3 (size) — bigint
  • Field4 (type) — varchar(255)
  • Field5 (created_at) — datetime(6)
  • Field6 (modified_at) — varchar(255)

login_hisotry (Untitled4)

  • Key (login_history) — bigint — Primary key — NOT NULL
  • Field (login_status) — datetime(6)
  • Field2 (username) — varchar(255)
  • c (created_at) — datetime(6)
  • Field4 (modified_at) — datetime(6)

refresh_token (Untitled5)

  • Key (refresh_token_id) — bigint — Primary key — NOT NULL
  • pk (users_id) — bigint — Foreign key → user.pk — NOT NULL
  • Field (token) — varchar(255)

todo (Untitled)

  • Key (todo_id) — bigint — Primary key — NOT NULL
  • pk (users_id) — bigint — Foreign key → user.pk — NOT NULL
  • (contents) — varchar(255)
  • Field2 (title) — varchar(255)
  • Field3 (created_at) — datetime(6)
  • Field (modified_at) — datetime(6)

user (Untitled3)

  • pk (users_id) — bigint — Primary key — NOT NULL
  • Field (nickname) — varchar(255)
  • Field2 (password) — varchar(255)
  • Field3 (role) — enum
  • Field4 (username) — varchar(255)
  • Field (created_at) — datetime(6)
  • Field2 (modified_at) — datetime(6)