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