test

Tables (26)

auth_providers

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • provider — ENUM('KAKAO','NAVER','APPLE','GOOGLE') — NOT NULL
  • provider_uid — VARCHAR(191) — NOT NULL
  • access_token — TEXT
  • refresh_token — TEXT
  • linked_at — TIMESTAMP

food_categories

  • id — INT
  • name — VARCHAR(40) — NOT NULL

foods

  • id — BIGINT — Primary key — NOT NULL
  • category — VARCHAR(50) — NOT NULL

inquiries

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(100)
  • content — TEXT
  • question_type — ENUM('GENERAL','BUG','ETC') — NOT NULL
  • image_url — VARCHAR(255)
  • user_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

inquiry_images

  • id — BIGINT
  • inquiry_id — BIGINT — NOT NULL
  • url — VARCHAR(512) — NOT NULL
  • sort_no — INT
  • created_at — TIMESTAMP

inquiry_replies

  • id — BIGINT
  • inquiry_id — BIGINT — NOT NULL
  • responder_user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

menu_items

  • id — BIGINT
  • store_id — BIGINT — NOT NULL
  • name — VARCHAR(120) — NOT NULL
  • price — INT — NOT NULL
  • created_at — TIMESTAMP

mission_verifications

  • id — BIGINT
  • user_mission_id — BIGINT — NOT NULL
  • method — ENUM('OWNER_CODE','RECEIPT_PHOTO','AMOUNT_INPUT') — NOT NULL
  • payload — JSON
  • verified_by_user_id — BIGINT
  • verified_at — DATETIME
  • created_at — TIMESTAMP

missions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • store_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

notification_settings

  • user_id — BIGINT
  • new_event — TINYINT(1)
  • review_reply — TINYINT(1)
  • inquiry_reply — TINYINT(1)
  • created_at — TIMESTAMP

notifications

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(100)
  • content — TEXT
  • is_read — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

point_transactions

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • kind — ENUM('EARN','SPEND','ADJUST') — NOT NULL
  • amount — INT — NOT NULL
  • source — ENUM('MISSION','REVIEW','EXCHANGE','ADMIN') — NOT NULL
  • ref_table — VARCHAR(50)
  • ref_id — BIGINT
  • created_at — TIMESTAMP

review_comments

  • id — BIGINT — Primary key — NOT NULL
  • review_id — BIGINT — NOT NULL
  • content — TEXT
  • created_at — DATETIME — NOT NULL

review_images

  • id — BIGINT
  • review_id — BIGINT — NOT NULL
  • url — VARCHAR(512) — NOT NULL
  • sort_no — INT
  • created_at — TIMESTAMP

review_replies

  • id — BIGINT
  • review_id — BIGINT — NOT NULL
  • store_id — BIGINT — NOT NULL
  • owner_user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

reviews

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • star_point — TINYINT — NOT NULL
  • content — TEXT
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

stores

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • region — VARCHAR(50)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

terms

  • id — BIGINT
  • code — ENUM('SERVICE','PRIVACY','LOCATION','MARKETING') — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • url — VARCHAR(512)
  • is_required — TINYINT(1)
  • published_at — DATETIME

user_consents

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • terms_id — BIGINT — NOT NULL
  • agreed — TINYINT(1) — NOT NULL
  • agreed_at — DATETIME — NOT NULL

user_favorite_foods

  • user_id — BIGINT — Primary key — NOT NULL
  • food_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME — NOT NULL

user_food_preferences

  • user_id — BIGINT — Primary key — NOT NULL
  • category_id — INT — Primary key — NOT NULL
  • created_at — TIMESTAMP

user_missions

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • mission_id — BIGINT — NOT NULL
  • status — ENUM('IN_PROGRESS','REQUESTED','APPROVED','REJECTED','EXPIRED')
  • progress — JSON
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_profiles

  • user_id — BIGINT
  • name — VARCHAR(80)
  • gender — ENUM('M','F','NA')
  • birth_date — DATE
  • address1 — VARCHAR(255)
  • address2 — VARCHAR(255)
  • region_code — VARCHAR(32)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_store_bookmarks

  • user_id — BIGINT — Primary key — NOT NULL
  • store_id — BIGINT — Primary key — NOT NULL
  • created_at — TIMESTAMP

user_visited_stores

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • store_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • gender — ENUM('MALE','FEMALE','OTHER') — NOT NULL
  • birth_date — DATE
  • address — VARCHAR(255)
  • point — BIGINT
  • phone_number — VARCHAR(20)
  • email — VARCHAR(100)
  • is_phone_verified — TINYINT(1) — NOT NULL
  • is_notification_enabled — TINYINT(1) — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL