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