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