하위
테이블 (11)
food_category
- id — BIGINT
- name — VARCHAR(15)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- Column4 — DATETIME(6)
member
- id — BIGINT
- name — VARCHAR(20)
- gender — VARCHAR(10)
- age — INT
- address — VARCHAR(40)
- status — VARCHAR(15)
- space_address — VARCHAR(40)
- inactive_date — DATETIME(6)
- social_type — VARCHAR(10)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- email — VARCHAR(50)
- point — INT
member_agree
- id — BIGINT
- member_id — BIGINT
- terms_id — BIGINT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
member_mission
- id — BIGINT
- member_id — BIGINT
- mission_id — BIGINT
- status — VARCHAR(15)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
member_prefer
- id — BIGINT
- member_id — BIGINT
- category_id — BIGINT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
mission
- id — BIGINT
- store_id — BIGINT
- reward — INT
- deadline — DATETIME(6)
- mission_spec — TEXT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
region
- id — BIGINT
- name — VARCHAR(20)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
review
- id — BIGINT
- member_id — BIGINT
- store_id — BIGINT
- body — TEXT
- score — FLOAT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
review_image
- id — BIGINT
- review_id — BIGINT
- image_url — TEXT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
store
- id — BIGINT
- region_id — BIGINT
- name — VARCHAR(50)
- address — VARCHAR(50)
- score — FLOAT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
terms
- id — BIGINT
- body — TEXT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- optional — BOOLEAN