UMC 1th assignment
Tables (9)
food_category (음식 종류)
- id (음식종류ID) — UUID — Primary key — NOT NULL
- name (이름) — VARCHAR(10)
mission (미션)
- id (미션ID) — UUID — Primary key — NOT NULL
- restaurant_id (식당ID) — UUID — Foreign key → restaurant.id — NOT NULL
- description (미션 설명) — VARCHAR(100)
- min_cost (미션달성금액) — INT
- reward_points (적립포인트) — INT
- deadline (미션기한) — DATETIME
restaurant (식당)
- id (식당ID) — UUID — Primary key — NOT NULL
- name (식당명) — VARCHAR(20)
- food_category_id (음식종류ID) — UUID — Foreign key → food_category.id — NOT NULL
- owner_number (사장구분번호) — VARCHAR(10)
- longitude (위도) — DECIMAL(9,6)
- latitude (경도) — DECIMAL(9,6)
- region (지역) — VARCHAR(20)
review (리뷰)
- id (리뷰ID) — UUID — Primary key — NOT NULL
- rating (평점) — DECIMAL(2,1)
- content (내용) — TEXT
- created_at (작성일시) — DATETIME
- user_id (유저ID) — UUID — Foreign key → user.id — NOT NULL
- restaurant_id (식당ID) — UUID — Foreign key → restaurant.id — NOT NULL
review_image (리뷰 사진)
- id (Key) — UUID — Primary key — NOT NULL
- image_url (사진URL) — VARCHAR(255)
- review_id (리뷰ID) — UUID — Foreign key → review.id — NOT NULL
social_account (소셜계정)
- id (소셜ID) — UUID — Primary key — NOT NULL
- user_id (유저ID) — UUID — Foreign key → user.id — NOT NULL
- provider (제공자) — ENUM
user (유저)
- id (유저ID) — UUID — Primary key — NOT NULL
- email (이메일) — VARCHAR(255)
- name (이름) — VARCHAR(50)
- age (나이) — INT
- gender (성별) — ENUM(M,F,E)
- address (주소) — VARCHAR(100)
- birth_date (생년월일) — DATE
- deleted_at (탈퇴일시) — DATETIME
user_mission (유저 미션 관계)
- id (Key) — UUID — Primary key — NOT NULL
- success_status (성공여부) — Boolean
- user_id (유저ID) — UUID — Foreign key → user.id — NOT NULL
- mission_id (미션ID) — UUID — Foreign key → mission.id — NOT NULL
user_preferred_food_kind (사용자 선호 음식 종류)
- id (Key) — UUID — Primary key — NOT NULL
- user_id (유저ID) — UUID — Foreign key → user.id — NOT NULL
- category_id (음식종류ID) — UUID — Foreign key → food_category.id — NOT NULL