Zero

Tables (6)

Comment (댓글)

  • comment_id (댓글 id) — LONG — Primary key — NOT NULL
  • review_id (리뷰아이디) — LONG — Foreign key → Review.review_id — NOT NULL
  • user_id (유저 아이디) — LONG — Foreign key → Review.user_id — NOT NULL
  • tag_id (태그 id) — LONG — Foreign key → Review.tag_id — NOT NULL
  • comment (댓글 내용) — VARCHAR(255)

Image (이미지)

  • photo_id (사진 id) — LONG — Primary key — NOT NULL
  • review_id (리뷰아이디) — LONG — Foreign key → Review.review_id — NOT NULL
  • user_id (유저 아이디) — LONG — Foreign key → Review.user_id — NOT NULL
  • tag_id (태그 id) — LONG — Foreign key → Review.tag_id — NOT NULL

MyPage (마이페이지)

  • mypage_id (마이페이지 아이디) — LONG — Primary key — NOT NULL
  • id (유저 아이디) — LONG — Foreign key → User.user_id — NOT NULL
  • role (등급) — ROLE
  • point (포인트) — int
  • nickname (닉네임) — VARCHAR(255)

Review (리뷰)

  • review_id (리뷰아이디) — LONG — Primary key — NOT NULL
  • user_id (유저 아이디) — LONG — Foreign key → User.user_id — NOT NULL
  • tag_id (태그 id) — LONG — Foreign key → Tag.tag_id — NOT NULL
  • title (제목) — VARCHAR(255) — NOT NULL
  • contents (내용) — VARCHAR(255) — NOT NULL
  • store (가게이름) — VARCHAR(255) — NOT NULL
  • createdDate (작성일자) — LocalDate — NOT NULL
  • updatedDate (수정일자) — LocalDate
  • good (좋아요 개수) — int
  • volume (다회용기의 크기(부피)) — int

Tag (태그)

  • tag_id (태그 id) — Primary key — NOT NULL
  • name (태그명) — VARCHAR(255)

User (유저)

  • user_id (유저 아이디) — LONG — Primary key — NOT NULL
  • Field
  • Field2