create table credit_cards (
  name_on_card text not null,
  billing_address ,
  card_type text not null,
  card_number text not null,
  authorized_amount numeric not null,
  full_amount numeric not null,
  expiry_date text not null,
  auth_code text not null,
  response_code integer not null,
  merchant_id integer,
  register_number text,
  transaction_number text not null,
  avs_response text not null
);
comment on table credit_cards is '
  A customer's complete credit card information
';

comment on column credit_cards.expiry_date is '
  MM-YY that the credit card expires
';
comment on column credit_cards.auth_code is '
  CVV code on the back of the card
';
comment on column credit_cards.avs_response is '
  Address Verification System response, Codes are available here: https://www.chasepaymentech.com/address_verification_service.html
';