점메추저메추

테이블 (16)

category (카테고리)

  • id (Key) — int — 기본 키 — NOT NULL
  • category_name — varchar
  • top_category_id — int

comment (댓글)

  • id (comment_id) — int — 기본 키 — NOT NULL
  • feed_id — int — 외래 키 → feed.id — NOT NULL
  • user_id (Key2) — 외래 키 → user.id — NOT NULL
  • id (Key22) — 외래 키 → feed.user_id — NOT NULL
  • contents — varchar
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

favorite (찜하기)

  • id (Key) — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → user.id — NOT NULL
  • kakao_id — int
  • place_name — varchar
  • store_address — varchar
  • category_name — varchar
  • phone — int
  • store_keyword — varchar
  • place_url — varchar
  • created_at — timestamp
  • deleted_at — timestamp

feed (피드)

  • id (Key) — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → user.id — NOT NULL
  • title — varchar
  • description — varchar
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp
  • deleted_at (Field5) — timestamp

feed_favorite (피드-찜하기)

  • feed_id — int — 외래 키 → feed.id — NOT NULL
  • favorite_id — int — 외래 키 → favorite.id — NOT NULL

feed_img (피드 이미지)

  • id — int — 기본 키 — NOT NULL
  • feed_id — int — 외래 키 → feed.id — NOT NULL

feed_like (피드 좋아요)

  • user_id — int — 외래 키 — NOT NULL
  • feed_id — int — 외래 키 → feed.id — NOT NULL

food (음식)

  • id (food_id) — int — 기본 키 — NOT NULL
  • category_id (Key) — int — 외래 키 → category.id — NOT NULL
  • food_name — varchar
  • food_img (null_able) — varchar

food_Ingredient (음식 재료)

  • food_id — int — 외래 키 → food.id — NOT NULL
  • ingredient_id — int — 외래 키 → ingredient.id — NOT NULL

food_img (음식 이미지)

  • id (food_img_id) — int — 기본 키 — NOT NULL

friend_list (친구 목록)

  • id — int — 기본 키 — NOT NULL
  • receiver_user_id — int
  • createdAt — timestamp

friend_req (친구 요청)

  • id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 — NOT NULL
  • receiver_id — int
  • status — varchar
  • createdAt — timestamp

ingredient (재료)

  • id (Key) — 기본 키 — NOT NULL
  • ingredient_name — varchar

note (쪽지)

  • id (Key) — int — 기본 키 — NOT NULL
  • note_message (채팅메시지)
  • FieId2 (Field2)

user (회원정보)

  • id (Key2) — 기본 키 — NOT NULL
  • email (Field) — varchar
  • is_admin (Field2) — boolean
  • nick_name (Field3) — varchar
  • password (Field4) — varchar
  • refresh_token (Field5) — varchar
  • created_at (Field6) — timestamp
  • updated_at (Field7) — timestamp
  • deleted_at (Field8) — timestamp

user_action (유저 행동)

  • id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 — NOT NULL
  • food_id — int — 외래 키 → food.id — NOT NULL
  • ingredient_id — int — 외래 키 → ingredient.id — NOT NULL
  • type — varchar
  • weight — int
  • created_at — timestamp