| Field | Type | Null | Key | Default | Extra |
|---|
| id | id | int(11) | int(11) | NO | NO | PRI | PRI | | | auto_increment | auto_increment |
| kode_meeting | kode_meeting | varchar(50) | varchar(50) | NO | NO | UNI | UNI | | | | |
| tanggal | tanggal | date | date | NO | NO | MUL | MUL | | | | |
| waktu_mulai | waktu_mulai | time | time | YES | YES | | | | | | |
| waktu_selesai | waktu_selesai | time | time | YES | YES | | | | | | |
| tempat | tempat | varchar(255) | varchar(255) | NO | NO | | | | | | |
| jenis_meeting | jenis_meeting | enum('internal','external','customer','supplier','planning','review') | enum('internal','external','customer','supplier','planning','review') | YES | YES | MUL | MUL | internal | internal | | |
| status | status | enum('planned','ongoing','completed','cancelled') | enum('planned','ongoing','completed','cancelled') | YES | YES | MUL | MUL | planned | planned | | |
| pic_meeting | pic_meeting | int(11) | int(11) | YES | YES | MUL | MUL | | | | |
| customer_id | customer_id | int(11) | int(11) | YES | YES | MUL | MUL | | | | |
| supplier_id | supplier_id | int(11) | int(11) | YES | YES | MUL | MUL | | | | |
| created_by | created_by | int(11) | int(11) | NO | NO | MUL | MUL | | | | |
| created_at | created_at | datetime | datetime | NO | NO | | | current_timestamp() | current_timestamp() | | |
| updated_at | updated_at | datetime | datetime | YES | YES | | | | | on update current_timestamp() | on update current_timestamp() |
| Field | Type | Null | Key | Default | Extra |
|---|
| id | id | int(11) | int(11) | NO | NO | PRI | PRI | | | auto_increment | auto_increment |
| meeting_id | meeting_id | int(11) | int(11) | NO | NO | MUL | MUL | | | | |
| urutan | urutan | int(11) | int(11) | NO | NO | MUL | MUL | 1 | 1 | | |
| subject | subject | varchar(255) | varchar(255) | NO | NO | | | | | | |
| detail_subject | detail_subject | text | text | YES | YES | | | | | | |
| status_agenda | status_agenda | enum('pending','discussed','completed','postponed') | enum('pending','discussed','completed','postponed') | YES | YES | | | pending | pending | | |
| pic_agenda | pic_agenda | int(11) | int(11) | YES | YES | MUL | MUL | | | | |
| deadline | deadline | date | date | YES | YES | | | | | | |
| prioritas | prioritas | enum('low','medium','high','urgent') | enum('low','medium','high','urgent') | YES | YES | | | medium | medium | | |