next-day-delivery

Tables (11)

order_detail

  • order_id — UUID — Primary key — NOT NULL
  • product_id — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255)
  • created_at — TIMESTAMP
  • created_by — VARCHAR(100)
  • updated_at — TIMESTAMP
  • updated_by — TIMESTAMP
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)
  • order_id2 — UUID — Foreign key → p_order.order_id — NOT NULL
  • product_id2 — UUID — Foreign key → p_product.product_id — NOT NULL

p_category

  • category_id — UUID — Primary key — NOT NULL
  • category_name — VARCHAR(100)

p_location

  • loc_id — UUID — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → p_user.user_id — NOT NULL
  • name — VARCHAR(100)
  • parent_id — VARCHAR(100)
  • depth — VARCHAR(100)
  • created_at — TIMESTAMP
  • created_by — VARCHAR(100)
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_order

  • order_id — UUID — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → p_user.user_id — NOT NULL
  • order_status — ENUM
  • address — VARCHAR()
  • created_at — TIMESTAMP
  • created_by — VARCHAR(100)
  • updated_at — TIMESTAMP
  • updated_by — TIMESTAMP
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_payment

  • payment_id — UUID — Primary key — NOT NULL
  • order_id — UUID — Foreign key → p_order.order_id — NOT NULL
  • payment_method — ENUM
  • pament_state — ENUM
  • created_at — TIMESTAMP
  • created_by — VARCHAR(100)
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_product

  • product_id — UUID — Primary key — NOT NULL
  • store_id — UUID — Foreign key → p_store.store_id — NOT NULL
  • product_name — VARCHAR(100)
  • price — INT
  • is_public — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — VARCHAR(100)
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_response

  • res_id — UUID — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → p_user.user_id — NOT NULL
  • content — TEXT

p_review

  • review_id — UUID — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → p_user.user_id — NOT NULL
  • order_id — UUID — Foreign key → p_order.order_id — NOT NULL
  • store_id — UUID — Foreign key → p_store.store_id — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255)
  • Field4 — VARCHAR(255)
  • Field5 — VARCHAR(255)

p_store

  • store_id — UUID — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → p_user.user_id — NOT NULL
  • name — VARCHAR(100)
  • rating_avg — DECIMAL(2,1)
  • Field — VARCHAR(255)
  • created_at — TIMESTAMP
  • created_by — VARCHAR(100)
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_store_category

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

p_user

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