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