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