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)