===== Database Table Description of "client" =====

=== Name ===

client

=== Description ===

Keeps track of all clients of a particular user.

=== Purpose ===

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 [[pobug>8]].)

=== Schema ===

<code sql>
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'));
);
</code>

=== References tables ===

  * client references [[users sql table|users]](identifier)
  * status references [[client_status sql table|client_status]](identifier)
  * users references [[users sql table|users]](identifier)

=== Is referenced by tables ===

None.

=== Related sequences ===

  * [[client_id_sequence sql sequence|client_id_sequence]]

=== Related indexes ===

  * [[client_id_idx sql index|client_id_idx]]

=== Related functions ===

  * [[is_user_my_client sql function|is_user_my_client]]

=== Related views ===

  * [[view_client sql view|view_client]]
  * [[view_contact sql view|view_contact]]
  * [[view_users_subscribed_to sql view|view_users_subscribed_to]]

=== History ===

== Used first ==

Version 2.5

== Used last ==

Still in use

== Schema change history ==

= Version 2.5 =

<code sql>
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)
);
</code>

= Version 2.19 =

<code sql>
alter table client add trusted char check (trusted in ('t', 'f'));
</code>

== Data change history ==

= Version 2.19 =

<code sql>
update client set trusted = 'f';
</code>