| id |
int(11)
|
|
|
|
| application_id |
int(11)
|
|
|
 浏览不相关的值
|
| type |
enum('maintenance', 'complaint', 'suggestion', 'other')
|
utf8mb4_unicode_ci
|
|
|
| category |
enum('plumbing', 'electrical', 'furniture', 'cleanliness', 'noise', 'security', 'internet', 'other')
|
utf8mb4_unicode_ci
|
|
|
| title |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| description |
text
|
utf8mb4_unicode_ci
|
|
|
| priority |
enum('low', 'medium', 'high', 'urgent')
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('open', 'in_progress', 'resolved', 'closed', 'rejected')
|
utf8mb4_unicode_ci
|
|
|
| assigned_to |
int(11)
|
|
|
|
| resolved_at |
timestamp
|
|
|
|
| resolution_notes |
text
|
utf8mb4_unicode_ci
|
|
|
| journal_entry_id |
int(11)
|
|
|
|
| maintenance_cost |
decimal(10,2)
|
|
|
|
| attachment |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
