Dog

Tables (5)

Dog (Untitled2)

  • Id — BIGINT — Primary key — NOT NULL
  • Name — STRING
  • Length — DOUBLE
  • Weight — DOUBLE
  • Age — INT
  • DogId — BIGINT — Foreign key → User.Id — NOT NULL

User (Untitled)

  • Id — BIGINT — Primary key — NOT NULL
  • Name — STRING
  • Nickname — STRING
  • Address — STRING
  • PhoneNumber — VARCHAR
  • Age — INT
  • Level — INT
  • Exp — BIGINT
  • Gender — ENUM

Vaccine (Untitled5)

  • Id — BIGINT — Primary key — NOT NULL
  • Date — DATE
  • Type — ENUM
  • RecomStartDate — DATE
  • RecomEndDate — DATE
  • DogId — BIGINT — Foreign key → Dog.Id — NOT NULL

Walk (Untitled3)

  • Id — BIGINT — Primary key — NOT NULL
  • Date — DATE
  • StartTime — DATE
  • EndTime — DATE
  • Distance — DOUBLE
  • DogId — BIGINT — Foreign key → Dog.Id — NOT NULL
  • UserId — BIGINT — Foreign key → User.Id — NOT NULL

Walkpoint (Untitled4)

  • Id — BIGINT — Primary key — NOT NULL
  • Latitude — DOUBLE
  • Longitude — DOUBLE
  • WalkId — BIGINT — Foreign key → Walk.Id — NOT NULL