1. Orders
1.1. Payment history
1.1.1. ID (PK)
1.1.2. Item ID (FK)
1.1.3. Amount Paid
1.1.4. Amount Due
1.1.5. Payment Type
1.1.6. Date
1.1.7. Payment Method
1.2. Previous Orders
1.2.1. ID (PK)
1.2.2. Account ID (FK)
1.2.3. Item ID (FK)
1.2.4. Date
1.3. Billing
1.3.1. ID (PK)
1.3.2. Account (ID)
1.3.3. Billing Address
1.3.3.1. CSZ
1.3.4. Shipping Address
1.3.4.1. CSZ
1.3.5. Payment Method
1.3.6. # of Purchases
1.3.7. CC/Paypal Info (?)
2. Account
2.1. Referrals
2.1.1. ID (PK
2.1.2. Account ID (FK)
2.1.3. Email
2.1.4. Date Referred
2.1.5. Successful (bool)
2.2. Subscriptions (?)
2.2.1. ID (PK)
2.2.2. Account ID (FK)
2.2.3. Start Date
2.2.4. End Date
2.2.5. Active (bool)
2.3. jml_users
2.3.1. ID (PK)
2.3.2. Name
2.3.3. Username
2.3.4. Email
2.3.5. Password
2.3.6. Usertype
2.3.7. Block
2.3.8. Send Email
2.3.9. Register Date
2.3.10. Last Visit Date
2.3.11. Activation
2.3.12. Params
2.3.13. Custom Fields
2.3.13.1. # of Referrals
2.3.13.2. Email2
2.3.13.3. Phone
2.3.13.4. Phone2
2.3.13.5. Active (bool)
2.3.13.6. CSZ
3. Items
3.1. Item
3.1.1. ID (PK)
3.1.2. Date
3.1.3. Cost
3.1.4. Description
3.1.5. Quantity
3.2. Returns
3.2.1. ID (PK)
3.2.2. Account ID (FK)
3.2.3. Item ID (FK)
3.2.4. Returned (bool)
3.2.5. Date