testing

Tables (16)

category

  • id — int — Primary key — NOT NULL
  • name_top — varchar(10) — NOT NULL
  • down_category_id — int — NOT NULL
  • down_category_name — varchar(10) — NOT NULL

comment

  • id — int — Primary key — NOT NULL
  • nick_name — varchar(255) — NOT NULL
  • contents — varchar(255) — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — timestamp(6)
  • user_id — int — Foreign key → user.id
  • feed_id — int — Foreign key → feed.id

favorite

  • id — int — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • user_id — int — Foreign key → user.id
  • address_name — varchar(30) — NOT NULL
  • road_address_name — varchar(300) — NOT NULL
  • kakao_id — varchar(20) — NOT NULL
  • category_name — varchar(300) — NOT NULL
  • phone — varchar(20) — NOT NULL
  • place_name — varchar(300) — NOT NULL
  • place_url — varchar(300) — NOT NULL

feed

  • id — int — Primary key — NOT NULL
  • title — varchar(30) — NOT NULL
  • description — varchar(300) — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • user_id — int — Foreign key → user.id
  • favorite_id — int — Foreign key → favorite.id

feed_like

  • feed_id — int — Foreign key → feed.id — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL

food

  • id — int — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • category_id — int — Foreign key → category.id

food_img

  • id — int — Primary key — NOT NULL
  • food_id — int — Foreign key → food.id

food_ingredient

  • ingredient_id — int — Foreign key → ingredient.id — NOT NULL
  • food_id — int — Foreign key → food.id — NOT NULL

food_survey

  • user_id — int — Foreign key → user.id — NOT NULL
  • food_like — int — NOT NULL
  • food_preferred — tinyint — NOT NULL
  • food_id — int — Foreign key → food.id

friendlist

  • id — int — Primary key — NOT NULL
  • receiver_user_id — varchar(255) — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • friend_id — int — Foreign key → friends.id

friends

  • id — int — Primary key — NOT NULL
  • sender — varchar(255) — NOT NULL
  • receiverEmail — varchar(255) — NOT NULL
  • status — varchar(255) — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • user_id — int — Foreign key → user.id

ingredient

  • id — int — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL

note

  • id — int — Primary key — NOT NULL
  • content — text — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL

user

  • id — int — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL
  • nick_name — varchar(10) — NOT NULL
  • password — varchar(255) — NOT NULL
  • refresh_token — varchar(255) — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • is_admin — int — NOT NULL

user_disliked_food

  • user_id — int — Foreign key → user.id — NOT NULL
  • food_id — int — Foreign key → food.id — NOT NULL

user_disliked_ingredient

  • user_id — int — Foreign key → user.id — NOT NULL
  • ingredient_id — int — Foreign key → ingredient.id — NOT NULL