ColumnsKeyNameTypeDescriptionDefaultPK,FKproj_idintegerFK to PROJECT table - identifies the project PK,FKproj_catg_type_idintegerFK to PCATTYPE table - identifies the project code type FKproj_catg_idintegerFK to PCATVAL table - identifies the project code value update_datedateRefresh audit field of last date updated. Trigger maintained. update_userstring(255)Refresh audit field of last user updated. Trigger maintained. create_datedateRefresh audit field for date record created. Trigger maintained. create_userstring(255)Refresh audit field for user that created the record. Trigger maintained. delete_session_idintegerDeleted by session id. Client maintained. delete_datedateDeleted date. Client maintained.
Member for
16 years 3 monthsproject codes or activity
project codes or activity codes ?
here is the project code schema
ColumnsKeyNameTypeDescriptionDefaultPK,FKproj_idintegerFK to PROJECT table - identifies the project PK,FKproj_catg_type_idintegerFK to PCATTYPE table - identifies the project code type FKproj_catg_idintegerFK to PCATVAL table - identifies the project code value update_datedateRefresh audit field of last date updated. Trigger maintained. update_userstring(255)Refresh audit field of last user updated. Trigger maintained. create_datedateRefresh audit field for date record created. Trigger maintained. create_userstring(255)Refresh audit field for user that created the record. Trigger maintained. delete_session_idintegerDeleted by session id. Client maintained. delete_datedateDeleted date. Client maintained.
IndexesNameUniqueFieldsndx_projpcat_pcattypeNONUNIQUEproj_catg_type_idndx_projpcat_pcatvalNONUNIQUEproj_catg_idndx_projpcat_update_date1NONUNIQUEupdate_datendx_projpcat_dsiNONUNIQUEdelete_session_id,delete_datendx_projpcat_updNONUNIQUEupdate_date,delete_session_id
TriggersPRMAUD_PROJPCATORSQL Server RT_PROJPCAT_DELORSQL Server RT_PROJPCATORSQL Server
ConstraintsNameTypeFieldsTargetFieldsDelete ruleRefer TypeConditionpk_projpcatPRIMARYproj_id,proj_catg_type_id fk_projpcat_pcattypeFOREIGNproj_catg_type_idPCATTYPEproj_catg_type_id DEPENDENT fk_projpcat_pcatvalFOREIGNproj_catg_idPCATVALproj_catg_id DEPENDENT fk_projpcat_projectFOREIGNproj_idPROJECTproj_id DEPENDENT