umc_1
Tables (9)
inquiry (문의)
- id (문의id) — long — Primary key — NOT NULL
- id (사용자id) — long — Foreign key → user.id — NOT NULL
- title (문의제목) — varchar(50)
- content (문의내용) — text
- type (문의유형) — enum
inquiry_img (문의사진)
- id (문의사진id) — long — Primary key — NOT NULL
- img (문의사진) — varchar(100)
- id (문의id) — long — Foreign key → inquiry.id — NOT NULL
- id (사용자id) — long — Foreign key → inquiry.id — NOT NULL
mission (미션)
- id (미션id) — long — Primary key — NOT NULL
- id (사용자id) — long — Foreign key → user.id — NOT NULL
- id (식당id) — long — Foreign key → restaurant.id — NOT NULL
- content (미션내용) — varchar(50)
- point (미션포인트) — int
- sucess (미션성공여부) — boolean
prefer_food (선호음식)
- id (선호음식 id) — long — Primary key — NOT NULL
- food (음식 종류) — enum
restaurant (식당)
- id (식당id) — long — Primary key — NOT NULL
- name (식당이름) — varchar(50)
- type (식당종류) — enum
- address (식당주소) — varchar(100)
- score (식당별점) — int
- type (식당유형) — enum
review (리뷰)
- id (리뷰id) — long — Primary key — NOT NULL
- id (사용자id) — long — Foreign key → user.id — NOT NULL
- id (식당id) — long — Foreign key → restaurant.id — NOT NULL
- content (리뷰내용) — text
- score (식당별점) — int
- created_at (리뷰작성시간) — datetime
- updated_at (리뷰수정시간) — datetime
review_img (리뷰사진)
- id (리뷰사진id) — long — Primary key — NOT NULL
- jpg (사진) — varchar(100)
- id (리뷰id) — long — Foreign key → review.id — NOT NULL
- id (사용자id) — long — Foreign key → review.id — NOT NULL
- id (식당id) — long — Foreign key → review.id — NOT NULL
user (사용자정보)
- id (사용자id) — long — Primary key — NOT NULL
- pw (비밀번호) — varchar(30)
- name (이름) — varchar(50)
- gender (닉네임) — varchar(50)
- birth (생년월일) — varchar(20)
- address (주소) — varchar(50)
- created_at (생성시간) — datetime
- updated_at (수정시간) — datetime
- point (포인트) — int
- email (이메일) — varchar(50)
- phone (핸드폰번호) — varchar(20)
user_prefer_food (Untitled)
- id (user_prefer_id) — long — Primary key — NOT NULL
- id (사용자 id) — long — Foreign key → user.id — NOT NULL
- id (선호음식 id) — long — Foreign key → prefer_food.id — NOT NULL