Standard PDM report
Table of Contents
The 'Table of contents' field needs to be updated!
PDM Graphes
Global model Graph
Graph of submodel Customer management
Graph of submodel Employee management
Lists of objects
Business Rule List
Name | Code | Type | Expr | U |
Test | TEST | Validation | Yes | Yes |
Table Compose
Name: Compose
Code: COMPOSE
Label:
Number:
PK constraint:
Source: Relationship COMPOSE
Column List
Name | Code | Type | P | M |
Material number | MATNUM | numeric(5) | Yes | Yes |
Composed Material number | COMPNUM | numeric(5) | Yes | Yes |
Column MATNUM
Column COMPNUM
Rule List
Name | Code | Type | Expr |
Test | TEST | Validation | Yes |
Index List
Index Code | P | F | U | C | Column Code | Sort |
COMPOSE_PK | Yes | No | Yes | No | MATNUM COMPNUM | ASC ASC |
Reference to List
Reference to | Primary Key | Foreign Key |
MATERIAL | MATNUM | COMPNUM |
MATERIAL | MATNUM | MATNUM |
Table Customer
Name: Customer
Code: CUSTOMER
Label:
Number:
PK constraint:
Source: Entity CUSTOMER
Column CUSNUM
Column CUSNAME
Column CUSADDR
Column CUSACT
Column CUSTEL
Column CUSFAX
Index List
Index Code | P | F | U | C | Column Code | Sort |
CUSTOMER_PK | Yes | No | Yes | No | CUSNUM | ASC |
Reference by List
Referenced by | Primary Key | Foreign Key |
PROJECT | CUSNUM | CUSNUM |
Table Division
Name: Division
Code: DIVISION
Label:
Number:
PK constraint:
Source: Entity DIVISION
Column DIVNUM
Column DIVNAME
Column DIVADDR
Index List
Index Code | P | F | U | C | Column Code | Sort |
DIVISION_PK | Yes | No | Yes | No | DIVNUM | ASC |
Reference by List
Referenced by | Primary Key | Foreign Key |
EMPLOYEE | DIVNUM | DIVNUM |
Table Employee
Name: Employee
Code: EMPLOYEE
Label:
Number:
PK constraint:
Source: Entity EMPLOYEE
Column EMPNUM
Column CHIEFNUM
Column DIVNUM
Column EMPFNAM
Column EMPLNAM
Column EMPFUNC
Column EMPSAL
Reference to List
Reference to | Primary Key | Foreign Key |
EMPLOYEE | EMPNUM | CHIEFNUM |
DIVISION | DIVNUM | DIVNUM |
Table Material
Name: Material
Code: MATERIAL
Label:
Number:
PK constraint:
Source: Entity MATERIAL
Column MATNUM
Column MATNAME
Column MATTYPE
Index List
Index Code | P | F | U | C | Column Code | Sort |
MATERIAL_PK | Yes | No | Yes | No | MATNUM | ASC |
Reference by List
Referenced by | Primary Key | Foreign Key |
COMPOSE | MATNUM | COMPNUM |
COMPOSE | MATNUM | MATNUM |
USED | MATNUM | MATNUM |
Table Member
Name: Member
Code: MEMBER
Label:
Number:
PK constraint:
Source: Relationship MEMBER
Column List
Name | Code | Type | P | M |
Team number | TEANUM | numeric(5) | Yes | Yes |
Employee number | EMPNUM | numeric(5) | Yes | Yes |
Column TEANUM
Column EMPNUM
Index List
Index Code | P | F | U | C | Column Code | Sort |
MEMBER_PK | Yes | No | Yes | No | TEANUM EMPNUM | ASC ASC |
Reference to List
Reference to | Primary Key | Foreign Key |
TEAM | TEANUM | TEANUM |
EMPLOYEE | EMPNUM | EMPNUM |
Table Participate
Name: Participate
Code: PARTICIPATE
Label:
Number:
PK constraint:
Source: Entity PARTICIPATE
Column PRONUM
Column TSKNAME
Column EMPNUM
Column PARBEG
Column PAREND
Index List
Index Code | P | F | U | C | Column Code | Sort |
PARTICIPATE_PK | Yes | No | Yes | No | PRONUM TSKNAME EMPNUM | ASC ASC ASC |
Reference to List
Reference to | Primary Key | Foreign Key |
EMPLOYEE | EMPNUM | EMPNUM |
TASK | PRONUM TSKNAME | PRONUM TSKNAME |
Table Project
Name: Project
Code: PROJECT
Label:
Number:
PK constraint:
Source: Entity PROJECT
Column PRONUM
Column CUSNUM
Column EMPNUM
Column PRONAME
Column PROLABL
Column PROBEG
Column PROEND
Reference to List
Reference to | Primary Key | Foreign Key |
EMPLOYEE | EMPNUM | EMPNUM |
CUSTOMER | CUSNUM | CUSNUM |
Reference by List
Referenced by | Primary Key | Foreign Key |
TASK | PRONUM | PRONUM |
Table Task
Name: Task
Code: TASK
Label:
Number:
PK constraint:
Source: Entity TASK
Column PRONUM
Column TSKNAME
Column TSKCOST
Index List
Index Code | P | F | U | C | Column Code | Sort |
TASK_PK | Yes | No | Yes | No | PRONUM TSKNAME | ASC ASC |
Reference to List
Reference to | Primary Key | Foreign Key |
PROJECT | PRONUM | PRONUM |
Reference by List
Referenced by | Primary Key | Foreign Key |
PARTICIPATE | PRONUM TSKNAME | PRONUM TSKNAME |
Table Team
Name: Team
Code: TEAM
Label:
Number:
PK constraint:
Source: Entity TEAM
Column List
Name | Code | Type | P | M |
Team number | TEANUM | numeric(5) | Yes | Yes |
Speciality | TEASPE | char(80) | No | No |
Column TEANUM
Column TEASPE
Index List
Index Code | P | F | U | C | Column Code | Sort |
TEAM_PK | Yes | No | Yes | No | TEANUM | ASC |
Reference by List
Referenced by | Primary Key | Foreign Key |
MEMBER | TEANUM | TEANUM |
Table Used
Name: Used
Code: USED
Label:
Number:
PK constraint:
Source: Relationship USED
Column List
Name | Code | Type | P | M |
Material number | MATNUM | numeric(5) | Yes | Yes |
Employee number | EMPNUM | numeric(5) | Yes | Yes |
Column MATNUM
Column EMPNUM
Index List
Index Code | P | F | U | C | Column Code | Sort |
USED_PK | Yes | No | Yes | No | MATNUM EMPNUM | ASC ASC |
Reference to List
Reference to | Primary Key | Foreign Key |
MATERIAL | MATNUM | MATNUM |
EMPLOYEE | EMPNUM | EMPNUM |