Design db schema for one off and recurring payments

  • Tila: Closed
  • Palkinto: $30
  • Vastaanotetut työt: 1
  • Voittaja: hoyleg

Kilpailun tehtävänanto

What we currently have:

users, places, products

each user can have 1 or more places.
Each place can have one or more product
Some products are recurring (N days - 7,12,15,30 etc) some are fixed days long and one off

Some product are shared between places that user has and have limit to how many places it can apply to

We need to design payment schema which will support the structure on top, as well payment gateway integration like stripe, pay_pal and direct banking

Some use cases schema should be able to handle

1) Adding removing places.
Customers buys 3 places product which can be serving 3 location for price X, for duration N days.
After M days M < N they want to add one more location (this meant they are now 4 places product with price Y), this means that they have to pay (N - M) * Y until next billing next month bill.
Customer removes one of the places - there is no change until next billing period, and from new period it will charge lower price
2) Bad customer
Customer pays for the service, after few days he goes to the bank and cancels transaction without notifying us. Bank will send us letter with transaction id to handle in our side and give them refund. The refund needs to be somewhere stored
3) Customer want refund before 7 days
4) Customer want to cancel next billing cicle
5) Customer want to add one time product for one of the places and they gonna do X number where we will charge them flat fee plus % of X

Suositellut taidot

Julkinen selvennystaulu

  • MMG2019
    MMG2019
    • 2 kuukautta sitten

    please review my entry #9. thanks

    • 2 kuukautta sitten
  • lucy012493
    lucy012493
    • 2 kuukautta sitten

    Is it required to sealed Entry?

    • 2 kuukautta sitten
  • lucy012493
    lucy012493
    • 2 kuukautta sitten

    Hi,

    • 2 kuukautta sitten
  • blui88
    blui88
    • 2 kuukautta sitten

    Hi,
    I am interested in this task.
    can you please share the fields/ form you are using right now. it will give a more clear picture about what you need.
    With best regards.
    Santosh

    • 2 kuukautta sitten
    1. pulsxplus
      Kilpailun järjestäjä
      • 2 kuukautta sitten

      We don't have users who are not customers, so all users are customers

      • 2 kuukautta sitten
    2. blui88
      blui88
      • 2 kuukautta sitten

      thanks for kind response.
      Can you please guide me, what kind of improvement you want. I guess we are not on same page. I am stuck, but want to move ahead.

      If you like you, ping me so that I may clarify my doubts.

      Thanks and regards
      Santosh

      • 2 kuukautta sitten
  • blui88
    blui88
    • 2 kuukautta sitten

    Please see Entry# 1 and share your thoughts to move further.
    Santosh

    • 2 kuukautta sitten

Näytä lisää kommentteja

Kuinka päästä alkuun kilpailuiden kanssa

  • Ilmoita kilpailusi

    Ilmoita kilpailusi Nopeaa ja helppoa

  • Saat valtavasti töitä

    Vastaanota tonnikaupalla osallistumisia Ympäri maailmaa

  • Myönnä palkinto parhaalle työlle

    Myönnä palkinto parhaalle työlle Lataa tiedostot - Helppoa!

Ilmoita kilpailu nyt tai liity tänään!