| id |
int(11)
|
|
|
|
| folio |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| id_empresa |
int(11)
|
|
|
|
| id_convenio |
int(11)
|
|
|
|
| fecha_elaboracion |
date
|
|
|
|
| fecha_envio |
date
|
|
|
|
| fecha_vigencia |
date
|
|
|
|
| fecha_respuesta |
date
|
|
|
|
| subtotal |
decimal(12,2)
|
|
|
|
| iva |
decimal(12,2)
|
|
|
|
| total |
decimal(12,2)
|
|
|
|
| tipo_precio |
enum('por_alumno', 'paquete', 'mixto')
|
utf8mb4_general_ci
|
|
|
| cantidad_alumnos |
int(11)
|
|
|
|
| observaciones |
text
|
utf8mb4_general_ci
|
|
|
| estatus |
enum('borrador', 'enviada', 'aprobada', 'rechazada')
|
utf8mb4_general_ci
|
|
|
| motivo_rechazo |
text
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| created_by |
int(11)
|
|
|
|
| updated_at |
datetime
|
|
|
|
| updated_by |
int(11)
|
|
|
|
| enabled |
tinyint(1)
|
|
|
|
