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