Pocket - ERD
Tables (6)
Like (찜한포토부스)
- like_id (찜ID) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → User.user_id — NOT NULL
- photobooth_id (포토부스ID) — BIGINT — Foreign key → PhotoBooth.photobooth_id
Photo (사진)
- photo_id (사진ID) — BIGINT — Primary key
- user_id (사용자ID) — BIGINT — Foreign key → User.user_id — NOT NULL
- photobooth_id (포토부스ID) — BIGINT — Foreign key → PhotoBooth.photobooth_id
- imageUrl (포토이미지주소) — VARCHAR
- photoDate (촬영날짜) — VARCHAR
- record (포토기록) — VARCHAR
- favorite (즐겨찾기) — BOOLEAN
PhotoBooth (포토부스)
- photobooth_id (포토부스ID) — BIGINT — Primary key
- name (포토부스 이름) — VARCHAR
- location (주소) — VARCHAR
- brand (브랜드) — ENUM
Review (리뷰)
- review_id (리뷰ID) — BIGINT — Primary key
- user_id (사용자ID) — BIGINT — Foreign key → User.user_id — NOT NULL
- photobooth_id (포토부스ID) — BIGINT — Foreign key → PhotoBooth.photobooth_id
- rating (별점) — INT
- content (리뷰내용) — VARCHAR
- booth_summary (리뷰요약(부스)) — ENUM
- photo_summary (리뷰요약(사진)) — ENUM
ReviewImage (리뷰사진)
- reviewimage_id (리뷰이미지ID) — BIGINT — Primary key
- review_id (리뷰ID) — BIGINT — Foreign key → Review.review_id
- imageUrl (리뷰이미지주소) — VARCHAR
User (사용자)
- user_id (사용자ID) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR
- email (이메일) — VARCHAR
- nickname (닉네임) — VARCHAR
- password (비밀번호) — VARCHAR