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)