Activiti

define table/column naming strategy

Details

  • Type: Task Task
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: None
  • Fix Version/s: 5.0.beta1
  • Component/s: Engine
  • Labels:
    None
  • Number of attachments :
    0

Description

The strategy for naming db tables and columns should be documented explicitely.

ACT_PROCESSDEFINITION and other table names are longer then 18, which is a problem in DB2 V7. That should be changed to less then 18 chars.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Tom Baeyens added a comment -

Here's the final verdict on the prefixes:

ID --> Identity
HI --> History
GE --> General
RE --> Repository
RU --> Runtime

ACT_ID_GROUP --> ACT_ID_GROUP
ACT_ID_MEMBERSHIP --> ACT_ID_MEMBERSHIP
ACT_ID_USER --> ACT_ID_USER
ACT_H_PROCINST --> ACT_HI_PROC_INST
ACT_H_ACTINST --> ACT_HI_ACT_INST
ACT_PROPERTY --> ACT_GE_PROPERTY
ACT_BYTEARRAY --> ACT_GE_BYTEARRAY
ACT_DEPLOYMENT --> ACT_RE_DEPLOYMENT
ACT_PROCESSDEFINITION --> ACT_RE_PROC_DEF
ACT_EXECUTION --> ACT_RU_EXECUTION
ACT_JOB --> ACT_RU_JOB
ACT_TASK --> ACT_RU_TASK
ACT_TASKINVOLVEMENT --> ACT_RU_TASK_IVMNT
ACT_VARIABLE --> ACT_RU_VARIABLE

Show
Tom Baeyens added a comment - Here's the final verdict on the prefixes: ID --> Identity HI --> History GE --> General RE --> Repository RU --> Runtime ACT_ID_GROUP --> ACT_ID_GROUP ACT_ID_MEMBERSHIP --> ACT_ID_MEMBERSHIP ACT_ID_USER --> ACT_ID_USER ACT_H_PROCINST --> ACT_HI_PROC_INST ACT_H_ACTINST --> ACT_HI_ACT_INST ACT_PROPERTY --> ACT_GE_PROPERTY ACT_BYTEARRAY --> ACT_GE_BYTEARRAY ACT_DEPLOYMENT --> ACT_RE_DEPLOYMENT ACT_PROCESSDEFINITION --> ACT_RE_PROC_DEF ACT_EXECUTION --> ACT_RU_EXECUTION ACT_JOB --> ACT_RU_JOB ACT_TASK --> ACT_RU_TASK ACT_TASKINVOLVEMENT --> ACT_RU_TASK_IVMNT ACT_VARIABLE --> ACT_RU_VARIABLE

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Codehaus. Try JIRA - bug tracking software for your team.