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