UMC ERD

Tables (9)

Favorite (선호음식)

  • id (favorite_id) — int — Primary key — NOT NULL
  • id (user_id) — bigint — Foreign key → User.id — NOT NULL
  • food (좋아하는 음식) — Enum

Inquiry (문의)

  • id (inquiry_id) — bigint — Primary key — NOT NULL
  • title (제목) — varchar(256)
  • content (내용) — varchar(256)
  • id (user_id) — bigint — Foreign key → User.id — NOT NULL

InquiryImg (문의사진)

  • id (inquiry_id) — bigint — Foreign key → Inquiry.id — NOT NULL
  • image_url (이미지) — varchar(256)

Mission (미션)

  • id (mission_id) — bigint — Primary key — NOT NULL
  • content (미션내용) — varchar(256)
  • benefit (보상) — int
  • statement (성공유무) — tinyint
  • id (store_id) — bigint — Foreign key → Store.id — NOT NULL
  • id (user_id) — bigint — Foreign key → User.id — NOT NULL
  • started_At (시작일시)

Notice (알람)

  • id (notice_id) — bigint — Primary key — NOT NULL
  • content (알람내용) — varchar(256)
  • Field
  • id (user_id) — bigint — Foreign key → User.id — NOT NULL

Review (리뷰)

  • id (review_id) — bigint — Primary key — NOT NULL
  • id (store_id) — bigint — Foreign key → Store.id — NOT NULL
  • content (리뷰내용) — varchar(256)
  • id (user_id) — bigint — Foreign key → User.id — NOT NULL
  • score (평점) — float

ReviewImg (리뷰이미지)

  • id (image_id) — bigint — Primary key — NOT NULL
  • id (review_id) — bigint — Foreign key → Review.id — NOT NULL
  • image (imageUrl) — varchar(256)

Store (가게)

  • id (store_id) — bigint — Primary key — NOT NULL
  • name (store_name) — varchar(256)
  • address (주소) — varchar(256

User (사용자)

  • id (user_id) — bigint — Primary key — NOT NULL
  • name (이름) — varchar(6)
  • gendeer (성별) — varchar(4)
  • birth (생년월일) — datetime
  • address (주소) — varchar(256)
  • email (이메일) — varchar(256)
  • point (포인트) — bigint
  • noticeStatement (알람수신상태) — boolean