Django Model Data Types and Fields List

Model fields define what kind of data a database column will store and how that data should be handled.

• Every field represents a specific data type and controls how data is stored and validated.
• Fields also decide the default form widget used for user input.
• Django uses field classes to determine the database column type, form widget, and validation rules.
• Reserved names like save, delete, and clean should not be used as field names to avoid conflicts with Django’s model system.

from django.db import models

class Musician(models.Model):
    first_name = models.CharField(max_length=200)
    last_name = models.CharField(max_length=200)
    instrument = models.CharField(max_length=200)

class Album(models.Model):
    artist = models.ForeignKey(Musician, on_delete=models.CASCADE)
    name = models.CharField(max_length=100) 
    release_date = models.DateField()
    num_stars = models.IntegerField()

• CharField is used for short text like names or instruments.
• IntegerField stores numbers (e.g., star ratings).
• DateField holds date values.
• ForeignKey establishes a relationship between two models (Album- Musician). 

After creating and applying migrations, the above two tables are now created in the database.

Viewing and Inspecting Database Tables

To view the tables and their structure, use Django’s database shell. Open the DB shell by running:

python manage.py dbshell

Then run the SQLite commands:

.tables
.schema geeks_musician
.schema geeks_album

DB Browser for SQLite can also be used to view the database in a clear and easy-to-read interface:

Common Field Types in Django

Note: NullBooleanField (a boolean field that allowed True, False, or NULL) is deprecated. Use BooleanField(null=True, blank=True) instead.