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 10 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 10 null
timemodified bigint 10 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