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
Related sequences
Related indexes
None.
Related functions
None.
Related views
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