Global model Graph

 

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 List

  Division DIVISION   Employee EMPLOYEE   Material MATERIAL

Reference List

  Member MEMBER EMPLOYEE MEMBER   Member MEMBER2 TEAM MEMBER   Relation_11 RELATION_11 EMPLOYEE EMPLOYEE

Column List

  CUSACT char(80)   CUSADDR char(80)   CUSFAX char(12)

Trigger List

  EMPLOYEE tib_employee No   EMPLOYEE tub_employee No   MEMBER tib_member No

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 List

  Customer address CUSADDR char(80) No Yes   Customer activity CUSACT char(80) No …   Customer telephone CUSTEL char(12) No No

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 List

  Division address DIVADDR char(80) No No  

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 List

  Division number DIVNUM numeric(5) No Yes   First name EMPFNAM char(30) No No   Last name EMPLNAM char(30) No Yes

Column EMPNUM

Column CHIEFNUM

Column DIVNUM

Column EMPFNAM

Column EMPLNAM

Column EMPFUNC

Column EMPSAL

Index List

  EMPLOYEE_FK2 No Yes No No DIVNUM ASC  

Reference to List

 

 

Reference to	Primary Key	Foreign Key
EMPLOYEE
EMPNUM	CHIEFNUM
DIVISION
DIVNUM	DIVNUM

Reference by List

  PROJECT EMPNUM EMPNUM   PARTICIPATE EMPNUM EMPNUM   USED EMPNUM EMPNUM

Table Material

Name: Material
Code: MATERIAL
Label:
Number:
PK constraint:
Source: Entity MATERIAL

 

Column List

  Material type MATTYPE char(30) No Yes  

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 List

  Employee number EMPNUM numeric(5) Yes Yes   Start date PARBEG timestamp No No   End date PAREND timestamp No No

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 List

  Employee number EMPNUM numeric(5) No No   Project name PRONAME char(30) No Yes …   Project label PROLABL char(80) No No

Column PRONUM

Column CUSNUM

Column EMPNUM

Column PRONAME

Column PROLABL

Column PROBEG

Column PROEND

Index List

  PROJECT_FK2 No Yes No No EMPNUM ASC  

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 List

  Task cost TSKCOST numeric(8,2) No Yes  

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