-- *********************************************
-- * SQL PostgreSQL generation                 *
-- *-------------------------------------------*
-- * Generator date:  May 30 2005              *
-- * Generation date: Fri Aug 05 14:24:00 2005 *
-- ********************************************* 


-- Database Section
-- ________________ 

create database esami;


-- Tables Section
-- _____________ 

create table directory_doc (
     id_dir -- Sequence attribute not implemented -- not null,
     nome_dir varchar(15) not null,
     constraint IDdir_esaminatore primary key (id_dir),
     constraint IDdirectory_docente unique (nome_dir));

create table esaminatore_dir (
,
     constraint IDdiritti_scrittura primary key (, ));

create table esaminatore (
     id_esaminatore -- Sequence attribute not implemented -- not null,
     username varchar(15) not null,
     password varchar(20) not null,
     cognome varchar(40) not null,
     nome varchar(40) not null,
     email varchar(100) not null,
     group char(1) not null,
     constraint IDesaminatore primary key (id_esaminatore),
     constraint IDesaminatore_2 unique (username),
     constraint IDesaminatore_1 unique (email));


-- Constraints Section
-- ___________________ 


-- Index Section
-- _____________