inquiry_history - bctone1/Garam_backend GitHub Wiki
| ํ๋ | ํค | ํ์ | ์ค๋ช |
|---|---|---|---|
| id | PK | BIGSERIAL | PK |
| inquiry_id | FK | BIGINT | FK โ inquiry.id, ON DELETE CASCADE |
| action | ย | TEXT | 'assign' / 'on_hold' / 'resume' / 'transfer' / 'complete' / 'note' / 'contact' / 'delete' |
| admin_id | FK | BIGINT | ์กฐ์น ๊ด๋ฆฌ์ FK โ admin_user.id, ON DELETE SET NULL |
| to_admin_id | FK | BIGINT | ์ด๊ด ๋์ ๊ด๋ฆฌ์ FK |
| details | ย | TEXT | ๋ฉ๋ชจ/์ฌ์ /์ฐ๋ฝ ๋ด์ฉ |
| created_at | ย | TIMESTAMPTZ, ๊ธฐ๋ณธ๊ฐ now() | ๊ธฐ๋ก ์๊ฐ |