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