Читайте также:
|
| Field Name | Data Type | Validation | Field length | Description |
| Product ID | Number | Identification of products(ID number) | ||
| Product name | Word | Name of products | ||
| CATEGORIES NAME | Word | Category of product | ||
| UNIT | Number | quantity of something; | ||
| DESCRIPTION | Word | other details; | ||
| PRICE | Number | How it cost | ||
| Images | image | photo |
3.9 UNF & 3NF Database Tables (with example data)
Table 20 Checkout
| User ID | User NAME | Product | status | Order reference |
| nurarys | Scanner of bar codes | checkedout | ||
| Printers of labels | checkedout | |||
| fiscal registrar | checkedout |
Table 21 Products
| PRODUCT ID | PRODUCT NAME | CATEGORIES NAME | UNIT | DESCRIPTION | PRICE | images |
| Equipment for shaped coding | shop equipment | The equipment for shaped coding will help you to provide the fastest identification of goods and data transmission in registration programs. | 
| |||
| Fiscal registrar | shop equipment | The modern fiscal registrar with the wide, representative check. It is intended for hyper - and supermarkets, minimarkets of various specialization, the entertainment and improving centres, hotels, catering establishments, a services sector. | 
| |||
| Printers of labels | shop equipment | Printers of labels will help you to supply a stroke - code labels the goods, which do not have industrial a stroke - code marking, to publish labels in any alphabet of a bar code and with an internal code. | 
|
Table 22 Order list
| User ID | User SURNAME | NOTES | E-mail address | User reference |
| Nurarys | 202cb962ac59075b964b07152d234b70 | Nurarys98@mail.ru | ||
| Nurik | c20ad4d76fe97759aa27a0c99bff6710 | Nurarys98@mail.ru | ||
| Aika | 37b096179792d7c6c7172b14a0fd5f41 | aiken_gul@mail.ru |
Дата добавления: 2015-08-18; просмотров: 83 | Нарушение авторских прав
| <== предыдущая страница | | | следующая страница ==> |
| Table 10 | | | List of files |