UMC_WEEK1

Tables (13)

AREAS

  • area_Index — INT — Primary key — NOT NULL
  • area_MissionCount — INT

FOOD_TYPES

  • food_index — INT — Primary key — NOT NULL
  • food_type — VARCHAR(100)

INQUIRYS (Untitled3)

  • inquiry_Index — INT — Primary key — NOT NULL
  • user_Index — INT — Foreign key → USERS.user_Index — NOT NULL
  • inquiry_Contents — Text
  • inquiry_TItle (inquiry_Title) — VARCHAR(30)
  • inquiry_CreatedAt — TIMESTAMP
  • inquiry_Status — TINYINT(10)
  • inquiry_Type — VARCHAR(30)

INQUIRYS_IMAGE (Untitled4)

  • inquiryImage_index (Key) — INT — Primary key — NOT NULL
  • inquiryImage_url (Field) — varchar(22)
  • inquiry_Index — INT — Foreign key → INQUIRYS.inquiry_Index — NOT NULL
  • inquiryImage_CreatedAt (Field2) — TIMESTAMP

MISSIONS

  • mission_Index — INT — Primary key — NOT NULL
  • mission_Contents — VARCHAR(100)
  • store_Index — INT — Foreign key → STORES.store_Index — NOT NULL
  • area_index — INT — Foreign key → AREAS.area_Index — NOT NULL
  • mission_Point — INT

POINTS (Untitled2)

  • point_index (point_Index) — INT — Primary key — NOT NULL
  • user_Index — INT — Foreign key → USERS.user_Index — NOT NULL
  • potin_log (point_Log) — INT
  • point_UpdatedAt — TIMESTAMP

REVIEWS

  • review_Index — INT — Primary key — NOT NULL
  • review_Contents — VARCHAR(300)
  • review_CreatedDay — TIMESTAMP
  • review_Stars — INT
  • store_Index — INT — Foreign key → STORES.store_Index — NOT NULL
  • user_Index — INT — Foreign key → USERS.user_Index — NOT NULL

STORES

  • store_Index — INT — Primary key — NOT NULL — auto increases
  • store_Name — VARCHAR(100)
  • store_Location — VARCHAR(100)
  • area_Index — INT — Foreign key → AREAS.area_Index — NOT NULL

STORE_FOOD_TYPE

  • store_Index — INT — Foreign key → STORES.store_Index — NOT NULL
  • food_index — INT — Foreign key → FOOD_TYPES.food_index — NOT NULL

USERS

  • user_Index — INT — Primary key — NOT NULL
  • user_Name — VARCHAR(100)
  • user_Id — VARCHAR(100) — NOT NULL
  • user_Password — VARCHAR(100) — NOT NULL
  • user_Email — VARCHAR(100)
  • user_Birth — DATETIME
  • user_Address — VARCHAR(100)
  • user_Gender — SHORTINT

USER_AREA

  • user_Index — INT — Foreign key → USERS.user_Index — NOT NULL
  • area_Index — INT — Foreign key → AREAS.area_Index — NOT NULL

USER_MISSION (Untitled)

  • user_Index — INT — Foreign key → USERS.user_Index — NOT NULL
  • mission_Index — INT — Foreign key → MISSIONS.mission_Index — NOT NULL
  • mission_status — tinyint(10)

USER_PREFER_FOOD_TYPE

  • user_Index — INT — Foreign key → USERS.user_Index — NOT NULL
  • food_index — INT — Foreign key → FOOD_TYPES.food_index — NOT NULL