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