포옹
테이블 (5)
donation (Untitled6)
- donations_id (Key) — BIGINT — 기본 키 — NOT NULL
- user_id (Key2) — BIGINT — 외래 키 → user.user_id — NOT NULL
- pet_id (Key3) — BIGINT — 외래 키 → pet.pet_id — NOT NULL
- donation_item_id (Key22) — INT — 외래 키 → donation_item.donation_item_id — NOT NULL
- createdAt (Field3) — DATE — NOT NULL
- quantity (Field) — INT
- isDelivery (Field2) — ENUM
- receivedPhoneNumber (Field4) — VARCHAR
- receivedAddress (Field5) — VARCHAR
donation_item (Untitled3)
- donation_item_id (Key2) — INT — 기본 키 — NOT NULL
- name (Field) — VARCHAR
- price (Field2) — INT
- brand (Field3) — VARCHAR
- donationItemImages (Field4) — JSON
- user_id (Key) — BIGINT — 외래 키 → user.user_id — NOT NULL
- donationItemDetailImages (Field5) — JSON
- tag (Field6) — ENUM
foster_diary (Untitled4)
- foster_diary_id (Key) — BIGINT — 기본 키 — NOT NULL
- pet_id (Key2) — BIGINT — 외래 키 → pet.pet_id — NOT NULL
- title (Field6) — VARCHAR
- content (Field) — TEXT
- image (Field2) — VARCHAR
- created_at (Field3) — TIMESTAMP
- updated_at (Field4) — TIMPSTAMP
- tag (Field5) — ENUM
- place (Field7) — VARCHAR
pet (Untitled2)
- pet_id (Key) — BIGINT — 기본 키 — NOT NULL
- name (Field) — VARCHAR
- profileImage (Field9) — TEXT
- species (Field10) — ENUM
- breed (Field11) — VARCHAR
- rescueLocation (Field3) — VARCHAR
- gender (Field4) — ENUM
- isNeutered (Field5) — BOOLEAN
- age (Field6) — INT
- weight (Field7) — FLOAT
- user_id (Key2) — BIGINT — 외래 키 → user.user_id — NOT NULL
- info (Field2) — TEXT
- protectionType (Field8) — ENUM
- vaccinations (Field12) — JSON
user (Untitled)
- user_id (Key) — BIGINT — 기본 키 — NOT NULL
- email (Field) — VARCHAR
- nickName (Field2) — VARCHAR
- profileImage (Field3) — TEXT
- socialProvider (Field4) — ENUM
- socialId (Field5) — INT
- createdAt (Field6) — TIMESTAMP
- isVerified (Field7) — BOOLEAN
- password (Field8) — VARCHAR
- favoritePetIds (Field9) — JSON
- isAdmin (Field10) — TINYINT