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