External Services Table Schema (external_services)


Description

built in and custom external services

external_services table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
external_services_functions.externalserviceid exteservfunc_ext2_fk R
external_services_users.externalserviceid exteservuser_ext2_fk R
external_tokens.externalserviceid extetoke_ext2_fk R
name VARCHAR 200
enabled BIT 1 null
requiredcapability VARCHAR 150 √ null
restrictedusers BIT 1 null
component VARCHAR 100 √ null
timecreated BIGINT 19 null
timemodified BIGINT 19 √ null
shortname VARCHAR 255 √ null

a unique shortname
downloadfiles BIT 1 0

1 if the service allow people to download file from webservice/plugins.php - 0 if not
uploadfiles BIT 1 0

1 if the service allow people to upload files to webservice/upload.php - 0 if not

Table contained -1 rows

external_services table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
exteserv_nam_uix Must be unique Asc name

external_services table relationships

Close relationships within degrees of separation