create table "Praise"

(

);

alter table "Praise"

owner to postgres;

create table "Random"

(

);

alter table "Random"

owner to postgres;

create table "_Visit"

(

);

alter table "_Visit"

owner to postgres;

create table "Method"

(

);

alter table "Method"

owner to postgres;

create table "Document"

(

id bigint,

debug smallint,

"userId" bigint,

"testAccountId" bigint,

version smallint,

name varchar(100),

type varchar(5),

url varchar(250),

request text,

apijson text,

sqlauto text,

standard text,

header text,

date timestamp,

detail text

);

alter table "Document"

owner to postgres;

create table apijson_privacy

(

id bigint not null

primary key,

certified smallint not null,

phone varchar(64) not null,

balance numeric(10, 2) not null,

_password varchar(20) not null,

"_payPassword" varchar(32) not null

);

comment on table apijson_privacy is '用户隐私信息表。\n对安全要求高，不想泄漏真实名称。对外名称为 Privacy';

comment on column apijson_privacy.id is '唯一标识';

comment on column apijson_privacy.certified is '已认证';

comment on column apijson_privacy.phone is '手机号，仅支持 11 位数的。不支持 +86 这种国家地区开头的。如果要支持就改为 VARCHAR(14)';

comment on column apijson_privacy.balance is '余额';

comment on column apijson_privacy._password is '登录密码';

comment on column apijson_privacy."_payPassword" is '支付密码';

alter table apijson_privacy

owner to postgres;

create index "phone_UNIQUE"

on apijson_privacy (phone);

create table apijson_user

(

id bigint not null

primary key,

sex smallint not null,

name varchar(20),

tag varchar(45),

head varchar(300),

"contactIdList" jsonb,

"pictureList" jsonb,

date timestamp(6)

);

comment on table apijson_user is '用户公开信息表。对安全要求高，不想泄漏真实名称。对外名称为 User';

comment on column apijson_user.id is '唯一标识';

1-女';

comment on column apijson_user.name is '名称';

comment on column apijson_user.tag is '标签';

comment on column apijson_user.head is '头像url';

comment on column apijson_user."contactIdList" is '联系人id列表';

comment on column apijson_user."pictureList" is '照片列表';

comment on column apijson_user.date is '创建日期';

alter table apijson_user

owner to postgres;

create table "Comment"

(

id bigint not null

primary key,

"toId" bigint default 0 not null,

"userId" bigint not null,

"momentId" bigint not null,

date timestamp(6),

content varchar(1000) not null

);

comment on table "Comment" is '评论';

comment on column "Comment".id is '唯一标识';

comment on column "Comment"."toId" is '被回复的id';

comment on column "Comment"."userId" is '评论人id';

comment on column "Comment"."momentId" is '动态id';

comment on column "Comment".date is '创建日期';

comment on column "Comment".content is '内容';

alter table "Comment"

owner to postgres;

create table "Moment"

(

id bigint not null

primary key,

"userId" bigint not null,

date timestamp(6),

content varchar(300),

"praiseUserIdList" jsonb not null,

"pictureList" jsonb not null

);

comment on table "Moment" is '动态';

comment on column "Moment".id is '唯一标识';

comment on column "Moment"."userId" is '用户id';

comment on column "Moment".date is '创建日期';

comment on column "Moment".content is '内容';

comment on column "Moment"."praiseUserIdList" is '点赞的用户id列表';

comment on column "Moment"."pictureList" is '图片列表';

alter table "Moment"

owner to postgres;

create table "TestRecord"

(

id bigint not null

primary key,

"userId" bigint not null,

"documentId" bigint not null,

response text not null,

date timestamp(6) default CURRENT_TIMESTAMP not null,

compare text,

standard text,

"randomId" bigint default 0,

headless smallint default 0 not null,

"reportId" bigint default 0 not null,

"testAccountId" bigint default 0 not null,

duration bigint default 0 not null,

"minDuration" bigint default 0 not null,

"maxDuration" bigint default 0 not null,

host varchar(200)

);

comment on column "TestRecord".id is '唯一标识';

comment on column "TestRecord"."userId" is '用户id';

comment on column "TestRecord"."documentId" is '测试用例文档id';

comment on column "TestRecord".response is '接口返回结果JSON';

comment on column "TestRecord".date is '创建日期';

