--
-- Host: 127.0.0.1    Database: escola
-- ------------------------------------------------------


--
-- Dumping data for table `contract_variables`
--

INSERT INTO `contract_variables` VALUES
(1,'Hoje','data_atual','current_date',NULL,NULL,NULL,NULL, 0, NULL),
(2,'Curso','curso','course,name','App\\Models\\Educacional','InstitutionClass','id','class_id', 0, 'InstitutionClass'),
(3,'Carga H','carga_horaria','hourly_load','App\\Models\\Educacional','InstitutionClass','id','class_id', 0, 'InstitutionClass'),
(4,'Data Início','data_inicio','start_date','App\\Models\\Educacional','InstitutionClass','id','class_id', 0, 'InstitutionClass'),
(5,'Previsão Término','previsao_termino','finish_date','App\\Models\\Educacional','InstitutionClass','id','class_id', 0, 'InstitutionClass'),
(6,'Turma','turma','name','App\\Models\\Educacional','InstitutionClass','id','class_id', 0, 'InstitutionClass'),
(7,'Razão Social','razao_social','razao_social','App','Cliente','id','cliente_id', 0, 'Institution'),
(8,'Fantasia','fantasia','fantasia','App','Cliente','id','cliente_id', 0, 'Institution'),
(9,'CNPJ','cnpj','cnpj','App','Cliente','id','cliente_id', 0, 'Institution'),
(10,'Logradouro Inst.','logradouro_instituicao','rua','App','Cliente','id','cliente_id', 0, 'Institution'),
(11,'Número Inst.','numero_instituicao','numero','App','Cliente','id','cliente_id', 0, 'Institution'),
(12,'Bairro Inst.','bairro_instituicao','bairro','App','Cliente','id','cliente_id', 0, 'Institution'),
(13,'Complemento Inst.','complemento_instituicao','complemento','App','Cliente','id','cliente_id', 0, 'Institution'),
(14,'Cep Inst.','cep_instituicao','cep','App','Cliente','id','cliente_id', 0, 'Institution'),
(15,'Cidade Inst.','cidade_instituicao','cityWithState','App','Cliente','id','cliente_id', 1, 'Institution'),
(16,'E-mail Inst.','email_instituicao','email','App','Cliente','id','cliente_id', 0, 'Institution'),
(17,'Nome Contratante','nome_contratante','full_name','App\\Models\\Educacional','User','id','student_id', 0, 'Student'),
(18,'CPF Contratante','cpf_contratante','cpf','App\\Models\\Educacional','User','id','student_id', 0, 'Student'),
(19,'RG Contratante','rg_contratante','rg','App\\Models\\Educacional','Person','educational_user_id','student_id', 0, 'Student'),
(20,'Data Nasc. Contratante','data_nasc_contratante','birth_date','App\\Models\\Educacional','Person','educational_user_id','student_id', 0, 'Student'),
(21,'Logradouro Contratante','logradouro_contratante','street','App\\Models\\Educacional','Person','educational_user_id','student_id', 0, 'Student'),
(22,'Número Contratante','numero_contratante','number','App\\Models\\Educacional','Person','educational_user_id','student_id', 0, 'Student'),
(23,'Bairro Contratante','bairro_contratante','district','App\\Models\\Educacional','Person','educational_user_id','student_id', 0, 'Student'),
(24,'Complemento Contratante','complemento_contratante','complement','App\\Models\\Educacional','Person','educational_user_id','student_id', 0, 'Student'),
(25,'Cep Contratante','cep_contratante','zip_code','App\\Models\\Educacional','Person','educational_user_id','student_id', 0, 'Student'),
(26,'Cidade Contratante','cidade_contratante','cityWithState','App\\Models\\Educacional','Person','educational_user_id','student_id', 1, 'Student'),
(27,'E-mail Contratante','email_contratante','email','App\\Models\\Educacional','User','id','student_id', 0, 'Student'),
(28,'Nome Responsável','nome_responsavel','full_name','App\\Models\\Educacional','User','id','responsible_id', 0, 'Responsible'),
(29,'CPF Responsável','cpf_responsavel','cpf','App\\Models\\Educacional','User','id','responsible_id', 0, 'Responsible'),
(30,'RG Responsável','rg_responsavel','rg','App\\Models\\Educacional','Person','educational_user_id','responsible_id', 0, 'Responsible'),
(31,'Data Nasc. Responsável','data_nasc_responsavel','birth_date','App\\Models\\Educacional','Person','educational_user_id','responsible_id', 0, 'Responsible'),
(32,'Logradouro Responsável','logradouro_responsavel','street','App\\Models\\Educacional','Person','educational_user_id','responsible_id', 0, 'Responsible'),
(33,'Número Responsável','numero_responsavel','number','App\\Models\\Educacional','Person','educational_user_id','responsible_id', 0, 'Responsible'),
(34,'Bairro Responsável','bairro_responsavel','district','App\\Models\\Educacional','Person','educational_user_id','responsible_id', 0, 'Responsible'),
(35,'Complemento Responsável','complemento_responsavel','complement','App\\Models\\Educacional','Person','educational_user_id','responsible_id', 0, 'Responsible'),
(36,'Cep Responsável','cep_responsavel','zip_code','App\\Models\\Educacional','Person','educational_user_id','responsible_id', 0, 'Responsible'),
(37,'Cidade Responsável','cidade_responsavel','cityWithState','App\\Models\\Educacional','Person','educational_user_id','responsible_id', 1, 'Responsible'),
(38,'E-mail Responsável','email_responsavel','email','App\\Models\\Educacional','User','id','responsible_id', 0, 'Responsible'),
(39,'Obs. Curso','observacao_curso','course,description','App\\Models\\Educacional','InstitutionClass','id','class_id', 0, 'InstitutionClass'),
(40,'Telefone Inst.','telefone_instituicao','telefone','App','Cliente','id','cliente_id', 0, 'Institution'),
(41,'Celular Inst.','celular_instituicao','celular','App','Cliente','id','cliente_id', 0, 'Institution'),
(42,'Telefone Contratante','telefone_contratante','phone_number','App\\Models\\Educacional','Person','educational_user_id','student_id', 0, 'Student'),
(43,'Celular Contratante','celular_contratante','cell_phone','App\\Models\\Educacional','Person','educational_user_id','student_id', 0, 'Student'),
(44,'Telefone Responsável','telefone_responsavel','phone_number','App\\Models\\Educacional','Person','educational_user_id','responsible_id', 0, 'Responsible'),
(45,'Celular Responsável','celular_responsavel','cell_phone','App\\Models\\Educacional','Person','educational_user_id','responsible_id', 0, 'Responsible');


