Please forgive this rudimentary question but I do not have access to our SQL database and I need to be able to describe how to set up a table to store an incremented number so we can assign application numbers.  The caveat is that we need to restart the numbering every year.

Can anyone help me describe how the sql table needs to be formatted/set up so I can let our database manager know our needs?  Is it one column?  Does it maintain the date?  We understand how to do this once the table has been set up but it is designing the table that is giving us a headache.

Our ultimate goal is to address our need to not only assign a permit number but extract information submitted with an online form associated with this assigned number.   Should the table include these fields of basic permit information also?