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