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