클라우드 2조 - 프로젝트 1

테이블 (14)

AI서비스로그 (p_ai_usage_log)

  • log_id — UUID — 기본 키
  • content — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP
  • created_by — UUID — NOT NULL
  • updated_by — UUID
  • deleted_by — UUID

가게 (p_store_Info)

  • store_id — UUID — 기본 키
  • user_id — UUID — 외래 키 → 유저.user_id
  • name — VARCHAR(255) — NOT NULL
  • address1 — VARCHAR(255) — NOT NULL
  • address2 — VARCHAR(255)
  • store_latitude — NUMERIC(9,6)
  • store_longitude — NUMERIC(9,6)
  • phoneNum — CHAR(11) — NOT NULL
  • introduction — TEXT
  • category — ENUM('한식', '중식', '양식', '일식', '야식') — NOT NULL
  • orderCount — FLOAT
  • totalProfit — FLOAT
  • businessNum — CHAR(10) — NOT NULL
  • imgURL — VARCHAR(255)
  • openTime — TIME — NOT NULL
  • closedTime — TIME — NOT NULL
  • isAvailable — ENUM('등록 심사중', '영업중', '영업준비', '폐업') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — UUID — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

결제내역 (p_payment_history)

  • payment_history_id — UUID — 기본 키
  • order_id — UUID — 외래 키 → 주문.order_id
  • payment_key — VARCHAR — NOT NULL
  • payment_method — VARCHAR — NOT NULL
  • total_amount — INTEGER — NOT NULL
  • currency — VARCHAR — NOT NULL
  • status — VARCHAR — NOT NULL
  • requested_at — VARCHAR — NOT NULL
  • approved_at — VARCHAR
  • created_at — TIMESTAMP — NOT NULL
  • created_by — UUID — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

리뷰 (p_reviews)

  • review_id — UUID — 기본 키
  • store_id — UUID — 외래 키 → 가게.store_id
  • user_id — UUID — 외래 키 → 가게.user_id
  • order_id — UUID — 외래 키 → 주문.order_id
  • rating — INT — NOT NULL
  • content — TEXT
  • imgURL — TEXT
  • ownerReview — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • created_by — UUID — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

메뉴 (p_menu_Info)

  • menu_id — UUID — 기본 키
  • store_id — UUID — 외래 키 → 가게.store_id
  • name — VARCHAR(255) — NOT NULL
  • introduction — VARCHAR(255)
  • imgURL — VARCHAR(255)
  • required_time — TIME
  • price — INT — NOT NULL
  • isAvailable — ENUM('판매중', '품절', '비활성화') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — UUID — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

유저 (p_user_Info)

  • user_id — UUID — 기본 키
  • name — VARCHAR(255) — NOT NULL
  • birthdate — DATE — NOT NULL
  • phone — CHAR(11) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • login_id — VARCHAR(255) — NOT NULL
  • password — CHAR(60) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • balance — INT
  • role — ENUM('관리자', '고객', '점주') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — UUID — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

유저 주소 (p_user_address)

  • user_address_id — UUID — 기본 키
  • user_id — UUID — 외래 키 → 유저.user_id
  • main_address_name — VARCHAR(255) — NOT NULL
  • main_address — VARCHAR(255) — NOT NULL
  • main_latitude — NUMERIC(9,6) — NOT NULL
  • main_longitude — NUMERIC(9,6) — NOT NULL
  • second_address_name — VARCHAR(255)
  • second_address — VARCHAR(255)
  • second_latitude — NUMERIC(9,6)
  • second_longitude — NUMERIC(9,6)
  • third_address_name — VARCHAR(255)
  • third_address — VARCHAR(255)
  • third_latitude — NUMERIC(9,6)
  • third_longitude — NUMERIC(9,6)
  • created_at — TIMESTAMP — NOT NULL
  • created_by — UUID — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

인증인가토큰 (p_refresh_token)

  • refresh_token_id — UUID — 기본 키
  • user_id — UUID — 외래 키 → 유저.user_id
  • provider — TEXT — NOT NULL
  • provider_user_id — TEXT — NOT NULL
  • access_token — TEXT — NOT NULL
  • refresh_token — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP
  • created_by — UUID — NOT NULL
  • updated_by — UUID
  • deleted_by — UUID

장바구니 (p_cart)

  • cart_id — UUID — 기본 키
  • user_id — UUID — 외래 키 → 유저.user_id
  • store_id — UUID — 외래 키 → 가게.store_id
  • created_at — TIMESTAMP — NOT NULL
  • created_by — UUID — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

장바구니 메뉴 (p_cart_items)

  • cart_items_id — UUID — 기본 키
  • cart_id — UUID — 외래 키 → 장바구니.cart_id
  • menu_id — UUID — 외래 키 → 메뉴.menu_id
  • quantity — INT — NOT NULL
  • price — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — UUID — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

점주 요청 (p_manager_request)

  • request_id — UUID — 기본 키
  • user_id — UUID — 외래 키 → 유저.user_id
  • store_id — UUID — 외래 키 → 가게.store_id
  • request_message — TEXT
  • request_status — VARCHAR(20) — NOT NULL
  • reject_message — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP
  • created_by — UUID — NOT NULL
  • updated_by — UUID
  • deleted_by — UUID

주문 (p_order_info)

  • order_id — UUID — 기본 키
  • store_id — UUID — 외래 키 → 가게.store_id
  • user_id — UUID — 외래 키 → 가게.user_id
  • total_price — INT — NOT NULL
  • request_message — VARCHAR(255)
  • order_status — ENUM('주문접수', '조리중', '배달중', '배달완료', '주문취소') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — UUID — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

주문 메뉴 (p_order_items)

  • order_item_id — UUID — 기본 키 — NOT NULL
  • order_id — UUID — 외래 키 → 주문.order_id
  • menu_id — UUID — 외래 키 → 메뉴.menu_id
  • store_name — TEXT — NOT NULL
  • menu_name — TEXT — NOT NULL
  • quantity — INT — NOT NULL
  • price — INT — NOT NULL
  • request_message — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • created_by — UUID — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

찜 (p_favorite)

  • favorite_id — UUID — 기본 키
  • user_id — UUID — 외래 키 → 유저.user_id
  • store_id — UUID — 외래 키 → 메뉴.menu_id
  • created_at — TIMESTAMP — NOT NULL
  • created_by — UUID — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID