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