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