[Asterisk-Users] LCR / Trollphone Rate Engine

[ml at neoninternet.com]

Hi. Thank you to Olle, the Wiki, and Trollphone.  I found the Trollphone Rate Engine listed on the Wiki at:

http://www.voip-info.org/wiki-Asterisk+addon+rate-engine

I'm not familiar with LCR yet, but this is something that I need to do.  I have it all installed but am not familiar with the terminology.  Can someone help me maybe figure out what some of these fields are for?

mysql> describe egress;
+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| route_id    | int(10) unsigned |      | PRI | NULL    | auto_increment |
| provider_id | int(10) unsigned |      | MUL | 0       |                |
| technology  | varchar(16)      |      |     |         |                |  (I assume this should be SIP, IAX, etc)
| peer        | varchar(32)      |      |     |         |                | (I assume this is the hostname of the peer)
| pattern     | varchar(80)      |      |     |         |                |  (Regex matching pattern?)
| substitute  | varchar(80)      |      |     |         |                |  (Something else to do with regex substitution? Example?)
| description | varchar(80)      | YES  |     | NULL    |                |  (Description of the entry)
+-------------+------------------+------+-----+---------+----------------+

mysql> describe rate;
+--------------+------------------+------+-----+---------+----------------+
| Field        | Type             | Null | Key | Default | Extra          |
+--------------+------------------+------+-----+---------+----------------+
| rate_id      | int(10) unsigned |      | PRI | NULL    | auto_increment |
| route_id     | int(10) unsigned |      | MUL | 0       |                |
| iso          | char(2)          |      |     |         |                |  (?? Description please? Example?)
| type         | char(3)          | YES  |     | NULL    |                | (Type.. ? Example?)
| country      | varchar(40)      |      |     |         |                |  (I guess this is freeform..)
| extra        | varchar(40)      | YES  |     | NULL    |                | (Extra what?)
| prefix       | varchar(10)      |      | MUL |         |                | (Ok, prefix of the number...)
| active_date  | date             | YES  |     | NULL    |                | (Starting date of rate)
| expires_date | date             | YES  |     | NULL    |                | (Ending date of rate)
| firstperiod  | int(10) unsigned |      |     | 0       |                | (Explain?)
| periods      | int(10) unsigned |      |     | 0       |                | (Examples?)
| startcost    | int(10) unsigned |      |     | 0       |                | (Connection fee?)
| periodcost   | int(10) unsigned |      |     | 0       |                | (Cost per unit?)
+--------------+------------------+------+-----+---------+----------------+

Once I get these question marks removed, I think it will be a very nice product.  Thank you for your help!

Kevin