Stickus

테이블 (5)

MakeHistory (make_history)

  • Seq (seq) — BIGINT — 기본 키 — NOT NULL
  • Pet Seq (pet_seq) — BIGINT — 외래 키 → Pet.Seq — NOT NULL
  • Created At (created_at) — date
  • Source (source) — varchar

Personal (personal)

  • Seq (seq) — BIGINT — 기본 키 — NOT NULL
  • History Seq (history_seq) — BIGINT — 외래 키 → MakeHistory.Seq — NOT NULL
  • Nutrient (nutrient_seq) — BIGINT
  • Amount (amount) — INT
  • CreatedBy (created_by) — BIGINT
  • CreatedTime (created_time) — timestamp
  • UpdatedBy (updated_by) — BIGINT
  • UpdatedTime (updated_time) — timestamp

Pet (pet)

  • Seq (seq) — BIGINT — 기본 키 — NOT NULL
  • Activity (activity) — varchar
  • Age (age) — varchar
  • BodyForm (body_form) — varchar
  • Breed (breed) — varchar
  • Image (image) — varchar
  • kind — varchar
  • name — varchar
  • Neutralization (neutralization) — bit(1)
  • Owner (owner) — varchar
  • Sex (sex) — varchar
  • Weight (weight) — varchar

설문 (survey)

  • Seq (seq) — BIGINT — 기본 키 — NOT NULL
  • Health (health) — BIGINT
  • Optional Nutrient (optional_nutrient) — varchar
  • Contents (contents) — TEXT
  • Recom Nutrient (recomnend_nutrient) — varchar

설문에 따른 영양제들 (servey_nutrient)

  • sequence (seq) — BIGINT — 기본 키 — NOT NULL
  • Survey Seq (survey_seq) — BIGINT — 외래 키 → 설문.Seq — NOT NULL
  • Nutrient Seq (nutrient_seq) — BIGINT
  • Score (score) — DECIMAL