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