| id |
bigint(20)
|
|
|
|
| decision_number |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| title |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| description |
text
|
utf8mb4_unicode_ci
|
|
|
| session_id |
bigint(20)
|
|
|
|
| status |
enum('new', 'in_progress', 'completed', 'approved', 'cancelled', 'reserved')
|
utf8mb4_unicode_ci
|
|
|
| type |
enum('executive', 'informational')
|
utf8mb4_unicode_ci
|
|
|
| priority |
enum('low', 'medium', 'high', 'urgent')
|
utf8mb4_unicode_ci
|
|
|
| deadline |
date
|
|
|
|
| supervisor_id |
bigint(20)
|
|
|
|
| created_by |
bigint(20)
|
|
|
|
| is_cancelled |
tinyint(1)
|
|
|
|
| cancellation_reason |
text
|
utf8mb4_unicode_ci
|
|
|
| cancellation_date |
date
|
|
|
|
| replaced_by_decision_id |
bigint(20)
|
|
|
|
| replaced_by_session_number |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| replaced_by_session_date |
date
|
|
|
|
| started_at |
timestamp
|
|
|
|
| completed_at |
timestamp
|
|
|
|
| approved_at |
timestamp
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| parent_id |
bigint(20)
|
|
|
|
| deleted_at |
timestamp
|
|
|
|