1. The 'customer' table holds information about each customer, including their ID, name, gender, and driving age.

  2. The 'bidding' table records repair bids made by customers. This includes the customer's ID, the TimID of the repair, the repair's start and estimated end dates, estimated material costs, estimated labor costs, and the estimated total cost.

  3. The 'billing' table records the amount billed to each customer for their repairs. This includes the customer's ID and the TimID of the repair.

  4. The 'Tim' table stores information about each technician, such as their ID.

  5. The 'supplier' table contains details about suppliers, including their ID, the material names they provide, the price of each material, the supplier's total amount, and their monthly payment.

  6. The 'shopping list' table records items purchased by technicians from suppliers. This includes the supplier ID, TimID, and the amount purchased.

Automotive Repair Database: Customers, Bids, Billing, Technicians, Suppliers & Shopping Lists

原文地址: https://www.cveoy.top/t/topic/nztz 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录