beer
Tables (19)
AromaHashTag (맥주향)
- aroma_hash_tag_id (Key) — Long — Primary key — NOT NULL
- aroma (Field) — String
Beer
- beer_id (Key) — Long — Primary key — NOT NULL
- beer_type_id (Key2) — Long — Foreign key → BeerType.beer_type_id — NOT NULL
- name (Unique) — String
- content (Field2) — String
- volumn (Field) — Double
- english_name (Field3) — String
BeerHasAromaHashTag (Beer - AromaHashTag)
- beer_id (Key) — Long — Foreign key → Beer.beer_id — NOT NULL
- aroma_hash_tag_id (Key2) — String — Foreign key → AromaHashTag.aroma_hash_tag_id — NOT NULL
BeerHasFlavorHashTag (Beer - FlavorHashTag)
- beer_id (Key) — Long — Foreign key → Beer.beer_id — NOT NULL
- flavor_hash_tag_id (Key2) — Long — Foreign key → FlavorHashTag.flavor_hash_tag_id — NOT NULL
BeerType (맥주 타입)
- beer_type_id (Key) — Long — Primary key — NOT NULL
- en_main (Field) — String
- en_detail (Field2) — String
- ko_main (Field3) — String
- ko_detail (Field4) — String
Comment
- commment_id (Key) — Primary key
- member_id (FK1) — Long — Foreign key → Member.member_id — NOT NULL
- post_id (FK2) — Long — Foreign key → Post.post_id — NOT NULL
- created_at (Field) — Date — NOT NULL
- content (Field3) — String
FlavorHashTag (맥주맛)
- flavor_hash_tag_id (Key) — Long — Primary key — NOT NULL
- flavor (Field) — String
Follow
- follow_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
- following_id (Key) — Long — Foreign key → Member.member_id — NOT NULL
Member
- member_id (Key) — Long — Primary key — NOT NULL
- nickname (Field) — String
- name (Field2) — String
- status (Field3) — String
- age (Field4) — int
- grade (Field6) — int
MemberFondAromaHashTag (Member - AromaHashTag)
- member_id (Key) — Long — Foreign key → Member.member_id — NOT NULL
- aroma_hash_tag_id (Key2) — Long — Foreign key → AromaHashTag.aroma_hash_tag_id — NOT NULL
MemberFondFlavorHashTag (Member - FlavorHashTag)
- member_id (Key) — Long — Foreign key → Member.member_id — NOT NULL
- flavor_hashtag_id (Key2) — Long — Foreign key → FlavorHashTag.flavor_hash_tag_id — NOT NULL
MemberLikeBeer (Member - Beer2)
- member_id (Key) — Long — Foreign key → Member.member_id — NOT NULL
- beer_id (Key2) — Long — Foreign key → Beer.beer_id — NOT NULL
MemberLikePost (Member - Post)
- member_id (Key) — Long — Foreign key → Member.member_id — NOT NULL
- post_id (PK) — Long — Foreign key → Post.post_id — NOT NULL
MemberRateBeer (Member - Beer1)
- member_rate_beer_id (Key3) — Long — Primary key — NOT NULL
- beer_id (Key) — Long — Foreign key → Beer.beer_id — NOT NULL
- member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
- rate (Field) — int
Photo (사진)
- photo_id (Key) — Long — Primary key — NOT NULL
- post_id (Key2) — Long — Foreign key → Post.post_id — NOT NULL
- data (Unique) — String
Post (게시글)
- post_id (PK) — Long — Primary key — NOT NULL
- beer_id (FK1) — Long — Foreign key → Beer.beer_id — NOT NULL
- member_id (FK2) — Long — Foreign key → Member.member_id — NOT NULL
- content (Field) — String
- created_at (Field2) — Date
- updated_at (Field3) — Date
- is_deleted (Field4) — Boolean
RateHasAromaHashTag (Rate - AromaHashTag)
- aroma_hash_tag_id (Key) — Long — Foreign key → AromaHashTag.aroma_hash_tag_id — NOT NULL
- rate_id (Key3) — Long — Foreign key — NOT NULL
RateHasFlavorHashTag (Rate - FlavorHashTag)
- flavor_hash_tag_id (Key) — Long — Foreign key → FlavorHashTag.flavor_hash_tag_id — NOT NULL
- rate_id (Key3) — Long — Foreign key — NOT NULL
UserHashTag (게시판 태그)
- user_hash_tag_id (Key) — Long — Primary key — NOT NULL
- post_id (PK) — Long — Foreign key → Post.post_id — NOT NULL
- content (Field) — String
- updated_at (Field2) — Date
- is_deleted (Field3) — Boolean