delivery

Tables (13)

p_ai_log

  • target_id (Key) — UUID — Primary key — NOT NULL
  • target_type — VARCHAR(30) — NOT NULL
  • prompt — VARCHAR(1000)
  • request_username — VARCHAR(100)
  • request — VARCHAR(1000)
  • model_name — VARCHAR(100) — NOT NULL
  • token_count (user_id) — INTEGER
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL

p_category

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_delivery_address

  • id — UUID — Primary key — NOT NULL
  • customer_username — VARCHAR(100) — Foreign key → p_user.username — NOT NULL
  • detail_address — VARCHAR(255)
  • address — TEXT — NOT NULL
  • is_default — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_order

  • id — UUID — Primary key — NOT NULL
  • username (customer_username) — VARCHAR(100) — Foreign key → p_user.username — NOT NULL
  • store_id — UUID — Foreign key → p_store.id — NOT NULL
  • product_id — UUID — Foreign key → p_product.id — NOT NULL
  • delivery_address — VARCHAR(255)
  • status — VARCHAR(30) — NOT NULL
  • total_price — INTEGER — NOT NULL
  • request_note — TEXT
  • order_type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_order_item

  • id — UUID — Primary key — NOT NULL
  • order_id — UUID — Foreign key → p_order.id — NOT NULL
  • product_name — VARCHAR(255) — NOT NULL
  • product_price — INTEGER — NOT NULL
  • quantity — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL

p_payment

  • id — UUID — Primary key — NOT NULL
  • order_id — UUID — Foreign key → p_order.id — NOT NULL
  • payment_method — VARCHAR(20) — NOT NULL
  • amount — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • paid_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_payment_log

  • id — UUID — Primary key — NOT NULL
  • id (payment_id) — UUID — Foreign key → p_payment.id — NOT NULL
  • payment_method — VARCHAR(20) — NOT NULL
  • amount — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • paid_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_product

  • id — UUID — Primary key — NOT NULL
  • store_id — UUID — Foreign key → p_store.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • price — INTEGER — NOT NULL
  • is_hidden — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_region

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • city — VARCHAR(100) — NOT NULL
  • district — VARCHAR(100) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_review

  • id — UUID — Primary key — NOT NULL
  • store_id — UUID — Foreign key → p_store.id — NOT NULL
  • order_id — UUID — Foreign key → p_order.id — NOT NULL
  • username — VARCHAR(100) — Foreign key → p_user.username — NOT NULL
  • rating — SMALLINT — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_store

  • id — UUID — Primary key — NOT NULL
  • owner_username — VARCHAR(100) — Foreign key → p_user.username — NOT NULL
  • region_id — UUID — Foreign key → p_region.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • phone — VARCHAR(20)
  • address — TEXT — NOT NULL
  • min_order_price — INTEGER — NOT NULL
  • is_open — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_store_category

  • id — UUID — Primary key — NOT NULL
  • category_id — UUID — Foreign key → p_category.id — NOT NULL
  • store_id — UUID — Foreign key → p_store.id — NOT NULL

p_user

  • username — VARCHAR(100) — Primary key — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • role — ENUM — NOT NULL
  • is_public — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)