t

Tables (12)

auth_session

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • token_hash — VARCHAR(71) — NOT NULL
  • family_id — VARCHAR(36) — NOT NULL
  • expires_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • last_used_at — DATETIME(6)
  • revoked_at — DATETIME(6)
  • replaced_by_hash — VARCHAR(71)
  • device_name — VARCHAR(100)
  • user_agent — VARCHAR(255)

companion

  • companion_id — BIGINT — Primary key — NOT NULL
  • created_time — DATETIME(6)
  • modified_time — DATETIME(6)
  • owner_id — BIGINT — Foreign key → user.user_id
  • display_name — VARCHAR(255)
  • linked_user_id — BIGINT — Foreign key → user.user_id
  • companion_type — ENUM('ALONE','LOVER','FRIEND','FAMILY','CUSTOM')

companion_request

  • request_id — BIGINT — Primary key — NOT NULL
  • created_time — DATETIME(6)
  • modified_time — DATETIME(6)
  • from_user_id — BIGINT — Foreign key → user.user_id
  • to_user_id — BIGINT — Foreign key → user.user_id
  • status — ENUM('PENDING','ACCEPTED','REJECTED') — NOT NULL

dining_record

  • record_id — BIGINT — Primary key — NOT NULL
  • created_time — DATETIME(6)
  • modified_time — DATETIME(6)
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • companion_id — BIGINT — Foreign key → companion.companion_id
  • restaurant_id — BIGINT — Foreign key → restaurant.restaurant_id — NOT NULL
  • food_name — VARCHAR(255) — NOT NULL
  • image_url — VARCHAR(1000)
  • visit_date — DATE — NOT NULL
  • location_type — ENUM('RESTAURANT','HOME','OFFICE','DELIVERY','UNKNOWN')
  • will_revisit — BIT(1)
  • is_public — BIT(1) — NOT NULL

dining_record_companion

  • dining_record_companion_id — BIGINT — Primary key — NOT NULL
  • record_id — BIGINT — Foreign key → dining_record.record_id — NOT NULL
  • companion_id — BIGINT — Foreign key → companion.companion_id — NOT NULL

draft_record

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • source_user_id — BIGINT — Foreign key → user.user_id
  • image_url — VARCHAR(255) — NOT NULL
  • food_name — VARCHAR(255)
  • food_tags_json — TEXT
  • scene_tags_json — TEXT
  • captured_latitude — DOUBLE
  • captured_longitude — DOUBLE
  • captured_at — DATETIME(6)
  • has_exif_gps — BIT(1)
  • location_type — ENUM('RESTAURANT','HOME','OFFICE','DELIVERY','UNKNOWN') — NOT NULL
  • kakao_place_id — VARCHAR(255)
  • place_name — VARCHAR(255)
  • category — VARCHAR(255)
  • address — VARCHAR(255)
  • restaurant_latitude — DOUBLE
  • restaurant_longitude — DOUBLE
  • restaurant_candidates_json — TEXT
  • status — ENUM('PENDING','APPROVED','REJECTED') — NOT NULL
  • created_at — DATETIME(6)

home_location

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • type — ENUM('HOME','OFFICE','CUSTOM') — NOT NULL
  • label — VARCHAR(255) — NOT NULL
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE — NOT NULL
  • radius_meters — INT — NOT NULL

oauth_login_code

  • id — BIGINT — Primary key — NOT NULL
  • code_hash — VARCHAR(71) — NOT NULL
  • binding_hash — VARCHAR(71) — NOT NULL
  • user_id — BIGINT — NOT NULL
  • is_new_user — BIT(1) — NOT NULL
  • expires_at — DATETIME(6) — NOT NULL
  • consumed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL

recommendation_daily_usage

  • id — BIGINT — Primary key — NOT NULL
  • created_time — DATETIME(6)
  • modified_time — DATETIME(6)
  • user_id — BIGINT — NOT NULL
  • usage_date — DATE — NOT NULL
  • used_count — INT — NOT NULL

restaurant

  • restaurant_id — BIGINT — Primary key — NOT NULL
  • created_time — DATETIME(6)
  • modified_time — DATETIME(6)
  • kakao_place_id — VARCHAR(255) — NOT NULL
  • place_name — VARCHAR(255) — NOT NULL
  • category — VARCHAR(255)
  • address — VARCHAR(255)
  • latitude — DOUBLE
  • longitude — DOUBLE

user

  • user_id — BIGINT — Primary key — NOT NULL
  • created_time — DATETIME(6)
  • modified_time — DATETIME(6)
  • email — VARCHAR(255)
  • social_id — VARCHAR(255)
  • nickname — VARCHAR(255)
  • image_url — VARCHAR(255)
  • authority — ENUM('ROLE_GUEST','ROLE_USER','ROLE_ADMIN')
  • social_type — ENUM('KAKAO','NAVER')
  • refresh_token — VARCHAR(255)
  • more_info1 — VARCHAR(255)
  • more_info2 — VARCHAR(255)
  • more_info3 — VARCHAR(255)
  • my_code — VARCHAR(6)

user_allergen

  • id — BIGINT — Primary key — NOT NULL
  • created_time — DATETIME(6)
  • modified_time — DATETIME(6)
  • allergen — VARCHAR(255)
  • user_id — BIGINT — Foreign key → user.user_id