ORM🏹: models.py와 sqlite create문 비교하기

1. 장고의 models.py

(venv) (base) marie@MarieJucBookPro:~/PycharmProjects/play-with-django(play-with-orm⚡) » cat play_with_orm_app/models.py 
from django.db import models


class Publisher(models.Model):
    name = models.CharField(max_length=255)

    def __str__(self):
        return self.name


class Book(models.Model):
    name = models.CharField(max_length=255)
    price = models.IntegerField(default=0)
    publisher = models.ForeignKey(Publisher, on_delete=models.CASCADE, related_name='books')

    def __str__(self):
        return self.name


class Store(models.Model):
    name = models.CharField(max_length=255)
    books = models.ManyToManyField(Book, related_name='stores')

    def __str__(self):
        return self.name
(venv) (base) marie@MarieJucBookPro:~/PycharmProjects/play-with-django(play-with-orm⚡) » 

2-1. sqlite에서 생성된 테이블 확인

2-2. sqlite에서 생성된 테이블의 스키마 확인

1) Publisher 클래스

CREATE TABLE "play_with_orm_app_publisher" 
("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, 
 "name" varchar(255) NOT NULL)

2) Book 클래스

CREATE TABLE "play_with_orm_app_book" 
("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, 
 "name" varchar(255) NOT NULL, 
 "price" integer NOT NULL,  
 "publisher_id" integer NOT NULL REFERENCES "play_with_orm_app_publisher" ("id") DEFERRABLE INITIALLY DEFERRED)

3) Store 클래스 (Many-to-Many 필드로 books라는 속성에 연결)

CREATE TABLE "play_with_orm_app_store" 
("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, 
 "name" varchar(255) NOT NULL)

4) 📌 store_books 테이블 (many-to-many field로 자동 생성됨)
Store클래스에서 books라는 테이블과 연결하는 맵핑테이블인! "play_with_orm_app_store_books"

• 여기서 맵핑테이블 이름의 네이밍규칙:

  "장고앱이름_'매니투매니필드설정을 한 클래스이름'_'매니투매니필드설정이 들어간 클래스속성이름'

CREATE TABLE "play_with_orm_app_store_books" 
("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, 
 "store_id" integer NOT NULL REFERENCES "play_with_orm_app_store" ("id") DEFERRABLE INITIALLY DEFERRED, 
 "book_id" integer NOT NULL REFERENCES "play_with_orm_app_book" ("id") DEFERRABLE INITIALLY DEFERRED)

여기서 잠깐!

"DEFERRABLE INITIALLY DEFERRED"은 무엇일까?

• https://begriffs.com/posts/2017-08-27-deferrable-sql-constraints.html