펫이레터

테이블 (3)

Letter (Untitled)

  • letter_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • letter_content (Field)
  • letter_isread (Field2)
  • letter_read_at (Field3)
  • letter_created_at (Field4)
  • letter_updated_at (Field5)
  • user_id (PK) — NOT NULL — 외래 키 → User.user_id — NOT NULL

Pet (반려동물)

  • pet_id (Key) — 기본 키 — NOT NULL
  • pet_name (Field)
  • pet_breed (Field2)
  • pet_gender (Field3)
  • pet_favorite_things (Field4)
  • pet_dislike_things (Field5)
  • pet_medical_history (Field6)
  • user_id (PK) — NOT NULL — 외래 키 → User.user_id — NOT NULL

User (사용자)

  • user_id (PK) — NOT NULL — 기본 키 — NOT NULL
  • user_login_id (Field3) — NOT NULL
  • user_password (Field4) — NOT NULL
  • user_name (Field) — NOT NULL
  • user_type (Field6)
  • pet_name (Field5) — NULL
  • user_regDate (Field2)