Procurement bids, evaluation and award audit
Retains evaluator declarations and bid-level scoring alongside final awards; uniqueness rules need database enforcement. Original worked design example; adapt responsibilities, thresholds and assumptions to your system.
Rendering…
What this template contains
- Diagram type
- Entity-relationship diagram
- Source
- 49 lines
Make it your own.
erDiagram
PROCUREMENT ||--o{ LOT : divides
LOT ||--o{ BID : receives
SUPPLIER ||--o{ BID : submits
BID ||--o{ EVALUATION : assessed_by
EVALUATOR ||--o{ EVALUATION : records
EVALUATOR ||--o{ DECLARATION : signs
PROCUREMENT ||--o{ DECLARATION : requires
LOT ||--o| AWARD : concludes
BID ||--o| AWARD : selected
PROCUREMENT {
string procurement_id PK
string method
}
LOT {
string lot_id PK
string procurement_id FK
}
BID {
string bid_id PK
string lot_id FK
string supplier_id FK
string submitted_at
}
SUPPLIER {
string supplier_id PK
string name
}
EVALUATION {
string evaluation_id PK
string bid_id FK
string evaluator_id FK
string score
}
EVALUATOR {
string evaluator_id PK
string name
}
DECLARATION {
string declaration_id PK
string evaluator_id FK
string procurement_id FK
}
AWARD {
string award_id PK
string lot_id FK
string bid_id FK
string reason
}