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