pretouch

Tables (10)

BaseBilling (Untitled5)

    CreditCardBillings (Untitled2)

    • id — Primary key — NOT NULL
    • user_id — Foreign key → User.id — NOT NULL
    • name
    • amount
    • custom_data
    • tax_free
    • currency
    • language
    • buyer_name
    • buyer_tel
    • buyer_addr
    • buyer_postcode
    • confirm_url
    • notice_url
    • display
    • digital
    • create_at
    • subscription_type
    • payment_type
    • Field

    CreditCardTransaction (-)

    • id — Primary key — NOT NULL
    • user_id — Foreign key → User.id — NOT NULL
    • data
    • ...
    • create_at

    Credits

    • id — Primary key — NOT NULL
    • user_id — Foreign key → User.id — NOT NULL
    • remain
    • create_at

    PaypalBilling (CopyOfUntitled5)

    • id (Field)
    • status (Field2)
    • status_update_time (Field3)
    • plan_id (Field4)
    • plan_overridden (Field5)
    • start_time (Field6)
    • quantity (Field7)
    • currency_code (Field8)
    • value (Field9)
    • subscriber_name_given_name (Field10)
    • subscriber_name_surname (Field11)
    • subscriber_email_address (Field12)
    • subscriber_payer_id (Field13)
    • subscriber_shipping_address_name_full_name (Field14)
    • subscriber_shipping_address_address_address_line_1 (Field15)
    • subscriber_shipping_address_address_address_line_2 (Field16)
    • subscriber_shipping_address_address_admin_area_2 (Field17)
    • subscriber_shipping_address_address_admin_area_1 (Field18)
    • subscriber_shipping_address_address_postal_code (Field19)
    • subscriber_shipping_address_address_country_code (Field20)
    • create_at (Field21)
    • Field22

    PaypalTransaction (CopyOf-)

    • id — Primary key — NOT NULL
    • user_id — Foreign key → User.id — NOT NULL
    • data
    • ...
    • create_at

    Refunds (Untitled3)

    • id — Primary key — NOT NULL
    • user_id — Foreign key → User.id — NOT NULL
    • subscription_id — Foreign key → Subscriptions.id — NOT NULL

    Subscriptions (Untitled4)

    • id — Primary key — NOT NULL
    • user_id — Foreign key → User.id — NOT NULL
    • credit_card_transaction_id — Foreign key → CreditCardTransaction.id — NOT NULL
    • paypal_transaction_id — Foreign key → PaypalTransaction.id — NOT NULL
    • create_at
    • expire_date
    • type
    • payment_type
    • status

    UsedCredit

    • id — Primary key — NOT NULL
    • user_id — Foreign key → User.id — NOT NULL
    • credit_id — Foreign key → Credits.id — NOT NULL
    • amount
    • create_at

    User (Untitled)

    • id — Primary key — NOT NULL
    • name
    • email
    • ...