todo-list

Tables (3)

MEMBER (회원)

  • id (아이디) — VARCHAR(36) — Primary key — NOT NULL
  • nickname (닉네임) — VARCHAR(30)
  • login_id (로그인 아이디) — VARCHAR(30)
  • password (비밀번호) — VARCHAR(60)
  • delete_yn (탈퇴여부) — CHAR(1)
  • created_at (생성일시) — TIMESTAMP
  • modified_at (수정일시) — TIMESTAMP
  • deleted_at (삭제일시) — TIMESTAMP

TODO (할 일)

  • id (아이디) — VARCHAR(36) — Primary key — NOT NULL
  • member_id (회원 ID) — VARCHAR(36) — Foreign key → MEMBER.id — NOT NULL
  • content (내용) — VARCHAR(255)
  • status (상태) — VARCHAR(20)
  • created_at (생성일시) — TIMESTAMP
  • modified_at (수정일시) — TIMESTAMP

USER_ACCOUNT (계정)

  • id (아이디) — VARCHAR(36) — Primary key — NOT NULL
  • member_id (회원 ID) — VARCHAR(36) — Foreign key → MEMBER.id — NOT NULL
  • role_type (역할 타입) — VARCHAR(20)
  • created_at (생성일시) — TIMESTAMP
  • modified_at (수정일시) — TIMESTAMP