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