푸드핏
테이블 (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)