포에버

테이블 (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