create table account (
        user_id SERIAL not null primary key,
        username varchar(15) not null,
        passwd   varchar(15) not null,
        person_id       integer not null
                        references person(person_id)
                        on delete cascade,
        active          bool not null default 'true',
        locked          bool not null default 'false'
);