UMC01
Tables (8)
Signup (Untitled3)
- user_id (Key) — int — Primary key — NOT NULL
- user_name (Field) — char
- gender (Field2) — char
- birth_date (Field3) — int
- e_address (Field4) — int
- user_id (Key2) — int — Foreign key → login.user_id — NOT NULL
favorite_food_type (Untitled4)
- user_id (Key) — int — Primary key — NOT NULL
- food_id (Field) — int
- Japan_food (Field2) — char
- korea_food (Field3) — char
- china_food (Field4) — char
- chicken (Field5) — char
- desert (Field6) — char
- user_id (Key2) — int — Foreign key → Signup.user_id — NOT NULL
login (Untitled)
- user_id (Key) — int — Primary key — NOT NULL
- User_name (Field) — char
- social_id (Field2) — int
- account-date (Field3) — int
login_type (Untitled2)
- User_id (Key) — int — Primary key — NOT NULL
- kakao_id (Field) — char
- naver_id (Field3) — char
- apple_id (Field2) — char
- google_id (Field4) — char
- user_id (Key2) — int — Foreign key → login.user_id — NOT NULL
mission_home (Untitled7)
- mission_id (Key) — int — Primary key — NOT NULL
- mission_title (Field2) — char
- mission_detail (Field) — char
- mission_goal_count (Field3) — int
- user_id (Key2) — int — Foreign key → Signup.user_id — NOT NULL
notice (Untitled9)
- user_id (Key) — int — Primary key — NOT NULL
- notice_detail (Field) — char
- date (Field2) — int
- read (Field3) — int
- user_id (Key2) — int — Foreign key → Signup.user_id — NOT NULL
user_home (Untitled6)
- user_id (Key) — int — Primary key — NOT NULL
- user_name (Field2) — char
- region (Field) — char
- point (Field3) — int
- user_id (Key2) — int — Foreign key → Signup.user_id — NOT NULL
user_mission_home (Untitled8)
- user_id (Key) — int — Primary key — NOT NULL
- mission_id (Field2) — int
- achive_count (Field) — int
- state (Field3) — int
- mission_id (Key2) — int — Foreign key → mission_home.mission_id — NOT NULL