db_Team5

Tables (7)

DOG (Untitled2)

  • Dog_ID (Key) — Primary key — NOT NULL
  • Name (Field)
  • Breed (Field2)
  • Birthday (Field3)
  • Gender (Field4)
  • Weight (Field5)
  • Status (Field6)
  • Description (Field7)
  • Photo_url (Field8)
  • Contract_ID (Key2) — Foreign key → POST.POST_ID — NOT NULL
  • Shelter_ID (Key3) — Foreign key → SHELTER.Shelter_ID — NOT NULL

POST (Untitled4)

  • POST_ID (Key) — Primary key — NOT NULL
  • Title (Field3)
  • Created_at (Field)
  • status (Field2)

REPORT (Untitled6)

  • Report_ID (Key) — Primary key — NOT NULL
  • Health_status (Field)
  • Notes (Field2)
  • Dog_ID (Key2) — Foreign key → DOG.Dog_ID — NOT NULL

SHELTER (Untitled3)

  • Shelter_ID (Key) — BIGINT — Primary key — NOT NULL
  • Name (name)
  • Address (address)
  • Phone (Field3)
  • Email (Field4)
  • Opening_hours (Field5)

USER (Untitled)

  • User_ID (Key) — BIGINT — Primary key — NOT NULL
  • PassWord (password) — VARCHAR(255)
  • user_Name (user_name) — VARCHAR(100)
  • Email (Field3) — VARCHAR(255)
  • Phone (Field4) — VARCHAR(20)
  • Address (Field5) — VARCHAR(255)
  • Birthday (Field6) — DATE
  • Gender (Field7) — CHAR(10)
  • Position (Field8)

USER (CONTRACT)

  • Applied_date (Field)
  • User_ID (Key) — Foreign key → USER.User_ID — NOT NULL
  • POST_ID (Key2) — Foreign key → POST.POST_ID — NOT NULL

VACCINATION (Untitled5)

  • Vaccination_ID (Key) — Primary key — NOT NULL
  • Name (Field)
  • Vaccination_date (Field2)
  • Field3
  • Report_ID (Key2) — Foreign key → REPORT.Report_ID — NOT NULL