CREATE TABLE IF NOT EXISTS `tax_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `org_id` varchar(50) NOT NULL,
  `pan` varchar(10) DEFAULT NULL,
  `tan` varchar(10) DEFAULT NULL,
  `tds_circle` varchar(3) DEFAULT NULL,
  `tds_ao_code` varchar(2) DEFAULT NULL,
  `tds_ao_number` varchar(3) DEFAULT NULL,
  `tds_ao_type` varchar(2) DEFAULT NULL,
  `tax_payment_frequency` varchar(20) NOT NULL DEFAULT 'Monthly',
  `deductor_type` enum('employee','non-employee') NOT NULL DEFAULT 'employee',
  `deductor_name` varchar(150) DEFAULT NULL,
  `deductor_father_name` varchar(150) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_tax_org` (`org_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
