CREATE TABLE `trx_order` (
  `id` varchar(191) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ref_shift_id` int(11) NOT NULL,
  `ref_toko_id` int(11) DEFAULT NULL,
  `inf_sales_id` int(11) NOT NULL,
  `inf_payment_method_id` int(11) NOT NULL,
  `sub_total` int(11) NOT NULL,
  `pb` int(11) NOT NULL,
  `total` int(11) NOT NULL,
  `tunai` int(11) DEFAULT NULL,
  `kembalian` int(11) DEFAULT NULL,
  `card_no` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1


CREATE TABLE `trx_order_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trx_order_id` varchar(191) NOT NULL,
  `inf_item_id` int(11) NOT NULL,
  `inf_variant_id` int(11) NOT NULL,
  `inf_modifier_options_id` int(11) NOT NULL,
  `jumlah` int(11) NOT NULL,
  `total` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1

CREATE TABLE `trx_temp_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trx_order_id` varchar(191) NOT NULL,
  `user_id` int(11) NOT NULL,
  `inf_promo_id` int(11) DEFAULT NULL,
  `inf_item_id` int(11) NOT NULL,
  `inf_variant_id` int(11) NOT NULL,
  `inf_modifier_options_id` int(11) NOT NULL,
  `jumlah` int(11) NOT NULL,
  `total` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1