| id |
int(11)
|
|
|
|
| tender_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| title |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| description |
text
|
utf8mb4_unicode_ci
|
|
|
| tender_type |
enum('supply', 'maintenance', 'service', 'construction', 'other')
|
utf8mb4_unicode_ci
|
|
|
| department_id |
int(11)
|
|
|
|
| estimated_value |
decimal(14,2)
|
|
|
|
| publish_date |
date
|
|
|
|
| submission_deadline |
date
|
|
|
|
| opening_date |
date
|
|
|
|
| status |
enum('draft', 'published', 'closed', 'awarded', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| winner_supplier_id |
int(11)
|
|
|
|
| awarded_amount |
decimal(14,2)
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|