client_status

A mapping of the allowed states of a client.

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

Will be removed.

CREATE TABLE client_status (
  identifier            integer NOT NULL PRIMARY KEY,
  value                 varchar(12)
);

None.

• client(status) references identifier

• client_status_id_sequence

None.

None.

• view_client
• view_contact
• view_users_subscribed_to

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE client_status (
  identifier            integer NOT NULL PRIMARY KEY,
  value                 varchar(12)
);

= Version 2.5 =

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');