Database script project design

Objective: To manage database scripts in a project

Requirements:

1. Script version management
2. Maintain script execution sequence
   1. Create a table
      1. Create by Table Category in sequence:
         1. Enum table, for example: all countriesCodeTable, ethnic code table. These tables do not depend on other tables
         2. Basic entity tables, such as the employee information table. These tables are basic entities.
         3. Other tables depend on other tables in the preceding table.
      2. Sequence of creating each table
         1. Use create table to create a table
         2. Add constraints (own)
         3. Add foreign key constraints
         4. Insert static initial data (for example, country code)
   2. Create views, functions, and stored procedures: Create one by dependency
3. Run a script to install or reinstall the entire database.
4. Execute a script to regenerate a table (including structure, data, constraints, and so on)

 

Database test project

1. Run a script to generate or regenerate the test data.
2. Execute a script to automatically test database functions, stored procedures