Subscribe

Tables (3)

order_sheet

  • Key (order_sheet_id) — BIGINT — Primary key — NOT NULL
  • Key (transaction_id) — VARCHAR(65) — Primary key — NOT NULL
  • Field (account_id) — VARCHAR(100) — NOT NULL
  • Field2 (service_code) — VARCHAR(100) — NOT NULL
  • Field (product_id) — BIGINT — NOT NULL
  • Field (store_item_id) — VARCHAR(100) — NOT NULL
  • Field (service_product_code) — VARCHAR(100) — NOT NULL
  • Field (event_type) — VARCHAR(80) — NOT NULL
  • Field (status) — VARCHAR(80) — NOT NULL
  • Field (payment_method) — VARCHAR(80) — NOT NULL
  • Field (amount) — BIGINT — NOT NULL
  • Field (charge_amount) — BIGINT — NOT NULL
  • Field (payment_at) — VARCHAR(65)
  • Field (payment_failure_code) — VARCHAR(65)
  • Field (payment_failure_message) — VARCHAR(65)
  • Field (charge_hub_transaction_id) — VARCHAR(65)
  • Field (jelly_transaction_id) — VARCHAR(65)
  • Field (first_transaction_id) — VARCHAR(65) — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL
  • Field (updated_at) — datetime(6) — NOT NULL
  • Field (market_type) — varchar(100) — NOT NULL
  • Field (market_original_id) — VARCHAR(65)
  • Field (market_payment_id) — VARCHAR(65)
  • Field (group_transaction_id) — VARCHAR(65)
  • Field (relate_transaction_id) — VARCHAR(65)
  • Field (order_promotion_type) — VARCHAR(50)
  • Field (subscribe_event_type) — VARCHAR(50)

subscribe

  • Key (subscribe_id) — BIGINT — Primary key — NOT NULL
  • Field (account_id) — VARCHAR(100) — NOT NULL
  • Field2 (service_code) — VARCHAR(100) — NOT NULL
  • Field (product_id) — BIGINT — NOT NULL
  • Field (store_item_id) — VARCHAR(100) — NOT NULL
  • Field (service_product_code) — VARCHAR(100) — NOT NULL
  • Field (subscribe_type) — VARCHAR(80) — NOT NULL
  • Field (status) — VARCHAR(80) — NOT NULL
  • Field (subscribe_start_at) — DATETIME(6) — NOT NULL
  • Field (start_at) — DATETIME(6) — NOT NULL
  • Field (renewal_billing_days) — BIGINT — NOT NULL
  • Field (promotion_round) — INT — NOT NULL
  • Field (promotion_ended_at) — DATETIME(6)
  • Field (next_payment_at) — DATETIME(6) — NOT NULL
  • Field (expiration_at) — DATETIME(6)
  • Field (ended_at) — DATETIME(6) — NOT NULL
  • Field (first_transaction_id) — VARCHAR(65) — NOT NULL
  • Key (transaction_id) — VARCHAR(65) — Foreign key → order_sheet.Key — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL
  • Field (updated_at) — datetime(6) — NOT NULL
  • Field (market_type) — VARCHAR(65)
  • Field (renewal_count) — INT — NOT NULL

subscribe_history

  • Key (subscribe_history_id) — BIGINT — Primary key — NOT NULL
  • Key (subscribe_id) — BIGINT — Foreign key → subscribe.Key — NOT NULL
  • Field (account_id) — VARCHAR(100) — NOT NULL
  • Field2 (service_code) — VARCHAR(100) — NOT NULL
  • Field (product_id) — BIGINT — NOT NULL
  • Field (store_item_id) — VARCHAR(100) — NOT NULL
  • Field (service_product_code) — VARCHAR(100) — NOT NULL
  • Field (subscribe_type) — VARCHAR(80) — NOT NULL
  • Field (status) — VARCHAR(80) — NOT NULL
  • Field (event_type) — VARCHAR(80) — NOT NULL
  • Field (subscribe_start_at) — DATETIME(6) — NOT NULL
  • Field (start_at) — DATETIME(6) — NOT NULL
  • Field (renewal_billing_days) — BIGINT — NOT NULL
  • Field (promotion_round) — INT — NOT NULL
  • Field (promotion_ended_at) — DATETIME(6)
  • Field (next_payment_at) — DATETIME(6) — NOT NULL
  • Field (expiration_at) — DATETIME(6)
  • Field (ended_at) — DATETIME(6) — NOT NULL
  • Field (first_transaction_id) — VARCHAR(65) — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL
  • Field (updated_at) — datetime(6) — NOT NULL
  • Field (market_type) — VARCHAR(65)
  • Field (renewal_count) — INT — NOT NULL