DB Schema

Todo Card 테이블

CREATE TABLE card (
  id int PRIMARY KEY AUTO_INCREMENT,
  order_index int NOT NULL,
  delete_yn tinyint(1) NOT NULL,
  title varchar(255) NOT NULL,
  content varchar(255) NOT NULL,
  section enum('todo', 'doing', 'done') NOT NULL,
  author varchar(255) NOT NULL
);

Card 로그 테이블

CREATE TABLE log (
  id int PRIMARY KEY AUTO_INCREMENT,
  event enum('create', 'update', 'move', 'delete') NOT NULL,
  title varchar(255) NOT NULL,
  log_time dateTime NOT NULL,
  prev_section varchar(255),
  section varchar(255) NOT NULL
);