We are building a bulk sms platform. The platform is multi-tenancy where we have a superadmin that creates admins. 
Each admin can create clients. The clients are the ones who send out the bulk smses.

The admin will be responsible for creating senderIDs which are alphanumeric and Shortcodes which are numeric.
the senderIDs and shortcodes will be used by the clients to send out the bulk smses.
so the client will have a dashboard and it will do the following:
1. Create users under the client who will have rights to send out smses on his behalf.
2. Create groups of msidns to which the smses will be sent out.
3. Create templates for the smses that will be sent out.
4. Create campaigns for sending out the smses. but the campaignd will default to the name of the group
5. Abiltiy to upload contants in bulk using csv files. and add them to groups.
6. Ability to schedule smses


We shall start with client dashboard for now we shall use default client with id 1.

lets create the db structure first.