UMC_0week_mission

Tables (8)

FOOT_TYPE (Untitled2)

  • id (bigint) — 음식 종류ID — Primary key — NOT NULL
  • name (varchar(20)) — 한식/일식/중식 — Primary key — NOT NULL
  • userId (bigint2) — 사용자ID — Foreign key → USER.userId — NOT NULL
  • name (varchar2) — 이름 — Foreign key → USER.name — NOT NULL
  • gender (enum(2)) — 성별 — Foreign key → USER.gender — NOT NULL
  • address (varchar(60)) — 주소 — Foreign key → USER.address — NOT NULL
  • social_provider (enum(3)) — 카카오/네이버/애플/구글 — Foreign key → USER.social_provider — NOT NULL
  • is_agreed_terms (boolean) — 이용동의 여부 — Foreign key → USER.is_agreed_terms — NOT NULL
  • created at (timestamp) — 생성일 — Foreign key → USER.created at — NOT NULL
  • updated_at (timestamp(10)) — 수정일 — Foreign key → USER.updated_at — NOT NULL
  • deleted-at (timestmap(12)) — 탈퇴일 — Foreign key → USER.deleted-at — NOT NULL

MISSION (Untitled5)

  • id (bigint) — 미션 ID — Primary key — NOT NULL
  • restaurant_id (bigint(20)) — 식당 연결 — Primary key — NOT NULL
  • name (varchar(30)) — 미션 이름 — Primary key — NOT NULL
  • description (varchar(50)) — 미션 내용 — Primary key — NOT NULL
  • point (int) — 적립 포인트 — Primary key — NOT NULL
  • due_date (date) — 마감일(D-day) — Primary key — NOT NULL
  • cert_number (varchar(8)) — 사장님 구분 인증번호 — Primary key — NOT NULL
  • id (bigint2) — 식당ID — Foreign key → RESTAURANT.id — NOT NULL
  • name (varchar(10)) — 식당 이름 — Foreign key → RESTAURANT.name — NOT NULL
  • type (enum(3)) — 한식/일식/중식 — Foreign key → RESTAURANT.type — NOT NULL
  • business_hours (varchar(20)) — 영업시간 — Foreign key → RESTAURANT.business_hours — NOT NULL
  • rating (float) — 평점 — Foreign key → RESTAURANT.rating — NOT NULL
  • latitude (float(30)) — 위도 — Foreign key → RESTAURANT.latitude — NOT NULL
  • longitude (float(20)) — 경도 — Foreign key → RESTAURANT.longitude — NOT NULL
  • address (varchar(30)2) — 주소 — Foreign key → RESTAURANT.address — NOT NULL

RESTAURANT (Untitled4)

  • id (bigint) — 식당ID — Primary key — NOT NULL
  • name (varchar(10)) — 식당 이름 — Primary key — NOT NULL
  • type (enum(3)) — 한식/일식/중식 — Primary key — NOT NULL
  • business_hours (varchar(20)) — 영업시간 — Primary key — NOT NULL
  • rating (float) — 평점 — Primary key — NOT NULL
  • latitude (float(30)) — 위도 — Primary key — NOT NULL
  • longitude (float(20)) — 경도 — Primary key — NOT NULL
  • address (varchar(30)) — 주소 — Primary key — NOT NULL

REVIEW (Untitled7)

  • id (bigint) — 리뷰 ID — Primary key — NOT NULL
  • user_mission_id (bigint(10)) — 미션 완료 연결 — Primary key — NOT NULL
  • restaurant_id (bigint(12)) — 식당 연결 — Primary key — NOT NULL
  • content (varchar(50)) — 리뷰 내용 — Primary key — NOT NULL
  • rating (float) — 별점 — Primary key — NOT NULL
  • created_at (timestamp) — 작성일 — Primary key — NOT NULL
  • id (bigint2) — ID — Foreign key → USER_MISSION.id — NOT NULL
  • user_id (bigint(10)2) — 사용자 연결 — Foreign key → USER_MISSION.user_id — NOT NULL
  • mission_id (bigint(20)) — 미션 연결 — Foreign key → USER_MISSION.mission_id — NOT NULL
  • status (enum(3)) — 진행중/성공/실패 — Foreign key → USER_MISSION.status — NOT NULL
  • started_at (timestamp2) — 시작일 — Foreign key → USER_MISSION.started_at — NOT NULL
  • completed_at (timestamp(10)) — 완료일 — Foreign key → USER_MISSION.completed_at — NOT NULL
  • userId (bigint22) — 사용자ID — Foreign key → USER_MISSION.userId — NOT NULL
  • name (varchar2) — 이름 — Foreign key → USER_MISSION.name — NOT NULL
  • gender (enum(2)) — 성별 — Foreign key → USER_MISSION.gender — NOT NULL
  • address (varchar(60)) — 주소 — Foreign key → USER_MISSION.address — NOT NULL
  • social_provider (enum(3)2) — 카카오/네이버/애플/구글 — Foreign key → USER_MISSION.social_provider — NOT NULL
  • is_agreed_terms (boolean) — 이용동의 여부 — Foreign key → USER_MISSION.is_agreed_terms — NOT NULL
  • created at (timestamp22) — 생성일 — Foreign key → USER_MISSION.created at — NOT NULL
  • updated_at (timestamp(10)2) — 수정일 — Foreign key → USER_MISSION.updated_at — NOT NULL
  • deleted-at (timestmap(12)) — 탈퇴일 — Foreign key → USER_MISSION.deleted-at — NOT NULL
  • id (bigint3) — 미션 ID — Foreign key → USER_MISSION.id — NOT NULL
  • restaurant_id (bigint(20)2) — 식당 연결 — Foreign key → USER_MISSION.restaurant_id — NOT NULL
  • name (varchar(30)) — 미션 이름 — Foreign key → USER_MISSION.name — NOT NULL
  • description (varchar(50)2) — 미션 내용 — Foreign key → USER_MISSION.description — NOT NULL
  • point (int22) — 적립 포인트 — Foreign key → USER_MISSION.point — NOT NULL
  • due_date (date) — 마감일(D-day) — Foreign key → USER_MISSION.due_date — NOT NULL
  • cert_number (varchar(8)) — 사장님 구분 인증번호 — Foreign key → USER_MISSION.cert_number — NOT NULL
  • id (bigint222) — 식당ID — Foreign key → USER_MISSION.id — NOT NULL
  • name (varchar(10)) — 식당 이름 — Foreign key → USER_MISSION.name — NOT NULL
  • type (enum(3)3) — 한식/일식/중식 — Foreign key → USER_MISSION.type — NOT NULL
  • business_hours (varchar(20)) — 영업시간 — Foreign key → USER_MISSION.business_hours — NOT NULL
  • rating (float2) — 평점 — Foreign key → USER_MISSION.rating — NOT NULL
  • latitude (float(30)) — 위도 — Foreign key → USER_MISSION.latitude — NOT NULL
  • longitude (float(20)) — 경도 — Foreign key → USER_MISSION.longitude — NOT NULL
  • address (varchar(30)2) — 주소 — Foreign key → USER_MISSION.address — NOT NULL

