Software Engineering for Internet Applications

Handling Users

create table users (
        user_id                 integer primary key,
        first_names             varchar(50),
        last_name               varchar(50) not null,
        email                   varchar(100) not null unique,
        password                varchar(30) not null,
        -- user's personal homepage elsewhere on the Internet
        url                     varchar(200),
        registration_date       timestamp(0),
        -- an optional photo; if Oracle Intermedia Image is installed
        -- use the image datatype instead of BLOB
        portrait                blob
);

José M. Vidal .

6 of 30