beerlot_erd

테이블 (10)

Beer Categories (category)

  • Key (id) — long — 기본 키 — NOT NULL
  • Parent Category (parent_id) — long — 외래 키 → Beer Categories.Key — NOT NULL

Beer Categories (category_international)

  • Key (language) — 기본 키 — NOT NULL
  • Parent Category (category_id) — long — 외래 키 → Beer Categories.Key — NOT NULL
  • Category name (name) — varchar(255) — NOT NULL
  • Description (description) — Mediumtext

Beer Favorites (Beer_Favorites)

  • User ID (user_id) — long — 외래 키 → 회원.Key — NOT NULL
  • Beer ID (beer_id) — long — 외래 키 → Beer_Core.Key — NOT NULL

Beer Localization KR (beer_localization)

  • Key (language) — 기본 키 — NOT NULL
  • beer_core_id (beer_id) — long — 외래 키 → Beer_Core.Key — NOT NULL
  • Beer Name (name) — varchar(255) — NOT NULL
  • Description (description) — Mediumtext — NOT NULL
  • (origin_city)
  • Field (origin_country)
  • Field

Beer Reviews (Beer_Reviews)

  • Key (id) — long — 기본 키 — NOT NULL
  • Text (content) — Mediumtext
  • Rate (rate) — int — NOT NULL
  • Created Date & Time (created_at) — NOT NULL
  • Beer ID (beer_id) — long — 외래 키 → Beer_Core.Key — NOT NULL
  • User_ID (user_id) — long — 외래 키 → 회원.Key — NOT NULL

Beer_Core (beer)

  • Key (id) — long — 기본 키 — NOT NULL
  • Alcohol Volume (volume) — float — NOT NULL
  • Rate (rate) — float — NOT NULL
  • Image URL (image_url)
  • Beer Category ID (category_id) — long — 외래 키 → Beer Categories.Key — NOT NULL

Review Images (Beer_Review_Images)

  • Key (id) — long — 기본 키 — NOT NULL
  • Beer Review Image URL (image_url) — varchar(255) — NOT NULL
  • Beer Review ID (review_id) — long — 외래 키 → Beer Reviews.Key — NOT NULL

member_oauth

  • Key (member_id) — long — 외래 키 → 회원.Key — NOT NULL
  • oauth_id
  • provider
  • roles

refresh_token

  • Key (member_id) — long — 외래 키 → member_oauth.Key — NOT NULL
  • Field

회원 (member)

  • Key (id) — long — 기본 키 — NOT NULL
  • E-Mail (email) — varchar(255) — NOT NULL
  • Username (username) — varchar(45) — NOT NULL
  • User Profile Image URL (image_url) — varchar(255)
  • status_message