这个是FlaskBB创建的用户表，参考一下。flask

-- Table: public.users

-- DROP TABLE IF EXISTS public.users;

CREATE TABLE IF NOT EXISTS public.users
(
    id integer NOT NULL DEFAULT 'nextval('users_id_seq'::regclass)',
    username character varying(200) COLLATE pg_catalog."default" NOT NULL,
    email character varying(200) COLLATE pg_catalog."default" NOT NULL,
    password character varying(120) COLLATE pg_catalog."default" NOT NULL,
    date_joined timestamp with time zone NOT NULL,
    lastseen timestamp with time zone,
    birthday timestamp without time zone,
    gender character varying(10) COLLATE pg_catalog."default",
    website character varying(200) COLLATE pg_catalog."default",
    location character varying(100) COLLATE pg_catalog."default",
    signature text COLLATE pg_catalog."default",
    avatar character varying(200) COLLATE pg_catalog."default",
    notes text COLLATE pg_catalog."default",
    last_failed_login timestamp with time zone,
    login_attempts integer NOT NULL,
    activated boolean NOT NULL,
    theme character varying(15) COLLATE pg_catalog."default",
    language character varying(15) COLLATE pg_catalog."default",
    post_count integer,
    primary_group_id integer NOT NULL,
    CONSTRAINT pk_users PRIMARY KEY (id),
    CONSTRAINT uq_users_email UNIQUE (email),
    CONSTRAINT uq_users_username UNIQUE (username),
    CONSTRAINT fk_users_primary_group_id_groups FOREIGN KEY (primary_group_id)
        REFERENCES public.groups (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.users
    OWNER to cfoperator;