Dermavera

Tables (3)

animals (Untitled3)

  • animalid (Key) — Primary key — NOT NULL
  • animalname (Field)
  • animalage (Field2)
  • animalspecies (Field3)
  • created_date (Field4)
  • user_pk (Key2) — Foreign key → users.user_pk — NOT NULL

diagnoses (Untitled)

  • diagnosis_id (Key) — Primary key — NOT NULL
  • status (Field)
  • score (Field2)
  • image (Field3)
  • create_date (Field4)
  • animalid (Key2) — Foreign key → animals.animalid — NOT NULL

users (Untitled2)

  • user_pk (Key) — Primary key — NOT NULL
  • user_id (Unique)
  • username (Field)
  • password (Field2)
  • provider (Field3)
  • provider_id (Field4)