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