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