Square-database-structure

Latest version: v2.1.0

Safety actively analyzes 693883 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

Page 2 of 3

1.3.0

- add support for stored procedures and functions.

**Full Changelog**: https://github.com/thepmsquare/square_database_structure/compare/1.2.0...1.3.0

1.2.0

- move data to separate file for each schema.
- add enums file for each schema.

**Full Changelog**: https://github.com/thepmsquare/square_database_structure/compare/1.1.0...1.2.0

1.1.0

Creating Tables

Once you have defined your databases, schemas, and tables, you can create them in your PostgreSQL database by using the create_database_and_tables function.
python
from square_database_structure import create_database_and_tables

Define the database connection details
db_username = "your_username"
db_password = "your_password"
db_ip = "localhost"
db_port = 5432

Call the function to create the database and tables
create_database_and_tables(db_username, db_password, db_ip, db_port)


**Full Changelog**: https://github.com/thepmsquare/square_database_structure/compare/1.0.3...1.1.0

1.0.3

- change structure of square->authentication->UserApp and square->authentication->UserSession (due to complications with
Composite Key).
- change default data in square->public->app.

**Full Changelog**: https://github.com/thepmsquare/square_database_structure/compare/1.0.2...1.0.3

1.0.2

- replace file_purpose with app_id in file_storage.

**Full Changelog**: https://github.com/thepmsquare/square_database_structure/compare/1.0.1...1.0.2

1.0.1

- add main.py file to have explicit mapping and ordering for schemas to be created.
- move database and schema names to __init__.
- add app table in public, change user, remove profile and add user app and remove enums.

**Full Changelog**: https://github.com/thepmsquare/square_database_structure/compare/1.0.0...1.0.1

Page 2 of 3

© 2025 Safety CLI Cybersecurity Inc. All Rights Reserved.