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