delivery app
Tables (15)
p_address
- id — BIGINT — Primary key — NOT NULL
- user_id — Foreign key → p_user.id — NOT NULL
- address_name — VARCHAR(100)
- address_line — TEXT — NOT NULL
- detail_address — TEXT
- postal_code — VARCHAR(20)
- is_default — BOOLEAN
- recipient_name — VARCHAR(50)
- recipient_phone — VARCHAR(20)
- created_at — DATETIME — NOT NULL
- created_by — VARCHAR(100)
- updated_at — DATETIME — NOT NULL
- updated_by — VARCHAR(100)
- deleted_at — DATETIME
- deleted_by — VARCHAR(100)
p_ai_log
- id — BINARY(16) — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → p_user.id — NOT NULL
- ai_model — VARCHAR(50) — NOT NULL
- product_name — VARCHAR(100) — NOT NULL
- response_content — VARCHAR(255) — NOT NULL
- request_type — VARCHAR(50) — NOT NULL
- status — VARCHAR(50)
- created_at
- created_by
p_category
- id — BINARY(16) — Primary key — NOT NULL — UUID
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- created_by — VARCHAR(100) — NOT NULL
- updated_at — DATETIME
- updated_by — VARCHAR(100)
p_menu
- id — BINARY(16) — Primary key — NOT NULL
- store_id — BINARY(16) — Foreign key → p_store.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- price — INT — NOT NULL
- is_hidden — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- created_by — VARCHAR(100) — NOT NULL
- updated_at — DATETIME
- updated_by — VARCHAR(100)
- deleted_at — DATETIME
- deleted_by — VARCHAR(100)
p_option
- id — BINARY(16) — Primary key — NOT NULL — UUID
- menu_id — BINARY(16) — Foreign key → p_menu.id — NOT NULL — UUID
- name — VARCHAR(15) — NOT NULL
- created_at — NOT NULL
- created_by — NOT NULL
- updated_at
- updated_by
- deleted_at
- deleted_by
p_option_value
- id — BINARY(16) — Primary key — NOT NULL — UUID
- option_id — BINARY(16) — Foreign key → p_option.id — NOT NULL — UUID
- value — VARCHAR(15) — NOT NULL
- description — VARCHAR(30)
- add_price — INT — NOT NULL — default = 0
- created_at — NOT NULL
- created_by — NOT NULL
- updated_at
- updated_by
- deleted_at
- deleted_by
p_order
- id — BINARY(16) — Primary key — NOT NULL — UUID
- user_id — BIGINT — Foreign key → p_user.id — NOT NULL
- store_id — BINARY(16) — Foreign key → p_store.id — NOT NULL — UUID
- status — ENUM( 'CREATED', 'PENDING', 'CANCELED', 'ACCEPTED', 'REJECTED', 'READY', 'DELIVERING', 'COMPLETED' ) — NOT NULL
- ordered_at — DATETIME — NOT NULL
- total_price — INT — NOT NULL
- delivery_address — VARCHAR(255) — NOT NULL
- detail_address — VARCHAR(255)
- memo — VARCHAR(200)
- created_at — DATETIME — NOT NULL
- created_by — VARCHAR(100)
- updated_at — DATETIME — NOT NULL
- updated_by — VARCHAR(100)
p_order_menu
- id — BIGINT — Primary key — NOT NULL — auto_increment
- order_id — BINARY(16) — Foreign key → p_order.id — NOT NULL
- menu_id — BINARY(16) — Foreign key → p_menu.id — NOT NULL
- menu_name — VARCHAR(100) — NOT NULL — item snapshot
- total_price — INT — NOT NULL
- quantity — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- created_by — VARCHAR(100) — NOT NULL
p_order_menu_option
- id — BIGINT — Primary key — NOT NULL — auto_increment
- order_menu_id — BIGINT — Foreign key → p_order_menu.id — NOT NULL
- option_name — VARCHAR(15) — NOT NULL
- add_price — INT — NOT NULL
- created_at
- created_by
p_order_menu_option_value
- id — BIGINT — Primary key — NOT NULL
- order_menu_option_id — BIGINT — Foreign key → p_order_menu_option.id — NOT NULL — auto_increment
- add_price — INT — NOT NULL
- option_value_name — VARCHAR(255) — NOT NULL
- created_at — NOT NULL
- created_by — NOT NULL
p_payment
- id — BINARY(16) — Primary key — NOT NULL — UUID
- user_id — BIGINT — Foreign key → p_user.id — NOT NULL — auto_increment
- order_id — CHAR(36) — Foreign key → p_order.id — NOT NULL — UUID
- amount — INT — NOT NULL
- payment_method — VARCHAR(50) — NOT NULL
- pg_transaction_id — VARCHAR(255) — NOT NULL
- status — ENUM('READY','PAID','FAILED','CANCELLED','REFUNDED') — NOT NULL
- fail_reason — VARCHAR(255)
- paid_at — DATETIME
- failed_at — DATETIME
- refunded_at — DATETIME
- created_at — DATETIME — NOT NULL
- created_by — VARCHAR(100)
- updated_at — DATETIME — NOT NULL
- updated_by — VARCHAR(100)
p_review
- id — CHAR(36) — Primary key — NOT NULL — UUID
- user_id — BIGINT — Foreign key → p_user.id — NOT NULL — auto_increment
- store_id — CHAR(36) — Foreign key → p_store.id — NOT NULL — UUID
- order_id — CHAR(36) — Foreign key → p_order.id — NOT NULL — UUID
- rating — INT — NOT NULL
- content — TEXT
- created_at — DATETIME — NOT NULL
- created_by — VARCHAR(100)
- updated_at — DATETIME — NOT NULL
- updated_by — VARCHAR(100)
- deleted_at — DATETIME
- deleted_by — VARCHAR(100)
p_store
- id — BINARY(16) — Primary key — NOT NULL
- owner_id — BIGINT — Foreign key → p_user.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- address — VARCHAR(255)
- location — POINT — NOT NULL
- phone_number — VARCHAR(20)
- is_active — BOOLEAN
- rating_count — INT
- rating_avg — DECIMAL(2,1)
- min_order_price — INT
- delivery_fee — INT
- opened_at — DATETIME — 가게 오픈 시간
- closed_at — DATETIME — 가게 마감 시간
- created_at — DATETIME — NOT NULL
- created_by — VARCHAR(100)
- updated_at — DATETIME — NOT NULL
- updated_by — VARCHAR(100)
- deleted_at — DATETIME
- deleted_by — VARCHAR(100)
p_store_category
- id (Key) — BIGINT — Primary key — NOT NULL
- category_id — BINARY(16) — Foreign key → p_category.id — NOT NULL
- store_id — BINARY(16) — Foreign key → p_store.id — NOT NULL
- created_at — DATETIME — NOT NULL
- created_by — VARCHAR(100)
p_user
- id — BIGINT — Primary key — NOT NULL — auto_increment
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — ENUM('USER', 'MASTER', 'MANAGER') — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- status — ENUM('ACTIVE', 'INACTIVE', 'BANNED') — NOT NULL
- created_at — DATETIME — NOT NULL
- created_by — VARCHAR(100) — NOT NULL
- updated_at — DATETIME
- updated_by — VARCHAR(100)
- deleted_at — DATETIME
- deleted_by — VARCHAR(100)
- is_deleted — BOOLEAN