Table Mapping using Doctrine 2, in Symfony 2 in YAML

Hello techs,

I hope you are doing good ­čÖé ┬áRecently, I have been working on a Symfony 2 project and in Symfony 2, the data layer is managed by using┬áDoctrine ORM. So today, I planned to post an article on how to correctly map an existing data table using Doctrine 2.x object relationship mapping (ORM) techniques. ┬áLater, (in next post) I will be showing how to map a relationship such as one-to-one, one-to-many, many-to-one, unidirectional and bidirectional using the same Doctrine ORM techniques.

Before continuing the Doctrine mapping procedure, we need a pre built table. This table can be any database format. For the sake of easiness I will be using a very simple MySQL data table. ┬áThe name of the table is ‘user’ and table looks like this,


Column Name Data Type Attributes
id integer primary key, auto increment, not null
first_name string not null
last_name string not null
email string
mobile Integer length 11
date_of_birth date
f_key_1 Integer unique

Continue reading