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