TheMightiest-kpk
Tables (11)
ALL_GROCERY (전체식료품)
- id (autoincrement) — int — Primary key — NOT NULL
- name (재료이름) — varchar
ALL_RECIPE (전체레시피)
- id (autoincreasement) — int — Primary key — NOT NULL
- name (요리이름) — varchar
- ingredient (재료종류들) — varchar
- ingredient_name (재료종류이름) — varchar
- seasoning (소스) — varchar
- howto (방법) — varchar
- purpose (목적(지병/다이어트)) — varchar
- views (조회수) — int
- img (이미지url) — varchar
- recipe_num (레세피번호) — int
Alarm (알림)
- id (autoincreament) — int — Primary key — NOT NULL
- email (사용자id) — varchar — Foreign key → USER_INFO.email — NOT NULL
- all_grocery_id (식료퓸id) — int — Foreign key → ALL_GROCERY.id — NOT NULL
- count (몇개일때 알림받을지) — int
FOLLOW (팔로우(친구))
- id (autoincresement) — int — Primary key — NOT NULL
- email (사용자id) — varchar — Foreign key → USER_INFO.email — NOT NULL
- following_user_email (팔로우한 상대 이메일) — varchar
- read (내가 상대 사진읽음) — boolean
NOW_GROCERY (현재냉장고식료품)
- id (autoincrement) — int — Primary key — NOT NULL
- email (사용자id) — varchar — Foreign key → USER_INFO.email — NOT NULL
- all_grocery_id (식료품id) — int
- name (재료이름) — varchar
- count (갯수) — int
- reg_date (날짜+시간) — datetime
- gubun (구분(이미지/직접입력)) — int
- cordinate (좌표값) — str
NOW_RECIPE (현재 레시피)
- id (autoincrement) — int — Primary key — NOT NULL
- email (사용자id) — varchar — Foreign key → USER_INFO.email — NOT NULL
- all_recipe_id (레시피 번호) — int
- name (요리이름) — varchar
- ingredient (재료종류들) — varchar
- ingredient_name (재료종류이름) — varchar
- seasoning (소스) — varchar
- seasoning_name (소스이름) — varchar
- howto (방법) — varchar
- purpose (목적(지병/다이어트)) — varchar
- views (조회수) — int
- img (이미지url) — varchar
- recipe_num (레시피번호) — int
PHOTO (사진)
- id (autoincrement) — int — Primary key — NOT NULL
- email (사용자id) — varchar — Foreign key → USER_INFO.email — NOT NULL
- file_name (파일명(냉장고 번호)) — varchar
- url (이미지url) — varchar
- reg_date (날짜+시간) — datetime
RECIPE_FAVORITE (레시피즐겨찾기)
- id (autoincrement) — int — Primary key — NOT NULL
- email (사용자id) — varchar — Foreign key → USER_INFO.email — NOT NULL
- all_recipe_id (레시피번호) — int — Foreign key → NOW_RECIPE.id — NOT NULL
REFRIGERATOR (냉장고자체정보)
- refri_unique_number (냉장고고유번호) — varchar — Primary key — NOT NULL
- email (사용자id) — varchar — Foreign key → USER_INFO.email — NOT NULL
- manufactor_date (제조일자) — date
- motion_sensor_on_off (모션센서on/off여부) — int
- motion_period (모션알림 설정 기간) — int
SENSOR (센서)
- id (autoincrement) — int — Primary key — NOT NULL
- email (사용자id) — varchar — Foreign key → USER_INFO.email — NOT NULL
- name (센서이름) — varchar
- value (값) — int
- reg_date (날짜+시간) — datetime
USER_INFO (사용자정보)
- email (이메일) — varchar — Primary key — NOT NULL
- age (나이) — int
- sex (성별(1or2)) — int
- phonenumber (사용자 핸드폰 번호) — varchar
- username (사용자이름) — varchar
- password (비밀번호) — varchar
- guardian_name (보호자이름) — varchar
- guardian_phonenumber (보호자번호) — varchar
- purpose (목적) — varchar
- img_url (프로필사진) — varchar