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''') |
| 11 | * user_table('''__user_id__''', '''username''', '''name_user''', '''email''', '''password''', phone_number '''user_id'''*(administrator)) |
| 12 | * administrator('''__user_id__'''*(user)) |
| 13 | * customer('''__user_id__'''*(user)) |
| 14 | * delivery_man('''__user_id__'''*(user)) |
| 15 | * service_man('''__user_id__'''*(user)) |
| 16 | * warehouseman('''__user_id__'''*(user)) |
| 17 | * warehouse('''__warehouse_id__''', '''warehouse_location''') |
| 18 | * vehicle('''__vehicle_id__''', '''vehicle_model''', '''vehicle_service''', '''delivery_man_id'''*(delivery_man)) |
| 19 | * delivery('''__delivery_id__''', '''delivery_status''', '''delivery_address''', '''delivery_man_id'''*(delivery_man)) |
| 20 | * review('''__review_id__''', '''review_rating''', '''review_description''', '''customer_id'''*(customer), '''product_id'''*(product)) |
| 21 | * order_table('''__order_id__''', '''order_status''', '''order_date''', '''customer_id'''*(customer)) |
| 22 | * category('''__category_id__''', '''category_name''') |
| 23 | * subcategory('''__subcategory_id__''', '''subcategory_name''', '''category_id'''*(category)) |
| 24 | * manufacturer('''__manufacturer_id__''', '''manufacturer_name''') |
| 25 | * product('''__product_id__''', '''product_name''', '''product_description''', '''product_price''', '''product_image''', '''manufacturer_id'''*(manufacturer), '''service_man_id'''*(service_man)) |
| 26 | * vehicle_is_used_for_delivery('''__vehicle_id__'''*(vehicle), '''__delivery_id__'''*(delivery)) |
| 27 | * product_is_in_stock_in_warehouse('''__product_id__'''*(product), '''__warehouse_id__'''*(warehouse),'''quantity''') |
| 28 | * order_table_contains_product('''__order_id__'''*(order_table), '''__product_id__'''*(product)) |
| 29 | * product_is_in_category('''__product_id__'''*(product), '''__category_id__'''*(category)) |
| 30 | |