최종
테이블 (12)
p_address
- id — UUID — 기본 키 — NOT NULL
- address — VARCHAR(255)
- detail_address — VARCHAR(255)
- created_at — TIMESTAMP
- created_by — VARCHAR(100)
- updated_at — TIMESTAMP
- updated_by — VARCHAR(100)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(100)
- status — ENUM
- user_id — LONG — 외래 키 → p_user.user_id
p_ai_history (AI 히스토리 프롬프트)
- ai_history_id — UUID — 기본 키 — NOT NULL
- menu_id — UUID — 외래 키 → p_menu.menu_id
- prompt — TEXT
- response — TEXT
- created_at — TIMESTAMP
- created_by — VARCHAR(100)
- user_id (user_id2) — LONG — 외래 키 → p_menu.user_id
p_category
- category_id (id) — UUID — 기본 키 — NOT NULL
- name — VARCHAR(100)
- status — ENUM
- created_at — TIMESTAMP
- created_by — LONG
- updated_at — TIMESTAMP
- updated_by — LONG
- deleted_at — TIMESTAMP
- deleted_by — LONG
p_image_file (이미지 파일)
- image_id — UUID — 기본 키 — NOT NULL
- ref_id — VARCHAR(100)
- ref_type — VARCHAR(100)
- image_url — VARCHAR(255)
- original_name — VARCHAR(255)
- saved_name — VARCHAR(255)
- content_type — VARCHAR(50)
- file_size — BIGINT
- display_order — INTEGER
- display_status — CHAR(1)
- created_at — TIMESTAMP
- created_by — VARCHAR(50)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(50)
p_menu (메뉴)
- menu_id — UUID — 기본 키 — NOT NULL
- store_id — UUID — 외래 키 → p_store.store_id
- menu_name — VARCHAR(100)
- price — INTEGER
- description — TEXT
- ai_generated — BOOLEAN
- menu_status — CHAR(1)
- created_at — TIMESTAMP
- created_by — VARCHAR(50)
- updated_at — TIMESTAMP
- updated_by — VARCHAR(50)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(50)
- user_id (user_id2) — LONG — 외래 키 → p_store.user_id
p_order
- order_id — UUID — 기본 키 — NOT NULL
- store_id — UUID — 외래 키 → p_store.store_id
- address — VARCHAR(255)
- detail_address — VARCHAR(255)
- total_price — INTEGER
- status — ENUM('REQUESTED, ACCEPTED, COOKING, DELIVERING, DELIVERED, COMPLETED, CANCELED')
- created_at — TIMESTAMP
- created_by — VARCHAR(100)
- updated_at — TIMESTAMP
- updated_by — VARCHAR(100)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(100)
- user_id (user_id2) — LONG — 외래 키 → p_user.user_id
p_order_item
- orderitem_id — UUID — 기본 키 — NOT NULL
- order_id — UUID — 외래 키 → p_order.order_id
- menu_id — UUID — 외래 키 → p_menu.menu_id
- quantity — INTEGER
- price — INTEGER
- created_at — TIMESTAMP
- created_by — VARCHAR(100)
- updated_at — TIMESTAMP
- updated_by — VARCHAR(100)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(100)
- user_id (user_id2) — LONG — 외래 키 → p_order.user_id
p_payment
- payment_id — UUID — 기본 키 — NOT NULL
- order_id — UUID — 외래 키 → p_order.order_id
- payment_method — VARCHAR(30)
- card_company — VARCHAR(50)
- amount — INTEGER
- status — ENUM('READY, SUCCESS, FAIL, CANCELED')
- approved_at — TIMESTAMP
- created_at — TIMESTAMP
- created_by — VARCHAR(100)
- updated_at — TIMESTAMP
- updated_by — VARCHAR(100)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(100)
- user_id (user_id2) — LONG — 외래 키 → p_order.user_id
p_region
- region_id (id) — UUID — 기본 키 — NOT NULL
- parent_region_id — UUID — 외래 키 → p_region.region_id
- name — VARCHAR(100)
- status — ENUM
- created_at — TIMESTAMP
- created_by — LONG
- updated_at — TIMESTAMP
- updated_by — LONG
- deleted_at — TIMESTAMP
- deleted_by — LONG
p_review
- review_id (id) — UUID — 기본 키 — NOT NULL
- store_id — UUID — 외래 키 → p_store.store_id — NOT NULL
- order_id — UUID — 외래 키 → p_order.order_id — NOT NULL
- rating — INTEGER — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
- created_by — VARCHAR(100)
- updated_at — TIMESTAMP
- updated_by — VARCHAR(100)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(100)
- user_id — LONG — 외래 키 → p_user.user_id
p_store
- store_id (id) — UUID — 기본 키 — NOT NULL
- category_id — UUID — 외래 키 → p_category.category_id
- region_id — UUID — 외래 키 → p_region.region_id
- name — VARCHAR(100)
- address — VARCHAR(255)
- phone — VARCHAR(30)
- open_time — TIME
- close_time — TIME
- status — ENUM
- created_at — TIMESTAMP
- created_by — LONG
- updated_at — TIMESTAMP
- updated_by — LONG
- deleted_at — TIMESTAMP
- deleted_by — LONG
- user_id (user_id2) — LONG — 외래 키 → p_user.user_id
p_user
- user_id — LONG — 기본 키
- nickname — VARCHAR(100)
- email — VARCHAR(255)
- password — VARCHAR(255)
- role — ENUM(`CUSTOMER`, `OWNER`, `MANAGER`, `MASTER`)
- phone — VARCHAR(30)
- created_at — TIMESTAMP
- created_by — VARCHAR(100)
- updated_at — TIMESTAMP
- updated_by — VARCHAR(100)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(100)
- status — ENUM
- username — VARCHAR(100) — NOT NULL