푸드핏

테이블 (5)

auth_local (일반 회원가입)

  • user_name (ID) — varchar(64) — 기본 키 — NOT NULL
  • user_no (회원번호) — unsigned int
  • user_passwd (PW) — varchar(128)
  • update_data (변경일자) — datetime
  • user_email (email) — varchar(25)

auth_social (소셜 회원가입)

  • social_login_id (식별자) — unsigned int — 기본 키 — NOT NULL
  • social_code (1:구글,2:카카오) — unsigned int
  • user_no (회원번호) — unsigned int
  • access_token (인증값)
  • update_date (변경일자) — datetime
  • user_email (email) — varchar(25)

member_profile (Untitled)

  • Field
  • Field2
  • Field3
  • Field4
  • Field5

member_today_nut (Untitled2)

    member_user (유저 정보)

    • user_no (회원번호) — unsigned int — 기본 키
    • user_name (ID) — varchar(64)
    • login_type (1:일반, 2:소셜) — unsigned int
    • user_email (email) — varchar(25)