Курсовая работа: Информационная система "Книга рецептов"

CREATE C_Recipe.p no no

WRITE W_Recipe.p no no

============================= FIELD SUMMARY =============================

============================= Table: Recipe =============================

Flags: <c>ase sensitive, <i>ndex component, <m>andatory, <v>iew component

Order Field Name Data Type Flags Format Initial

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

10 prod_code inte im ->,>>>,>>9 0

20 dish_code inte im ->,>>>,>>9 0

30 needed_amount deci-2 ->,>>>,>>9.99 0

Field Name Label Column Label

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

prod_code код продукта код продукта

dish_code код блюда код блюда

needed_amount необходимое количество необходимое количество

============================= INDEX SUMMARY =============================

============================= Table: Recipe =============================

Flags: <p>rimary, <u>nique, <w>ord, <a>bbreviated, <i>nactive, + asc, - desc

Flags Index Name Cnt Field Name

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

pu XPKRecipe 2 + prod_code

+ dish_code

** Index Name: XPKRecipe

Storage Area: N/A

============================= FIELD DETAILS =============================

============================= Table: Recipe =============================

============================= SEQUENCES =================================