^Field ^Type ^Null ^Key ^Default ^Extra^ | id | int(11) | NO | | 0 | | | account_id | int(11) | YES | | NULL | | | discount | double | YES | | NULL | | | discount_with_tax | double | YES | | NULL | | | service_id | int(11) | YES | | NULL | | | discount_period_id | int(11) | YES | | NULL | | | slink_id | int(11) | YES | | NULL | | | discount_date | int(11) | YES | MUL | NULL | | | discount_date_hour | int(11) | YES | | NULL | | | discount_date_day | int(11) | YES | | NULL | | | discount_date_month | int(11) | YES | | NULL | | | t_class | int(11) | YES | | 0 | | | base_cost | double | YES | | 0 | | | ipid | int(11) | YES | | 0 | | | bytes | bigint(20) | YES | | NULL | | | is_canceled | int(11) | YES | | 0 | | | cancel_id | int(11) | YES | | 0 | | ^Table ^ Non_unique ^ Key_name ^ Seq_in_index ^ Column_name ^ Collation ^ Cardinality ^ Sub_part ^ Packed ^ Null ^ Index_type ^ Comment ^ | discount_transactions_iptraffic_all | 1 | my_dtr | 1 | discount_date | A | 1460233 | NULL | NULL | YES | BTREE | | | discount_transactions_iptraffic_all | 1 | my_dtr | 2 | account_id | A | 10221631 | NULL | NULL | YES | BTREE | | | discount_transactions_iptraffic_all | 1 | index_71be80c932a1d596a863a4f87ba05a03 | 1 | discount_date | A | 1460233 | NULL | NULL | YES | BTREE | | | discount_transactions_iptraffic_all | 1 | index_71be80c932a1d596a863a4f87ba05a03 | 2 | account_id | A | 10221631 | NULL | NULL | YES | BTREE | | | discount_transactions_iptraffic_all | 1 | index_71be80c932a1d596a863a4f87ba05a03 | 3 | ipid | A | 10221631 | NULL | NULL | YES | BTREE | | | discount_transactions_iptraffic_all | 1 | index_71be80c932a1d596a863a4f87ba05a03 | 4 | discount_date_hour | A | 10221631 | NULL | NULL | YES | BTREE | | | discount_transactions_iptraffic_all | 1 | index_71be80c932a1d596a863a4f87ba05a03 | 5 | discount_date_day | A | 10221631 | NULL | NULL | YES | BTREE | | | discount_transactions_iptraffic_all | 1 | index_71be80c932a1d596a863a4f87ba05a03 | 6 | discount_date_month | A | 10221631 | NULL | NULL | YES | BTREE | | | discount_transactions_iptraffic_all | 1 | index_71be80c932a1d596a863a4f87ba05a03 | 7 | t_class | A | 10221631 | NULL | NULL | YES | BTREE | | | discount_transactions_iptraffic_all | 1 | index_71be80c932a1d596a863a4f87ba05a03 | 8 | base_cost | A | 10221631 | NULL | NULL | YES | BTREE | | | discount_transactions_iptraffic_all | 1 | index_71be80c932a1d596a863a4f87ba05a03 | 9 | slink_id | A | 10221631 | NULL | NULL | YES | BTREE | | | discount_transactions_iptraffic_all | 1 | index_71be80c932a1d596a863a4f87ba05a03 | 10 | bytes | A | 10221631 | NULL | NULL | YES | BTREE | | | discount_transactions_iptraffic_all | 1 | index_71be80c932a1d596a863a4f87ba05a03 | 11 | discount | A | 10221631 | NULL | NULL | YES | BTREE | | | discount_transactions_iptraffic_all | 1 | index_71be80c932a1d596a863a4f87ba05a03 | 12 | discount_with_tax | A | 10221631 | NULL | NULL | YES | BTREE | |