# Table Usage ``` get /api/1.1/cdns/domains - DB: Profile, CDN
get /api/1.1/servers/:id/configfiles/ats get /api/1.1/profiles/:id/configfiles/ats/:filename get /api/1.1/servers/:id/configfiles/ats/:filename get /api/1.1/cdns/:id/configfiles/ats/:filename get /api/1.1/dbdump - Ext: pg_dump get /api/1.1/deliveryservices/:id/routing - DB: Tenant, DeliveryService, DeliveryServiceRegex, Regex, Cdn, Type - Ext: Router get /api/1.1/deliveryservices/:id/state - DB: Tenant, DeliveryService, CDN - Ext: Monitor post /api/1.1/deliveryservices/request - Ext: Email delete /api/1.1/divisions/name/:name - DB: Division, Region get /api/1.1/federations - DB: TmUser, FederationTmUser, FederationDeliveryService, DeliveryService post /api/1.1/federations put /api/1.1/federations delete /api/1.1/federations get /api/1.1/cdns/:name/federations get /api/1.1/cdns/:name/federations/:fedId post /api/1.1/cdns/:name/federations put /api/1.1/cdns/:name/federations/:fedId delete /api/1.1/cdns/:name/federations/:fedId get /api/1.1/federations/:fedId/users post /api/1.1/federations/:fedId/users delete /api/1.1/federations/:fedId/users/:userId get /api/1.1/federations/:fedId/deliveryservices post /api/1.1/federations/:fedId/deliveryservices delete /api/1.1/federations/:fedId/deliveryservices/:dsId get /api/1.1/federations/:fedId/federation_resolvers post /api/1.1/federations/:fedId/federation_resolvers post /api/1.1/federation_resolvers delete /api/1.1/federation_resolvers/:id - DB: TmUser, FederationTmUser, FederationDeliveryService, DeliveryService, FederationResolver, FederationFederationResolver get /api/1.1/hwinfo/dtdata - DB: HwInfo, Server get /api/1.1/osversions - DB: Parameter, Server - Ext: file:osversions.cfg post /api/1.1/isos - DB: Parameter - Ext: mkisofs get /api/1.1/jobs - DB: DeliveryService, Tenant, Job get /api/1.1/jobs/:id - DB: DeliveryService, Job get /api/1.1/user/current/jobs - DB: Tenant, DeliveryService, Job, TmUser post /api/1.1/user/current/jobs - DB: Tenant, DeliveryService, Job, TmUser post /api/1.1/parameters/validate - DB: Parameter get /api/1.1/cachegroups/:id/parameters - DB: Parameter, CachegroupParameter get /api/1.1/cachegroups/:id/unassigned_parameters - DB: Parameter, CachegroupParameter get /api/1.1/cachegroup/:parameter_id/parameter - DB: Cachegroup, CachegroupParameter get /api/1.1/cachegroupparameters - DB: CachegroupParameter post /api/1.1/cachegroupparameters - DB: Cachegroup, Parameter, ProfileParameter, CachegroupParameter delete /api/1.1/cachegroupparameters/:cachegroup_id/:parameter_id - DB: Cachegroup, Parameter, CachegroupParameter get /api/1.1/cachegroups/:parameter_id/parameter/available - DB: Cachegroup, CachegroupParameter post /api/1.1/regions/:region_name/phys_locations - DB: PhysLocation, Region post /api/1.1/profiles/name/:profile_name/copy/:profile_copy_from - DB: Profile, ProfileParameter get /api/1.1/profiles/:id/export - DB: Profile, ProfileParameter, Parameter post /api/1.1/profiles/import - DB: Cdn, Profile, ProfileTypeValue, Parameter, ProfileParameter get /api/1.1/parameters/:id/profiles - DB: Profile, ProfileParameter get /api/1.1/parameters/:id/unassigned_profiles - DB: Profile, ProfileParameter post /api/1.1/divisions/:division_name/regions - DB: Region, Division delete /api/1.1/regions/name/:name - DB: Region get /api/1.1/roles - DB: Role get /api/1.1/capabilities - DB: Capability get /api/1.1/capabilities/:name - DB: Capability put /api/1.1/capabilities/:name - DB: Capability post /api/1.1/capabilities - DB: Capability delete /api/1.1/capabilities/:name - DB: Capability, ApiCapability get /api/1.1/api_capabilities - DB: ApiCapability get /api/1.1/api_capabilities/:id - DB: ApiCapability put /api/1.1/api_capabilities/:id - DB: ApiCapability post /api/1.1/api_capabilities - DB: ApiCapability delete /api/1.1/api_capabilities/:id - DB: ApiCapability get /api/1.1/servers/totals - DB: ServerTypes, Server, Type get /api/1.1/servers/status - DB: Server, Status, Type post /api/1.1/servers/:id/queue_update - DB: Server put /api/1.1/servers/:id/status - DB: Server, Status, Type, Cachegroup get /api/1.1/servers/checks - DB: ToExtension, Server, Profile, Status, Cachegroup, Type get /api/1.1/servercheck/aadata - DB: Type, Server, ServerCheck post /api/1.1/servercheck - DB: ToExtension, Server get /api/1.1/stats_summary - DB: StatsSummary post /api/1.1/stats_summary/create - DB: StatsSummary get /api/1.1/types/trimmed - DB: Type post /api/1.1/users/register - DB: TmUser, Role, Tenant - Ext: Email put /api/1.1/user/current - DB: Tenant, TmUser post /api/1.1/user/current/update - DB: Tenant, TmUser post /api/1.1/user/login/token - DB: Tenant, TmUser post /api/1.1/user/logout - nothing post /api/1.1/user/reset_password - DB: TmUser - Ext: Email get /api/1.1/to_extensions - DB: ToExtension, Parameter, ProfileParameter post /api/1.1/to_extensions - DB: ToExtension, ServerCheck post /api/1.1/to_extensions/:id/delete - DB: ToExtension get /api/1.1/traffic_monitor/stats - DB: Server, Cdn - Ext: Monitor ``` # External ## Commands get /api/1.1/dbdump (pg_dump) get /api/1.1/osversions (file:osversions.cfg) post /api/1.1/isos (mkisofs) ## Monitor get /api/1.1/deliveryservices/:id/state get /api/1.1/traffic_monitor/stats ## Router get /api/1.1/deliveryservices/:id/routing ## Email post /api/1.1/deliveryservices/request post /api/1.1/users/register post /api/1.1/user/reset_password # Observations - Deliveryservices overlap almost 1:1 with (Riak,) Monitor, Router - Most Delete check other tables, to ensure foreign keys - can we remove from Perl, and rely on DB for foreign key constraints? - 30/110 endpoints use DeliveryServices table # Delivery Services Table ``` get /api/1.1/deliveryservices/:id/routing get /api/1.1/deliveryservices/:id/state get /api/1.1/federations post /api/1.1/federations put /api/1.1/federations delete /api/1.1/federations get /api/1.1/jobs get /api/1.1/jobs/:id get /api/1.1/user/current/jobs post /api/1.1/user/current/jobs ``` [ Full content available at: https://github.com/apache/trafficcontrol/issues/2232 ] This message was relayed via gitbox.apache.org for [email protected]
