git
Tables (23)
CATEGORY (Untitled7)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → RESTAURANT.Key — NOT NULL
- Key (Key3) — Foreign key → CATEGORY.Key — NOT NULL
- Key (Key22) — Foreign key → CATEGORY.Key — NOT NULL
Food (음식)
- id (음식 키) — LONG — Primary key — NOT NULL
- name (이름) — VARCHAR(100)
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
Inquiry (문의)
- id (문의 키) — LONG — Primary key — NOT NULL
- user_id (유저 키) — LONG — Foreign key → User.id — NOT NULL
- content (내용) — VARCHAR(1000)
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
Inquiry_Photo (문의 등록 사진)
- id (리뷰 사진 키) — LONG — Primary key — NOT NULL
- id (문의 키) — LONG — Foreign key → Inquiry.id — NOT NULL
- user_id (유저 키) — LONG — Foreign key → Inquiry.user_id — NOT NULL
- imageURL (사진) — VARCHAR(256)
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
Inquiry_Reply (문의 답변)
- id (답변 키) — LONG — Primary key — NOT NULL
- inquiry_id (문의 키) — LONG — Foreign key → Inquiry.id — NOT NULL
- user_id (유저 키) — LONG — Foreign key → Inquiry.user_id — NOT NULL
- content (내용) — VARCHAR(1000)
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
MENU (Untitled8)
- Key3 — Primary key — NOT NULL
- Key — Foreign key → RESTAURANT.Key — NOT NULL
- Key (Key2) — Foreign key → CATEGORY.Key — NOT NULL
- Key (Key22) — Foreign key → CATEGORY.Key — NOT NULL
Mission (미션)
- id (미션 키) — LONG — Primary key — NOT NULL
- restaurant_id (식당 키) — LONG — Foreign key → Restaurant.id — NOT NULL
- region_id (지역 키) — LONG — Foreign key → Restaurant.region_id — NOT NULL
- remaining_duration (남은 기간) — INT
- mission_description (미션 내용) — VARCHAR(1000)
- reward (보상) — VARCHAR(100)
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
OPTION_GROUP (Untitled9)
- Key4 — Primary key — NOT NULL
- Key3 — Foreign key → MENU.Key3 — NOT NULL
- Key — Foreign key → MENU.Key — NOT NULL
- Key (Key2) — Foreign key → MENU.Key — NOT NULL
- Key (Key22) — Foreign key → MENU.Key — NOT NULL
- Key4 (Key42) — Foreign key → OPTION_ITEM.Key4 — NOT NULL
- Key3 (Key32) — Foreign key → OPTION_ITEM.Key3 — NOT NULL
- Key (Key5) — Foreign key → OPTION_ITEM.Key — NOT NULL
- Key (Key23) — Foreign key → OPTION_ITEM.Key — NOT NULL
- Key (Key222) — Foreign key → OPTION_ITEM.Key — NOT NULL
OPTION_ITEM (Untitled)
- Key4 — Foreign key → OPTION_GROUP.Key4 — NOT NULL
- Key3 — Foreign key → OPTION_GROUP.Key3 — NOT NULL
- Key — Foreign key → OPTION_GROUP.Key — NOT NULL
- Key (Key2) — Foreign key → OPTION_GROUP.Key — NOT NULL
- Key (Key22) — Foreign key → OPTION_GROUP.Key — NOT NULL
- Key4 (Key42) — Foreign key → OPTION_GROUP.Key4 — NOT NULL
- Key3 (Key32) — Foreign key → OPTION_GROUP.Key3 — NOT NULL
- Key (Key5) — Foreign key → OPTION_GROUP.Key — NOT NULL
- Key (Key23) — Foreign key → OPTION_GROUP.Key — NOT NULL
- Key (Key222) — Foreign key → OPTION_GROUP.Key — NOT NULL
Owner_Restaurant (식당 오너)
- id (식당 오너 키) — LONG — Primary key — NOT NULL
- owner_id (오너 키) — LONG — Foreign key → User.id — NOT NULL
- restaurant_id (식당 키) — LONG — Foreign key → Restaurant.id — NOT NULL
- id (지역 키) — LONG — Foreign key → Restaurant.region_id — NOT NULL
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
Point_History (포인트 기록)
- id (포인트 기록 키) — LONG — Primary key — NOT NULL
- user_point_id (유저 포인트 키) — LONG — Foreign key → User_Point.id — NOT NULL
- user_id (유저 키) — LONG — Foreign key → User_Point.user_id — NOT NULL
- transaction_type (거래 타입) — ENUM(+, -)
- amount (거래량) — INT
- description (설명) — VARCHAR(100)
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
RESTAURANT (Untitled6)
- Key — Primary key — NOT NULL
Region (지역)
- id (지역 키) — LONG — Primary key — NOT NULL
- name (지역명) — VARCHAR(100)
- latitude (위도) — DOUBLE
- longitude (경도) — DOUBLE
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
Restaurant (식당)
- id (식당 키) — LONG — Primary key — NOT NULL
- region_id (지역 키) — LONG — Foreign key → Region.id — NOT NULL
- name (식당명) — VARCHAR(100)
- latutude (위도) — DOUBLE
- longitude (경도) — DOUBLE
- address (주소) — VARCHAR(100)
- res_type (식당 타입) — ENUM(A, B, C)
- star (별점) — INT
- description (식당 설명) — VARCHAR(1000)
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
Review (리뷰)
- id (리뷰 키) — LONG — Primary key — NOT NULL
- user_id (유저 키) — LONG — Foreign key → User.id — NOT NULL
- restaurant_id (식당 키) — LONG — Foreign key → Restaurant.id — NOT NULL
- region_id (지역 키) — LONG — Foreign key → Restaurant.region_id — NOT NULL
- star (별점) — INT
- content (내용) — VARCHAR(1000)
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
Review_Photo (리뷰 등록 사진)
- id (리뷰 사진 키) — LONG — Primary key — NOT NULL
- id (리뷰 키) — LONG — Foreign key → Review.id — NOT NULL
- user_id (유저 키) — LONG — Foreign key → Review.user_id — NOT NULL
- restaurant_id (식당 키) — LONG — Foreign key → Review.restaurant_id — NOT NULL
- region_id (지역 키) — LONG — Foreign key → Review.region_id — NOT NULL
- imageURL (사진) — VARCHAR(256)
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
Review_Reply (리뷰 답글)
- id (답글 키) — LONG — Primary key — NOT NULL
- review_id (리뷰 키) — LONG — Foreign key → Review.id — NOT NULL
- user_id (유저 키) — LONG — Foreign key → Review.user_id — NOT NULL
- restaurant_id (식당 키) — LONG — Foreign key → Review.restaurant_id — NOT NULL
- region_id (지역 키) — LONG — Foreign key → Review.region_id — NOT NULL
- content (내용) — VARCHAR(1000)
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
User (유저)
- id (유저 키) — LONG — Primary key — NOT NULL
- nickname (닉네임) — VARCHAR(100)
- role (역할) — ENUM(U, O)
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
- status (활성화 상태) — BOOLEAN
- inactived_at (비활성화 시간) — DATETIME(6)
User_Auth (유저 인증)
- id (유저 인증 키) — LONG — Primary key — NOT NULL
- id (유저 키) — LONG — Foreign key → User.id — NOT NULL
- login_type (로그인 타입) — ENUM(K, G, N, A)
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
User_Food (유저 선호 음식)
- id (유저 선호 음식 키) — LONG — Primary key — NOT NULL
- user_id (유저 키) — LONG — Foreign key → User.id — NOT NULL
- food_id (음식 키) — LONG — Foreign key → Food.id — NOT NULL
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
User_Info (유저 정보)
- id (유저 정보 키) — LONG — Primary key — NOT NULL
- user_id (유저 키) — LONG — Foreign key → User.id — NOT NULL
- gender (성병) — ENUM(M,W, N)
- birth (생년월일) — DATETIME(6)
- address (주소) — VARCHAR(100)
- email (이메일) — VARCHAR(100)
- image (프로필 사진) — VARCHAR(256)
- phone_num (휴대폰 번호) — VARCHAR(100)
- phone_num_verification (휴대폰 인증) — BOOLEAN
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
User_Mission (유저 미션)
- id (유저 미션 키) — LONG — Primary key — NOT NULL
- user_id (유저 키) — LONG — Foreign key → User.id — NOT NULL
- mission_id (미션 키) — LONG — Foreign key → Mission.id — NOT NULL
- restaurant_id (식당 키) — LONG — Foreign key → Mission.restaurant_id — NOT NULL
- region_id (지역 키) — LONG — Foreign key → Mission.region_id — NOT NULL
- is_success (성공 여부) — BOOLEAN
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)
User_Point (유저 포인트)
- id (유저 포인트 키) — LONG — Primary key — NOT NULL
- user_id (유저 키) — LONG — Foreign key → User.id — NOT NULL
- point (총 포인트) — INT
- created_at (생성일) — DATETIME(6)
- updated_at (갱신일) — DATETIME(6)