DPL-880-1 Add a new postgresql table for storing the prefixes instead of a config file to avoid deployment of baracoda for adding a prefix

[Sangeetha-Bheeman]

User story
As PSD developer I want to create a new postgresql table for storing the prefixes instead of a config file to avoid deployment of baracoda for adding a prefix.

Who are the primary contacts for this story
Sangeetha, Steve

Who is the nominated tester for UAT
Sangeetha
Acceptance criteria
To be considered successful the solution must allow:

• to store the prefixes in a postgresql table
• to be able to read/write to the database to retrieve existing prefixes and create new prefixes.
• the application should continue to work as expected without any loss of service to the users.

Dependencies

• DPL-880 Baracoda to add/remove/retrieve prefixes using UI backed in database (S=L; C=M) #417
• DPL-890-2 Add a new UI and the endpoint to allow the creation of new prefixes #471
• DPL-880-3 Add a new UI to show all prefix data and also provide the ability to mark a prefix as inactive and not delete. #472

Additional context
Add any other context or screenshots about the feature request here.

[Sangeetha-Bheeman]

Tasks:

• Create a new table named prefixes with the following fields:

Column name	Type	Description
Id	SERIAL
prefix	VARCHAR(32) NOT NULL	The prefix to be created
barcode_format	VARCHAR(255) NOT NULL	Format for the barcode like -. Example: ASDF-A34ADA
sequence_name	VARCHAR(32) NOT NULL	The sequence name to use like heron, pam, csm etc to maintain the sequence number
enable_children_creation	BOOLEAN NOT NULL	True/False to allow child barcode creation
is_active	BOOLEAN NOT NULL	True/False to maintain list of active/inactive prefixes
created_at	TIMESTAMP NOT NULL	Creation timestamp
modified_at	TIMESTAMP	Modified timestamp

• Add a migration to create the table.
• Write script to seed the existing prefixes from the config/defaults to the new table.