점메추저메추
테이블 (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