-- Table: price_card_details
-- Detailed pricing slabs for price cards based on distance and cart amount

CREATE TABLE `price_card_details` (
  `id` int UNSIGNED NOT NULL,
  `price_card_id` int UNSIGNED NOT NULL,
  `distance_from` int DEFAULT NULL,
  `distance_to` int DEFAULT NULL,
  `condition` int DEFAULT NULL,
  `cart_amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slab_amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '1:active 2:inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Primary key and indexes would be added via ALTER TABLE statements
