DB ERD

Tables (13)

badge (뱃지)

  • PK (Key) — int — Primary key — NOT NULL
  • (뱃지 타이틀) — string
  • (설명) — string
  • (조건) — string
  • (뱃지 이미지)

beer (맥주)

  • PK (Key) — int — Primary key — NOT NULL
  • (맥주명) — string
  • FK (국가명) — string — Foreign key → country.Key — NOT NULL
  • (종류) — string
  • (도수) — float
  • (맥주이미지) — string

bookmark (북마크)

  • FK (유저 id) — int — Foreign key → user.PK — NOT NULL
  • PK (맥주 id) — int — Foreign key → beer.PK — NOT NULL

country (나라)

  • Key (국가명) — string — Primary key — NOT NULL
  • (국기) — string

follow (팔로우)

  • FK (사용자 id) — int — Foreign key → user.PK — NOT NULL
  • (팔로우한 사람) — int

hash_tag (Untitled)

  • PK (key) — int(AI) — Primary key — NOT NULL
  • (태그명) — string

review (리뷰)

  • PK (Key) — int — Primary key — NOT NULL
  • FK (유저 ID) — int — Foreign key → user.PK — NOT NULL
  • FK (맥주 ID) — int — Foreign key → beer.PK — NOT NULL
  • (별점) — int

review_hash_tag (리뷰-해시태그)

  • PK (Key) — int — Foreign key → review.PK — NOT NULL
  • PK (key) — int(AI) — Foreign key → hash_tag.PK — NOT NULL
  • (맥주 ID) — int

snack_category (메인안주)

  • Key — string — Primary key — NOT NULL
  • Field — string

snack_detail (안주)

  • Key — string — Foreign key → snack_category.Key — NOT NULL
  • (안주명) — string

user (유저)

  • PK (카카오토큰) — bigint — Primary key — NOT NULL
  • (사용자 ID) — string
  • (닉네임) — string
  • (성별) — string
  • (프로필이미지) — string
  • (공유횟수) — long

user_badge (유저_뱃지)

  • PK (뱃지 id) — int — Foreign key → badge.PK — NOT NULL
  • FK (사용자 ID) — int — Foreign key → user.PK — NOT NULL
  • (취득날짜) — date

user_review (리뷰 좋아요)

  • FK (사용자 ID) — int — Foreign key → user.PK — NOT NULL
  • FK (리뷰 ID) — int — Foreign key → review.PK — NOT NULL