Photo Organizer

Database Table Description of "user_type"

Name

user_type

Description

Purpose

Schema

create table user_type (
  identifier            integer not null primary key,
  value                 varchar(15)
);

References tables

None.

Is referenced by tables

system_preferences(new_user_type) references identifier
users(type) references identifier

Related sequences

user_type_id_sequence

Related indexes

None.

Related functions

None.

Related views

None.

History

Used first

Version 2.5

Used last

Still in use

Schema change history

= Version 2.5 =

CREATE TABLE user_type (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(15)
);

Data change history

= Version 2.5 =

INSERT INTO user_type VALUES (NEXTVAL('user_type_id_sequence'), 'Disabled');
INSERT INTO user_type VALUES (NEXTVAL('user_type_id_sequence'), 'Client');
INSERT INTO user_type VALUES (NEXTVAL('user_type_id_sequence'), 'User');
INSERT INTO user_type VALUES (NEXTVAL('user_type_id_sequence'), 'Administrator');