external_services

0 rows


Description

built in and custom external services

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
external_services_functions.externalserviceid exteservfunc_ext2_fkR
external_services_users.externalserviceid exteservuser_ext2_fkR
external_tokens.externalserviceid extetoke_ext2_fkR
name VARCHAR 200 ''
enabled BIT 3 null
requiredcapability VARCHAR 150 √ NULL
restrictedusers BIT 3 null
component VARCHAR 100 √ NULL
timecreated BIGINT 19 null
timemodified BIGINT 19 √ NULL
shortname VARCHAR 255 √ NULL

a unique shortname

downloadfiles BIT 3 0

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

uploadfiles BIT 3 0

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

Indexes

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

Relationships