doctorfit
Tables (7)
Health (health)
- Seq (seq) — BIGINT — Primary key — NOT NULL
- Name (name) — VARCHAR
- HealthDesc (health_desc) — TEXT
HealthScore (health_score)
- Seq (seq) — BIGINT — Primary key — NOT NULL
- HealthSeq (health_seq) — BIGINT — Foreign key → Health.Seq — NOT NULL
- NutrientSeq (nutrient_seq) — BIGINT
- Score (score) — DECIMAL
PetNutrientLog (pet_nutrient_log)
- seq — BIGINT — Primary key — NOT NULL
- PetNutrientTypeLog (pet_nutrient_type_log) — BIGINT — Foreign key → PetNutritionalHistory.Seq — NOT NULL
- nutrient_seq — BIGINT
- amount — INT
- created_by — BIGINT
- created_time — timestamp
- updated_by — BIGINT
- updated_time — timestamp
PetNutritionalHistory (pet_nutrient_type_log)
- Seq (seq) — BIGINT — Primary key — NOT NULL
- pet_seq — BIGINT — Foreign key → pet.seq — NOT NULL
- Type (type) — varchar
- created_by — BIGINT
- created_time — timestamp
- updated_by — BIGINT
- updated_time — timestamp
SurveyNutrient (survey_nutrient)
- Seq (seq) — BIGINT — Primary key — NOT NULL
- SurveySeq (survey_seq) — BIGINT — Foreign key → survey.Seq — NOT NULL
- NutrientSeq (nutrient_seq) — BIGINT
- score — DECIMAL
- TypeCode (typeCode) — VARCHAR
- created_by — BIGINT
- created_time — timestamp
- updated_by — BIGINT
- updated_time — timestamp
pet
- seq — BIGINT — Primary key — NOT NULL
- activity — varchar
- age — varchar
- body_form — varchar
- breed — varchar
- image — varchar
- kind — varchar
- name — varchar
- neutralization — bit(1)
- owner — varchar
- sex — varchar
- weight — varchar
- created_by — BIGINT
- created_time — timestamp
- updated_by — BIGINT
- updated_time — timestamp
survey
- Seq (seq) — BIGINT — Primary key — NOT NULL
- health — BIGINT
- contents — TEXT
- created_by — BIGINT
- created_time — timestamp
- updated_by — BIGINT
- updated_time — timestamp