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