To support this comment in this part we will create a property management application based on two major features of Symfony: generating classes (MNOs) from an existing database and generation of forms. I would like to give an example for creation of the database :
Code:
CREATE TABLE TYPE_BIEN (
idTypeWell INTEGER NOT NULL AUTO_INCREMENT
, LibTypeWell VARCHAR (255) NOT NULL
, PRIMARY KEY (IdTypeWell)
);
CREATE TABLE PROPERTY (
idWell INT NOT NULL AUTO_INCREMENT
, LibWell VARCHAR (255) NOT NULL
, DescriptionWell TEXT NOT NULL
, DateLimiteWell DATE NOT NULL
, Price FLOAT NOT NULL
, IdTypeWell INTEGER NOT NULL
, PRIMARY KEY (IdWell)
, INDEX (IdTypeWell)
, CONSTRAINT FOREIGN FK_WELL_1 KEY (IdTypeWell)
REFERENCES TYPE_WELL(idTypeWell)
);
Bookmarks