| | 1 | = Логички и физички дизајн |
| | 2 | |
| | 3 | === Релациска шема |
| | 4 | |
| | 5 | > Primary key: __underline [[br]] |
| | 6 | > Foreign key: * [[br]] |
| | 7 | > not null: '''bold''' [[br]] |
| | 8 | |
| | 9 | ---- |
| | 10 | |
| | 11 | * User('''__user_id__''', '''username''', '''name_user''', '''email''', '''password''', phone_number) |
| | 12 | * Administrator('''__user_id__'''*(user)) |
| | 13 | * Custimer('''__user_id__'''*(user)) |
| | 14 | * Delivery Man('''__user_id__'''*(user)) |
| | 15 | * Warehouseman('''__user_id__'''*(user)) |
| | 16 | * Warehouse('''__warehouse_id__''', '''warehouse_location''') |
| | 17 | * Product('''__product_id__''', '''product_name''', '''product_description''') |
| | 18 | * Manufacturer('''__manufacturer_id__''', '''manufacturer_name''') |
| | 19 | * Price('''__price_id__''', '''amount''') |
| | 20 | * Category('''__category_id__''', '''category_name''') |
| | 21 | * Vehicle('''__vehicle_id__''', '''vehicle_model''') |
| | 22 | * Delivery('''__delivery_id__''', '''delivery_status''', '''delivery_address''') |
| | 23 | * Location('''__location_id__''', '''location_address''') |
| | 24 | * Review('''__review_id__''', '''review_rating''', '''review_description''') |
| | 25 | * Order('''__order_id__''', '''order_status''', '''order_date''') |
| | 26 | * Subcategory('''__subcategory_id__''', '''subcategory_name''') |
| | 27 | * Picture('''__picture_id__''', '''picture_filepath''') |
| | 28 | |
| | 29 | === DDL скрипта за бришење и креирање на табелите |
| | 30 | > [attachment:kreiranje_v1.jpg kreiranje] |
| | 31 | === DML скрипта за полнење на табелите со податоци |
| | 32 | > [attachment:polnenje_v1.jpg polnenje] |
| | 33 | === Релациски дијаграм |
| | 34 | > [attachment:schema_v1.jpg schema] |
