에푸메'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