점메추저메추

테이블 (17)

Board_Like (게시글좋아요)

  • user_id (id) — int
  • board_id — int

Board_img (보드이미지)

  • board_img_id — int — 기본 키 — NOT NULL
  • user_id (id2) — int
  • created_at — timestamp
  • deleted_at — datetime
  • updated_at — timestamp

Category (카테고리)

  • category_id (Key) — int — 기본 키 — NOT NULL
  • name_top — boolean
  • top_category_id (Field2) — int
  • down_category_name (Field) — varchar
  • created_at — timestamp
  • updated_at — timestamp

Comment (댓글)

  • comment_id — int — 기본 키 — NOT NULL
  • feed_id — int — 외래 키 → Feed.feed_id — NOT NULL
  • user_id — int — 외래 키 → User.user_id — NOT NULL
  • comment — varchar(300)
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — datetime

Favorate (찜하기)

  • favorate_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → User.user_id — NOT NULL
  • store_name — varchar
  • store_address — varchar
  • store_business_hours — int
  • store_contact — int
  • store_keyword — varchar
  • store_img (Field) — varchar

Feed (피드)

  • feed_id — int — 기본 키 — NOT NULL
  • basket_id — int — 외래 키 → Favorate.favorate_id — NOT NULL
  • user_id (id2) — int — 외래 키 → User.user_id — NOT NULL
  • title — varchar(300)
  • description — varchar(300)
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — datetime

Feed_like (피드 좋아요)

  • user_id — int — 외래 키 → User.user_id — NOT NULL
  • feed_id — int — 외래 키 → Feed.feed_id — NOT NULL

Food_Like (음식좋아요)

  • food_like_id — int — 기본 키 — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

Food_category (취향 선호 음식)

  • Field

Friend (친구)

  • friend_id (친구id) — int — 기본 키 — NOT NULL
  • friend_name (친구이름) — varchar(64)
  • Field2
  • Field3

Menu (메뉴)

  • menu_id — int — 기본 키 — NOT NULL
  • category_id (Key) — int — 외래 키 → Category.category_id — NOT NULL
  • name — int
  • ingrediant — varchar
  • created_at — datetime
  • updated_at — timestamp

Menu_img (메뉴 이미지)

  • menu_img_id — int — 기본 키 — NOT NULL
  • menu_id — int — 외래 키 → Menu.menu_id — NOT NULL
  • category_id (Key) — int — 외래 키 → Menu.category_id — NOT NULL
  • created_at — datetime
  • updated_at — timestamp

Menu_like (메뉴선호도정보)

  • user_id — int — 외래 키 → User.user_id — NOT NULL
  • menu_id — int — 외래 키 → Menu.menu_id — NOT NULL
  • preference (선호도) — int

Note (쪽지)

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

Store (추천상점)

  • store_id — int — 기본 키 — NOT NULL
  • name — varchar(128)
  • is_selected (Field) — int
  • created_at — timestamp
  • updated_at — timestamp

User (회원정보)

  • user_id (id) — int — 기본 키 — NOT NULL
  • email — varchar(64)
  • is_admin — boolean
  • nick_name — varchar(16)
  • password — varchar(300)
  • refresh_token — varchar(300)
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — datetime

advertisement (광고)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2