= Логички и физички дизајн

== Релациска шема (со мапирачка трансформација) 

•  Примарни клучеви - bold и underline
•  Надворешни клучеви: bold и * до името на надворешниот клуч, во заграда табелата кон која покажува
•  Останати атрибути: bold



----


''User''(**__user_id__, name, surname, email, username, password**)

''Client''(**__client_number_id__**)

''Shipping_employee''(**__shipping_employee_id__**)

''Role''(**__id_role__**, **role_name, role_desc**)

''Online_stores''(**__store_id__, name, web_address, phone_number, email, social_media**)

''Shipping''(**__shipping_id__, location, date_from, date_to**)

''Payment''(**__payment_id__, info**)

''Category''(**__category_id__, category_name**)

''Store_employee''(**__store_employee_id__**, store_id*(online_stores))

''Catalogue''(**__catalogue_id__, catalogue_from, catalogue_to, type**, store_id*(online_stores))

''Shopping_bag''(**__shopping_id__, order_date, shipping_date, modified, client_number_id***(client))

''Product_in_store''(**__product_in_store_id__**, store_id*(online_stores), product_id*(product))

''Product''(**__product_id__, name, in_store, size, color**, category_id*(category))

''Price''(**__price_id__, price, price_from, price_to, product_in_store_id***(product_in_store))

''Works_as''(**__id_role*__**(role), **__store_employee_id*__**(store_employee), **works_from**, **works_to**)

''Carries''(**__shipping_employee_id*__**(shipping_employee), **__shipping_id*__**(shipping))

''Exists''(**__catalogue_id*__**(catalogue),**__product_in_store_id*__**(product_in_store))

''Order''(**__shopping_id*__**(shopping_bag), **__product_in_store_id*__**(product_in_store))