따끈
테이블 (13)
AIDiagnosis
- id — INT
- diagnosis_id — INT — NOT NULL
- model_used — VARCHAR(255)
- ai_result — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Diagnosis
- id — INT
- user_id — INT — NOT NULL
- pet_id — INT — NOT NULL
- diagnosis_date — DATE — NOT NULL
- symptoms — TEXT
- result — TEXT
- recommendation — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
DiagnosisPoint
- id — INT
- user_id — INT — NOT NULL
- points — INT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Diary
- id — INT
- user_id — INT — NOT NULL
- pet_id — INT — NOT NULL
- date — DATE — NOT NULL
- entry — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Login
- id — INT
- user_id — INT — NOT NULL
- login_type — VARCHAR(50) — NOT NULL
- token — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- expired_at — TIMESTAMP
Onboarding
- id — INT
- user_id — INT — NOT NULL
- video_url — VARCHAR(255) — NOT NULL
- started_at — TIMESTAMP
- completed_at — TIMESTAMP
Pet
- id — INT
- user_id — INT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- birthdate — DATE
- type — VARCHAR(50) — NOT NULL
- breed — VARCHAR(255)
- photo_url — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
ProductCategory
- id — INT
- name — VARCHAR(255) — NOT NULL
ProductRank
- id — INT
- product_id — INT — NOT NULL
- rank — INT — NOT NULL
- rank_date — DATE — NOT NULL
ProductRecommendation
- id — INT
- pet_id — INT — NOT NULL
- recommendation_date — DATE — NOT NULL
- product_name — VARCHAR(255) — NOT NULL
- product_url — VARCHAR(255)
- image_url — VARCHAR(255)
- price — DECIMAL(10, 2)
- category — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Schedule
- id — INT
- user_id — INT — NOT NULL
- pet_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- date — DATE — NOT NULL
- time — TIME — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
User
- id — INT
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- kakao_token — VARCHAR(255)
- apple_token — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
diary
- diary_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- pet_id — BIGINT — NOT NULL
- date — DATE — NOT NULL
- entry — TEXT — NOT NULL
- category — ENUM('귀', '눈', '털', '발톱', '이빨') — NOT NULL — ENUM(귀, 눈, 털, 발톱, 이빨)
- created_at — DATETIME
- updated_at — DATETIME