Fresh Keepie

Tables (11)

Board (board)

  • id (board_id) — bigint — Primary key — NOT NULL — AI
  • 이름 (name) — varchar(15) — NOT NULL

Comment (comment)

  • 댓글id (comment_id) — bigint — Primary key — NOT NULL — AI
  • 게시글id (post_id) — bigint — Foreign key → Post.게시글id — NOT NULL — AI
  • 게시판id (board_id) — bigint — Foreign key → Post.게시판id — NOT NULL — AI
  • 사용자id (user_id) — bigint — Foreign key → User.id — NOT NULL — AI
  • 댓글내용 (content) — varchar(500) — NOT NULL
  • 날짜 (date) — timestamp — NOT NULL
  • 수정날짜 (modifiedAt) — timestamp

Content (content)

  • 게시글id (post_id) — bigint — Foreign key → Post.게시글id — NOT NULL — AI
  • 게시판id (board_id) — bigint — Foreign key → Board.id — NOT NULL — AI
  • 게시글내용 (content) — varchar(500) — NOT NULL

Fridge_Ingredient (fridge_ingredient)

  • id (fridge_ingredient_id) — bigint — Primary key — NOT NULL — AI
  • 사용자id (user_id) — bigint — Foreign key → User.id — NOT NULL — AI
  • 이름 (name) — varchar(40) — NOT NULL
  • 양 (amount) — int — NOT NULL
  • 마감 (Dday) — int — NOT NULL
  • 만료일자 (exp) — timestamp — NOT NULL

Jjim (jjim)

  • 찜id (jjim_id) — bigint — Primary key — AI
  • 사용자id (user_id) — bigint — Foreign key → User.id — NOT NULL — AI
  • 레시피id (recipe_id) — bigint — Foreign key → Recipe.id — NOT NULL — AI

Post (post)

  • 게시글id (post_id) — bigint — Primary key — NOT NULL — AI
  • 게시판id (board_id) — bigint — Foreign key → Board.id — NOT NULL — AI
  • 사용자id (user_id) — bigint — Foreign key → User.id — NOT NULL — AI
  • 제목 (title) — varchar(40) — NOT NULL
  • 날짜 (date) — timestarmp — NOT NULL
  • 수정날짜 (modifiedAt) — timestamp
  • 댓글개수 (comment_cnt) — int
  • 이미지_id (upload_image_id) — bigint — NOT NULL
  • 좋아요 (liked) — boolean
  • 스크랩 (scrap) — boolean
  • 조회수 (view) — int

Recipe (recipe)

  • id (recipe_id) — bigint — Primary key — NOT NULL — AI
  • 레시피제목 (title) — varchar(15) — NOT NULL
  • 레시피 글 (content) — varchar(500) — NOT NULL
  • 레시피사진 (upload_imgage_id) — bigint
  • 대표이미지 (image) — text — NOT NULL
  • 재료 (ingredient) — varchar(40) — NOT NULL
  • 양 (amout) — int — NOT NULL

Scrap (scrap)

  • 스크랩id (scrap_id) — bigint — Primary key — NOT NULL — AI
  • 사용자id (user_id) — bigint — Foreign key → User.id — NOT NULL — AI
  • 게시글id (post_id) — bigint — Foreign key → Post.게시글id — NOT NULL — AI
  • 게시판id (board_id) — bigint — Foreign key → Post.게시판id — NOT NULL — AI

Upload_image (upload-image)

  • 이미지id (uploadid) — bigint — Primary key — NOT NULL — AI
  • 게시글id (post_id) — bigint — Foreign key → Content.게시글id — NOT NULL — AI
  • 게시판id (board_id) — bigint — Foreign key → Content.게시판id — NOT NULL — AI
  • 기존파일 (original_filename) — varchar(255) — NOT NULL
  • 저장파일 (saved_filename) — varchar(255) — NOT NULL
  • Field

User (user)

  • id — int — Primary key — NOT NULL — AI
  • 계정 ID (realId) — user_id — NOT NULL
  • 이름 (name) — varchar(15) — NOT NULL
  • 닉네임 (nick) — varchar(40) — NOT NULL
  • 비번 (password) — varchar(15) — NOT NULL

Written (written)

  • 쓴글id (written_id) — bigint — Primary key — NOT NULL — AI
  • 사용자id (user_id) — bigint — Foreign key → User.id — NOT NULL — AI
  • 게시글id (post_id) — bigint — Foreign key → Post.게시글id — NOT NULL — AI
  • 게시판id (board_id) — bigint — Foreign key → Post.게시판id — NOT NULL — AI