globalteam

Tables (8)

attorneys

  • id — SERIAL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100)
  • created_at — TIMESTAMPTZ — NOT NULL

clients

  • id — SERIAL
  • name — VARCHAR(100) — NOT NULL
  • industry — VARCHAR(50) — NOT NULL
  • attorney_id — INTEGER — Foreign key → attorneys.id
  • created_at — TIMESTAMPTZ — NOT NULL

lag_comments

  • id — SERIAL
  • lag_id — INTEGER — Foreign key → lags.id — NOT NULL
  • attorney_id — INTEGER — Foreign key → attorneys.id
  • text — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

lags

  • id — SERIAL
  • matter_id — INTEGER — Foreign key → matters.id
  • attorney_id — INTEGER — Foreign key → attorneys.id
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • law — VARCHAR(200)
  • urgency — lag_urgency — NOT NULL
  • status — lag_status — NOT NULL
  • resolution — TEXT
  • resolved_by — VARCHAR(100)
  • resolved_date — DATE
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

matter_areas

  • id — SERIAL
  • name — VARCHAR(100) — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

matters

  • id — SERIAL
  • client_id — INTEGER — Foreign key → clients.id — NOT NULL
  • attorney_id — INTEGER — Foreign key → attorneys.id
  • title — VARCHAR(200) — NOT NULL
  • area — matter_area — NOT NULL
  • status — matter_status — NOT NULL
  • priority — matter_priority — NOT NULL
  • start_date — DATE
  • due_date — DATE
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

meeting_attorneys

  • meeting_id — INTEGER — Foreign key → meetings.id — NOT NULL
  • attorney_id — INTEGER — Foreign key → attorneys.id — NOT NULL

meetings

  • id — SERIAL
  • client_id — INTEGER — Foreign key → clients.id — NOT NULL
  • matter_id — INTEGER — Foreign key → matters.id
  • title — VARCHAR(200) — NOT NULL
  • date — DATE — NOT NULL
  • needs — TEXT
  • insights — TEXT
  • actions — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL