XDR group

The XDR group of tables provide access to database tables relating to data records for items of usage.

Informational tables are identified with the information symbol:

Table name	Description
`access_server`	Each row describes a Network Access Server (NAS) that Smile knows about.
`access_server_vendor`	List of supported RADIUS vendors in Smile.
`connection_type`	Descriptions of connection types as reported by current_connections view.
`current_connections`	Describes current connections. For example, RADIUS connections.
`destination`	Represents the, usually geographical, classification of an endpoint of an XDR for charging purposes.
`destination_type`	A more general classification of destinations.
`plan`	Represents a plan, which is a header record for rating rules, recurring charges and more.
`rating_period`	Header records for rating periods, which represent periods which usage is bound to and rated against.
`rating_period_prerate_status`	Configuration list of the kinds of rating cycles useable in Smile.
`rating_period_status`	Enumerates the values for pre-rate status of rating periods.
`service`	Contains the basic configuration for the different kinds of services. Subscriptions can be considered instances of services.
`subscription`	Header record for subscriptions.
`subservice`	Extra usernames or identifiers for a subscription.
`szu`	A Standard Zone Unit as defined by ACMA.
`tariff`	Description of how matching CDRs will be rated.
`tariff_type`	A categorisation of CDRs.
`xdr`	Represents an item of usage (CDR/XDR) bound to a subscription, but not necessarily rated.
`xdr_rated`	A summary of the ratings of an XDR.
`xdr_rating`	A rating for an XDR.
`xdr_type`	Enumerates the types of XDRs.