CREATE TABLE IF NOT EXISTS `datos_fiscales` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `razon_social` varchar(255) NOT NULL,
  `rfc` varchar(20) NOT NULL,
  `regimen_fiscal` varchar(10) DEFAULT NULL,
  `fecha_vigencia_certificado` datetime DEFAULT NULL,
  `calle` varchar(255) NOT NULL,
  `num_exterior` varchar(50) DEFAULT NULL,
  `num_interior` varchar(50) DEFAULT NULL,
  `codigo_postal` varchar(10) NOT NULL,
  `colonia` varchar(255) NOT NULL,
  `localidad` varchar(255) NOT NULL,
  `municipio` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `pais` varchar(100) NOT NULL DEFAULT 'MÉXICO',
  `diseno_factura` varchar(50) NOT NULL DEFAULT 'estandar',
  `certificado_path` varchar(255) DEFAULT NULL,
  `llave_path` varchar(255) DEFAULT NULL,
  `llave_password` text DEFAULT NULL,
  `escudo_path` varchar(255) DEFAULT NULL,
  `incluir_becas_descuentos` tinyint(1) NOT NULL DEFAULT 0,
  `activo` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
