<?php

/** @Entity @Table(name="user") */
class User {
        /** @Id @Column(type="integer") @GeneratedValue */
        private $id;

        /** @Column(type="string", length=50) */
        private $username;

        /** @Column(type="string", length=255) */
        private $password;

        /** @OneToOne(targetEntity="Profile", inversedBy="user") */
        private $profile;
}

<?php

/** @Entity @Table(name="profile") */
class Profile {
        /** @Id @Column(type="integer") @GeneratedValue */
        private $id;

        /** @Column(type="string", length=2000) */
        private $link_to_avatar;

        /** @Column(type="string", length=50) */
        private $display_name;

        /** @Column(type="string", length=2000) */
        private $description;

        /** @OnToOne(targetEntity="User", mappedBy="profile") */
        private $user;
}

CREATE TABLE profile (id INT AUTO_INCREMENT NOT NULL, link_to_avatar VARCHAR(2000) NOT NULL, display_name VARCHAR(50) NOT NULL, description VARCHAR(2000) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, profile_id INT DEFAULT NULL, username VARCHAR(50) NOT NULL, password VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_8D93D649CCFA12B8 (profile_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
ALTER TABLE user ADD CONSTRAINT FK_8D93D649CCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id);

CREATE TABLE profile (id INT AUTO_INCREMENT NOT NULL, link_to_avatar VARCHAR(2000) NOT NULL, display_name VARCHAR(50) NOT NULL, description VARCHAR(2000) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, username VARCHAR(50) NOT NULL, password VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;