...

Generate human readable declaration number

• Use algorithm to generate declaration_number
• Declaration number should consist of a 4 serial symbols and 8 number symbols and looks like XXXX-12H4-245D
• Add field to ops.declarations - declaration_number

Validate uniqueness of human readable declaration number

• generate declaration_number
• SELECT declaration_id FROM declarations where declaration_number=$.declaration_number
• if exists = go to 'generate declaration_number'
• else save declaration_number to declaration_request