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)