wine-log

테이블 (3)

user

  • id — long — 기본 키 — NOT NULL
  • 카카오id (kakako_id) — long
  • email — varchar(255)
  • 프로필 (profile_image) — varchar(255)
  • refresh (refresh_token) — varchar(255)
  • 활성사용자 (is_active) — boolean
  • 생성일 (created_at) — timestamptz
  • 수정일 (updated_at) — timestamptz

다이어리 (diary)

  • id — long — 기본 키 — NOT NULL
  • id (id2) — long — 외래 키 → user.id — NOT NULL
  • id (id3) — long — 외래 키 → 와인.id — NOT NULL
  • frontImage — varchar(255)
  • backImage — varchar(255)
  • thumbnailImage — varchar(255)
  • downloadImage — varchar(255)
  • rating — int
  • review — varchar(255)
  • price — int
  • createdAt — timestamptz
  • Field (updatedAt) — timestamptz
  • isPublic — boolean

와인 (wine)

  • id — long — 기본 키 — NOT NULL
  • name
  • Field2 (origin)
  • Field3 (grape)
  • Field4 (year)
  • Field5 (alcohol)
  • Field (type)
  • Field (aromaNote)
  • Field (tasteNote)
  • Field (finishNote)
  • Field (sweetness)
  • Field (acidity)
  • Field (tannin)
  • Field (body)