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