User Tools

Site Tools


podoc:client_status_sql_table

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

CREATE TABLE client_status (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(12)
);

References tables

None.

Is referenced by tables

  • client(status) references identifier

None.

None.

History

Used first

Version 2.5

Used last

Still in use

Schema change history

= Version 2.5 =

CREATE TABLE client_status (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(12)
);
Data change history

= 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');
podoc/client_status_sql_table.txt · Last modified: 2007/04/20 12:14 by Luud