클라우드 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