Examples of er.extensions.migration.ERXMigrationTable.addForeignKey()

Class er.extensions.migration.ERXMigrationTable

Examples of er.extensions.migration.ERXMigrationTable.addForeignKey()

er.extensions.migration.ERXMigrationTable.addForeignKey()
Executes the SQL operations to add this foreign key constraint (only supports single attribute FK's right now). @param sourceColumnName the source column name of the relationship @param destinationTableName the destination table of the relationship (should be the PK of the destination table) @param destinationColumnName the destination column of the relationship (should be the PK of the destination table) @throws SQLException if the add fails

    ERXMigrationTable employeeRoleTable = database.newTableNamed("EmployeeRole");
    employeeRoleTable.newIntegerColumn("employeeId", false);
    employeeRoleTable.newIntegerColumn("roleId", false);
    employeeRoleTable.create();
    employeeRoleTable.setPrimaryKey("employeeId", "roleId");
    employeeRoleTable.addForeignKey("employeeId", "Employee", "id");
    employeeRoleTable.addForeignKey("roleId", "Role", "id");


    ERXMigrationTable paycheckTable = database.newTableNamed("Paycheck");
    paycheckTable.newBigDecimalColumn("amount", 38, 2, false);
    paycheckTable.newBooleanColumn("cashed", false);

View Full Code Here

    employeeRoleTable.newIntegerColumn("employeeId", false);
    employeeRoleTable.newIntegerColumn("roleId", false);
    employeeRoleTable.create();
    employeeRoleTable.setPrimaryKey("employeeId", "roleId");
    employeeRoleTable.addForeignKey("employeeId", "Employee", "id");
    employeeRoleTable.addForeignKey("roleId", "Role", "id");


    ERXMigrationTable paycheckTable = database.newTableNamed("Paycheck");
    paycheckTable.newBigDecimalColumn("amount", 38, 2, false);
    paycheckTable.newBooleanColumn("cashed", false);
    paycheckTable.newIntegerColumn("employeeID", false);

View Full Code Here

    paycheckTable.newIntegerColumn("employeeID", false);
    paycheckTable.newIntegerColumn("id", false);
    paycheckTable.newTimestampColumn("paymentDate", false);
    paycheckTable.create();
    paycheckTable.setPrimaryKey("id");
    paycheckTable.addForeignKey("employeeID", "Employee", "id");
  }
}

View Full Code Here

0 1 2

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.