Common Points

Table level view

Design a key one the basis of business process
Identify unique business process and design key on the basis of business process

Design a key one the basis of business process
Identify unique business process and design key on the basis of business process

Breakdown common columns for each system on BPM

Key :Primary Key   ,Identity complete business process management
Code:Foreign Key :Identity sub business process management for linking  of external services
Key No businessprocess1
Key No businessprocess2
Key No businessprocess3
Key No businessprocess4
Key No businessprocess5
Key No businessprocess5

Customer code 1 businessprocess6
Customer code 2 businessprocess7
destination code 1 businessprocess8
destination code 2 businessprocess9
source code 1 businessprocess10
source code 2 businessprocess11

Distributor code businessprocess10

Division Code  businessprocess11

Sales department code businessprocess12




Billing code businessprocess12


 billing code 1 businessprocess13
 billing code 2 businessprocess14

 agency code 1 businessprocess14
 agency code 2 businessprocess15


insurance company code 1 businessprocess16
insurance company code 2 businessprocess17

Owner code 1 businessprocess18
Owner code 2 businessprocess19

User code 1 businessprocess20
User code 2 businessprocess21

Vendor Code 1 businessprocess22
Vendor Code 2  businessprocess23

Maintenance  contractors code 1 businessprocess24
Maintenance  contractors code 2 businessprocess25

Sale disposal destination code 1 businessprocess26
Sale disposal destination code 2 businessprocess27

sales representative businessprocess28
Before user code 1 businessprocess29
Before user code 2 businessprocess30

Company identification code businessprocess31

Agency code 1 businessprocess32
Agency code 2  businessprocess33

Bank Code businessprocess34
Department code businessprocess35

Buyer code 1 businessprocess36
Buyer code 2 businessprocess37

Asset code
Vendor code
Group code
Management department code
Sales department code
Storage Department code
Location code

Payment code1
payment code 2

Payment destination customer 1
payment destination customer 2

Classification process  code
sales department code

Primary key design hints

Transfer foreign key derived as the result of BPM into primary key creation in separate table
sales department code :K

User table example


userid :k
name

BPMuserrelation table

Bpmid :k
columns 1
columns 2
userid

To get the value of name left outer join BPMuserrelation  with User
Simple User
User ID
User name
worCenter
Computer name
Workstation

Operation Date
Operation time
Updated mark
Delete mark
   create PGM
   create USER
   create Workstation
   create responsible
   creation date
   creation time
   change PGM
   DATA change
   change WSID
   change in charge
   change date
   change time



------------------------------------------
Operation Date
Operation time
Updated mark
Delete mark
   create PGM
   create USER
   create Workstation
   create responsible
   creation date
   creation time
   change PGM
   DATA change
   change WSID
   change in charge
   change date
   change time

-------------------------------------------------------

These above mentioned fields are common for all data either master data,BPM data or development enhancer data Or code generator data.

Object level view



Take out common columns of every table .
Define interface for it .
Provide implementation for different tables with same columns










System level view