Fields (9)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| areaID | int(11) unsigned | YES | MUL | NULL | |
| countryID | int(11) unsigned | YES | MUL | NULL | |
| stateID | int(11) unsigned | YES | MUL | NULL | |
| groupID | int(11) unsigned | NO | MUL | NULL | |
| customer_groupID | int(11) unsigned | NO | MUL | NULL | |
| tax | decimal(10,2) | NO | NULL | ||
| name | varchar(255) | NO | NULL | ||
| active | int(1) unsigned | NO | NULL |
Indexes (6)
| Name | Columns | Unique |
|---|---|---|
| areaID | areaID | No |
| countryID | countryID | No |
| groupID | groupID | No |
| PRIMARY | id | Yes |
| stateID | stateID | No |
| tax_rate_by_conditions | customer_groupID,areaID,countryID,stateID | No |