SQL Antipatterns

setup.sql

CREATE TABLE accounts (
       account_id     integer NOT NULL primary key,
       account_name   character varying(20),
       first_name     character varying(20),
       last_name      character varying(20),
       email          character varying(100),
       portrait_image bytea,
       hourly_rate    numeric(9,2)
);

CREATE SEQUENCE accounts_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE accounts_id_seq OWNED BY accounts.account_id;

CREATE TABLE bug_status (
       status           character varying(20) primary key
);