// Set primary key & seal schema:
static {
HFK_SCHEMA.setPrimaryKey(
PrimaryKey.WithColumnNames(
HFK_PROJECT_KEY_COLUMN,
HFK_FORM_POSITION_COLUMN,
HFK_RELATIONSHIP_FIELD_POSITION_COLUMN),
true /*seal!*/);
}
// Set primary key & seal schema:
static {
// Add index to enforce unique combination of project and correspondent:
SEND_SCHEDULE_SCHEMA.addIndex(
new Index(
"IdxProjectCorrespondent",
true,
SEND_SCHEDULE_COLUMN_PROJECT,
SEND_SCHEDULE_COLUMN_RECEIVER));
SEND_SCHEDULE_SCHEMA.setPrimaryKey(
new AutoIncrementingPrimaryKey("IDIdx", SEND_SCHEDULE_COLUMN_ID), true /*seal!*/);
}
// Add index, set primary key & seal schema:
static {
// Unique index to ensure name+variant+version combinations are unique:
PROJECT_SCHEMA.addIndex(
new Index(
"ProjectUnique",
true,
PROJECT_NAME_COLUMN,
PROJECT_VARIANT_COLUMN,
PROJECT_VERSION_COLUMN));
PROJECT_SCHEMA.setPrimaryKey(
PrimaryKey.WithColumnNames(PROJECT_ID_COLUMN, PROJECT_FINGERPRINT_COLUMN), true /*seal!*/);
}
// Set primary key & seal schema:
static {
FSI_SCHEMA.setPrimaryKey(
PrimaryKey.WithColumnNames(FSI_PROJECT_KEY_COLUMN, FSI_FORM_POSITION_COLUMN),
true /*seal!*/);
}