클라우드 2조 프로젝트
테이블 (15)
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
- store_id — UUID — 외래 키 → 가게.store_id
- menu_id — UUID — 외래 키 → 메뉴.menu_id
가게 (p_store_Info)
- store_id — UUID — 기본 키
- 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
- user_id — UUID — 외래 키 → 유저.user_id
결제내역 (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
- user_id — UUID — 외래 키 → 주문.user_id
리뷰 (p_reviews)
- review_id — UUID — 기본 키
- store_id — UUID — 외래 키 → 가게.store_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
- user_id — UUID — 외래 키 → 가게.user_id
메뉴 (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
- user_id — UUID — 외래 키 → 가게.user_id
신고내역 (p_admin_reports)
- report_id — UUID — 기본 키 — NOT NULL
- reporter_id — UUID
- reported_id — UUID
- report_type
- content — TEXT
- status — ENUM('처리 대기', '처리 완료', '거절됨')
- created_at — TIMESTAMP
- created_by — UUID
- updated_at — TIMESTAMP
- updated_by — UUID
- deleted_at — TIMESTAMP
- deleted_by — UUID
- user_id — UUID — 외래 키 → 유저.user_id
유저 (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
- Key (sanction_id) — UUID — 외래 키 → 유저 제재.Key — NOT NULL
- refresh_token_id — UUID — 외래 키 → 인증인가토큰.refresh_token_id
유저 제재 (p_admin_user_sanctions)
- Key (sanction_id) — UUID — 기본 키 — NOT NULL
- Field (user_id) — UUID
- Field (reason) — VARCHAR(255)
- Field (sanction_status) — ENUM
- Field (note) — TEXT
- Field (start_date) — DATE
- Field (end_date) — DATE
- Field (created_at) — TIMESTAMP
- Field (created_by) — UUID
- Field (updated_at) — TIMESTAMP
- Field (updated_by) — UUID
- Field (deleted_at) — TIMESTAMP
- Field (deleted_by) — UUID
인증인가토큰 (p_refresh_token)
- refresh_token_id — UUID — 기본 키
- 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 — 기본 키
- 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
- user_id (user_id2) — UUID — 외래 키 → 유저.user_id
- store_id (store_id2) — UUID — 외래 키 → 가게.store_id
- user_id — UUID — 외래 키 → 유저.user_id
장바구니 메뉴 (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
- user_id — UUID — 외래 키 → 장바구니.user_id
점주 요청 (p_manager_request)
- request_id — UUID — 기본 키
- 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
- user_id — UUID — 외래 키 → 유저.user_id
주문 (p_order_info)
- order_id — UUID — 기본 키
- store_id — UUID — 외래 키 → 가게.store_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
- user_id — UUID — 외래 키 → 가게.user_id
주문 메뉴 (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
- user_id — UUID — 외래 키 → 주문.user_id
찜 (p_favorite)
- favorite_id — UUID — 기본 키
- 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
- user_id — UUID — 외래 키 → 유저.user_id