pretouch
Tables (10)
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
- ...