Here is the table list of Shopping Cart Price Rule.

1. salesrule
Create rule info will get it from here.

2. salesrule_coupon
Coupon info will get here

3. salesrule_coupon_usage
How many time used this coupon by customer ID

4. salesrule_customer

5. salesrule_customer_group
Rule mapped to which customer groups

6. salesrule_label

7. salesrule_product_attribute
attribute based rule infor

8. salesrule_website
if rule applied by website.