CREATE TABLE IF NOT EXISTS `mydb`.`ROLE` (
  `ID` BIGINT NOT NULL AUTO_INCREMENT,
  `ROLE_NAME` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`ID`))
ENGINE = InnoDB

CREATE TABLE IF NOT EXISTS `mydb`.`USER` (
  `ID` BIGINT NOT NULL AUTO_INCREMENT,
  `LOGIN` VARCHAR(45) NOT NULL,
  `PASSWORD` VARCHAR(45) NOT NULL,
  `IS_ACTIVE` TINYINT(1) NOT NULL DEFAULT false,
  `ROLE_ID` BIGINT NOT NULL,
  PRIMARY KEY (`ID`),
  INDEX `fk_USER_ROLE1_idx` (`ROLE_ID` ASC),
  CONSTRAINT `fk_USER_ROLE1`
    FOREIGN KEY (`ROLE_ID`)
    REFERENCES `mydb`.`ROLE` (`ID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB

CREATE TABLE IF NOT EXISTS `mydb`.`USER_DETAILS` (
  `ID` BIGINT NOT NULL AUTO_INCREMENT,
  `FIRST_NAME` VARCHAR(45) NULL,
  `LAST_NAME` VARCHAR(45) NULL,
  `EMAIL` VARCHAR(45) NULL,
  `DATE_REG_TIMESTAMP` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `PAY_CODE` VARCHAR(45) NULL,
  `MONEY` DECIMAL(6,2) NOT NULL DEFAULT 0.0000,
  `INVITE_COUNT` INT NULL DEFAULT 0,
  `USER_ID` BIGINT NOT NULL,
  PRIMARY KEY (`ID`),
  INDEX `fk_USER_DETAILS_USER_idx` (`USER_ID` ASC),
  CONSTRAINT `fk_USER_DETAILS_USER`
    FOREIGN KEY (`USER_ID`)
    REFERENCES `mydb`.`USER` (`ID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.myapp.model.entity">
    <class name="com.myapp.model.entity.Role" table="ROLE">
        <id name="id" column="ID">
            <generator class="identity"/>
        </id>
        <property name="roleName" type="string" column="ROLE_NAME" />
        <set name="userCollection">
            <key>
                <column name="ROLE_ID" />
            </key>
            <one-to-many class="com.myapp.model.entity.User" />
        </set>
    </class>

    <query name="Role.getAll"><![CDATA[
        from Role
    ]]></query>
    <query name="Role.deleteById"><![CDATA[
        delete from Role r where r.id = id
    ]]></query>
</hibernate-mapping>

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.myapp.model.entity">
    <class name="com.myapp.model.entity.User" table="USER">
        <id name="id" column="ID">
            <generator class="identity"/>
        </id>
        <property name="login" type="string" column="LOGIN"/>
        <property name="password" type="string" column="PASSWORD"/>
        <property name="isActive" type="boolean" column="IS_ACTIVE"/>
        <many-to-one name="role" class="com.myapp.model.entity.Role" column="ROLE_ID" cascade="none" />
        <one-to-one name="userDetails" class="com.myapp.model.entity.UserDetails" cascade="save-update"/>
        <one-to-one name="activationCode" class="com.myapp.model.entity.ActivationCode"/>
        <set name="sessionCollection">
            <key>
                <column name="USER_ID" />
            </key>
            <one-to-many class="com.myapp.model.entity.Session"/>
        </set>
        <set name="fileCollection">
            <key>
                <column name="USER_ID" />
            </key>
            <one-to-many class="com.myapp.model.entity.File"/>
        </set>
        <set name="inviteCollection">
            <key>
                <column name="USER_ID" />
            </key>
            <one-to-many class="com.myapp.model.entity.Invite" />
        </set>
    </class>

    <query name="User.getAll"><![CDATA[
        from User
    ]]></query>
    <query name="User.deleteById"><![CDATA[
        delete from User u where u.id = :id
    ]]></query>
</hibernate-mapping>

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.myapp.model.entity">
    <class name="com.myapp.model.entity.UserDetails" table="USER_DETAILS">
        <id name="id" column="ID">
            <generator class="identity"/>
        </id>
        <property name="firstName" type="string" column="FIRST_NAME" />
        <property name="lastName" type="string" column="LAST_NAME" />
        <property name="email" type="string" column="EMAIL" />
        <property name="dateRegistration" type="timestamp" column="DATE_REG_TIMESTAMP" />
        <property name="payCode" type="string" column="PAY_CODE" />
        <property name="money" type="java.math.BigDecimal" column="MONEY" />
        <property name="inviteCount" type="integer" column="INVITE_COUNT" />
        <one-to-one name="user" class="com.myapp.model.entity.User" />
    </class>
</hibernate-mapping>

        Role role = roleDao.get(1L);

        User user = new User();
        user.setRole(role);
        user.setIsActive(true);
        user.setLogin("CommonUser");
        user.setPassword("e899071ad51c959adfeed6e6627fe858");

        UserDetails userDetails = new UserDetails();
        userDetails.setDateRegistration(new Date());
        userDetails.setMoney(new BigDecimal(0));

        userDetails.setUser(user);
        user.setUserDetails(userDetails);

        userDao.saveOrUpdate(user); // на уровне DAO происходит getSession().saveOrUpdate(...);

        return userDao.get(1L);