ai비서
테이블 (5)
Clients (Untitled)
- tenant_id (Key) — serials — 기본 키 — NOT NULL
- client_name (Field) — varchar(250)
assigner (Untitled5)
- officer_id (Key) — num — 기본 키 — NOT NULL
- assigned_name (Field) — varchar(100)
client-task (Untitled4)
- clt_id (Key) — serials — 기본 키 — NOT NULL
- tenant_id (Key2) — serials — 외래 키 → Clients.tenant_id — NOT NULL
- task_id (Key3) — serials — 외래 키 → task.task_id — NOT NULL
- tscate_id (Key22) — serials — 외래 키 → task.tscate_id — NOT NULL
- officer_id (Key32) — num — 외래 키 → task.officer_id — NOT NULL
task (Untitled3)
- task_id (Key) — serials — 기본 키 — NOT NULL
- tscate_id (Key2) — serials — 외래 키 → task-category.tscate_id — NOT NULL
- officer_id (Key3) — num — 외래 키 → assigner.officer_id — NOT NULL
- task_name (Field) — text
- status (Field2) — enum — Approved, Running, Suspended, Review, Completed, Canceled
- priority (Field3)
- deadline (Field4) — Date
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- deleted_at (Field7) — timestamp
task-category (Untitled2)
- tscate_id (Key) — serials — 기본 키 — NOT NULL
- category_name (Field) — varchar(250)
- Field2