create table payments (
  payid bigint not null,
  actorid text not null,
  amount numeric not null,
  ref_accountid bigint not null,
  payment_method text not null,
  operatorid text not null,
  phone bigint not null,
  pin integer not null,
  currency text not null,
  payment_context text not null
);
comment on table payments is '
  Payment is defined by the app specifically to emit users transactions.
';

comment on column payments.payid is '
  Internal unique identifier for this payment.
';
comment on column payments.actorid is '
  The username registered in the application
';
comment on column payments.amount is '
  The amount to send. This field allowed the processing transactions.
';
comment on column payments.ref_accountid is '
  The accountid to use to send money to the specific account.
';
comment on column payments.payment_method is '
  The type of payment to use [Mobile Money or Credit Card].
';
comment on column payments.operatorid is '
  The operator specified the type of payment if Mobile Money.
';
comment on column payments.phone is '
  The phone identifying specific account of consumer.
';
comment on column payments.pin is '
  The code used to validate the transaction.
';
comment on column payments.currency is '
  The phone identifying specific account of consumer.
';
comment on column payments.payment_context is '
  This field specify the type of transaction [Buying, Deposit, Withdraw].
';