Questions tagged as 'relacionamento'

Tagged questions
1
answer

Make relationship (0,1) in mysql workbench

I'm doing a project and started by modeling the database was all right up to the point of users that I was confused. Rules: general admin (access to all), admin company (access to all company events) and user (access to only one event). In th...
asked by 02.03.2016 / 13:46
1
answer

Relating multiple data from one table to one data from another with SQL

I needed to list, with SQL, the father, mother and spouse of a person together with their general data (eg name, address, telephone, email, father, mother, spouse, status). This data is in another table called dependent, each one related to t...
asked by 13.05.2015 / 18:50
1
answer

I can not make search work with eloquent and relationship !!! Laravel 5.5 and mysql

I am doing a search by taking a word part and playing in a search type LIKE for fields fields. I use Eloquent and relationships, but it does not bring the data. { $pesquisa = $dataForm['pesquisa']; $atestados = Atestad...
asked by 19.12.2018 / 12:07
1
answer

Create a new table for optional values

Having trouble creating a new table for fields that are not required? For example in the address table (cod_endereco, pasadouro, cep, number, complement) where complement is an optional field, and when a user inserts data the table does not have...
asked by 06.07.2018 / 04:26
1
answer

Insert in related tables

That's right, I'm not sure how to do this. tb_Customer(id_Customer INTEGER [PK], nm_Customer VARCHAR, cpf_cnpj NUMERIC) dm_address_type(cd_address_type CHAR(1) [PK], ds_address_type VARCHAR) tb_customer_address(id_customer [PFK], cd_address...
asked by 13.05.2018 / 16:30
2
answers

Error in customizing the default user registry Laravel Auth

Error after registering and redirecting PS: it does the registration normally, and I can access normally, but this error always! I MAKE A MODIFICATION ONLY IN THE USER REGISTRATION, MAKE THE PARAMETERIZATION OF MY MANY TO MANY R...
asked by 08.03.2018 / 13:26
1
answer

Software to create relationship and MySQL DB structure

I am with a project in mind and would like to map the data and create the relationship of the tables, even if only visually before developing the pages, could you indicate me a software (I think the concept is mer) preferably free me help to vis...
asked by 24.02.2018 / 00:07
3
answers

Display products from various categories

This is my first post, I've been trying to solve a problem for some time now, but without success. I have the CATEGORIES table and the PRODUCTS table I need to display the following way: CATEGORY 1 - Produto 1 - Produto 2 CATEGORY...
asked by 23.04.2018 / 22:17
1
answer

Can I use select in relationship in laravel?

I have a model that takes the data with a with in laravel, to get correlated data, is there form of this correlated data to see only some specific fields and not all the data in the table? I tried to do so: return ModelPai::with(array('nome...
asked by 19.10.2017 / 14:27
1
answer

BelongsToMany Laravel 5.4 Class 'Department :: class' not found

I have several 4 tables Starting with Users - > Departments - > category_department - > category - > postings; Where the department_category table it serves as pivo for many to many relationship between the departments table and the...
asked by 11.09.2017 / 19:06