With Pet
Tables (4)
Pet (반려동물)
- pet_id (반려동물ID) — INT UNSIGNED — Primary key — NOT NULL
- user_id (회원ID) — INT UNSIGNED — Foreign key → User.user_id — NOT NULL
- pet_name (반려동물 이름) — VARCHAR(512) — NOT NULL
- pet (반려동물 종류) — VARCHAR(512) — NOT NULL
- birth (반려동물 생년월일) — DATE
- pet_imgURL (반려동물 이미지) — VARCHAR(512)
Todo (할일)
- todo_id (투두리스트ID) — INT UNSIGNED — Primary key — NOT NULL
- user_id (회원ID) — INT UNSIGNED — Foreign key → User.user_id — NOT NULL
- title (제목) — VARCHAR(512) — NOT NULL
- memo (메모) — VARCHAR(512) — NOT NULL
- dueDate (실행 날짜) — TIMESTAMP
- check_it (체크 상태) — TINYINT — NOT NULL
Todo_kind (할일 종류)
- kind_id (투두 종류ID) — INT UNSIGNED — Primary key — NOT NULL
- title (제목) — VARCHAR(512) — NOT NULL
User (회원)
- user_id (회원ID) — INT UNSIGNED — Primary key — NOT NULL
- user_name (이름) — VARCHAR(512) — NOT NULL
- email (이메일) — VARCHAR(512) — NOT NULL
- birth (생년월일) — DATE — NOT NULL
- platform_type (플랫폼) — NOT NULL
- access_token (액세스 토큰) — NOT NULL
- user_imgURL (회원 이미지) — VARCHAR(512)