REVIEW_IMAGE (Untitled8)

  • id (bigint) — 이미지 ID — Primary key — NOT NULL
  • review_id (bigint(10)) — 리뷰 연결 — Primary key — NOT NULL
  • image_url (varchar(30)) — 이미지 경로 — Primary key — NOT NULL
  • Field

USER (Untitled)

  • userId (bigint) — 사용자ID — Primary key — NOT NULL
  • name (varchar) — 이름 — Primary key — NOT NULL
  • gender (enum(2)) — 성별 — Primary key — NOT NULL
  • address (varchar(60)) — 주소 — Primary key — NOT NULL
  • social_provider (enum(3)) — 카카오/네이버/애플/구글 — Primary key — NOT NULL
  • is_agreed_terms (boolean) — 이용동의 여부 — Primary key — NOT NULL
  • created at (timestamp) — 생성일 — Primary key — NOT NULL
  • updated_at (timestamp(10)) — 수정일 — Primary key — NOT NULL
  • deleted-at (timestmap(12)) — 탈퇴일 — Primary key — NOT NULL

USER_FOOD_TYPE (Untitled3)

  • user_id (bigint) — 사용지 — Primary key — NOT NULL
  • food_type_id (enum(3)) — 음식 종류 — Primary key — NOT NULL

USER_MISSION (Untitled6)

  • id (bigint) — ID — Primary key — NOT NULL
  • user_id (bigint(10)) — 사용자 연결 — Primary key — NOT NULL
  • mission_id (bigint(20)) — 미션 연결 — Primary key — NOT NULL
  • status (enum(3)) — 진행중/성공/실패 — Primary key — NOT NULL
  • started_at (timestamp) — 시작일 — Primary key — NOT NULL
  • completed_at (timestamp(10)) — 완료일 — Primary key — NOT NULL
  • userId (bigint2) — 사용자ID — Foreign key → USER.userId — NOT NULL
  • name (varchar) — 이름 — Foreign key → USER.name — NOT NULL
  • gender (enum(2)) — 성별 — Foreign key → USER.gender — NOT NULL
  • address (varchar(60)) — 주소 — Foreign key → USER.address — NOT NULL
  • social_provider (enum(3)2) — 카카오/네이버/애플/구글 — Foreign key → USER.social_provider — NOT NULL
  • is_agreed_terms (boolean) — 이용동의 여부 — Foreign key → USER.is_agreed_terms — NOT NULL
  • created at (timestamp2) — 생성일 — Foreign key → USER.created at — NOT NULL
  • updated_at (timestamp(10)2) — 수정일 — Foreign key → USER.updated_at — NOT NULL
  • deleted-at (timestmap(12)) — 탈퇴일 — Foreign key → USER.deleted-at — NOT NULL
  • id (bigint3) — 미션 ID — Foreign key → MISSION.id — NOT NULL
  • restaurant_id (bigint(20)2) — 식당 연결 — Foreign key → MISSION.restaurant_id — NOT NULL
  • name (varchar(30)) — 미션 이름 — Foreign key → MISSION.name — NOT NULL
  • description (varchar(50)) — 미션 내용 — Foreign key → MISSION.description — NOT NULL
  • point (int2) — 적립 포인트 — Foreign key → MISSION.point — NOT NULL
  • due_date (date) — 마감일(D-day) — Foreign key → MISSION.due_date — NOT NULL
  • cert_number (varchar(8)) — 사장님 구분 인증번호 — Foreign key → MISSION.cert_number — NOT NULL
  • id (bigint22) — 식당ID — Foreign key → MISSION.id — NOT NULL
  • name (varchar(10)) — 식당 이름 — Foreign key → MISSION.name — NOT NULL
  • type (enum(3)3) — 한식/일식/중식 — Foreign key → MISSION.type — NOT NULL
  • business_hours (varchar(20)) — 영업시간 — Foreign key → MISSION.business_hours — NOT NULL
  • rating (float) — 평점 — Foreign key → MISSION.rating — NOT NULL
  • latitude (float(30)) — 위도 — Foreign key → MISSION.latitude — NOT NULL
  • longitude (float(20)) — 경도 — Foreign key → MISSION.longitude — NOT NULL
  • address (varchar(30)2) — 주소 — Foreign key → MISSION.address — NOT NULL