wprzadka / shop_database Goto Github PK

start order with initial status

blacklist chosen ip

we have to implement autoincreasing primary keys

Should express the intensity of traffic on website

Functions:

• show_conversation_function

Views:

• average_response_time
• best_clients_view
• best_workers_view
• clients_per_city_view
• clients_per_country_view
• conversations_per_category_view
• logs_intensity

Procedures:

• add_to_blacklist_procedure
• add_worker_procedure
• register_client_procedure
• start_conversation

Triggers:

• archive_price
• auto_response
• check_attachment
• clients_activity
• update_product_status_trigger

validate data and insert to clients table

validate attachment

create new worker account

Show all messages connected to one conversation

Clients that have bought the most items

To decrease average response time just send auto message after message from user

start new conversation and send message to user

update product price and insert old to table

Modify add_new_order to add entries to order details

Remember to create all of the functions, triggers etc. in order of them appearing in the script

After keyword KEY we have sometimes space and sometimes not, we should change it so it will be the same form everywhere.

depends on quantity change status of product

Function that should return table with balance between two dates

Workers ordered by amount of sent messages/started conversations

change order status

• Add amount field to Product
• Add status field to Product
• Add default amount to Category

add string size for VARCHAR type tiles

update activity of certain user after transaction