На головну

Index List

  1. Http://www.sno.pro1.ru/lib/fest/index.htm
  2. Indexliste
  3. Liste des index
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

Name Code Type P M
Project number
PRONUM numeric(5) Yes Yes
Customer number
CUSNUM numeric(5) No Yes
Employee number
EMPNUM numeric(5) No No
Project name
PRONAME char(30) No Yes
Project label
PROLABL char(80) No No
Start date
PROBEG timestamp No No
End date
PROEND timestamp No No

Column PRONUM

Column CUSNUM

Column EMPNUM

Column PRONAME

Column PROLABL

Column PROBEG

Column PROEND

Index List

Index Code P F U C Column Code Sort
PROJECT_PK
Yes No Yes No PRONUM ASC
PROJECT_FK1
No Yes No No CUSNUM ASC
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

Name Code Type P M
Project number
PRONUM numeric(5) Yes Yes
Task name
TSKNAME char(30) Yes Yes
Task cost
TSKCOST numeric(8,2) No Yes


Column List | Column PRONUM

Graph of submodel Employee management | Column List | Column List | Column DIVNUM |

© um.co.ua - учбові матеріали та реферати