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 '';

comment on column apijson_user.sex is '
0-
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  JavaJDK 1.6-11  JavaScriptJDK 12+  Nashron/Rhiro  js  ScriptEngineManager ';

comment on column "Function".name is '';

comment on column "Function"."returnType" is '';

comment on column "Function".arguments is ' String
 ,   [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';

comment on column "Access".get is ' get  ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]
 JSON  JSONArray
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;