Zu-Story

Tables (11)

beverage

  • beverage_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → category.category_id — NOT NULL
  • beverage_name — VARCHAR — NOT NULL
  • company — VARCHAR — NOT NULL
  • abv — FLOAT — NOT NULL
  • contents — VARCHAR
  • img_url — VARCHAR
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL
  • created_by — VARCHAR — NOT NULL
  • modified_by — VARCHAR — NOT NULL

board

  • board_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • category_id — BIGINT — Foreign key → category.category_id — NOT NULL
  • title — VARCHAR — NOT NULL
  • contents — VARCHAR — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL
  • created_by — VARCHAR — NOT NULL
  • modified_by — VARCHAR — NOT NULL
  • views — INT
  • Field

board_heart

  • board_heart_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • board_id — BIGINT — Foreign key → board.board_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL
  • created_by — VARCHAR — NOT NULL
  • modified_by — VARCHAR — NOT NULL

board_img

  • board_img_id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → board.board_id — NOT NULL
  • img_url — VARCHAR — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL
  • created_by — VARCHAR — NOT NULL
  • modified_by — VARCHAR — NOT NULL

category

  • category_id — BIGINT — Primary key — NOT NULL
  • type — VARCHAR — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL
  • created_by — VARCHAR — NOT NULL
  • modified_by — VARCHAR — NOT NULL

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → board.board_id — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • contents — VARCHAR — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL
  • created_by — VARCHAR — NOT NULL
  • modified_by — VARCHAR — NOT NULL

comment_heart

  • comment_heart_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • comment_id — BIGINT — Foreign key → comment.comment_id — NOT NULL
  • board_id — BIGINT — Foreign key → comment.board_id — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → comment.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL
  • created_by — VARCHAR — NOT NULL
  • modified_by — VARCHAR — NOT NULL

re_comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • comment_id (comment_id2) — BIGINT — Foreign key → comment.comment_id — NOT NULL
  • board_id — BIGINT — Foreign key → comment.board_id — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → comment.user_id — NOT NULL
  • contents — VARCHAR — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL
  • created_by — VARCHAR — NOT NULL
  • modified_by — VARCHAR — NOT NULL

review

  • review_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • beverage_id — BIGINT — Foreign key → beverage.beverage_id — NOT NULL
  • title — VARCHAR — NOT NULL
  • contents — VARCHAR — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL
  • created_by — VARCHAR — NOT NULL
  • modified_by — VARCHAR — NOT NULL

review_img (CopyOfboard_img)

  • user_id — BIGINT — Primary key — NOT NULL
  • review_id — BIGINT — Foreign key → review.review_id — NOT NULL
  • img_url — VARCHAR — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL
  • created_by — VARCHAR — NOT NULL
  • modified_by — VARCHAR — NOT NULL

user

  • user_id — BIGINT — Primary key — NOT NULL
  • login_id — VARCHAR — NOT NULL
  • user_name — VARCHAR — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL
  • created_by — VARCHAR — NOT NULL
  • modified_by — VARCHAR — NOT NULL