На головну

Column List

  1. Column DIVNUM
  2. Column List
  3. Column List
  4. Column PRONUM
  5. Draw lines between the columns to make true sentences about jobs in A opposite.
  6. III. Taking turns with your partner cover each of the columns and encourage each other to provide translation for the given words.
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

Name Code Type P M
Customer number
CUSNUM numeric(5) Yes Yes
Customer name
CUSNAME char(30) No Yes
Customer address
CUSADDR char(80) No Yes
Customer activity
CUSACT char(80) No No
Customer telephone
CUSTEL char(12) No No
Customer fax
CUSFAX 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

Name Code Type P M
Division number
DIVNUM numeric(5) Yes Yes
Division name
DIVNAME char(30) No Yes
Division address
DIVADDR char(80) No No


Column List | Column DIVNUM

Graph of submodel Employee management | Column List | Index List | Column PRONUM |

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