에푸메's
테이블 (12)
Board (Untitled2)
- id (Key) — UUID — 기본 키 — NOT NULL
- writer (Key2) — UUID — 외래 키 → Member.id — NOT NULL
- title (Field2) — String — NOT NULL
- content (Field3) — String — NOT NULL
- hit_count (Field4) — int — NOT NULL — 조회수
- heart_count (Field5) — 좋아요수
- comment_count (Field6) — int — NOT NULL — 댓글수
- updated_at (Field7) — DATETIME — NOT NULL
- deleted_at (Field8) — DATETIME
- deleted_at (Field9) — DATETIME
BoardComment (Untitled8)
- id (Key3) — UUID — 기본 키 — NOT NULL
- board (Key) — UUID — 외래 키 → Board.id — NOT NULL
- writer (Key2) — UUID — 외래 키 → Member.id — NOT NULL
- content (Field) — String — NOT NULL
BoardFile (Untitled9)
- id (Key) — UUID — 기본 키 — NOT NULL
- board (Key2) — UUID — 외래 키 → Board.id — NOT NULL
BoardHeart (Untitled7)
- id (Key2) — UUID — 기본 키 — NOT NULL
- board (Key) — UUID — 외래 키 → Board.id — NOT NULL
- member (Key3) — UUID — 외래 키 → Member.id — NOT NULL
- is_checked (Field) — BooleanN — NOT NULL
CarbonFootprint (Untitled11)
- id (Key) — UUID — 기본 키 — NOT NULL
- ingredient (Key2) — UUID — 외래 키 → Ingredient.id — NOT NULL
- size (Field) — int — NOT NULL
Ingredient (Untitled4)
- id (Key) — UUID — 기본 키 — NOT NULL
- member (Key2) — UUID — 외래 키 → Member.id — NOT NULL
- name (Field) — string — NOT NULL
- price (Field7) — int
- count (Field8) — int
- purchase_date (Field2) — DATETIME — NOT NULL — 구매날짜
- expiration_date (Field3) — DATETIME — NOT NULL — 유통기한
- created_at (Field4) — DATETIME — NOT NULL
- updated_at (Field5) — DATETIME
- deleted_at (Field6) — DATETIME
IngredientImage (Untitled10)
- id (Key2) — UUID — 기본 키 — NOT NULL
- Ingredient (Key) — UUID — 외래 키 → Ingredient.id — NOT NULL
- url (Field) — String — NOT NULL
Member (Untitled)
- id (Key) — UUID — 기본 키 — NOT NULL
- profile_image (Field) — String — 이미지 url
- nickname (Field2) — String — NOT NULL — 별명
- social_type (Field3) — ENUM — NOT NULL — NAVER, KAKAO, GOOGLE
- milege (Field7) — int — NOT NULL — 마일리지
- created_at (Field4) — DATETIME — NOT NULL
- updated_at (Field5) — DATETIME
- deleted_at (Field6) — DATETIME
Proposal (Untitled3)
- id (Key) — UUID — 기본 키 — NOT NULL
- writer (Key2) — UUID — 외래 키 → Member.id — NOT NULL
- title (Field) — String — NOT NULL
- content (Field2) — String — NOT NULL
- created_at (Field3) — DATETIME — NOT NULL
- updated_at (Field4) — DATETIME
- deleted_at (Field5) — DATETIME
Recipe (Untitled5)
- id (Key) — UUID — 기본 키 — NOT NULL
- writer (Key2) — UUID — 외래 키 → Member.id — NOT NULL
- title (Field) — String — NOT NULL
- content (Field2) — String — NOT NULL
- ingredient (Field3) — String — NOT NULL — 레시피에 포함된 재료
- hit_count (Field7) — int — NOT NULL
- heart_count (Field8) — int — NOT NULL
- comment_count (Field9) — int — NOT NULL
- created_at (Field4) — DATETIME — NOT NULL
- updated_atD (Field5) — DATETIME
- deleted_at (Field6) — DATETIME
RecipeImage (Untitled12)
- id (Key) — UUID — 기본 키 — NOT NULL
- Recipe (Key2) — UUID — 외래 키 → Recipe.id — NOT NULL
- url (Field) — String — NOT NULL
Refrigerator (Untitled6)
- id (Key) — UUID — 기본 키 — NOT NULL
- ingredient (Key2) — UUID — 외래 키 → Ingredient.id — NOT NULL