Affiliate Id Coding

Hello all,

I'm trying to write code for when a users signs up, he'll be given an affiliate id.  How would I make a table in the database for this?  Would I add "AffiliateId" to the members table?  And when they click on create user, what would be the coding to automatically assign affiliate id to users?  Thank you!
...