All database connections are available in the Connections section. To create a new connection, click the Connections button on the main toolbar, and then click Create New Connection. A new modal form opens. Select MySQL and enter the connection details.
When you are finished, click the Save Connection button.
Your new MySQL connection will appear in the list of all database connections.… Read the rest
To generate SQL script from your project click the Script icon on the main toolbar. The SQL Script modal form opens.
Click Save Script and select a location where the file should be stored.
You can control how the script will be generated on the Generation settings tab
The order in which the objects will be in the resulting SQL script can be modified on the Order items tab.… Read the rest
To define or edit table keys, edit your table and navigate to tab Keys or change values directly in the right-side panel in section Keys.
A primary key exists in every table. If you wish to add a new alternate key, click the button + Add Key.… Read the rest
In Moon Modeler you can easily draw MySQL structures.
Database tables are displayed as graphical boxes with all column fields.
One of the main advantages of Moon Modeler is the possibility to visually display nested structures.
The structures are displayed inside tables and also as separate graphical objects.… Read the rest
Quick-start guide for MySQL DB database design
To create a new project, click the New icon on the main toolbar and select the MySQL project type.… Read the rest
What primary keys are and what they are used for is explained in the article describing the difference between primary and foreign keys.
A short summary: Primary keys serve as the identifier of a unique record, it can be unique information, such as a driver’s license number, telephone number including area code, car VIN number, etc.… Read the rest
Primary keys serve as the identifier of a unique record in a database table. It can be unique information, such as a driver’s license number, telephone number including area code, car VIN number, etc.
CREATE TABLE `ecommerce`.`customer` (
`driving_license` VARCHAR(100),
`name` VARCHAR(150) NOT NULL,
`surname` VARCHAR(150) NOT NULL,
`email` VARCHAR(150),
`phone` VARCHAR(200),
PRIMARY KEY `Primary key`(
`driving_license`
)
)
ENGINE = InnoDB;A primary key can contain one or more columns.… Read the rest