umc_db
Tables (11)
food_category
- id — INT — Primary key — NOT NULL
- name — VARCHAR(15)
- created_at — TIMESTAMP
- Column4 — DATETIME
member_agree
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- terms_id — INT — Foreign key → terms.id — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
member_mission
- id — INT — Primary key — NOT NULL
- mission_id — INT — Foreign key → mission.id — NOT NULL
- store_id — INT — Foreign key → mission.store_id — NOT NULL
- region_id — INT — Foreign key → mission.region_id — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- status — VARCHAR(15)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
mission
- id — INT — Primary key — NOT NULL
- store_id — INT — Foreign key → store.id — NOT NULL
- region_id — INT — Foreign key → store.region_id — NOT NULL
- reward — INT
- deadline — DATETIME
- mission_spec — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
region
- id — INT — Primary key — NOT NULL
- name — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
review
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- store_id — INT — Foreign key → store.id — NOT NULL
- region_id — INT — Foreign key → store.region_id — NOT NULL
- body — TEXT
- score — FLOAT
review_image
- id — INT — Primary key — NOT NULL
- review_id — INT — Foreign key → review.id — NOT NULL
- user_id — INT — Foreign key → review.user_id — NOT NULL
- store_id — INT — Foreign key → review.store_id — NOT NULL
- region_id — INT — Foreign key → review.region_id — NOT NULL
- image_url — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
store
- id — INT — Primary key — NOT NULL
- region_id — INT — Foreign key → region.id — NOT NULL
- name — VARCHAR(50)
- address — VARCHAR(50)
- score — FLOAT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
terms
- id — INT — Primary key — NOT NULL
- title — VARCHAR(20)
- body — TEXT
- optional — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user
- id — INT — Primary key — NOT NULL
- name — VARCHAR(20)
- gender — VARCHAR(10)
- age — INT
- address — VARCHAR(40)
- spec_address — VARCHAR(40)
- social_type — VARCHAR(10)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- email — VARCHAR(50)
- point — INT
- birthdate — DATETIME
- phonenumber — VARCHAR(15)
user_favor_category
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- category_id — INT — Foreign key → food_category.id — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP