UMC server week1

Tables (9)

member (사용자)

  • id (사용자식별코드) — bigint — Primary key — NOT NULL — autoincrement
  • name (이름) — varchar(40) — NOT NULL
  • gender (성별) — varchar(10) — NOT NULL — 여자, 남자, 선택 안함
  • birth (생년월일) — date — NOT NULL — YYYY-MM-DD
  • address (주소) — varchar(200) — NOT NULL
  • preferred_food (선호 음식) — enum — 한식, 일식, 중식, 양식 등,,
  • login_method (로그인 방식) — varchar(10) — NOT NULL — kakao, naver, apple, google

mission (미션)

  • mission_id (미션식별코드) — bigint — Primary key — NOT NULL — autoincrement
  • restaurant_id (식당식별코드) — bigint — Foreign key → restaurant.restaurant_id — NOT NULL — autoincrement
  • point (적립 포인트) — int — NOT NULL
  • minimum_price (최소가격) — int — NOT NULL

my_mission (내 미션)

  • mission_id (미션식별코드) — bigint — Foreign key → mission.mission_id — NOT NULL — autoincrement
  • id (사용자식별코드) — bigint — Foreign key → member.id — NOT NULL — autoincrement
  • d_day (디데이) — int — NOT NULL

preferred (선호음식)

  • id (음식식별코드) — bigint — Primary key — NOT NULL — autoincrement
  • food_name (음식이름) — varchar(20) — NOT NULL

restaurant (식당)

  • restaurant_id (식당식별코드) — bigint — Primary key — NOT NULL — autoincrement
  • name (식당 이름) — varchar(100) — NOT NULL
  • category (식당 종류) — enum — NOT NULL — 한식당, 중식당, 일식당 등
  • status (상태) — varchar(10) — NOT NULL — 영업 중, 영업 종료 등
  • address (주소) — varchar(200) — NOT NULL

restaurant_category (식당 종류)

  • category_id (카테고리 식별코드) — bigint — Primary key — NOT NULL — auro_increment
  • category_name (카테고리 이름) — varchar(10) — NOT NULL
  • restaurant_id (식당식별코드) — bigint — Foreign key → restaurant.restaurant_id — NOT NULL — autoincrement

review (리뷰)

  • review_id (리뷰식별코드) — bigint — Primary key — NOT NULL — autoincrement
  • star (별점) — float — NOT NULL
  • contents (리뷰내용) — varchar(500) — NOT NULL
  • restaurant_id (식당식별코드) — bigint — Foreign key → restaurant.restaurant_id — NOT NULL — autoincrement
  • id (사용자식별코드) — bigint — Foreign key → member.id — NOT NULL — autoincrement

review_picture (리뷰사진)

  • picture_id (사진식별코드) — bigint — Primary key — NOT NULL
  • picture (사진) — varchar(500) — NOT NULL
  • review_id (리뷰식별코드) — bigint — Foreign key → review.review_id — NOT NULL — autoincrement

user_preferred (사용자 선호음식)

  • id (사용자식별코드) — bigint — Foreign key → member.id — NOT NULL — autoincrement
  • id (음식식별코드) — bigint — Foreign key → preferred.id — NOT NULL — autoincrement