Need help in designing database schema

See more:

SQL

database

SQL-Server-2008R2

, +

Hi
i have a system "x" which has some promocodes, when user logs in to system x, then SMS is sent to user with unique promocode

System x has some 3rd party app when user trys to register or login to that app using promocode

Then 3rd party system registers user or it authenticates it and send a response to system x as user has logged in with promocode and credentials used

How should i  design database schema for such scenario

What I have tried:

i have created a table which as Xpromocodes which as field as id, promocode,lodingForX
and another table which will have data return from 3rd party app
table:promoReturned
id
promocode
applogin