Changes between Version 22 and Version 23 of SQL & DDL


Ignore:
Timestamp:
06/08/25 13:00:33 (6 days ago)
Author:
213231
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • SQL & DDL

    v22 v23  
    2727- Status
    2828
    29 **Truck / Trailer**\\
    30 - Truck: ProductID (FK), HP
    31 - Trailer: ProductID (FK), Capacity
     29** Truck **
     30- ProductID (PK, FK → Product)
     31- HP
     32
     33** Trailer **
     34- ProductID (PK, FK → Product)
     35- Capacity
    3236
    3337**Procurement**\\
    3438- TransactionID (PK)
    35 - EmployeeID (FK)
    36 - CustomerID (FK)
    37 - ProductID (FK)
     39- EmployeeID (FK → Employee)
     40- CustomerID (FK → Customer)
     41- ProductID (FK → Product)
    3842- ProcurementDate
    3943- Quantity
     44- Status
     45- Notified
     46- GroupID
    4047
    4148**T_Type**\\
    42 - TransactionID (PK, FK)
     49- TransactionID (PK, FK → Procurement)
    4350- Type (Rent/Buy)
    4451- Duration (ако е Rent)
    … …  
    5764**Maintenance**\\
    5865- MainID (PK)
    59 - EmployeeID (FK)
    60 - ProductID (FK)
     66- EmployeeID (FK → Employee)
     67- ProductID (FK → Product)
    6168- MainDate
     69- Description
     70- Cost
     71- Status
     72- StartTime
     73- EndTime
    6274
    6375**Views**\\
    64 - CustomerID (PK, FK)
    65 - ProductID (PK, FK)
     76- CustomerID (PK, FK → Customer)
     77- ProductID (PK, FK → Product)
     78
     79* Wallet **\\
     80
     81- WalletID (PK)
     82- CustomerID (FK → Customer)
     83- Balance
     84- CardNumber
     85- ExpiryDate
     86- CVV
     87- CardHolderName
     88
    6689
    6790