Start Designing For Free | DbDesigner.net Guest Login

Click "Add Field" at the bottom of the table to add a new field. The new field will be added as the last field to the table. You can change order of the fields by dragging the small up-down icon. Right click on the table to delete or clone the table and to change table color.

Save Cancel Delete

Creating Relationships To create a relation between two tables, you need to add a "Foreign Key" to a table. When adding a new field click on "Foreign Key" and select the "Referenced Table" and "Referenced Field"

Save Cancel Delete

Students

Table Name Table Comment Cancel Delete Table
	id	integer
	grade	float
	created_at	datetime
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

Teachers

Table Name Table Comment Cancel Delete Table
	id	integer
	student_id	integer
	name	string
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

Courses

Table Name Table Comment Cancel Delete Table
	id	integer
	name	string
	created_at	datetime
	updated_at	datetime
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

StudentCourses

Table Name Table Comment Cancel Delete Table
	id	integer
	student_id	integer
	course_id	integer
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

Schema Name:	Guest Template
Database:	generic