![SQL server datetime with getdate() default value for timestamp](https://www.datensen.com/blog/wp-content/uploads/default-value-timestamp-sql-server.png)
Tag: database modeling
Articles related to database modeling in Moon Modeler and Luna Modeler – ER diagram tools for both relational and noSQL databases.
![SQL server datetime with getdate() default value for timestamp](https://www.datensen.com/blog/wp-content/uploads/default-value-timestamp-sql-server.png)
![Identity column in SQL Server database design](https://www.datensen.com/blog/wp-content/uploads/identity-autoincrement-sql-server.png)
How to Add an Identity Column to SQL Server Database Design
![Data modeling tools](https://www.datensen.com/blog/wp-content/uploads/data-modeling-tools-512-4.jpg)
Top 5 Data Modeling Tools to know in 2024
![ERD from SQL Server Express Database.](https://www.datensen.com/blog/wp-content/uploads/sql-express-erd.jpg)
How to visualize SQL Server Express Database
![ER diagram from Azure SQL Server database](https://www.datensen.com/blog/wp-content/uploads/loaded-structure-1.png)
Step-by-Step Guide: Creating an ER Diagram from Azure SQL Server Database Structure
![](https://www.datensen.com/blog/wp-content/uploads/project-repair.png)
How to repair your project
![SQL Server Database Connection](https://www.datensen.com/blog/wp-content/uploads/connection-sql-server-servername-1.png)
Deprecation Warning: Setting the TLS ServerName to an IP address is not permitted by RFC 6066
![Luna Modeler - database design tool for PostgreSQL](https://www.datensen.com/blog/wp-content/uploads/luna-modeler-postgresql-gui-database-design.jpg)
Top 5 GUI tools for PostgreSQL in 2024
![Logical data model for multiple database systems](https://www.datensen.com/blog/wp-content/uploads/logical-data-model-multiple-databases.jpg)
Benefits of data modeling for multiple database systems
![Logical data model](https://www.datensen.com/blog/wp-content/uploads/logical-data-model.jpg)
Logical data model
![Database Schema Conversion](https://www.datensen.com/blog/wp-content/uploads/original-database-schema.png)
How to Convert a Database Schema
![ER Diagram with subject area](https://www.datensen.com/blog/wp-content/uploads/erd-diagram-subject-area.jpg)
Subject Areas in ER Diagrams & Schema Designs
![Database Schema Conversion](https://www.datensen.com/blog/wp-content/uploads/converted-database-schema.png)
Database Schema Conversion in Luna Modeler
![Datatype aliases in ERD](https://www.datensen.com/blog/wp-content/uploads/datatype-alias-erd-diagram.jpg)
Datatype aliases
![Database Entity with Attributes](https://www.datensen.com/blog/wp-content/uploads/database-entity-with-attributes.png)
What is a Database Entity
![Database diagram](https://www.datensen.com/blog/wp-content/uploads/database-diagram.jpg)
How to Create a Database Diagram?
![Code defined for other database object in ER diagram for PostgreSQL.](https://www.datensen.com/blog/wp-content/uploads/postgresql-function.png)
Other database objects in PostgreSQL
![PostgreSQL Composite Properties](https://www.datensen.com/blog/wp-content/uploads/postgresql-composite-properties.png)
Composite types & PostgreSQL ER Diagram
![Relationships in ERD for PostgreSQL](https://www.datensen.com/blog/wp-content/uploads/postgresql-relationships-new.webp)
Relationships in ER diagrams for PostgreSQL
![PostgreSQL indexes in an ER diagram](https://www.datensen.com/blog/wp-content/uploads/postgresql-indexes-er-diagram.webp)
PostgreSQL Indexes
![Diagram used instead of the show collections command in MongoDB](https://www.datensen.com/blog/wp-content/uploads/mongodb-show-collections-moon-modeler.webp)
How to list databases and show collections in MongoDB
![Top 5 Benefits of Database Modeling Tools](https://www.datensen.com/blog/wp-content/uploads/sql-server-script.png)
Top 5 Benefits of Database Modeling Tools
![Database modeling for SQL Server](https://www.datensen.com/blog/wp-content/uploads/database-design-sql-server.png)
Database modeling for SQL Server
![Database modeling](https://www.datensen.com/blog/wp-content/uploads/database-modeling.webp)
What is database modeling?
![Luna Modeler - Advanced copy and paste](https://www.datensen.com/blog/wp-content/uploads/luna-modeler-copy-table.png)
Advanced Copy and Paste in Luna Modeler
![SQL Server Indexes in ERD](https://www.datensen.com/blog/wp-content/uploads/sql-server-indexes-er-diagram.png)
SQL Server indexes
![ER diagram for SQL Server - SQL script generated by Luna Modeler](https://www.datensen.com/blog/wp-content/uploads/sql-server-script-from-diagram.webp)
How to generate SQL script for SQL Server
![Project update in Luna Modeler](https://www.datensen.com/blog/wp-content/uploads/update-project-link.png)
Updating SQL Server projects
![Loading SQL Server database structure | Luna Modeler data modeling tool](https://www.datensen.com/blog/wp-content/uploads/load-database-structure-sql-server.jpg)
Visualization of existing SQL Server databases
![SQL Server database design](https://www.datensen.com/blog/wp-content/uploads/sql-server-database-design.png)
SQL Server database design
![SQLite comparison](https://www.datensen.com/blog/wp-content/uploads/sqlite-comparison.png)
Updating SQLite projects
![How to update a database model for PostgreSQL](https://www.datensen.com/blog/wp-content/uploads/update-database-model-postgresql.jpg)
Updating PostgreSQL projects
![Luna Modeler](https://www.datensen.com/blog/wp-content/uploads/about-luna-modeler.png)
About Luna Modeler
![MongoDB Schema Design](https://www.datensen.com/blog/wp-content/uploads/mongodb-schema-design.jpg)
MongoDB schema design
![Heroku PostgreSQL ERD made with Luna Modeler](https://www.datensen.com/blog/wp-content/uploads/pg-heroku-1-1.png)
Heroku Postgres and ER diagrams
![MongoDB indexes](https://www.datensen.com/blog/wp-content/uploads/2021/10/mongodb-index-1.png)
MongoDB indexes
![Crow's feet notation in ERD](https://www.datensen.com/blog/wp-content/uploads/crows-feet-notation-erd.png)
Crow’s foot notation in ER diagram
![MongoDB ER Diagram](https://www.datensen.com/blog/wp-content/uploads/mongodb-er-diagram-3.jpg)
MongoDB ER diagram & Graphics
![entity relationship diagram](https://www.datensen.com/blog/wp-content/uploads/entity-relationship-diagram.png)
What is Entity Relationship Diagram (ERD)?
![ERD exported to PDF](https://www.datensen.com/blog/wp-content/uploads/erd-exported-to-pdf.png)
Export ER diagram to PDF
![Custom data types](https://www.datensen.com/blog/wp-content/uploads/custom-data-types.png)
Custom data types
![MongoDB Default Values](https://www.datensen.com/blog/wp-content/uploads/mongodb-default-values-1.png)
Default values
![Forward engineering](https://www.datensen.com/blog/wp-content/uploads/forward-engineering.png)
Forward engineering
![Reverse engineering of a database structure](https://www.datensen.com/blog/wp-content/uploads/reverse-engineering.png)
Reverse engineering
![A list of projects in data modeling tool](https://www.datensen.com/blog/wp-content/uploads/projects.jpg)
Projects
![Freeware database modeling tool](https://www.datensen.com/blog/wp-content/uploads/freeware-database-modeling-tool.jpg)
Free ER diagram tool?
![ERD for SQLite made in Luna Modeler - ERD Creator for SQLite](https://www.datensen.com/blog/wp-content/uploads/erd-sqlite-luna-modeler-erd-creator.webp)
Import & Visualization of existing SQLite databases
![ER diagram SQLite](https://www.datensen.com/blog/wp-content/uploads/er-diagram-sqlite.webp)
SQLite database design
![Connection to MySQL database in Luna Modeler - ERD Creator](https://www.datensen.com/blog/wp-content/uploads/connection-mysql-detail.png)
Visualization of existing MySQL databases
![SQL Script generated for MySQL](https://www.datensen.com/blog/wp-content/uploads/2022/03/sql-script-mysql.png)