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
password character_varying
method_id integer

foreign key to general.method.id
body json
answer character_varying
active boolean
id integer
name character_varying
url character_varying


boundary

OSM area boundaries.

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


boundary_hierarchy

Hierarchy of OSM boundaries.

Name Type Description
id integer
parent_id integer
child_id integer
parent_distance integer


chat

Chat

Name Type Description
id integer
time_created timestamp_with_time_zone
message character_varying
person_id integer

foreign key to auth.person.id
room_id integer

foreign key to general.room.id


color

Catalog of colors.

Name Type Description
code character_varying
name character_varying
id integer
order_no integer


country

Catalog of countries.

Name Type Description
code character
id integer
region_id integer

foreign key to general.region.id
sub_region_id integer

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


email_counter

Email counter

Name Type Description
cnt integer


email_provider

Email provider

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


email_ssl

Email ssl

Name Type Description
id integer
name character_varying


file

File

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


file_delete

File delete

Name Type Description
file character_varying


file_id

varchar

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


forum

Forum

Name Type Description
person_id integer

foreign key to auth.person.id
time_modified timestamp_with_time_zone
time_created timestamp_with_time_zone
message text
response_forum_id integer

foreign key to general.forum.id
title character_varying
forum_topic_id integer
id integer


forum_topic

Forum topic

Name Type Description
name character_varying
id integer


message

Chat messages.

Name Type Description
prompt text
response text
time_modified timestamp_without_time_zone
person_id integer

foreign key to auth.person.id
id integer


method

Method

Name Type Description
name character_varying
id integer


nuts

NUTS regions.

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


partner

Catalog of project partners

Name Type Description
short_name character_varying
name character_varying
id integer
time_modified timestamp_without_time_zone
user_modified_id integer

foreign key to auth.person.id


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