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