todo-list
Tables (3)
Card (todo_users_table)
- userId (user_id) — bigint — Primary key — NOT NULL
- nickName (nick_name) — varchar(50)
- phoneNumber (phone_number) — varchar(12)
Card (todo_list_table)
- cardId (todo_id) — bigint — Primary key — NOT NULL
- userId (user_id) — bigint — Foreign key → Card.userId — NOT NULL
- subject — varchar(50)
- content — varchar(500)
- status (todo_status) — varchar(20)
- order (todo_order) — bigint
- deleted — tinyint(1)
- createdAt (todo_created_date) — timestamp
CardHistory (todo_user_history_table)
- historyId (user_history_id) — bigint — Primary key — NOT NULL
- cardId (todo_id2) — bigint — Foreign key → Card.cardId — NOT NULL
- historyStatus (history_status) — varchar(15)
- beforeStatus (before_todo_status) — varchar(10)
- afterStatus (after_todo_status) — varchar(10)
- beforeSubject (before_subject) — varchar(50)
- afterSubject (after_subject) — varchar(50)
- createdAy (created_at) — timestamp
- updatedAt (updated_at) — timestamp
- userId (history_user_id) — bigint