netflix_billing_history

✎ View and edit SQL

This data as json

0 records

CREATE TABLE `netflix_billing_history` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`transaction_date` datetime,`service_period_start_date` datetime,`service_period_end_date` datetime,`description` text,`payment_type` text,`mop_last4` text,`mop_creation_date` datetime,`mop_pmt_processor_desc` text,`item_price_amt` real,`currency` text,`tax_amt` real,`gross_sale_amt` real,`pmt_txn_type` text,`pmt_status` text,`final_invoice_result` text,`country` text,`next_billing_date` datetime,PRIMARY KEY (`id`));
CREATE UNIQUE INDEX `netflix_billing_history_key` ON `netflix_billing_history`(`transaction_date`,`payment_type`,`mop_last4`,`pmt_txn_type`,`pmt_status`,`final_invoice_result`);
CREATE INDEX `idx_netflix_billing_history_deleted_at` ON `netflix_billing_history`(`deleted_at`);