create table project_user
(
	id serial not null,
	project_name varchar(128) not null,
	project_describe varchar,
   project_type varchar(128) not null,
	monitor_object integer[] not null,
	account varchar(128) not null,
	password varchar(128) not null,
   create_time timestamp not null,
   code varchar(128) not null,
   del boolean not null
);

comment on table project_user is '发布项目';

comment on column project_user.project_name is '项目名称';

comment on column project_user.project_describe is '项目描述';

comment on column project_user.project_type is '项目类型';

comment on column project_user.monitor_object is '监测对象';

comment on column project_user.account is '发布账号';

comment on column project_user.password is '发布密码';

comment on column project_user.create_time is '创建时间';

comment on column project_user.code is 'p';

create unique index project_user_id_uindex
	on project_user (id);

alter table project_user
	add constraint project_user_pk
		primary key (id);


create table project_user_token
(
    token             uuid      not null,
    project_user_info jsonb     not null,
    expired           timestamp not null
);