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