ERD without memo
Tables (12)
p_address
- address_id — UUID — Primary key — NOT NULL
- user_id — LONG — Foreign key → p_user.user_id — NOT NULL
- address — VARCHAR(255)
- detail_address — VARCHAR(255)
- created_at — TIMESTAMP
- created_by — LONG
- updated_at — TIMESTAMP
- updated_by — LONG
- deleted_at — TIMESTAMP
- deleted_by — LONG
p_ai_history
- ai_history_id — UUID — Primary key — NOT NULL
- prompt — TEXT
- response — TEXT
- created_at — TIMESTAMP
- created_by — LONG
p_category (p_store_category)
- category_id — UUID — Primary key — 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 (image__id) — UUID — Primary key — NOT NULL
- ref_type — VARCHAR(100)
- ref_id — VARCHAR(100)
- image_key — VARCHAR(255)
- original_name — VARCHAR(255)
- content_type — VARCHAR(50)
- file_size — BIGINT
- display_order — INTEGER
- display_status — ENUM
- created_at — TIMESTAMP
- created_by — LONG
- deleted_at — TIMESTAMP
- deleted_by — LONG
p_menu
- menu_id — UUID — Primary key — NOT NULL
- store_id — UUID — Foreign key → p_store.store_id
- menu_name — VARCHAR(100)
- price — INTEGER
- description — TEXT
- ai_generated — BOOLEAN
- menu_status — ENUM
- created_at — TIMESTAMP
- created_by — LONG
- updated_at — TIMESTAMP
- updated_by — LONG
- deleted_at — TIMESTAMP
- deleted_by — LONG
p_order
- order_id — UUID — Primary key — NOT NULL
- user_id — LONG — Foreign key → p_user.user_id — NOT NULL
- store_id — UUID — Foreign key → 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 — LONG
- updated_at — TIMESTAMP
- updated_by — LONG
- deleted_at — TIMESTAMP
- deleted_by — LONG
p_order_item
- orderitem_id — UUID — Primary key — NOT NULL
- order_id — UUID — Foreign key → p_order.order_id
- menu_id — UUID — Foreign key → p_menu.menu_id
- quantity — INTEGER
- price — INTEGER
- created_at — TIMESTAMP
- created_by — LONG
- updated_at — TIMESTAMP
- updated_by — LONG
- deleted_at — TIMESTAMP
- deleted_by — LONG
p_payment
- payment_id — UUID — Primary key — NOT NULL
- order_id — UUID — Foreign key → 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 — LONG
- updated_at — TIMESTAMP
- updated_by — LONG
- deleted_at — TIMESTAMP
- deleted_by — LONG
p_region
- region_id — UUID — Primary key — NOT NULL
- name — VARCHAR(100)
- parent_region_id — UUID — Foreign key → p_region.region_id
- status — ENUM
- created_at — TIMESTAMP
- created_by — LONG
- updated_at — TIMESTAMP
- updated_by — LONG
- deleted_at — TIMESTAMP
- deleted_by — LONG
p_review
- review_id — UUID — Primary key — NOT NULL
- store_id — UUID — Foreign key → p_store.store_id — NOT NULL
- order_id (id2) — UUID — Foreign key → p_order.order_id — NOT NULL
- user_id — LONG — Foreign key → p_user.user_id — NOT NULL
- rating — INTEGER — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
- created_by — LONG
- updated_at — TIMESTAMP
- updated_by — LONG
- deleted_at — TIMESTAMP
- deleted_by — LONG
p_store
- store_id — UUID — Primary key — NOT NULL
- user_id — LONG — Foreign key → p_user.user_id — NOT NULL
- category_id — UUID — Foreign key → p_category.category_id
- region_id — UUID — Foreign key → 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
p_user
- user_id — LONG — Primary key — NOT NULL
- username (Field) — VARCHAR(100)
- nickname — VARCHAR(100)
- email — VARCHAR(255)
- password — VARCHAR(255)
- role — ENUM(`CUSTOMER`, `OWNER`, `MANAGER`, `MASTER`)
- phone — VARCHAR(11)
- created_at — TIMESTAMP
- created_by — LONG
- updated_at — TIMESTAMP
- updated_by — LONG
- deleted_at — TIMESTAMP
- deleted_by — LONG
- is_deleted — BOOLEAN