ETA DB

Tables (7)

call_record (통화기록)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • daily_id — BIGINT — Foreign key → daily_statistic.id — NOT NULL
  • 날짜 (date) — DATETIME
  • 이름 (name) — VARCHAR
  • 시간 (time) — TIMESTAMP

daily_statistic (일별통계)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • 날짜 (date) — DATETIME
  • 걸음수 (steps) — INT

diary (일기)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • 위치 (location) — VARCHAR
  • 날짜 (date) — DATETIME
  • 내용 (contents) — TEXT
  • 작성일자 (created_at) — DATETIME
  • 수정일자 (updated_at) — DATETIME
  • daily_id — BIGINT — Foreign key → daily_statistic.id — NOT NULL
  • 위도 (latitude) — FLOAT
  • 경도 (longitude) — FLOAT

image (이미지)

  • id — BIGINT — Primary key — NOT NULL
  • diary_id — BIGINT — Foreign key → diary.id — NOT NULL
  • image_url — VARCHAR
  • 촬영시각 (timestamp) — DATETIME

monthly_statistic (월별통계)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • 년월 (year_month) — DATE
  • 평균걸음수 (averag_step) — INT
  • 방문장소수 (visited_location) — INT
  • 전화많이한사람 (call_person) — VARCHAR

user (유저)

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR
  • role — ENUM
  • 생성일자 (created_at) — DATETIME
  • 수정일자 (updated_at) — DATETIME
  • name — VARCHAR

visited_region (방문지역)

  • id — BIGINT — Primary key — NOT NULL
  • month_id — BIGINT — Foreign key → monthly_statistic.id — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • 지역(시) (region) — VARCHAR
  • 백분율 (percentage) — FLOAT