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