You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
47 lines
1.2 KiB
47 lines
1.2 KiB
10 months ago
|
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
|
||
|
|
);
|