sql – How to define a composite key object in SQLite?

I am doing an integrated database as a means of fieldwork in the integration between two systems. The system A, where you have the data, export all your data to the system B already correctly mapped.

However, if I want the performance, A should only send to B the changes made. Then he enters the middle of the field, M.

B informs its structure for Mfor example:

{
"Columns": [
    {"chave":true,"nome":"cd_meio_pgto"},
    {"nome":"ds_meio_pgto","chave":true}
  ],
"table_name": "interim_payment"
}

However, they can scroll composite keys. For example:

{
"Columns": [
    {"chave":true,"nome":"cd_meio_pgto"},
    {"nome":"ds_meio_pgto","chave":true},
    {"nome":"chave_01","chave":true}
  ],
"table_name": "middle_exp_example"
}

For the integration to work perfectly, I need to M to be able to regularly maintain a sufficient copy of A & # 39; (the data in A after applying the matches) with the data reported by B.

For the built-in database, we are studying the use of SQLite. However, how to create a composite primary key in SQLite?

Considering all type columns TEXT, how are the tables middle_payment? E middle_expand_example?