===== Database Table Description of "client_status" =====

=== Name ===

client_status

=== Description ===

A mapping of the allowed states of a client.

=== Purpose ===

Clients have to be approved.  This table just enforces referential integrity into the process.

Will be removed.

=== Schema ===

<code sql>
create table client_status (
  identifier            integer not null primary key,
  value                 varchar(12)
);
</code>

=== References tables ===

None.

=== Is referenced by tables ===

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

=== Related sequences ===

  * [[client_status_id_sequence sql sequence|client_status_id_sequence]]

=== Related indexes ===

None.

=== Related functions ===

None.

=== 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_status (
  identifier            integer not null primary key,
  value                 varchar(12)
);
</code>

== Data change history ==

= Version 2.5 =

<code sql>
insert into client_status values (nextval('client_status_id_sequence'), 'Pending');
insert into client_status values (nextval('client_status_id_sequence'), 'Accepted');
insert into client_status values (nextval('client_status_id_sequence'), 'Rejected');
</code>