client

Keeps track of all clients of a particular user.

Clients are a special kind of user; this allows a client to access photos that are otherwise not available to the public.

(Note that this will go away in the future via the permission modem rewrite, see 8.)

CREATE TABLE client (
  identifier            integer NOT NULL PRIMARY KEY,
  users                 integer NOT NULL REFERENCES users(identifier),
  client                integer NOT NULL REFERENCES users(identifier), -- client of user
  date_of_creation      timestamp,
  STATUS                integer NOT NULL REFERENCES client_status(identifier),
  TRUSTED               char CHECK (TRUSTED IN ('t', 'f'));
);

• client references users(identifier)
• status references client_status(identifier)
• users references users(identifier)

None.

• client_id_sequence

• client_id_idx

• is_user_my_client

• view_client
• view_contact
• view_users_subscribed_to

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE client (
  identifier            integer NOT NULL PRIMARY KEY,
  users                 integer NOT NULL REFERENCES users(identifier),
  client                integer NOT NULL REFERENCES users(identifier), -- client of user
  date_of_creation      timestamp,
  STATUS                integer NOT NULL REFERENCES client_status(identifier)
);

= Version 2.19 =

ALTER TABLE client ADD TRUSTED char CHECK (TRUSTED IN ('t', 'f'));

= Version 2.19 =

UPDATE client SET TRUSTED = 'f';