펫이레터
테이블 (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)