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