Todo
Tables (4)
Authority (권한)
- id — bigint — Primary key — NOT NULL
- userId — bigint — Foreign key → Customer.id — NOT NULL
- name (권한) — char(10)
Customer (유저)
- id — bigint — Primary key — NOT NULL
- username (유저이름) — char(10)
- password (비밀번호) — char(15)
Todo (할일)
- id — bigint — Primary key — NOT NULL
- title (제목) — char(50)
- content (내용) — text
- createdAt (작성일) — datetime
- isComplete (완료 상태) — boolean
- author (작성자) — char(10)
comment (댓글)
- id — bigint — Primary key — NOT NULL
- todoId (할일 식별자) — bigint — Foreign key → Todo.id — NOT NULL
- content (내용) — text
- createdAt (작성일) — datetime
- author (작성자) — char(10)