Billing Table Design Help Needed

[craigfw]

I need some help designing database tables. I have years of DBA/SA experience, but have tried to stay away from coding, Well life has caught up with me:

I have to create a Cell Phone Billing database and have the following general logical design for five tables:

BillingCharges (PlanType is a Foreign Key)
IndividualCharges
UserInfo
(These three use PhoneNum as the Primary Key)

PhonePlans
PhoneInfo
(both use PlanType as the Primay Key)

I know this info is sparse, but does anyone have any suggestions, feedback, or resources?

Thanks

 

[Edimator]

This link was helpfull for my billing project

http://job.wowak.com/introduction-telecom-billing.html

 

[craigfw]

Thank you for the referal Edimator.

Craig Webber