me-in-dle
Tables (11)
calendar_contents
- content_id — BIGINT — Primary key — NOT NULL
- daily_id — BIGINT — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- relation_types — VARCHAR(100) — 관계 타입
- contents — TEXT
- during_time — INT — 소요시간(분)
- use_yn — CHAR(1)
- tag_ids — JSON — 태그 ID 배열
- created_at — DATETIME
calendar_integrations
- calendar_id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- type — VARCHAR(20) — GOOGLE, OUTLOOK, APPLE
- use_yn — CHAR(1)
- external_calendar_id — VARCHAR(255)
- sync_token — VARCHAR(500)
- last_sync_at — DATETIME
- created_at — DATETIME
daily_schedules
- daily_id — BIGINT — Primary key — NOT NULL
- user_id (user_id2) — VARCHAR(50) — Foreign key → users.user_id — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- day — DATE
- schedule_data — JSON — 일정 상세 정보
- created_at — DATETIME
- updated_at — DATETIME
notification_schedules
- log_id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- card_id — BIGINT
- status — VARCHAR(20) — PENDING, SENT, FAILED
- message — TEXT
- send_time — DATETIME
- created_at — DATETIME
real_time_data
- id — BIGINT — Primary key — NOT NULL
- real_detail — JSON — 실시간 데이터 상세
- updated_at — DATETIME
recommendation_cards
- id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- daily_id — BIGINT
- contents — TEXT — 추천 내용
- during_time — INT — 소요시간(분)
- place — VARCHAR(200)
- place_type — VARCHAR(50) — 장소 타입
- place_type_detail — VARCHAR(100) — 세부 카테고리
- status — VARCHAR(20) — PENDING, APPROVED, REJECTED
- created_at — DATETIME
recommendation_feedback
- id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- card_id — BIGINT — NOT NULL
- during_time — INT — 실제 소요시간
- place — VARCHAR(200) — 실제 선택한 장소
- place_type — VARCHAR(50)
- place_type_detail — VARCHAR(100)
- fail_count — INT — 실패 횟수
- success_count — INT — 성공 횟수
- created_at — DATETIME
sns_accounts
- id — BIGINT — Primary key — NOT NULL
- user_id (user_id2) — VARCHAR(50) — Foreign key → users.user_id — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- sns_type — VARCHAR(20) — GOOGLE, KAKAO, NAVER
- use_yn — CHAR(1)
- email — VARCHAR(100)
- provider_detail — JSON
- created_at — DATETIME
tags
- tag_id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(50)
- tag — VARCHAR(100)
- created_at — DATETIME
user_life_patterns
- id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- pattern_type — VARCHAR(50) — SLEEP, EXERCISE, MEAL, WORK
- pattern_value — JSON — 패턴 상세 데이터
- updated_at — DATETIME
users
- user_id — VARCHAR(50) — Primary key — NOT NULL
- email — VARCHAR(100)
- password — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME