main

Tables (13)

BOARD

  • id (BOARD_ID) — not null — Primary key — NOT NULL
  • member_id (MEMBER_ID) — not null — Foreign key → MEMBER.id
  • created_at (CREATED_AT) — not null
  • modified_at (MODIFIED_AT) — not null
  • content (CONTENT) — not null
  • board_image_url (IMAGE_URL)
  • board_title (Field) — not null
  • board_content (Field2) — not null

COMMENT_BOARD

  • id (Key) — not null — Primary key — NOT NULL
  • board_id (BOARD_ID) — not null — Foreign key → BOARD.id — NOT NULL
  • member_id (Field) — not null
  • comment_content (Field2) — not null
  • created_at (Field3) — not null
  • modified_at (Field4)

COMMENT_DRINKS

  • id (Key2) — not null — Primary key — NOT NULL
  • drink_id (Key) — not null — Foreign key → DRINK.id — NOT NULL
  • member_id (Field) — not null
  • comment_content (Field2) — not null,
  • created_at (Field3) — not null
  • modified_at (Field4)

DRINK (DRINKS)

  • id (Key) — not null — Primary key — NOT NULL
  • drinks_name (Field) — not null
  • drinks_code (Field2) — not null, identity
  • drinks_abv (Field4) — not null
  • tasting_note (Field3) — not null
  • drinks_image_url (Field5) — not null
  • drinks_price_rank (Field6) — not null
  • drinks_volume (Field7) — not null

IMAGE (Untitled4)

  • id (Key) — not null — Primary key — NOT NULL
  • board_id (BOARD_ID) — not null — Foreign key → BOARD.id — NOT NULL
  • file_name (Field) — not null
  • img_url (Field2) — not null,

LIKE_BOARD

  • id (LIKE_BOARD_ID) — not null — Primary key — NOT NULL
  • board_id (BOARD_ID) — not null — Foreign key → BOARD.id — NOT NULL
  • member_id (MEMBER_ID) — not null — Foreign key → BOARD.member_id

LIKE_DRINKS

  • id (Key2) — not null — Primary key — NOT NULL
  • drink_id (Key) — not null — Foreign key → DRINK.id — NOT NULL
  • member_id (Field) — not null

MEMBER

  • id (MEMBER_ID) — not null — Primary key
  • email (VARCHAR) — not null, identity
  • display_name (DISPLAY_NAME) — not null
  • phone_number (PHONE_NUMBER)
  • about_me (ABOUT_ME)
  • profile_picture_url (PROFILE_PICTURE)
  • oauth_type (Field) — not null

SNACK

  • id (Key) — not null — Primary key — NOT NULL
  • snack_kcal (Field)
  • snack_info (Field2)
  • snack_image_url (Field3)
  • snack_name (Field4) — not null, identity

SNACK_DRINKS (Untitled3)

  • id (Key3) — not null — Primary key — NOT NULL
  • drink_id (Key) — not null — Foreign key → DRINK.id — NOT NULL
  • snack_id (Key2) — not null — Foreign key → SNACK.id — NOT NULL

TAG

  • id (Key) — not null — Primary key — NOT NULL
  • tag_name (Field) — not null, identity
  • tag_info (Field2) — not null

TAG_BOARD (Untitled2)

  • id (Key2) — not null — Primary key — NOT NULL
  • tag_id (Key) — not null — Foreign key → TAG.id — NOT NULL
  • board_id (BOARD_ID) — not null — Foreign key → BOARD.id — NOT NULL

TAG_DRINKS (Untitled)

  • id (Key3) — not null — Primary key — NOT NULL
  • tag_id (Key) — not null — Foreign key → TAG.id — NOT NULL
  • drink_id (Key2) — not null — Foreign key → DRINK.id — NOT NULL