Schema: general

general

General objects, reusable outside the AI4SoilHealth context



Tables


ai_model

Catalog of AI models for chat.

Name Type Description
username character_varying
active boolean
answer character_varying
id integer
name character_varying
url character_varying
body json
method_id integer

foreign key to general.method.id
password character_varying


boundary

OSM area boundaries.

Name Type Description
level integer
name character_varying
admin_level integer
local_name character_varying
geom geometry
osm_id integer
id integer


boundary_hierarchy

Hierarchy of OSM boundaries.

Name Type Description
parent_id integer
id integer
parent_distance integer
child_id integer


chat

Chat

Name Type Description
room_id integer

foreign key to general.room.id
time_created timestamp_with_time_zone
message character_varying
person_id integer

foreign key to auth.person.id
id integer


color

Catalog of colors.

Name Type Description
name character_varying
code character_varying
order_no integer
id integer


country

Catalog of countries.

Name Type Description
sub_region_id integer

foreign key to general.sub_region.id
region_id integer

foreign key to general.region.id
code character
name character_varying
id integer
lucas_code character
osm_id integer


email_counter

Email counter

Name Type Description
cnt integer


email_provider

Email provider

Name Type Description
username character_varying
port integer
smtp character_varying
name character_varying
id integer
sender_from character_varying
default boolean
must_pay boolean
internal_name character_varying
password character_varying
email_ssl_id integer
sender_name character_varying
user_id integer


email_ssl

Email ssl

Name Type Description
name character_varying
id integer


file

File

Name Type Description
zipped_size integer
original_name character_varying
file_id character_varying
public boolean
time_created timestamp_with_time_zone
name character_varying
size integer
id integer


file_delete

File delete

Name Type Description
file character_varying


file_id

varchar

Name Type Description
public_domain boolean
original_name character_varying
time_created timestamp_with_time_zone
id integer
zipped_size integer
size integer
name character_varying


forum

Forum

Name Type Description
time_modified timestamp_with_time_zone
forum_topic_id integer
title character_varying
person_id integer

foreign key to auth.person.id
response_forum_id integer

foreign key to general.forum.id
message text
time_created timestamp_with_time_zone
id integer


forum_topic

Forum topic

Name Type Description
id integer
name character_varying


message

Chat messages.

Name Type Description
id integer
person_id integer

foreign key to auth.person.id
response text
time_modified timestamp_without_time_zone
prompt text


method

Method

Name Type Description
name character_varying
id integer


nuts

NUTS regions.

Name Type Description
cntr_code character
levl_code integer
id integer
fid character_varying
coast_type integer
urbn_type integer
geom geometry
mount_type integer
nuts_name character_varying
name_latn character_varying
nuts_id character_varying


partner

Catalog of project partners

Name Type Description
id integer
name character_varying
short_name character_varying
user_modified_id integer

foreign key to auth.person.id
time_modified timestamp_without_time_zone


pdf_template

Pdf template

Name Type Description
name character_varying
state json
api_options json
api character_varying
id integer


region

Catalog of OSM regions.

Name Type Description
name character_varying
id smallint


room

Room

Name Type Description
id integer
name character_varying


sub_region

Catalog of OSM subregions.

Name Type Description
id smallint
name character_varying


Functions

add_forum

Add forum

Parameters:
Name Type Description
Json text
Source:
Returns:
Type
integer

calculate_levels

Calculate levels in OSM boundary hierarchy

Source:
Returns:
Type
void

delete_all_messages

Delete all chat messages for a person

Parameters:
Name Type Description
PersonId integer
Source:
Returns:
Type
void

delete_file_from_os

Delete file from os

Source:
Returns:
Type
trigger

delete_forum

Delete forum

Parameters:
Name Type Description
Id integer
Source:
Returns:
Type
void

delete_message

Delete single chat message

Parameters:
Name Type Description
Id integer
Source:
Returns:
Type
void

envelope

Envelope

Parameters:
Name Type Description
extent character_varying
srid integer
Source:
Returns:
Type
geometry

file_check_download

File check download

Parameters:
Name Type Description
Id integer
Source:
Returns:
Type
void

general_country_import_excel

Import countries from excel

Parameters:
Name Type Description
jsonCV text
jsonData text
Source:
Returns:
Type
void

get_ai_model

Get ai model

Parameters:
Name Type Description
Id integer
Source:
Returns:

integer idcharacter_varying namecharacter_varying urlcharacter_varying usernamecharacter_varying passwordjson bodycharacter_varying methodcharacter_varying answer

Type
Object

get_ai_models

Get ai models

Properties:
Name Type Description
value integer
label character_varying
Source:
Returns:
Type
Object

get_all_nuts

Get all nuts

Parameters:
Name Type Description
Id integer
Srid integer
Source:
Returns:
Type
json

get_boundaries

Get OSM boundaries

Parameters:
Name Type Description
Level integer
Srid integer
Zoom integer
Extent varchar
IndicatorId integer
Source:
Returns:
Type
json

get_boundary

Get boundary by OsmId

Parameters:
Name Type Description
OsmId integer
Srid integer
Source:
Returns:
Type
json

get_chats

Get chats

Parameters:
Name Type Description
RoomId integer
Source:
Returns:

integer idinteger room_idinteger person_idcharacter_varying messagetimestamp_with_time_zone time_createdcharacter_varying name

Type
Object

get_children_boundaries

Get children boundaries

Parameters:
Name Type Description
OsmId integer
Srid integer
Source:
Returns:
Type
json

get_forum

Get forum

Parameters:
Name Type Description
Id integer
Source:
Returns:

integer idinteger levelinteger response_forum_idcharacter_varying titletext messagetimestamp_with_time_zone time_createdtimestamp_with_time_zone time_modifiedinteger person_idcharacter_varying author

Type
Object

get_mail_msg

Get mail msg

Parameters:
Name Type Description
TemplateId integer
ProviderId integer
Source:
Returns:

character_varying SenderFromcharacter_varying SenderNamecharacter_varying Smtpinteger Portinteger EmailSslIdcharacter_varying Usernamecharacter_varying Passwordtext Subjecttext Bodycharacter_varying InternalName

Type
Object

get_messages

Get chat messages for a person

Parameters:
Name Type Description
PersonId integer
Properties:
Name Type Description
id integer
parent_id integer
message text
time_modified timestamp_without_time_zone
Source:
Returns:
Type
Object

get_srids

Get srids

Source:
Returns:
Type
json

import_osm_boundaries

Import osm boundaries from planet_osm_polygon and planet_osm_rels tables

Source:
Returns:
Type
void

save_chat

Save chat

Parameters:
Name Type Description
PersonId integer
RoomId integer
Message character_varying
Source:
Returns:
Type
json

save_file

Save file

Parameters:
Name Type Description
FileId character_varying
Name character_varying
Size integer
ZippedSize integer
Source:
Returns:
Type
integer

save_message

Save chat message

Parameters:
Name Type Description
PersonId integer
Message text
ParentId integer
Source:
Returns:
Type
integer

set_children_geometry

Set children geometry and properties in the database from the JSON object passed as argument

Parameters:
Name Type Description
Properties text
Geometry text
Source:
Returns:
Type
void

set_nuts

Set nuts data from geojson to database table

Parameters:
Name Type Description
Properties text
Geometry text
Source:
Returns:
Type
void

simplify

Simplify

Parameters:
Name Type Description
Zoom integer
Source:
Returns:
Type
double_precision

update_forum

Update forum

Parameters:
Name Type Description
Json text
Source:
Returns:
Type
void