organism (organism_id, organism_name, organism_compagny, organism_email_address,
organism_siret, organism_telephone, organism_fax, organism_tva_intracom,
#customers_id)
personal (personal_id, personal_gender, personal_firstname, personal_lastname,
personal_dob, personal_email_address, personal_telephone, #customers_id)
customers ( customers_id, customers_password, customers_validation_code,
customers_validation)
customers_address (customers_address_id, customers_id, address_id)
address (address_id, address_street_address, address_suburb, address_postcode,
address_city, address_state, #countries_id)
countries (countries_id, countries_name, countries_iso_code_2, countries_iso_code_3,
#address_format_id)
address_format (address_format_id, address_format, address_summary)
orders ( orders_id, payment_method, date_purchased, last_modified, orders_date_finished)
orders_status_history (orders_status_history_id, orders_id, orders_status_id,
customer_notified, comments)
orders_status (orders_status_id, orders_status_name)
orders_invoice ( orders_invoice_id, date_invoice, #orders_id)
orders_products (orders_products _id, orders_id, products_id, products_name, final_price, products_tax)
products (products_id, products_quantity, products_model, products_image, products_price,
products_price_cost, products_cost, products_date_added, products_last_modified,
products_date_available, products_weight, products_status, products_ordered,
products_compare_status, products_compare_expedition)
orders_total ( orders_total_id, title, text, value, class, #orders_id)
Partager