CREATE TABLE `student` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `alu_codigo` int(11) NOT NULL,
  `alu_nombre` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `alu_nivel` int(11) NOT NULL,
  `alu_jornada` int(11) NOT NULL,
  `alu_genero` text COLLATE latin1_general_ci NOT NULL,
  `alu_fecnac` date NOT NULL,
  `alu_fecing` date NOT NULL,
  `alu_madre` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `alu_padre` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `alu_acudiente` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `alu_telefono` varchar(30) COLLATE latin1_general_ci NOT NULL,
  `alu_direccion` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `alu_email` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `alu_notas` TEXT COLLATE latin1_general_ci NOT NULL,
  `alu_cargos` int(11) NOT NULL,
  `alu_abonos` int(11) NOT NULL,
  `alu_saldo` int(11) NOT NULL,
  `alu_imagen` varchar(200) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cargos`
--

CREATE TABLE `position` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `car_alumno` int(4) NOT NULL,
  `car_consecutivo` int(11) NOT NULL,
  `car_concepto` int(11) NOT NULL,
  `car_fecha` date NOT NULL,
  `car_valor` int(11) NOT NULL,
  `car_cantidad` int(11) NOT NULL,
  `car_neto` int(11) NOT NULL,
  `car_descuento` int(11) NOT NULL,
  `car_adicional` int(11) NOT NULL,
  `car_total` int(11) NOT NULL,
  `car_notas` varchar(100) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `gastos`
--

CREATE TABLE `expenses` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gas_codigo` int(11) NOT NULL,
  `gas_fecha` date NOT NULL,
  `gas_concepto` int(11) NOT NULL,
  `gas_valor` int(11) NOT NULL,
  `gas_nota` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `gas_estado` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `jornada`
--

CREATE TABLE `time_range` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `jor_codigo` int(11) NOT NULL,
  `jor_nombre` varchar(50) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `nivel`
--

CREATE TABLE `level` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `niv_codigo` int(11) NOT NULL,
  `niv_nombre` varchar(50) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `pagos`
--

CREATE TABLE `payments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pag_alumno` int(11) NOT NULL,
  `pag_consecutivo` int(11) NOT NULL,
  `pag_fecha` date NOT NULL,
  `pag_formapago` int(11) NOT NULL,
  `pag_valor` int(11) NOT NULL,
  `pag_nota` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `pag_estado` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tarifas`
--

CREATE TABLE `rates` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tar_codigo` int(11) NOT NULL,
  `tar_concepto` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `tar_valor` int(11) NOT NULL,
  `tar_estado` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tipogasto`
--

CREATE TABLE `expense_cat` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tg_codigo` int(11) NOT NULL,
  `tg_concepto` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `tp_estado` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;