Affects Version/s: None
Fix Version/s: 1.0
KULRICE-4992 Review and rename tables/columns in master database KULRICE-1519 Rename KIM_NMSPCE_DLFT_ATTR_T.constraints.ddl to match table name KULRICE-6534 Rename KREW_STYLE_T table to KRCR_STYLE_T, change it's id column to a string, and change StyleContract.getStyleId to StyleContract.getId() returning a String instead of a Long KULRICE-7166 KRMS valid tables PKs and a few FKs need renaming KULRICE-8037 Analysis: Rename KRAD database tables KULRICE-1481 Add a new KIM_PERSONS_PRINCIPALS_T table KULRICE-3522 Drop application URL from KIM attribute definition table KULRICE-7042 Component name cannot be null on KIM type table KULRICE-5589 Rename TypeContract and Type classes in Kim to CodedAttributeContract and CodedAttribute KULRICE-1539 Refactor the KIM_GROUPS_PERSONS_T table to be named KIM_GROUPS_PRINCIPALS_T instead
As per discussion with Jonathan, there is really no need for this column to be named this way anymore on these tables as these tables reference specific foreign keys now. The name change should be:
KRIM_DLGN_MBR_ATTR_DATA_T.TARGET_PRIMARY_KEY -> DLGN_MBR_ID
KRIM_GRP_ATTR_DATA_T.TARGET_PRIMARY_KEY -> GRP_ID
KRIM_PERM_ATTR_DATA_T.TARGET_PRIMARY_KEY -> PERM_ID
KRIM_ROLE_MBR_ATTR_DATA_T.TARGET_PRIMARY_KEY -> ROLE_MBR_ID
KRIM_PND_ROLE_MBR_ATTR_DATA_MT.TARGET_PRIMARY_KEY -> ROLE_MBR_ID
KRIM_RSP_ATTR_DATA_T.TARGET_PRIMARY_KEY -> RSP_ID
A couple of things to remember here:
1) This needs to be updated in all 4 of our dbs that require updating (rice094dba, rice094dev, rice094ci, ricekulcli094dba)
2) We will also need to update any OJB and jpa mappings that point to these columns and any other files (probably just search the project for TARGET_PRIMARY_KEY)
3) We will want to include the update sql in the updates-during-qa filder
4) We will need to notify firstname.lastname@example.org as soon as this change is committed so that KFS will know that they need to update their database.
5) We will want to make this change fairly soon since it involves database changes.