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)