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