12 lines
516 B
SQL
12 lines
516 B
SQL
-- BizMatch Phase 2 — module 6a: NDAs arrive from Dropbox Sign
|
|
--
|
|
-- dropbox_sign_id is the import anchor: UNIQUE, so the same signature request
|
|
-- can never be imported twice, and NULL for every round entered by hand.
|
|
|
|
ALTER TABLE nda
|
|
ADD COLUMN dropbox_sign_id text UNIQUE,
|
|
ADD COLUMN signer_name text,
|
|
-- A declined round keeps status SENT (it was never signed) but must be
|
|
-- distinguishable from one that is merely still outstanding.
|
|
ADD COLUMN declined boolean NOT NULL DEFAULT false;
|