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