spring-expert
Tables (4)
comment (댓글)
- id (PK) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → user.id — NOT NULL
- todo_id (FK2) — bigint — Foreign key → todo.id — NOT NULL
- contents (Field) — varchar
- created_at (Field2) — datetime
- motified_at (Field3) — datetime
manager (담당자)
- id (PK) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → user.id — NOT NULL
- todo_id (FK2) — bigint — Foreign key → todo.user_id — NOT NULL
todo (할 일)
- id (PK) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → user.id — NOT NULL
- title (Field) — varchar
- contents (Field2) — varchar
- weather (Field3) — varchar
- created_at (Field4) — datetime
- motified_at (Field5) — datetime
user (유저)
- id (PK) — bigint — Primary key — NOT NULL
- username (Field) — varchar
- email (Field2) — varchar
- password (Field3) — varchar
- user_role (Field4) — varchar
- created_at (Field5) — datetime
- modified_at (Field6) — datetime