renew_ERD
Tables (21)
BADGE
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- image — VARCHAR(255)
- required_points — INT — NOT NULL
- type — VARCHAR(50)
CATEGORY
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- icon — VARCHAR(255)
- is_active — BOOLEAN — NOT NULL
INQUIRY
- id — BIGINT
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- status — VARCHAR(50) — NOT NULL
- type — VARCHAR(50)
INQUIRY_RESPONSE
- id — BIGINT
- inquiry_id — BIGINT — Foreign key → INQUIRY.id — NOT NULL
- admin_id — BIGINT — Foreign key → USER.id — NOT NULL
- content — TEXT — NOT NULL
- response_date — DATETIME — NOT NULL
LOG
- id — BIGINT
- user_id — BIGINT — Foreign key → USER.id
- action_type — VARCHAR(100) — NOT NULL
- timestamp — DATETIME — NOT NULL
- ip_address — VARCHAR(45)
- additional_data — TEXT
MENU
- id — BIGINT
- store_id — BIGINT — Foreign key → STORE.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- price — DECIMAL(10,2) — NOT NULL
- is_available — BOOLEAN — NOT NULL
- image_url — VARCHAR(255)
MISSION
- id — BIGINT
- store_id — BIGINT — Foreign key → STORE.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- reward_points — INT — NOT NULL
- start_date — DATETIME — NOT NULL
- end_date — DATETIME — NOT NULL
- type — VARCHAR(50)
- is_active — BOOLEAN — NOT NULL
- difficulty_level — INT — NOT NULL
REGION
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- latitude — FLOAT
- longitude — FLOAT
REVIEW
- id — BIGINT
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- mission_id — BIGINT — Foreign key → MISSION.id
- store_id — BIGINT — Foreign key → STORE.id — NOT NULL
- rating — INT — NOT NULL
- content — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- is_verified — BOOLEAN — NOT NULL
- helpful_count — INT — NOT NULL
REVIEW_IMAGE
- id — BIGINT
- review_id — BIGINT — Foreign key → REVIEW.id — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- display_order — INT — NOT NULL
- uploaded_at — DATETIME — NOT NULL
REVIEW_REPLY
- id — BIGINT
- review_id — BIGINT — Foreign key → REVIEW.id — NOT NULL
- owner_id — BIGINT — Foreign key → USER.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
STORE
- id — BIGINT
- region_id — BIGINT — Foreign key → REGION.id — NOT NULL
- category_id — BIGINT — Foreign key → CATEGORY.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- address — VARCHAR(255) — NOT NULL
- contact_number — VARCHAR(20)
- latitude — FLOAT
- longitude — FLOAT
- business_hours — VARCHAR(255)
- main_image — VARCHAR(255)
- is_active — BOOLEAN — NOT NULL
STORE_IMAGE
- id — BIGINT
- store_id — BIGINT — Foreign key → STORE.id — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- caption — VARCHAR(255)
- display_order — INT — NOT NULL
- uploaded_at — DATETIME — NOT NULL
STORE_INFO
- id — BIGINT
- store_id — BIGINT — Foreign key → STORE.id — NOT NULL
- detailed_description — TEXT
- last_updated — DATETIME — NOT NULL
STORE_OWNER
- id — BIGINT
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- store_id — BIGINT — Foreign key → STORE.id — NOT NULL
- registered_date — DATETIME — NOT NULL
- is_verified — BOOLEAN — NOT NULL
- business_license_number — VARCHAR(50)
USER
- id — BIGINT
- username — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- last_login — DATETIME
- is_active — BOOLEAN — NOT NULL
- phone_number — VARCHAR(20)
- social_login_type — VARCHAR(50)
USER_BADGE
- id — BIGINT
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- badge_id — BIGINT — Foreign key → BADGE.id — NOT NULL
- acquired_date — DATETIME — NOT NULL
USER_CATEGORY_PREFERENCE
- id — BIGINT
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- category_id — BIGINT — Foreign key → CATEGORY.id — NOT NULL
- created_at — DATETIME — NOT NULL
USER_MISSION
- id — BIGINT
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- mission_id — BIGINT — Foreign key → MISSION.id — NOT NULL
- assigned_date — DATETIME — NOT NULL
- completed_date — DATETIME
- status — VARCHAR(50) — NOT NULL
- proof_image — VARCHAR(255)
- admin_comment — TEXT
USER_POINT
- id — BIGINT
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- amount — INT — NOT NULL
- type — VARCHAR(50) — NOT NULL
- description — TEXT
- created_at — DATETIME — NOT NULL
- mission_id — BIGINT — Foreign key → MISSION.id
USER_PROFILE
- id — BIGINT
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- profile_image — VARCHAR(255)
- total_points — INT — NOT NULL
- level — INT — NOT NULL
- updated_at — DATETIME — NOT NULL