CREATE TABLE public.tab_spend (
  id BIGINT NOT NULL ,
  user_id BIGINT NOT NULL ,
  user_account text,
  user_nickname text,
  game_id BIGINT NOT NULL ,
  game_appid text ,
  game_name text ,
  server_id text ,
  server_name text ,
  game_player_id text ,
  game_player_name text,
  promote_id BIGINT NOT NULL ,
  promote_account text,
  order_number text ,
  pay_order_number text ,
  props_name text ,
  pay_amount numeric(10,2) ,
  pay_time BIGINT ,
  pay_status int4,
  pay_game_status int4 ,
  extend text ,
  pay_way int4 ,
  spend_ip text ,
  settle_check int4 NOT NULL ,
  selle_status BIGINT NOT NULL ,
  selle_ratio DOUBLE PRECISION ,
  sub_status BIGINT NOT NULL,
  selle_time text ,
  sdk_version int4 ,
  cost numeric(10,2) ,
  discount_type BIGINT ,
  auto_compensation BIGINT ,
  diamond text,
  payplatform2cp text ,
  platform_id BIGINT ,
  settle_ratio_id BIGINT  ,
  pay_game_amount numeric(10,2) ,
  settle_state int4 NOT NULL ,
  ratio_state int4 NOT NULL ,
  is_box_pay int4 NOT NULL ,
  create_time BIGINT NOT NULL ,
  pay_company text ,
  live_no BIGINT NOT NULL ,
  scene int4 NOT NULL ,
  main_server_id BIGINT ,
  refund_type int4 ,
  ticket_type int4 ,
  pay_uid text
,PRIMARY KEY (id)
)