SteelHanger

Get Started. It's Free
or sign up with your email address
Rocket clouds
SteelHanger by Mind Map: SteelHanger

1. Account

1.1. Referrals

1.1.1. ID (PK

1.1.2. Account ID (FK)

1.1.3. Email

1.1.4. Date Referred

1.1.5. Successful (bool)

1.2. Subscriptions (?)

1.2.1. ID (PK)

1.2.2. Account ID (FK)

1.2.3. Start Date

1.2.4. End Date

1.2.5. Active (bool)

1.3. jml_users

1.3.1. ID (PK)

1.3.2. Name

1.3.3. Username

1.3.4. Email

1.3.5. Password

1.3.6. Usertype

1.3.7. Block

1.3.8. Send Email

1.3.9. Register Date

1.3.10. Last Visit Date

1.3.11. Activation

1.3.12. Params

1.3.13. Custom Fields

1.3.13.1. # of Referrals

1.3.13.2. Email2

1.3.13.3. Phone

1.3.13.4. Phone2

1.3.13.5. Active (bool)

1.3.13.6. CSZ

2. Items

2.1. Item

2.1.1. ID (PK)

2.1.2. Date

2.1.3. Cost

2.1.4. Description

2.1.5. Quantity

2.2. Returns

2.2.1. ID (PK)

2.2.2. Account ID (FK)

2.2.3. Item ID (FK)

2.2.4. Returned (bool)

2.2.5. Date

3. Orders

3.1. Payment history

3.1.1. ID (PK)

3.1.2. Item ID (FK)

3.1.3. Amount Paid

3.1.4. Amount Due

3.1.5. Payment Type

3.1.6. Date

3.1.7. Payment Method

3.2. Previous Orders

3.2.1. ID (PK)

3.2.2. Account ID (FK)

3.2.3. Item ID (FK)

3.2.4. Date

3.3. Billing

3.3.1. ID (PK)

3.3.2. Account (ID)

3.3.3. Billing Address

3.3.3.1. CSZ

3.3.4. Shipping Address

3.3.4.1. CSZ

3.3.5. Payment Method

3.3.6. # of Purchases

3.3.7. CC/Paypal Info (?)