UMC_week4
Tables (9)
Mission (미션)
- id (미션Id) — Long — Primary key — NOT NULL
- name (이름) — varchar(50)
- description (설명) — text
- point (포인트) — int
- created_at (생성일) — datetime(6)
- updated_at (수정일) — datetime(6)
- status (활성화여부) — tinyint
- market_id (식당Id) — Long
Restaurant (식당)
- id (식당id) — Long — Primary key — NOT NULL
- food_category_id (음식 카테고리) — longv — Foreign key → food_category.id — NOT NULL
- name (식당이름) — varchar
- rating (평점) — int
- address (주소) — varchar
- img_url (식당 이미지 url) — varchar
- created_at (생성일) — datetime
- updated_at (수정일)
Review (리뷰)
- id — long — Primary key — NOT NULL
- user_id (id2) — Long — Foreign key → User.id — NOT NULL
- mission_id (미션Id) — Long — Foreign key → Mission.id — NOT NULL
- user_id (작성자) — long
- rating (별점) — int
- content (내용) — varchar
- created_at (생성일) — datetime
- updated_at (수정일) — datetime
Review_reply (답글)
- id — long — Primary key — NOT NULL
- review_id (리뷰id) — long — Foreign key → Review.id — NOT NULL
- restaurant_id (식당id) — Long — Foreign key → Restaurant.id — NOT NULL
- content (내용) — varchar
- created_at (생성일) — datetime
- updated_at (수정일) — datetime
User (사용자)
- id — Long — Primary key — NOT NULL
- interest_id (선호음식 id) — long — Foreign key → User_Interest.id — NOT NULL
- social_login (소셜로그인방식) — varchar(10)
- token (로그인토큰) — varchar(200)
- name (이름) — varchar(5)
- nickname (닉네임) — varchar(20)
- password (비밀번호) — varchar(200)
- gender (성별) — tinyint
- birth (생일) — datetime
- address (주소) — varchar(100)
- point (소지포인트) — int
- status (활성화상태) — tinyint
- inactive_date (비활성 시기) — datetime
- created_at (생성일) — datetime
- updated_at (수정일) — datetime
User_Interest (사용자 선호)
- id — long — Primary key — NOT NULL
- food_category_id (카테고리 id) — long
- created_At (생성일) — datetime
- updated_at (수정일) — datetime
User_Mission (사용자-미션 관계테이블)
- id — Long — Primary key — NOT NULL
- mission_id (미션Id) — Long — Foreign key → Mission.id — NOT NULL
- user_id (사용자id) — Long — Foreign key → User.id — NOT NULL
- status (상태) — tinyint
- point (점수) — int
- create_at (생성일) — datetime(6)
- updated_at (수정일) — datetime(6)
food_category (음식 카테고리)
- id — longv — Primary key — NOT NULL
- name (음식이름) — varchar
- created_at (생성일) — datetime
- updated_at (수정일) — datetime
review_image (리뷰 이미지)
- id — long — Primary key — NOT NULL
- review_id (리뷰) — long — Foreign key → Review.id — NOT NULL
- img_url (이미지) — varchar
- created_at (생성일) — datetime
- updated_at (수정일) — datetime