포에버
테이블 (9)
DIARY
- diary_id — INT
- dog_id — INT
- date — DATE
- walk_distance — FLOAT
- play_time — INT
- notes — TEXT
- created_at — DATETIME
DOG
- dog_id — INT
- user_id — INT
- name — VARCHAR(100)
- breed — VARCHAR(100)
- age — INT
- health_notes — TEXT
- created_at — DATETIME
EXTERNAL_DATA
- ext_data_id — INT
- date — DATE
- weather — TEXT
- temp_avg — FLOAT
- rain_chance — FLOAT
- source — VARCHAR(100)
- last_updated — DATETIME
- created_at — DATETIME
FEEDBACK
- feedback_id — INT
- user_id — INT
- rec_id — INT
- feedback_text — TEXT
- score — FLOAT
- created_at — DATETIME
PHOTO_VIDEO
- file_id — INT
- diary_id — INT
- file_url — VARCHAR(255)
- file_type — VARCHAR(50)
- file_size — FLOAT
- metadata — TEXT
- tags — TEXT
- uploaded_at — DATETIME
RECOMMENDATION
- rec_id — INT
- diary_id — INT
- recommendation — TEXT
- status — VARCHAR(50)
- accuracy_score — FLOAT
- adopted_at — DATETIME
- created_at — DATETIME
USER
- user_id — INT
- name — VARCHAR(100)
- email — VARCHAR(255)
- created_at — DATETIME
USER_GROUP
- group_id — INT
- group_name — VARCHAR(100)
- description — TEXT
- created_at — DATETIME
USER_GROUP_MEMBERS
- member_id — INT
- user_id — INT
- group_id — INT
- role — VARCHAR(50)
- joined_at — DATETIME