UMC9th
Tables (15)
AREAS (Areas)
- area_Index — varchar(255) — Primary key — NOT NULL
- area_MissionCount (mission_count) — INT
FOOD_TYPES (Food_type)
- food_index — varchar(255) — Primary key — NOT NULL
- food_type (type) — enum('한식','양식','중식','일식')
MISSIONS (Missions)
- mission_Index — varchar(255) — Primary key — NOT NULL
- store_Index — varchar(255) — Foreign key → STORES.store_Index — NOT NULL — auto increases
- area_Index — varchar(255) — Foreign key → STORES.area_Index — NOT NULL
- mission_Contents (contents) — VARCHAR(100)
- mission_Point (point) — INT
- Field (status) — enum('pending','progress','done')
Points
- point_Index — varchar(255) — Primary key — NOT NULL
- user_Index — varchar(255) — Foreign key → USERS.user_Index — NOT NULL
- store_Index — varchar(255) — Foreign key → STORES.store_Index — NOT NULL — auto increases
- area_Index — varchar(255) — Foreign key → STORES.area_Index — NOT NULL
- mission_Index — varchar(255) — Foreign key → MISSIONS.mission_Index — NOT NULL
- point_Log (point) — INT
- point_UpdatedAt (update_at) — TIMESTAMP
REVIEWS (Reviews)
- review_Index — varchar(255) — Primary key — NOT NULL
- store_Index — varchar(255) — Foreign key → STORES.store_Index — NOT NULL — auto increases
- user_Index — varchar(255) — Foreign key → USERS.user_Index — NOT NULL
- review_Contents (contents) — VARCHAR(300)
- review_CreatedDay (create_at) — datetime
- review_Stars (stars) — INT
STORES (Stores)
- store_Index — varchar(255) — Primary key — NOT NULL — auto increases
- area_Index — varchar(255) — Foreign key → AREAS.area_Index — NOT NULL
- store_Name (name) — VARCHAR(100)
- store_Location (location) — VARCHAR(100)
- Field (lat) — varchar(100)
- Field (lng) — varchar(100)
- Field (created_at) — datetime
- Field (avg_star) — int
STORE_FOOD_TYPE (Store_food_type)
- store_Index — varchar(255) — Foreign key → STORES.store_Index — NOT NULL — auto increases
- area_Index — varchar(255) — Foreign key → STORES.area_Index — NOT NULL
- food_index — varchar(255) — Foreign key → FOOD_TYPES.food_index — NOT NULL
USERS (Users)
- user_Index — varchar(255) — Primary key — NOT NULL
- user_Name (name) — VARCHAR(100)
- user_Id (id) — VARCHAR(100) — NOT NULL
- user_Password (password) — VARCHAR(100) — NOT NULL
- user_Email (email) — VARCHAR(100)
- user_Birth (birthday) — datetime
- user_Address (address) — VARCHAR(100)
- user_Gender (gender) — tinyint(10)
- Field (point) — int
- Field (profile_url) — varchar(255)
- Field (phone) — varchar(50)
USER_AREA (User_Area)
- area_Index — varchar(255) — Foreign key → AREAS.area_Index — NOT NULL
- user_Index — varchar(255) — Foreign key → USERS.user_Index — NOT NULL
USER_PREFER_FOOD_TYPE (User_prefer_Food_type)
- food_index — varchar(255) — Foreign key → FOOD_TYPES.food_index — NOT NULL
- user_Index — varchar(255) — Foreign key → USERS.user_Index — NOT NULL
Untitled (User_Mission)
- user_Index — varchar(255) — Foreign key → USERS.user_Index — NOT NULL
- mission_Index — varchar(255) — Foreign key → MISSIONS.mission_Index — NOT NULL
- store_Index — varchar(255) — Foreign key → MISSIONS.store_Index — NOT NULL — auto increases
- area_Index — varchar(255) — Foreign key → MISSIONS.area_Index — NOT NULL
- mission_status — tinyint(10)
Untitled (Review_photo)
- Key (Review_photo_Index) — varchar(255) — Primary key — NOT NULL
- review_Index — varchar(255) — Foreign key → REVIEWS.review_Index — NOT NULL
- store_Index — varchar(255) — Foreign key → REVIEWS.store_Index — NOT NULL — auto increases
- user_Index — varchar(255) — Foreign key → REVIEWS.user_Index — NOT NULL
- Field (s3url) — varchar(255)
- Field (created_at) — datetime
Untitled (Notification)
- Key (notification_Index) — varchar(255) — Primary key — NOT NULL
- user_Index — varchar(255) — Foreign key → USERS.user_Index — NOT NULL
- Field (event) — bool
- Field (review) — bool
- Field3 (inquiry) — bool
- Field (created_at) — datetime
- Field (push_token) — varchar(255)
Untitled (Owner)
- Key (owner_Index) — varchar(255) — Primary key — NOT NULL
- user_Index — varchar(255) — Foreign key → USERS.user_Index — NOT NULL
- store_Index — varchar(255) — Foreign key → STORES.store_Index — NOT NULL — auto increases
- area_Index — varchar(255) — Foreign key → STORES.area_Index — NOT NULL
Untitled3 (Inquirys)
- inquiry_Index — varchar(255) — Primary key — NOT NULL
- user_Index — varchar(255) — Foreign key → USERS.user_Index — NOT NULL
- inquiry_Contents (contents) — Text
- inquiry_Title (title) — VARCHAR(30)
- inquiry_CreatedAt (creaete_at) — TIMESTAMP
- inquiry_Status (status) — TINYINT(10)
- inquiry_Type (type) — VARCHAR(30)