포옹

테이블 (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