comment on column "TestRecord".compare is '对比结果';

comment on column "TestRecord".standard is 'response 的校验标准，是一个 JSON 格式的 AST ，描述了正确 Response 的结构、里面的字段名称、类型、长度、取值范围 等属性。';

comment on column "TestRecord"."randomId" is '随机配置 id';

comment on column "TestRecord".headless is '是否为无 UI 的 Headless 模式：0-否 1-是';

comment on column "TestRecord"."reportId" is '测试报告 ID';

comment on column "TestRecord"."testAccountId" is '测试账号 id';

alter table "TestRecord"

owner to postgres;

create table "Function"

(

id bigint not null

primary key,

language varchar,

name varchar(30) not null,

"returnType" varchar(45) default 'Object'::character varying,

arguments varchar(100),

demo text not null,

detail varchar(1000),

date timestamp(6) default CURRENT_TIMESTAMP not null,

"userId" bigint default 0,

version integer default 0,

tag varchar,

methods varchar,

return integer

);

comment on column "Function".language is '语言：Java(java), JavaScript(js), Lua(lua), Python(py), Ruby(ruby), PHP(php) 等，NULL 默认为 Java，JDK 1.6-11 默认支持 JavaScript，JDK 12+ 需要额外依赖 Nashron/Rhiro 等 js 引擎库，其它的语言需要依赖对应的引擎库，并在 ScriptEngineManager 中注册';

comment on column "Function".name is '方法名';

comment on column "Function"."returnType" is '返回类型';

用 , 分割的字符串 比 [JSONArray] 更好，例如 array,item ，更直观，还方便拼接函数。';

comment on column "Function".demo is '可用的示例。';

comment on column "Function".detail is '详细描述';

comment on column "Function".date is '创建时间';

comment on column "Function"."userId" is '用户id';

comment on column "Function".version is '允许的最低版本号，只限于GET,HEAD外的操作方法。\nTODO 使用 requestIdList 替代 version,tag,methods';

comment on column "Function".tag is '允许的标签.\nnull - 允许全部\nTODO 使用 requestIdList 替代 version,tag,methods';

comment on column "Function".methods is '允许的操作方法。\nnull - 允许全部\nTODO 使用 requestIdList 替代 version,tag,methods';

comment on column "Function".return is '返回值示例';

alter table "Function"

owner to postgres;

create table "Request"

(

id bigint,

debug smallint,

version smallint,

method varchar(10),

tag varchar(30),

structure json,

detail varchar(10000),

date timestamp

);

alter table "Request"

owner to postgres;

create table "Script"

(

id bigint,

"userId" bigint,

"testAccountId" bigint,

"documentId" bigint,

simple smallint,

ahead smallint,

title varchar(100),

name varchar(100),

script text,

date timestamp,

detail varchar(1000)

);

alter table "Script"

owner to postgres;

create table "Access"

(

id integer not null

primary key,

schema varchar(100) default NULL::character varying,

debug integer default 0 not null,

name varchar(50) default '实际表名，例如 apijson_user'::character varying not null,

alias text,

get text default '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]'::text not null,

head text default '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]'::text not null,

gets text default '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]'::text not null,

heads text default '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]'::text not null,

post text default '["OWNER", "ADMIN"]'::text not null,

put text default '["OWNER", "ADMIN"]'::text not null,

delete text default '["OWNER", "ADMIN"]'::text not null,

date text default CURRENT_TIMESTAMP not null,

detail text

);

comment on column "Access".id is '唯一标识';

comment on column "Access".debug is '是否为调试表，只允许在开发环境使用，测试和线上环境禁用';

comment on column "Access".alias is '外部调用的表别名，例如 User';

TODO: 直接 LOGIN,CONTACT,CIRCLE,OWNER 更简单，反正是开发内部用，不需要复杂查询。';

comment on column "Access".head is '允许 head 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]';

comment on column "Access".gets is '允许 gets 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]';

comment on column "Access".heads is '允许 heads 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]';

comment on column "Access".post is '允许 post 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]';

comment on column "Access".put is '允许 put 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]';

comment on column "Access".delete is '允许 delete 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]';

comment on column "Access".date is '创建时间';

alter table "Access"

owner to postgres;

create table "Verify"

(

id bigint,

type integer,

phone bigint,

verify integer,

date timestamp

);

alter table "Verify"

owner to postgres;