fields.txt 89 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445
  1. =====================
  2. Model field reference
  3. =====================
  4. .. module:: django.db.models.fields
  5. :synopsis: Built-in field types.
  6. .. currentmodule:: django.db.models
  7. This document contains all the API references of :class:`Field` including the
  8. `field options`_ and `field types`_ Django offers.
  9. .. seealso::
  10. If the built-in fields don't do the trick, you can try `django-localflavor
  11. <https://github.com/django/django-localflavor>`_ (`documentation
  12. <https://django-localflavor.readthedocs.io/>`_), which contains assorted
  13. pieces of code that are useful for particular countries and cultures.
  14. Also, you can easily :doc:`write your own custom model fields
  15. </howto/custom-model-fields>`.
  16. .. note::
  17. Technically, these models are defined in :mod:`django.db.models.fields`, but
  18. for convenience they're imported into :mod:`django.db.models`; the standard
  19. convention is to use ``from django.db import models`` and refer to fields as
  20. ``models.<Foo>Field``.
  21. .. _common-model-field-options:
  22. Field options
  23. =============
  24. The following arguments are available to all field types. All are optional.
  25. ``null``
  26. --------
  27. .. attribute:: Field.null
  28. If ``True``, Django will store empty values as ``NULL`` in the database. Default
  29. is ``False``.
  30. Avoid using :attr:`~Field.null` on string-based fields such as
  31. :class:`CharField` and :class:`TextField`. If a string-based field has
  32. ``null=True``, that means it has two possible values for "no data": ``NULL``,
  33. and the empty string. In most cases, it's redundant to have two possible values
  34. for "no data;" the Django convention is to use the empty string, not
  35. ``NULL``. One exception is when a :class:`CharField` has both ``unique=True``
  36. and ``blank=True`` set. In this situation, ``null=True`` is required to avoid
  37. unique constraint violations when saving multiple objects with blank values.
  38. For both string-based and non-string-based fields, you will also need to
  39. set ``blank=True`` if you wish to permit empty values in forms, as the
  40. :attr:`~Field.null` parameter only affects database storage
  41. (see :attr:`~Field.blank`).
  42. .. note::
  43. When using the Oracle database backend, the value ``NULL`` will be stored to
  44. denote the empty string regardless of this attribute.
  45. ``blank``
  46. ---------
  47. .. attribute:: Field.blank
  48. If ``True``, the field is allowed to be blank. Default is ``False``.
  49. Note that this is different than :attr:`~Field.null`. :attr:`~Field.null` is
  50. purely database-related, whereas :attr:`~Field.blank` is validation-related. If
  51. a field has ``blank=True``, form validation will allow entry of an empty value.
  52. If a field has ``blank=False``, the field will be required.
  53. .. admonition:: Supplying missing values
  54. ``blank=True`` can be used with fields having ``null=False``, but this will
  55. require implementing :meth:`~django.db.models.Model.clean` on the model in
  56. order to programmatically supply any missing values.
  57. .. _field-choices:
  58. ``choices``
  59. -----------
  60. .. attribute:: Field.choices
  61. A :term:`sequence` consisting itself of iterables of exactly two items (e.g.
  62. ``[(A, B), (A, B) ...]``) to use as choices for this field. If choices are
  63. given, they're enforced by :ref:`model validation <validating-objects>` and the
  64. default form widget will be a select box with these choices instead of the
  65. standard text field.
  66. The first element in each tuple is the actual value to be set on the model,
  67. and the second element is the human-readable name. For example::
  68. YEAR_IN_SCHOOL_CHOICES = [
  69. ("FR", "Freshman"),
  70. ("SO", "Sophomore"),
  71. ("JR", "Junior"),
  72. ("SR", "Senior"),
  73. ("GR", "Graduate"),
  74. ]
  75. Generally, it's best to define choices inside a model class, and to
  76. define a suitably-named constant for each value::
  77. from django.db import models
  78. class Student(models.Model):
  79. FRESHMAN = "FR"
  80. SOPHOMORE = "SO"
  81. JUNIOR = "JR"
  82. SENIOR = "SR"
  83. GRADUATE = "GR"
  84. YEAR_IN_SCHOOL_CHOICES = [
  85. (FRESHMAN, "Freshman"),
  86. (SOPHOMORE, "Sophomore"),
  87. (JUNIOR, "Junior"),
  88. (SENIOR, "Senior"),
  89. (GRADUATE, "Graduate"),
  90. ]
  91. year_in_school = models.CharField(
  92. max_length=2,
  93. choices=YEAR_IN_SCHOOL_CHOICES,
  94. default=FRESHMAN,
  95. )
  96. def is_upperclass(self):
  97. return self.year_in_school in {self.JUNIOR, self.SENIOR}
  98. Though you can define a choices list outside of a model class and then
  99. refer to it, defining the choices and names for each choice inside the
  100. model class keeps all of that information with the class that uses it,
  101. and helps reference the choices (e.g, ``Student.SOPHOMORE``
  102. will work anywhere that the ``Student`` model has been imported).
  103. .. _field-choices-named-groups:
  104. You can also collect your available choices into named groups that can
  105. be used for organizational purposes::
  106. MEDIA_CHOICES = [
  107. (
  108. "Audio",
  109. (
  110. ("vinyl", "Vinyl"),
  111. ("cd", "CD"),
  112. ),
  113. ),
  114. (
  115. "Video",
  116. (
  117. ("vhs", "VHS Tape"),
  118. ("dvd", "DVD"),
  119. ),
  120. ),
  121. ("unknown", "Unknown"),
  122. ]
  123. The first element in each tuple is the name to apply to the group. The
  124. second element is an iterable of 2-tuples, with each 2-tuple containing
  125. a value and a human-readable name for an option. Grouped options may be
  126. combined with ungrouped options within a single list (such as the
  127. ``'unknown'`` option in this example).
  128. For each model field that has :attr:`~Field.choices` set, Django will add a
  129. method to retrieve the human-readable name for the field's current value. See
  130. :meth:`~django.db.models.Model.get_FOO_display` in the database API
  131. documentation.
  132. Note that choices can be any sequence object -- not necessarily a list or
  133. tuple. This lets you construct choices dynamically. But if you find yourself
  134. hacking :attr:`~Field.choices` to be dynamic, you're probably better off using
  135. a proper database table with a :class:`ForeignKey`. :attr:`~Field.choices` is
  136. meant for static data that doesn't change much, if ever.
  137. .. note::
  138. A new migration is created each time the order of ``choices`` changes.
  139. .. _field-choices-blank-label:
  140. Unless :attr:`blank=False<Field.blank>` is set on the field along with a
  141. :attr:`~Field.default` then a label containing ``"---------"`` will be rendered
  142. with the select box. To override this behavior, add a tuple to ``choices``
  143. containing ``None``; e.g. ``(None, 'Your String For Display')``.
  144. Alternatively, you can use an empty string instead of ``None`` where this makes
  145. sense - such as on a :class:`~django.db.models.CharField`.
  146. .. _field-choices-enum-types:
  147. Enumeration types
  148. ~~~~~~~~~~~~~~~~~
  149. In addition, Django provides enumeration types that you can subclass to define
  150. choices in a concise way::
  151. from django.utils.translation import gettext_lazy as _
  152. class Student(models.Model):
  153. class YearInSchool(models.TextChoices):
  154. FRESHMAN = "FR", _("Freshman")
  155. SOPHOMORE = "SO", _("Sophomore")
  156. JUNIOR = "JR", _("Junior")
  157. SENIOR = "SR", _("Senior")
  158. GRADUATE = "GR", _("Graduate")
  159. year_in_school = models.CharField(
  160. max_length=2,
  161. choices=YearInSchool,
  162. default=YearInSchool.FRESHMAN,
  163. )
  164. def is_upperclass(self):
  165. return self.year_in_school in {
  166. self.YearInSchool.JUNIOR,
  167. self.YearInSchool.SENIOR,
  168. }
  169. These work similar to :mod:`enum` from Python's standard library, but with some
  170. modifications:
  171. * Enum member values are a tuple of arguments to use when constructing the
  172. concrete data type. Django supports adding an extra string value to the end
  173. of this tuple to be used as the human-readable name, or ``label``. The
  174. ``label`` can be a lazy translatable string. Thus, in most cases, the member
  175. value will be a ``(value, label)`` two-tuple. See below for :ref:`an example
  176. of subclassing choices <field-choices-enum-subclassing>` using a more complex
  177. data type. If a tuple is not provided, or the last item is not a (lazy)
  178. string, the ``label`` is :ref:`automatically generated
  179. <field-choices-enum-auto-label>` from the member name.
  180. * A ``.label`` property is added on values, to return the human-readable name.
  181. * A number of custom properties are added to the enumeration classes --
  182. ``.choices``, ``.labels``, ``.values``, and ``.names`` -- to make it easier
  183. to access lists of those separate parts of the enumeration.
  184. .. warning::
  185. These property names cannot be used as member names as they would conflict.
  186. * The use of :func:`enum.unique()` is enforced to ensure that values cannot be
  187. defined multiple times. This is unlikely to be expected in choices for a
  188. field.
  189. Note that using ``YearInSchool.SENIOR``, ``YearInSchool['SENIOR']``, or
  190. ``YearInSchool('SR')`` to access or lookup enum members work as expected, as do
  191. the ``.name`` and ``.value`` properties on the members.
  192. .. _field-choices-enum-auto-label:
  193. If you don't need to have the human-readable names translated, you can have
  194. them inferred from the member name (replacing underscores with spaces and using
  195. title-case):
  196. .. code-block:: pycon
  197. >>> class Vehicle(models.TextChoices):
  198. ... CAR = "C"
  199. ... TRUCK = "T"
  200. ... JET_SKI = "J"
  201. ...
  202. >>> Vehicle.JET_SKI.label
  203. 'Jet Ski'
  204. Since the case where the enum values need to be integers is extremely common,
  205. Django provides an ``IntegerChoices`` class. For example::
  206. class Card(models.Model):
  207. class Suit(models.IntegerChoices):
  208. DIAMOND = 1
  209. SPADE = 2
  210. HEART = 3
  211. CLUB = 4
  212. suit = models.IntegerField(choices=Suit)
  213. It is also possible to make use of the `Enum Functional API
  214. <https://docs.python.org/3/library/enum.html#functional-api>`_ with the caveat
  215. that labels are automatically generated as highlighted above:
  216. .. code-block:: pycon
  217. >>> MedalType = models.TextChoices("MedalType", "GOLD SILVER BRONZE")
  218. >>> MedalType.choices
  219. [('GOLD', 'Gold'), ('SILVER', 'Silver'), ('BRONZE', 'Bronze')]
  220. >>> Place = models.IntegerChoices("Place", "FIRST SECOND THIRD")
  221. >>> Place.choices
  222. [(1, 'First'), (2, 'Second'), (3, 'Third')]
  223. .. _field-choices-enum-subclassing:
  224. If you require support for a concrete data type other than ``int`` or ``str``,
  225. you can subclass ``Choices`` and the required concrete data type, e.g.
  226. :class:`~datetime.date` for use with :class:`~django.db.models.DateField`::
  227. class MoonLandings(datetime.date, models.Choices):
  228. APOLLO_11 = 1969, 7, 20, "Apollo 11 (Eagle)"
  229. APOLLO_12 = 1969, 11, 19, "Apollo 12 (Intrepid)"
  230. APOLLO_14 = 1971, 2, 5, "Apollo 14 (Antares)"
  231. APOLLO_15 = 1971, 7, 30, "Apollo 15 (Falcon)"
  232. APOLLO_16 = 1972, 4, 21, "Apollo 16 (Orion)"
  233. APOLLO_17 = 1972, 12, 11, "Apollo 17 (Challenger)"
  234. There are some additional caveats to be aware of:
  235. - Enumeration types do not support :ref:`named groups
  236. <field-choices-named-groups>`.
  237. - Because an enumeration with a concrete data type requires all values to match
  238. the type, overriding the :ref:`blank label <field-choices-blank-label>`
  239. cannot be achieved by creating a member with a value of ``None``. Instead,
  240. set the ``__empty__`` attribute on the class::
  241. class Answer(models.IntegerChoices):
  242. NO = 0, _("No")
  243. YES = 1, _("Yes")
  244. __empty__ = _("(Unknown)")
  245. .. versionchanged:: 5.0
  246. Support for using enumeration types directly in the ``choices`` was added.
  247. ``db_column``
  248. -------------
  249. .. attribute:: Field.db_column
  250. The name of the database column to use for this field. If this isn't given,
  251. Django will use the field's name.
  252. If your database column name is an SQL reserved word, or contains
  253. characters that aren't allowed in Python variable names -- notably, the
  254. hyphen -- that's OK. Django quotes column and table names behind the
  255. scenes.
  256. ``db_comment``
  257. --------------
  258. .. versionadded:: 4.2
  259. .. attribute:: Field.db_comment
  260. The comment on the database column to use for this field. It is useful for
  261. documenting fields for individuals with direct database access who may not be
  262. looking at your Django code. For example::
  263. pub_date = models.DateTimeField(
  264. db_comment="Date and time when the article was published",
  265. )
  266. ``db_default``
  267. --------------
  268. .. versionadded:: 5.0
  269. .. attribute:: Field.db_default
  270. The database-computed default value for this field. This can be a literal value
  271. or a database function, such as :class:`~django.db.models.functions.Now`::
  272. created = models.DateTimeField(db_default=Now())
  273. More complex expressions can be used, as long as they are made from literals
  274. and database functions::
  275. month_due = models.DateField(
  276. db_default=TruncMonth(
  277. Now() + timedelta(days=90),
  278. output_field=models.DateField(),
  279. )
  280. )
  281. Database defaults cannot reference other fields or models. For example, this is
  282. invalid::
  283. end = models.IntegerField(db_default=F("start") + 50)
  284. If both ``db_default`` and :attr:`Field.default` are set, ``default`` will take
  285. precedence when creating instances in Python code. ``db_default`` will still be
  286. set at the database level and will be used when inserting rows outside of the
  287. ORM or when adding a new field in a migration.
  288. ``db_index``
  289. ------------
  290. .. attribute:: Field.db_index
  291. If ``True``, a database index will be created for this field.
  292. .. admonition:: Use the :attr:`~Options.indexes` option instead.
  293. Where possible, use the :attr:`Meta.indexes <Options.indexes>` option
  294. instead. In nearly all cases, :attr:`~Options.indexes` provides more
  295. functionality than ``db_index``. ``db_index`` may be deprecated in the
  296. future.
  297. ``db_tablespace``
  298. -----------------
  299. .. attribute:: Field.db_tablespace
  300. The name of the :doc:`database tablespace </topics/db/tablespaces>` to use for
  301. this field's index, if this field is indexed. The default is the project's
  302. :setting:`DEFAULT_INDEX_TABLESPACE` setting, if set, or the
  303. :attr:`~Options.db_tablespace` of the model, if any. If the backend doesn't
  304. support tablespaces for indexes, this option is ignored.
  305. ``default``
  306. -----------
  307. .. attribute:: Field.default
  308. The default value for the field. This can be a value or a callable object. If
  309. callable it will be called every time a new object is created.
  310. The default can't be a mutable object (model instance, ``list``, ``set``, etc.),
  311. as a reference to the same instance of that object would be used as the default
  312. value in all new model instances. Instead, wrap the desired default in a
  313. callable. For example, if you want to specify a default ``dict`` for
  314. :class:`~django.db.models.JSONField`, use a function::
  315. def contact_default():
  316. return {"email": "to1@example.com"}
  317. contact_info = JSONField("ContactInfo", default=contact_default)
  318. ``lambda``\s can't be used for field options like ``default`` because they
  319. can't be :ref:`serialized by migrations <migration-serializing>`. See that
  320. documentation for other caveats.
  321. For fields like :class:`ForeignKey` that map to model instances, defaults
  322. should be the value of the field they reference (``pk`` unless
  323. :attr:`~ForeignKey.to_field` is set) instead of model instances.
  324. The default value is used when new model instances are created and a value
  325. isn't provided for the field. When the field is a primary key, the default is
  326. also used when the field is set to ``None``.
  327. The default value can also be set at the database level with
  328. :attr:`Field.db_default`.
  329. ``editable``
  330. ------------
  331. .. attribute:: Field.editable
  332. If ``False``, the field will not be displayed in the admin or any other
  333. :class:`~django.forms.ModelForm`. They are also skipped during :ref:`model
  334. validation <validating-objects>`. Default is ``True``.
  335. ``error_messages``
  336. ------------------
  337. .. attribute:: Field.error_messages
  338. The ``error_messages`` argument lets you override the default messages that the
  339. field will raise. Pass in a dictionary with keys matching the error messages you
  340. want to override.
  341. Error message keys include ``null``, ``blank``, ``invalid``, ``invalid_choice``,
  342. ``unique``, and ``unique_for_date``. Additional error message keys are
  343. specified for each field in the `Field types`_ section below.
  344. These error messages often don't propagate to forms. See
  345. :ref:`considerations-regarding-model-errormessages`.
  346. ``help_text``
  347. -------------
  348. .. attribute:: Field.help_text
  349. Extra "help" text to be displayed with the form widget. It's useful for
  350. documentation even if your field isn't used on a form.
  351. Note that this value is *not* HTML-escaped in automatically-generated
  352. forms. This lets you include HTML in :attr:`~Field.help_text` if you so
  353. desire. For example::
  354. help_text = "Please use the following format: <em>YYYY-MM-DD</em>."
  355. Alternatively you can use plain text and
  356. :func:`django.utils.html.escape` to escape any HTML special characters. Ensure
  357. that you escape any help text that may come from untrusted users to avoid a
  358. cross-site scripting attack.
  359. ``primary_key``
  360. ---------------
  361. .. attribute:: Field.primary_key
  362. If ``True``, this field is the primary key for the model.
  363. If you don't specify ``primary_key=True`` for any field in your model, Django
  364. will automatically add a field to hold the primary key, so you don't need to
  365. set ``primary_key=True`` on any of your fields unless you want to override the
  366. default primary-key behavior. The type of auto-created primary key fields can
  367. be specified per app in :attr:`AppConfig.default_auto_field
  368. <django.apps.AppConfig.default_auto_field>` or globally in the
  369. :setting:`DEFAULT_AUTO_FIELD` setting. For more, see
  370. :ref:`automatic-primary-key-fields`.
  371. ``primary_key=True`` implies :attr:`null=False <Field.null>` and
  372. :attr:`unique=True <Field.unique>`. Only one primary key is allowed on an
  373. object.
  374. The primary key field is read-only. If you change the value of the primary
  375. key on an existing object and then save it, a new object will be created
  376. alongside the old one.
  377. The primary key field is set to ``None`` when
  378. :meth:`deleting <django.db.models.Model.delete>` an object.
  379. ``unique``
  380. ----------
  381. .. attribute:: Field.unique
  382. If ``True``, this field must be unique throughout the table.
  383. This is enforced at the database level and by model validation. If
  384. you try to save a model with a duplicate value in a :attr:`~Field.unique`
  385. field, a :exc:`django.db.IntegrityError` will be raised by the model's
  386. :meth:`~django.db.models.Model.save` method.
  387. This option is valid on all field types except :class:`ManyToManyField` and
  388. :class:`OneToOneField`.
  389. Note that when ``unique`` is ``True``, you don't need to specify
  390. :attr:`~Field.db_index`, because ``unique`` implies the creation of an index.
  391. ``unique_for_date``
  392. -------------------
  393. .. attribute:: Field.unique_for_date
  394. Set this to the name of a :class:`DateField` or :class:`DateTimeField` to
  395. require that this field be unique for the value of the date field.
  396. For example, if you have a field ``title`` that has
  397. ``unique_for_date="pub_date"``, then Django wouldn't allow the entry of two
  398. records with the same ``title`` and ``pub_date``.
  399. Note that if you set this to point to a :class:`DateTimeField`, only the date
  400. portion of the field will be considered. Besides, when :setting:`USE_TZ` is
  401. ``True``, the check will be performed in the :ref:`current time zone
  402. <default-current-time-zone>` at the time the object gets saved.
  403. This is enforced by :meth:`Model.validate_unique()` during model validation
  404. but not at the database level. If any :attr:`~Field.unique_for_date` constraint
  405. involves fields that are not part of a :class:`~django.forms.ModelForm` (for
  406. example, if one of the fields is listed in ``exclude`` or has
  407. :attr:`editable=False<Field.editable>`), :meth:`Model.validate_unique()` will
  408. skip validation for that particular constraint.
  409. ``unique_for_month``
  410. --------------------
  411. .. attribute:: Field.unique_for_month
  412. Like :attr:`~Field.unique_for_date`, but requires the field to be unique with
  413. respect to the month.
  414. ``unique_for_year``
  415. -------------------
  416. .. attribute:: Field.unique_for_year
  417. Like :attr:`~Field.unique_for_date` and :attr:`~Field.unique_for_month`.
  418. ``verbose_name``
  419. ----------------
  420. .. attribute:: Field.verbose_name
  421. A human-readable name for the field. If the verbose name isn't given, Django
  422. will automatically create it using the field's attribute name, converting
  423. underscores to spaces. See :ref:`Verbose field names <verbose-field-names>`.
  424. ``validators``
  425. --------------
  426. .. attribute:: Field.validators
  427. A list of validators to run for this field. See the :doc:`validators
  428. documentation </ref/validators>` for more information.
  429. .. _model-field-types:
  430. Field types
  431. ===========
  432. .. currentmodule:: django.db.models
  433. ``AutoField``
  434. -------------
  435. .. class:: AutoField(**options)
  436. An :class:`IntegerField` that automatically increments
  437. according to available IDs. You usually won't need to use this directly; a
  438. primary key field will automatically be added to your model if you don't specify
  439. otherwise. See :ref:`automatic-primary-key-fields`.
  440. ``BigAutoField``
  441. ----------------
  442. .. class:: BigAutoField(**options)
  443. A 64-bit integer, much like an :class:`AutoField` except that it is
  444. guaranteed to fit numbers from ``1`` to ``9223372036854775807``.
  445. ``BigIntegerField``
  446. -------------------
  447. .. class:: BigIntegerField(**options)
  448. A 64-bit integer, much like an :class:`IntegerField` except that it is
  449. guaranteed to fit numbers from ``-9223372036854775808`` to
  450. ``9223372036854775807``. The default form widget for this field is a
  451. :class:`~django.forms.NumberInput`.
  452. ``BinaryField``
  453. ---------------
  454. .. class:: BinaryField(max_length=None, **options)
  455. A field to store raw binary data. It can be assigned :class:`bytes`,
  456. :class:`bytearray`, or :class:`memoryview`.
  457. By default, ``BinaryField`` sets :attr:`~Field.editable` to ``False``, in which
  458. case it can't be included in a :class:`~django.forms.ModelForm`.
  459. .. attribute:: BinaryField.max_length
  460. Optional. The maximum length (in bytes) of the field. The maximum length is
  461. enforced in Django's validation using
  462. :class:`~django.core.validators.MaxLengthValidator`.
  463. .. admonition:: Abusing ``BinaryField``
  464. Although you might think about storing files in the database, consider that
  465. it is bad design in 99% of the cases. This field is *not* a replacement for
  466. proper :doc:`static files </howto/static-files/index>` handling.
  467. ``BooleanField``
  468. ----------------
  469. .. class:: BooleanField(**options)
  470. A true/false field.
  471. The default form widget for this field is :class:`~django.forms.CheckboxInput`,
  472. or :class:`~django.forms.NullBooleanSelect` if :attr:`null=True <Field.null>`.
  473. The default value of ``BooleanField`` is ``None`` when :attr:`Field.default`
  474. isn't defined.
  475. ``CharField``
  476. -------------
  477. .. class:: CharField(max_length=None, **options)
  478. A string field, for small- to large-sized strings.
  479. For large amounts of text, use :class:`~django.db.models.TextField`.
  480. The default form widget for this field is a :class:`~django.forms.TextInput`.
  481. :class:`CharField` has the following extra arguments:
  482. .. attribute:: CharField.max_length
  483. The maximum length (in characters) of the field. The ``max_length``
  484. is enforced at the database level and in Django's validation using
  485. :class:`~django.core.validators.MaxLengthValidator`. It's required for all
  486. database backends included with Django except PostgreSQL, which supports
  487. unlimited ``VARCHAR`` columns.
  488. .. note::
  489. If you are writing an application that must be portable to multiple
  490. database backends, you should be aware that there are restrictions on
  491. ``max_length`` for some backends. Refer to the :doc:`database backend
  492. notes </ref/databases>` for details.
  493. .. versionchanged:: 4.2
  494. Support for unlimited ``VARCHAR`` columns was added on PostgreSQL.
  495. .. attribute:: CharField.db_collation
  496. Optional. The database collation name of the field.
  497. .. note::
  498. Collation names are not standardized. As such, this will not be
  499. portable across multiple database backends.
  500. .. admonition:: Oracle
  501. Oracle supports collations only when the ``MAX_STRING_SIZE`` database
  502. initialization parameter is set to ``EXTENDED``.
  503. ``DateField``
  504. -------------
  505. .. class:: DateField(auto_now=False, auto_now_add=False, **options)
  506. A date, represented in Python by a ``datetime.date`` instance. Has a few extra,
  507. optional arguments:
  508. .. attribute:: DateField.auto_now
  509. Automatically set the field to now every time the object is saved. Useful
  510. for "last-modified" timestamps. Note that the current date is *always*
  511. used; it's not just a default value that you can override.
  512. The field is only automatically updated when calling :meth:`Model.save()
  513. <django.db.models.Model.save>`. The field isn't updated when making updates
  514. to other fields in other ways such as :meth:`QuerySet.update()
  515. <django.db.models.query.QuerySet.update>`, though you can specify a custom
  516. value for the field in an update like that.
  517. .. attribute:: DateField.auto_now_add
  518. Automatically set the field to now when the object is first created. Useful
  519. for creation of timestamps. Note that the current date is *always* used;
  520. it's not just a default value that you can override. So even if you
  521. set a value for this field when creating the object, it will be ignored.
  522. If you want to be able to modify this field, set the following instead of
  523. ``auto_now_add=True``:
  524. * For :class:`DateField`: ``default=date.today`` - from
  525. :meth:`datetime.date.today`
  526. * For :class:`DateTimeField`: ``default=timezone.now`` - from
  527. :func:`django.utils.timezone.now`
  528. The default form widget for this field is a
  529. :class:`~django.forms.DateInput`. The admin adds a JavaScript calendar,
  530. and a shortcut for "Today". Includes an additional ``invalid_date`` error
  531. message key.
  532. The options ``auto_now_add``, ``auto_now``, and ``default`` are mutually exclusive.
  533. Any combination of these options will result in an error.
  534. .. note::
  535. As currently implemented, setting ``auto_now`` or ``auto_now_add`` to
  536. ``True`` will cause the field to have ``editable=False`` and ``blank=True``
  537. set.
  538. .. note::
  539. The ``auto_now`` and ``auto_now_add`` options will always use the date in
  540. the :ref:`default timezone <default-current-time-zone>` at the moment of
  541. creation or update. If you need something different, you may want to
  542. consider using your own callable default or overriding ``save()`` instead
  543. of using ``auto_now`` or ``auto_now_add``; or using a ``DateTimeField``
  544. instead of a ``DateField`` and deciding how to handle the conversion from
  545. datetime to date at display time.
  546. ``DateTimeField``
  547. -----------------
  548. .. class:: DateTimeField(auto_now=False, auto_now_add=False, **options)
  549. A date and time, represented in Python by a ``datetime.datetime`` instance.
  550. Takes the same extra arguments as :class:`DateField`.
  551. The default form widget for this field is a single
  552. :class:`~django.forms.DateTimeInput`. The admin uses two separate
  553. :class:`~django.forms.TextInput` widgets with JavaScript shortcuts.
  554. ``DecimalField``
  555. ----------------
  556. .. class:: DecimalField(max_digits=None, decimal_places=None, **options)
  557. A fixed-precision decimal number, represented in Python by a
  558. :class:`~decimal.Decimal` instance. It validates the input using
  559. :class:`~django.core.validators.DecimalValidator`.
  560. Has the following **required** arguments:
  561. .. attribute:: DecimalField.max_digits
  562. The maximum number of digits allowed in the number. Note that this number
  563. must be greater than or equal to ``decimal_places``.
  564. .. attribute:: DecimalField.decimal_places
  565. The number of decimal places to store with the number.
  566. For example, to store numbers up to ``999.99`` with a resolution of 2 decimal
  567. places, you'd use::
  568. models.DecimalField(..., max_digits=5, decimal_places=2)
  569. And to store numbers up to approximately one billion with a resolution of 10
  570. decimal places::
  571. models.DecimalField(..., max_digits=19, decimal_places=10)
  572. The default form widget for this field is a :class:`~django.forms.NumberInput`
  573. when :attr:`~django.forms.Field.localize` is ``False`` or
  574. :class:`~django.forms.TextInput` otherwise.
  575. .. note::
  576. For more information about the differences between the
  577. :class:`FloatField` and :class:`DecimalField` classes, please
  578. see :ref:`FloatField vs. DecimalField <floatfield_vs_decimalfield>`. You
  579. should also be aware of :ref:`SQLite limitations <sqlite-decimal-handling>`
  580. of decimal fields.
  581. ``DurationField``
  582. -----------------
  583. .. class:: DurationField(**options)
  584. A field for storing periods of time - modeled in Python by
  585. :class:`~python:datetime.timedelta`. When used on PostgreSQL, the data type
  586. used is an ``interval`` and on Oracle the data type is ``INTERVAL DAY(9) TO
  587. SECOND(6)``. Otherwise a ``bigint`` of microseconds is used.
  588. .. note::
  589. Arithmetic with ``DurationField`` works in most cases. However on all
  590. databases other than PostgreSQL, comparing the value of a ``DurationField``
  591. to arithmetic on ``DateTimeField`` instances will not work as expected.
  592. ``EmailField``
  593. --------------
  594. .. class:: EmailField(max_length=254, **options)
  595. A :class:`CharField` that checks that the value is a valid email address using
  596. :class:`~django.core.validators.EmailValidator`.
  597. ``FileField``
  598. -------------
  599. .. class:: FileField(upload_to='', storage=None, max_length=100, **options)
  600. A file-upload field.
  601. .. note::
  602. The ``primary_key`` argument isn't supported and will raise an error if
  603. used.
  604. Has the following optional arguments:
  605. .. attribute:: FileField.upload_to
  606. This attribute provides a way of setting the upload directory and file name,
  607. and can be set in two ways. In both cases, the value is passed to the
  608. :meth:`Storage.save() <django.core.files.storage.Storage.save>` method.
  609. If you specify a string value or a :class:`~pathlib.Path`, it may contain
  610. :func:`~time.strftime` formatting, which will be replaced by the date/time
  611. of the file upload (so that uploaded files don't fill up the given
  612. directory). For example::
  613. class MyModel(models.Model):
  614. # file will be uploaded to MEDIA_ROOT/uploads
  615. upload = models.FileField(upload_to="uploads/")
  616. # or...
  617. # file will be saved to MEDIA_ROOT/uploads/2015/01/30
  618. upload = models.FileField(upload_to="uploads/%Y/%m/%d/")
  619. If you are using the default
  620. :class:`~django.core.files.storage.FileSystemStorage`, the string value
  621. will be appended to your :setting:`MEDIA_ROOT` path to form the location on
  622. the local filesystem where uploaded files will be stored. If you are using
  623. a different storage, check that storage's documentation to see how it
  624. handles ``upload_to``.
  625. ``upload_to`` may also be a callable, such as a function. This will be
  626. called to obtain the upload path, including the filename. This callable must
  627. accept two arguments and return a Unix-style path (with forward slashes)
  628. to be passed along to the storage system. The two arguments are:
  629. ====================== ===============================================
  630. Argument Description
  631. ====================== ===============================================
  632. ``instance`` An instance of the model where the
  633. ``FileField`` is defined. More specifically,
  634. this is the particular instance where the
  635. current file is being attached.
  636. In most cases, this object will not have been
  637. saved to the database yet, so if it uses the
  638. default ``AutoField``, *it might not yet have a
  639. value for its primary key field*.
  640. ``filename`` The filename that was originally given to the
  641. file. This may or may not be taken into account
  642. when determining the final destination path.
  643. ====================== ===============================================
  644. For example::
  645. def user_directory_path(instance, filename):
  646. # file will be uploaded to MEDIA_ROOT/user_<id>/<filename>
  647. return "user_{0}/{1}".format(instance.user.id, filename)
  648. class MyModel(models.Model):
  649. upload = models.FileField(upload_to=user_directory_path)
  650. .. attribute:: FileField.storage
  651. A storage object, or a callable which returns a storage object. This
  652. handles the storage and retrieval of your files. See :doc:`/topics/files`
  653. for details on how to provide this object.
  654. The default form widget for this field is a
  655. :class:`~django.forms.ClearableFileInput`.
  656. Using a :class:`FileField` or an :class:`ImageField` (see below) in a model
  657. takes a few steps:
  658. #. In your settings file, you'll need to define :setting:`MEDIA_ROOT` as the
  659. full path to a directory where you'd like Django to store uploaded files.
  660. (For performance, these files are not stored in the database.) Define
  661. :setting:`MEDIA_URL` as the base public URL of that directory. Make sure
  662. that this directory is writable by the web server's user account.
  663. #. Add the :class:`FileField` or :class:`ImageField` to your model, defining
  664. the :attr:`~FileField.upload_to` option to specify a subdirectory of
  665. :setting:`MEDIA_ROOT` to use for uploaded files.
  666. #. All that will be stored in your database is a path to the file
  667. (relative to :setting:`MEDIA_ROOT`). You'll most likely want to use the
  668. convenience :attr:`~django.db.models.fields.files.FieldFile.url` attribute
  669. provided by Django. For example, if your :class:`ImageField` is called
  670. ``mug_shot``, you can get the absolute path to your image in a template with
  671. ``{{ object.mug_shot.url }}``.
  672. For example, say your :setting:`MEDIA_ROOT` is set to ``'/home/media'``, and
  673. :attr:`~FileField.upload_to` is set to ``'photos/%Y/%m/%d'``. The ``'%Y/%m/%d'``
  674. part of :attr:`~FileField.upload_to` is :func:`~time.strftime` formatting;
  675. ``'%Y'`` is the four-digit year, ``'%m'`` is the two-digit month and ``'%d'`` is
  676. the two-digit day. If you upload a file on Jan. 15, 2007, it will be saved in
  677. the directory ``/home/media/photos/2007/01/15``.
  678. If you wanted to retrieve the uploaded file's on-disk filename, or the file's
  679. size, you could use the :attr:`~django.core.files.File.name` and
  680. :attr:`~django.core.files.File.size` attributes respectively; for more
  681. information on the available attributes and methods, see the
  682. :class:`~django.core.files.File` class reference and the :doc:`/topics/files`
  683. topic guide.
  684. .. note::
  685. The file is saved as part of saving the model in the database, so the actual
  686. file name used on disk cannot be relied on until after the model has been
  687. saved.
  688. The uploaded file's relative URL can be obtained using the
  689. :attr:`~django.db.models.fields.files.FieldFile.url` attribute. Internally,
  690. this calls the :meth:`~django.core.files.storage.Storage.url` method of the
  691. underlying :class:`~django.core.files.storage.Storage` class.
  692. .. _file-upload-security:
  693. Note that whenever you deal with uploaded files, you should pay close attention
  694. to where you're uploading them and what type of files they are, to avoid
  695. security holes. *Validate all uploaded files* so that you're sure the files are
  696. what you think they are. For example, if you blindly let somebody upload files,
  697. without validation, to a directory that's within your web server's document
  698. root, then somebody could upload a CGI or PHP script and execute that script by
  699. visiting its URL on your site. Don't allow that.
  700. Also note that even an uploaded HTML file, since it can be executed by the
  701. browser (though not by the server), can pose security threats that are
  702. equivalent to XSS or CSRF attacks.
  703. :class:`FileField` instances are created in your database as ``varchar``
  704. columns with a default max length of 100 characters. As with other fields, you
  705. can change the maximum length using the :attr:`~CharField.max_length` argument.
  706. ``FileField`` and ``FieldFile``
  707. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  708. .. currentmodule:: django.db.models.fields.files
  709. .. class:: FieldFile
  710. When you access a :class:`~django.db.models.FileField` on a model, you are
  711. given an instance of :class:`FieldFile` as a proxy for accessing the underlying
  712. file.
  713. The API of :class:`FieldFile` mirrors that of :class:`~django.core.files.File`,
  714. with one key difference: *The object wrapped by the class is not necessarily a
  715. wrapper around Python's built-in file object.* Instead, it is a wrapper around
  716. the result of the :attr:`Storage.open()<django.core.files.storage.Storage.open>`
  717. method, which may be a :class:`~django.core.files.File` object, or it may be a
  718. custom storage's implementation of the :class:`~django.core.files.File` API.
  719. In addition to the API inherited from :class:`~django.core.files.File` such as
  720. ``read()`` and ``write()``, :class:`FieldFile` includes several methods that
  721. can be used to interact with the underlying file:
  722. .. warning::
  723. Two methods of this class, :meth:`~FieldFile.save` and
  724. :meth:`~FieldFile.delete`, default to saving the model object of the
  725. associated ``FieldFile`` in the database.
  726. .. attribute:: FieldFile.name
  727. The name of the file including the relative path from the root of the
  728. :class:`~django.core.files.storage.Storage` of the associated
  729. :class:`~django.db.models.FileField`.
  730. .. attribute:: FieldFile.path
  731. A read-only property to access the file's local filesystem path by calling the
  732. :meth:`~django.core.files.storage.Storage.path` method of the underlying
  733. :class:`~django.core.files.storage.Storage` class.
  734. .. attribute:: FieldFile.size
  735. The result of the underlying :attr:`Storage.size()
  736. <django.core.files.storage.Storage.size>` method.
  737. .. attribute:: FieldFile.url
  738. A read-only property to access the file's relative URL by calling the
  739. :meth:`~django.core.files.storage.Storage.url` method of the underlying
  740. :class:`~django.core.files.storage.Storage` class.
  741. .. method:: FieldFile.open(mode='rb')
  742. Opens or reopens the file associated with this instance in the specified
  743. ``mode``. Unlike the standard Python ``open()`` method, it doesn't return a
  744. file descriptor.
  745. Since the underlying file is opened implicitly when accessing it, it may be
  746. unnecessary to call this method except to reset the pointer to the underlying
  747. file or to change the ``mode``.
  748. .. method:: FieldFile.close()
  749. Behaves like the standard Python ``file.close()`` method and closes the file
  750. associated with this instance.
  751. .. method:: FieldFile.save(name, content, save=True)
  752. This method takes a filename and file contents and passes them to the storage
  753. class for the field, then associates the stored file with the model field.
  754. If you want to manually associate file data with
  755. :class:`~django.db.models.FileField` instances on your model, the ``save()``
  756. method is used to persist that file data.
  757. Takes two required arguments: ``name`` which is the name of the file, and
  758. ``content`` which is an object containing the file's contents. The
  759. optional ``save`` argument controls whether or not the model instance is
  760. saved after the file associated with this field has been altered. Defaults to
  761. ``True``.
  762. Note that the ``content`` argument should be an instance of
  763. :class:`django.core.files.File`, not Python's built-in file object.
  764. You can construct a :class:`~django.core.files.File` from an existing
  765. Python file object like this::
  766. from django.core.files import File
  767. # Open an existing file using Python's built-in open()
  768. f = open("/path/to/hello.world")
  769. myfile = File(f)
  770. Or you can construct one from a Python string like this::
  771. from django.core.files.base import ContentFile
  772. myfile = ContentFile("hello world")
  773. For more information, see :doc:`/topics/files`.
  774. .. method:: FieldFile.delete(save=True)
  775. Deletes the file associated with this instance and clears all attributes on
  776. the field. Note: This method will close the file if it happens to be open when
  777. ``delete()`` is called.
  778. The optional ``save`` argument controls whether or not the model instance is
  779. saved after the file associated with this field has been deleted. Defaults to
  780. ``True``.
  781. Note that when a model is deleted, related files are not deleted. If you need
  782. to cleanup orphaned files, you'll need to handle it yourself (for instance,
  783. with a custom management command that can be run manually or scheduled to run
  784. periodically via e.g. cron).
  785. .. currentmodule:: django.db.models
  786. ``FilePathField``
  787. -----------------
  788. .. class:: FilePathField(path='', match=None, recursive=False, allow_files=True, allow_folders=False, max_length=100, **options)
  789. A :class:`CharField` whose choices are limited to the filenames in a certain
  790. directory on the filesystem. Has some special arguments, of which the first is
  791. **required**:
  792. .. attribute:: FilePathField.path
  793. Required. The absolute filesystem path to a directory from which this
  794. :class:`FilePathField` should get its choices. Example: ``"/home/images"``.
  795. ``path`` may also be a callable, such as a function to dynamically set the
  796. path at runtime. Example::
  797. import os
  798. from django.conf import settings
  799. from django.db import models
  800. def images_path():
  801. return os.path.join(settings.LOCAL_FILE_DIR, "images")
  802. class MyModel(models.Model):
  803. file = models.FilePathField(path=images_path)
  804. .. attribute:: FilePathField.match
  805. Optional. A regular expression, as a string, that :class:`FilePathField`
  806. will use to filter filenames. Note that the regex will be applied to the
  807. base filename, not the full path. Example: ``"foo.*\.txt$"``, which will
  808. match a file called ``foo23.txt`` but not ``bar.txt`` or ``foo23.png``.
  809. .. attribute:: FilePathField.recursive
  810. Optional. Either ``True`` or ``False``. Default is ``False``. Specifies
  811. whether all subdirectories of :attr:`~FilePathField.path` should be included
  812. .. attribute:: FilePathField.allow_files
  813. Optional. Either ``True`` or ``False``. Default is ``True``. Specifies
  814. whether files in the specified location should be included. Either this or
  815. :attr:`~FilePathField.allow_folders` must be ``True``.
  816. .. attribute:: FilePathField.allow_folders
  817. Optional. Either ``True`` or ``False``. Default is ``False``. Specifies
  818. whether folders in the specified location should be included. Either this
  819. or :attr:`~FilePathField.allow_files` must be ``True``.
  820. The one potential gotcha is that :attr:`~FilePathField.match` applies to the
  821. base filename, not the full path. So, this example::
  822. FilePathField(path="/home/images", match="foo.*", recursive=True)
  823. ...will match ``/home/images/foo.png`` but not ``/home/images/foo/bar.png``
  824. because the :attr:`~FilePathField.match` applies to the base filename
  825. (``foo.png`` and ``bar.png``).
  826. :class:`FilePathField` instances are created in your database as ``varchar``
  827. columns with a default max length of 100 characters. As with other fields, you
  828. can change the maximum length using the :attr:`~CharField.max_length` argument.
  829. ``FloatField``
  830. --------------
  831. .. class:: FloatField(**options)
  832. A floating-point number represented in Python by a ``float`` instance.
  833. The default form widget for this field is a :class:`~django.forms.NumberInput`
  834. when :attr:`~django.forms.Field.localize` is ``False`` or
  835. :class:`~django.forms.TextInput` otherwise.
  836. .. _floatfield_vs_decimalfield:
  837. .. admonition:: ``FloatField`` vs. ``DecimalField``
  838. The :class:`FloatField` class is sometimes mixed up with the
  839. :class:`DecimalField` class. Although they both represent real numbers, they
  840. represent those numbers differently. ``FloatField`` uses Python's ``float``
  841. type internally, while ``DecimalField`` uses Python's ``Decimal`` type. For
  842. information on the difference between the two, see Python's documentation
  843. for the :mod:`decimal` module.
  844. ``GenericIPAddressField``
  845. -------------------------
  846. .. class:: GenericIPAddressField(protocol='both', unpack_ipv4=False, **options)
  847. An IPv4 or IPv6 address, in string format (e.g. ``192.0.2.30`` or
  848. ``2a02:42fe::4``). The default form widget for this field is a
  849. :class:`~django.forms.TextInput`.
  850. The IPv6 address normalization follows :rfc:`4291#section-2.2` section 2.2,
  851. including using the IPv4 format suggested in paragraph 3 of that section, like
  852. ``::ffff:192.0.2.0``. For example, ``2001:0::0:01`` would be normalized to
  853. ``2001::1``, and ``::ffff:0a0a:0a0a`` to ``::ffff:10.10.10.10``. All characters
  854. are converted to lowercase.
  855. .. attribute:: GenericIPAddressField.protocol
  856. Limits valid inputs to the specified protocol.
  857. Accepted values are ``'both'`` (default), ``'IPv4'``
  858. or ``'IPv6'``. Matching is case insensitive.
  859. .. attribute:: GenericIPAddressField.unpack_ipv4
  860. Unpacks IPv4 mapped addresses like ``::ffff:192.0.2.1``.
  861. If this option is enabled that address would be unpacked to
  862. ``192.0.2.1``. Default is disabled. Can only be used
  863. when ``protocol`` is set to ``'both'``.
  864. If you allow for blank values, you have to allow for null values since blank
  865. values are stored as null.
  866. ``ImageField``
  867. --------------
  868. .. class:: ImageField(upload_to=None, height_field=None, width_field=None, max_length=100, **options)
  869. Inherits all attributes and methods from :class:`FileField`, but also
  870. validates that the uploaded object is a valid image.
  871. In addition to the special attributes that are available for :class:`FileField`,
  872. an :class:`ImageField` also has ``height`` and ``width`` attributes.
  873. To facilitate querying on those attributes, :class:`ImageField` has the
  874. following optional arguments:
  875. .. attribute:: ImageField.height_field
  876. Name of a model field which will be auto-populated with the height of the
  877. image each time the model instance is saved.
  878. .. attribute:: ImageField.width_field
  879. Name of a model field which will be auto-populated with the width of the
  880. image each time the model instance is saved.
  881. Requires the `Pillow`_ library.
  882. .. _Pillow: https://pillow.readthedocs.io/en/latest/
  883. :class:`ImageField` instances are created in your database as ``varchar``
  884. columns with a default max length of 100 characters. As with other fields, you
  885. can change the maximum length using the :attr:`~CharField.max_length` argument.
  886. The default form widget for this field is a
  887. :class:`~django.forms.ClearableFileInput`.
  888. ``IntegerField``
  889. ----------------
  890. .. class:: IntegerField(**options)
  891. An integer. Values from ``-2147483648`` to ``2147483647`` are safe in all
  892. databases supported by Django.
  893. It uses :class:`~django.core.validators.MinValueValidator` and
  894. :class:`~django.core.validators.MaxValueValidator` to validate the input based
  895. on the values that the default database supports.
  896. The default form widget for this field is a :class:`~django.forms.NumberInput`
  897. when :attr:`~django.forms.Field.localize` is ``False`` or
  898. :class:`~django.forms.TextInput` otherwise.
  899. ``JSONField``
  900. -------------
  901. .. class:: JSONField(encoder=None, decoder=None, **options)
  902. A field for storing JSON encoded data. In Python the data is represented in its
  903. Python native format: dictionaries, lists, strings, numbers, booleans and
  904. ``None``.
  905. ``JSONField`` is supported on MariaDB, MySQL, Oracle, PostgreSQL, and SQLite
  906. (with the :ref:`JSON1 extension enabled <sqlite-json1>`).
  907. .. attribute:: JSONField.encoder
  908. An optional :py:class:`json.JSONEncoder` subclass to serialize data types
  909. not supported by the standard JSON serializer (e.g. ``datetime.datetime``
  910. or :class:`~python:uuid.UUID`). For example, you can use the
  911. :class:`~django.core.serializers.json.DjangoJSONEncoder` class.
  912. Defaults to ``json.JSONEncoder``.
  913. .. attribute:: JSONField.decoder
  914. An optional :py:class:`json.JSONDecoder` subclass to deserialize the value
  915. retrieved from the database. The value will be in the format chosen by the
  916. custom encoder (most often a string). Your deserialization may need to
  917. account for the fact that you can't be certain of the input type. For
  918. example, you run the risk of returning a ``datetime`` that was actually a
  919. string that just happened to be in the same format chosen for
  920. ``datetime``\s.
  921. Defaults to ``json.JSONDecoder``.
  922. To query ``JSONField`` in the database, see :ref:`querying-jsonfield`.
  923. .. admonition:: Default value
  924. If you give the field a :attr:`~django.db.models.Field.default`, ensure
  925. it's a callable such as the :py:class:`dict` class or a function that
  926. returns a fresh object each time. Incorrectly using a mutable object like
  927. ``default={}`` or ``default=[]`` creates a mutable default that is shared
  928. between all instances.
  929. .. admonition:: Indexing
  930. :class:`~django.db.models.Index` and :attr:`.Field.db_index` both create a
  931. B-tree index, which isn't particularly helpful when querying ``JSONField``.
  932. On PostgreSQL only, you can use
  933. :class:`~django.contrib.postgres.indexes.GinIndex` that is better suited.
  934. .. admonition:: PostgreSQL users
  935. PostgreSQL has two native JSON based data types: ``json`` and ``jsonb``.
  936. The main difference between them is how they are stored and how they can be
  937. queried. PostgreSQL's ``json`` field is stored as the original string
  938. representation of the JSON and must be decoded on the fly when queried
  939. based on keys. The ``jsonb`` field is stored based on the actual structure
  940. of the JSON which allows indexing. The trade-off is a small additional cost
  941. on writing to the ``jsonb`` field. ``JSONField`` uses ``jsonb``.
  942. .. admonition:: Oracle users
  943. Oracle Database does not support storing JSON scalar values. Only JSON
  944. objects and arrays (represented in Python using :py:class:`dict` and
  945. :py:class:`list`) are supported.
  946. ``PositiveBigIntegerField``
  947. ---------------------------
  948. .. class:: PositiveBigIntegerField(**options)
  949. Like a :class:`PositiveIntegerField`, but only allows values under a certain
  950. (database-dependent) point. Values from ``0`` to ``9223372036854775807`` are
  951. safe in all databases supported by Django.
  952. ``PositiveIntegerField``
  953. ------------------------
  954. .. class:: PositiveIntegerField(**options)
  955. Like an :class:`IntegerField`, but must be either positive or zero (``0``).
  956. Values from ``0`` to ``2147483647`` are safe in all databases supported by
  957. Django. The value ``0`` is accepted for backward compatibility reasons.
  958. ``PositiveSmallIntegerField``
  959. -----------------------------
  960. .. class:: PositiveSmallIntegerField(**options)
  961. Like a :class:`PositiveIntegerField`, but only allows values under a certain
  962. (database-dependent) point. Values from ``0`` to ``32767`` are safe in all
  963. databases supported by Django.
  964. ``SlugField``
  965. -------------
  966. .. class:: SlugField(max_length=50, **options)
  967. :term:`Slug <slug>` is a newspaper term. A slug is a short label for something,
  968. containing only letters, numbers, underscores or hyphens. They're generally used
  969. in URLs.
  970. Like a CharField, you can specify :attr:`~CharField.max_length` (read the note
  971. about database portability and :attr:`~CharField.max_length` in that section,
  972. too). If :attr:`~CharField.max_length` is not specified, Django will use a
  973. default length of 50.
  974. Implies setting :attr:`Field.db_index` to ``True``.
  975. It is often useful to automatically prepopulate a SlugField based on the value
  976. of some other value. You can do this automatically in the admin using
  977. :attr:`~django.contrib.admin.ModelAdmin.prepopulated_fields`.
  978. It uses :class:`~django.core.validators.validate_slug` or
  979. :class:`~django.core.validators.validate_unicode_slug` for validation.
  980. .. attribute:: SlugField.allow_unicode
  981. If ``True``, the field accepts Unicode letters in addition to ASCII
  982. letters. Defaults to ``False``.
  983. ``SmallAutoField``
  984. ------------------
  985. .. class:: SmallAutoField(**options)
  986. Like an :class:`AutoField`, but only allows values under a certain
  987. (database-dependent) limit. Values from ``1`` to ``32767`` are safe in all
  988. databases supported by Django.
  989. ``SmallIntegerField``
  990. ---------------------
  991. .. class:: SmallIntegerField(**options)
  992. Like an :class:`IntegerField`, but only allows values under a certain
  993. (database-dependent) point. Values from ``-32768`` to ``32767`` are safe in all
  994. databases supported by Django.
  995. ``TextField``
  996. -------------
  997. .. class:: TextField(**options)
  998. A large text field. The default form widget for this field is a
  999. :class:`~django.forms.Textarea`.
  1000. If you specify a ``max_length`` attribute, it will be reflected in the
  1001. :class:`~django.forms.Textarea` widget of the auto-generated form field.
  1002. However it is not enforced at the model or database level. Use a
  1003. :class:`CharField` for that.
  1004. .. attribute:: TextField.db_collation
  1005. Optional. The database collation name of the field.
  1006. .. note::
  1007. Collation names are not standardized. As such, this will not be
  1008. portable across multiple database backends.
  1009. .. admonition:: Oracle
  1010. Oracle does not support collations for a ``TextField``.
  1011. ``TimeField``
  1012. -------------
  1013. .. class:: TimeField(auto_now=False, auto_now_add=False, **options)
  1014. A time, represented in Python by a ``datetime.time`` instance. Accepts the same
  1015. auto-population options as :class:`DateField`.
  1016. The default form widget for this field is a :class:`~django.forms.TimeInput`.
  1017. The admin adds some JavaScript shortcuts.
  1018. ``URLField``
  1019. ------------
  1020. .. class:: URLField(max_length=200, **options)
  1021. A :class:`CharField` for a URL, validated by
  1022. :class:`~django.core.validators.URLValidator`.
  1023. The default form widget for this field is a :class:`~django.forms.URLInput`.
  1024. Like all :class:`CharField` subclasses, :class:`URLField` takes the optional
  1025. :attr:`~CharField.max_length` argument. If you don't specify
  1026. :attr:`~CharField.max_length`, a default of 200 is used.
  1027. ``UUIDField``
  1028. -------------
  1029. .. class:: UUIDField(**options)
  1030. A field for storing universally unique identifiers. Uses Python's
  1031. :class:`~python:uuid.UUID` class. When used on PostgreSQL, this stores in a
  1032. ``uuid`` datatype, otherwise in a ``char(32)``.
  1033. Universally unique identifiers are a good alternative to :class:`AutoField` for
  1034. :attr:`~Field.primary_key`. The database will not generate the UUID for you, so
  1035. it is recommended to use :attr:`~Field.default`::
  1036. import uuid
  1037. from django.db import models
  1038. class MyUUIDModel(models.Model):
  1039. id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
  1040. # other fields
  1041. Note that a callable (with the parentheses omitted) is passed to ``default``,
  1042. not an instance of ``UUID``.
  1043. .. admonition:: Lookups on PostgreSQL
  1044. Using :lookup:`iexact`, :lookup:`contains`, :lookup:`icontains`,
  1045. :lookup:`startswith`, :lookup:`istartswith`, :lookup:`endswith`, or
  1046. :lookup:`iendswith` lookups on PostgreSQL don't work for values without
  1047. hyphens, because PostgreSQL stores them in a hyphenated uuid datatype type.
  1048. Relationship fields
  1049. ===================
  1050. .. module:: django.db.models.fields.related
  1051. :synopsis: Related field types
  1052. .. currentmodule:: django.db.models
  1053. Django also defines a set of fields that represent relations.
  1054. .. _ref-foreignkey:
  1055. ``ForeignKey``
  1056. --------------
  1057. .. class:: ForeignKey(to, on_delete, **options)
  1058. A many-to-one relationship. Requires two positional arguments: the class to
  1059. which the model is related and the :attr:`~ForeignKey.on_delete` option.
  1060. .. _recursive-relationships:
  1061. To create a recursive relationship -- an object that has a many-to-one
  1062. relationship with itself -- use ``models.ForeignKey('self',
  1063. on_delete=models.CASCADE)``.
  1064. .. _lazy-relationships:
  1065. If you need to create a relationship on a model that has not yet been defined,
  1066. you can use the name of the model, rather than the model object itself::
  1067. from django.db import models
  1068. class Car(models.Model):
  1069. manufacturer = models.ForeignKey(
  1070. "Manufacturer",
  1071. on_delete=models.CASCADE,
  1072. )
  1073. # ...
  1074. class Manufacturer(models.Model):
  1075. # ...
  1076. pass
  1077. Relationships defined this way on :ref:`abstract models
  1078. <abstract-base-classes>` are resolved when the model is subclassed as a
  1079. concrete model and are not relative to the abstract model's ``app_label``:
  1080. .. code-block:: python
  1081. :caption: ``products/models.py``
  1082. from django.db import models
  1083. class AbstractCar(models.Model):
  1084. manufacturer = models.ForeignKey("Manufacturer", on_delete=models.CASCADE)
  1085. class Meta:
  1086. abstract = True
  1087. .. code-block:: python
  1088. :caption: ``production/models.py``
  1089. from django.db import models
  1090. from products.models import AbstractCar
  1091. class Manufacturer(models.Model):
  1092. pass
  1093. class Car(AbstractCar):
  1094. pass
  1095. # Car.manufacturer will point to `production.Manufacturer` here.
  1096. To refer to models defined in another application, you can explicitly specify
  1097. a model with the full application label. For example, if the ``Manufacturer``
  1098. model above is defined in another application called ``production``, you'd
  1099. need to use::
  1100. class Car(models.Model):
  1101. manufacturer = models.ForeignKey(
  1102. "production.Manufacturer",
  1103. on_delete=models.CASCADE,
  1104. )
  1105. This sort of reference, called a lazy relationship, can be useful when
  1106. resolving circular import dependencies between two applications.
  1107. A database index is automatically created on the ``ForeignKey``. You can
  1108. disable this by setting :attr:`~Field.db_index` to ``False``. You may want to
  1109. avoid the overhead of an index if you are creating a foreign key for
  1110. consistency rather than joins, or if you will be creating an alternative index
  1111. like a partial or multiple column index.
  1112. Database Representation
  1113. ~~~~~~~~~~~~~~~~~~~~~~~
  1114. Behind the scenes, Django appends ``"_id"`` to the field name to create its
  1115. database column name. In the above example, the database table for the ``Car``
  1116. model will have a ``manufacturer_id`` column. (You can change this explicitly by
  1117. specifying :attr:`~Field.db_column`) However, your code should never have to
  1118. deal with the database column name, unless you write custom SQL. You'll always
  1119. deal with the field names of your model object.
  1120. .. _foreign-key-arguments:
  1121. Arguments
  1122. ~~~~~~~~~
  1123. :class:`ForeignKey` accepts other arguments that define the details of how the
  1124. relation works.
  1125. .. attribute:: ForeignKey.on_delete
  1126. When an object referenced by a :class:`ForeignKey` is deleted, Django will
  1127. emulate the behavior of the SQL constraint specified by the
  1128. :attr:`on_delete` argument. For example, if you have a nullable
  1129. :class:`ForeignKey` and you want it to be set null when the referenced
  1130. object is deleted::
  1131. user = models.ForeignKey(
  1132. User,
  1133. models.SET_NULL,
  1134. blank=True,
  1135. null=True,
  1136. )
  1137. ``on_delete`` doesn't create an SQL constraint in the database. Support for
  1138. database-level cascade options :ticket:`may be implemented later <21961>`.
  1139. The possible values for :attr:`~ForeignKey.on_delete` are found in
  1140. :mod:`django.db.models`:
  1141. * .. attribute:: CASCADE
  1142. Cascade deletes. Django emulates the behavior of the SQL constraint ON
  1143. DELETE CASCADE and also deletes the object containing the ForeignKey.
  1144. :meth:`.Model.delete` isn't called on related models, but the
  1145. :data:`~django.db.models.signals.pre_delete` and
  1146. :data:`~django.db.models.signals.post_delete` signals are sent for all
  1147. deleted objects.
  1148. * .. attribute:: PROTECT
  1149. Prevent deletion of the referenced object by raising
  1150. :exc:`~django.db.models.ProtectedError`, a subclass of
  1151. :exc:`django.db.IntegrityError`.
  1152. * .. attribute:: RESTRICT
  1153. Prevent deletion of the referenced object by raising
  1154. :exc:`~django.db.models.RestrictedError` (a subclass of
  1155. :exc:`django.db.IntegrityError`). Unlike :attr:`PROTECT`, deletion of the
  1156. referenced object is allowed if it also references a different object
  1157. that is being deleted in the same operation, but via a :attr:`CASCADE`
  1158. relationship.
  1159. Consider this set of models::
  1160. class Artist(models.Model):
  1161. name = models.CharField(max_length=10)
  1162. class Album(models.Model):
  1163. artist = models.ForeignKey(Artist, on_delete=models.CASCADE)
  1164. class Song(models.Model):
  1165. artist = models.ForeignKey(Artist, on_delete=models.CASCADE)
  1166. album = models.ForeignKey(Album, on_delete=models.RESTRICT)
  1167. ``Artist`` can be deleted even if that implies deleting an ``Album``
  1168. which is referenced by a ``Song``, because ``Song`` also references
  1169. ``Artist`` itself through a cascading relationship. For example:
  1170. .. code-block:: pycon
  1171. >>> artist_one = Artist.objects.create(name="artist one")
  1172. >>> artist_two = Artist.objects.create(name="artist two")
  1173. >>> album_one = Album.objects.create(artist=artist_one)
  1174. >>> album_two = Album.objects.create(artist=artist_two)
  1175. >>> song_one = Song.objects.create(artist=artist_one, album=album_one)
  1176. >>> song_two = Song.objects.create(artist=artist_one, album=album_two)
  1177. >>> album_one.delete()
  1178. # Raises RestrictedError.
  1179. >>> artist_two.delete()
  1180. # Raises RestrictedError.
  1181. >>> artist_one.delete()
  1182. (4, {'Song': 2, 'Album': 1, 'Artist': 1})
  1183. * .. attribute:: SET_NULL
  1184. Set the :class:`ForeignKey` null; this is only possible if
  1185. :attr:`~Field.null` is ``True``.
  1186. * .. attribute:: SET_DEFAULT
  1187. Set the :class:`ForeignKey` to its default value; a default for the
  1188. :class:`ForeignKey` must be set.
  1189. * .. function:: SET()
  1190. Set the :class:`ForeignKey` to the value passed to
  1191. :func:`~django.db.models.SET()`, or if a callable is passed in,
  1192. the result of calling it. In most cases, passing a callable will be
  1193. necessary to avoid executing queries at the time your ``models.py`` is
  1194. imported::
  1195. from django.conf import settings
  1196. from django.contrib.auth import get_user_model
  1197. from django.db import models
  1198. def get_sentinel_user():
  1199. return get_user_model().objects.get_or_create(username="deleted")[0]
  1200. class MyModel(models.Model):
  1201. user = models.ForeignKey(
  1202. settings.AUTH_USER_MODEL,
  1203. on_delete=models.SET(get_sentinel_user),
  1204. )
  1205. * .. attribute:: DO_NOTHING
  1206. Take no action. If your database backend enforces referential
  1207. integrity, this will cause an :exc:`~django.db.IntegrityError` unless
  1208. you manually add an SQL ``ON DELETE`` constraint to the database field.
  1209. .. attribute:: ForeignKey.limit_choices_to
  1210. Sets a limit to the available choices for this field when this field is
  1211. rendered using a ``ModelForm`` or the admin (by default, all objects
  1212. in the queryset are available to choose). Either a dictionary, a
  1213. :class:`~django.db.models.Q` object, or a callable returning a
  1214. dictionary or :class:`~django.db.models.Q` object can be used.
  1215. For example::
  1216. staff_member = models.ForeignKey(
  1217. User,
  1218. on_delete=models.CASCADE,
  1219. limit_choices_to={"is_staff": True},
  1220. )
  1221. causes the corresponding field on the ``ModelForm`` to list only ``Users``
  1222. that have ``is_staff=True``. This may be helpful in the Django admin.
  1223. The callable form can be helpful, for instance, when used in conjunction
  1224. with the Python ``datetime`` module to limit selections by date range. For
  1225. example::
  1226. def limit_pub_date_choices():
  1227. return {"pub_date__lte": datetime.date.today()}
  1228. limit_choices_to = limit_pub_date_choices
  1229. If ``limit_choices_to`` is or returns a :class:`Q object
  1230. <django.db.models.Q>`, which is useful for :ref:`complex queries
  1231. <complex-lookups-with-q>`, then it will only have an effect on the choices
  1232. available in the admin when the field is not listed in
  1233. :attr:`~django.contrib.admin.ModelAdmin.raw_id_fields` in the
  1234. ``ModelAdmin`` for the model.
  1235. .. note::
  1236. If a callable is used for ``limit_choices_to``, it will be invoked
  1237. every time a new form is instantiated. It may also be invoked when a
  1238. model is validated, for example by management commands or the admin.
  1239. The admin constructs querysets to validate its form inputs in various
  1240. edge cases multiple times, so there is a possibility your callable may
  1241. be invoked several times.
  1242. .. attribute:: ForeignKey.related_name
  1243. The name to use for the relation from the related object back to this one.
  1244. It's also the default value for :attr:`related_query_name` (the name to use
  1245. for the reverse filter name from the target model). See the :ref:`related
  1246. objects documentation <backwards-related-objects>` for a full explanation
  1247. and example. Note that you must set this value when defining relations on
  1248. :ref:`abstract models <abstract-base-classes>`; and when you do so
  1249. :ref:`some special syntax <abstract-related-name>` is available.
  1250. If you'd prefer Django not to create a backwards relation, set
  1251. ``related_name`` to ``'+'`` or end it with ``'+'``. For example, this will
  1252. ensure that the ``User`` model won't have a backwards relation to this
  1253. model::
  1254. user = models.ForeignKey(
  1255. User,
  1256. on_delete=models.CASCADE,
  1257. related_name="+",
  1258. )
  1259. .. attribute:: ForeignKey.related_query_name
  1260. The name to use for the reverse filter name from the target model. It
  1261. defaults to the value of :attr:`related_name` or
  1262. :attr:`~django.db.models.Options.default_related_name` if set, otherwise it
  1263. defaults to the name of the model::
  1264. # Declare the ForeignKey with related_query_name
  1265. class Tag(models.Model):
  1266. article = models.ForeignKey(
  1267. Article,
  1268. on_delete=models.CASCADE,
  1269. related_name="tags",
  1270. related_query_name="tag",
  1271. )
  1272. name = models.CharField(max_length=255)
  1273. # That's now the name of the reverse filter
  1274. Article.objects.filter(tag__name="important")
  1275. Like :attr:`related_name`, ``related_query_name`` supports app label and
  1276. class interpolation via :ref:`some special syntax <abstract-related-name>`.
  1277. .. attribute:: ForeignKey.to_field
  1278. The field on the related object that the relation is to. By default, Django
  1279. uses the primary key of the related object. If you reference a different
  1280. field, that field must have ``unique=True``.
  1281. .. attribute:: ForeignKey.db_constraint
  1282. Controls whether or not a constraint should be created in the database for
  1283. this foreign key. The default is ``True``, and that's almost certainly what
  1284. you want; setting this to ``False`` can be very bad for data integrity.
  1285. That said, here are some scenarios where you might want to do this:
  1286. * You have legacy data that is not valid.
  1287. * You're sharding your database.
  1288. If this is set to ``False``, accessing a related object that doesn't exist
  1289. will raise its ``DoesNotExist`` exception.
  1290. .. attribute:: ForeignKey.swappable
  1291. Controls the migration framework's reaction if this :class:`ForeignKey`
  1292. is pointing at a swappable model. If it is ``True`` - the default -
  1293. then if the :class:`ForeignKey` is pointing at a model which matches
  1294. the current value of ``settings.AUTH_USER_MODEL`` (or another swappable
  1295. model setting) the relationship will be stored in the migration using
  1296. a reference to the setting, not to the model directly.
  1297. You only want to override this to be ``False`` if you are sure your
  1298. model should always point toward the swapped-in model - for example,
  1299. if it is a profile model designed specifically for your custom user model.
  1300. Setting it to ``False`` does not mean you can reference a swappable model
  1301. even if it is swapped out - ``False`` means that the migrations made
  1302. with this ForeignKey will always reference the exact model you specify
  1303. (so it will fail hard if the user tries to run with a User model you don't
  1304. support, for example).
  1305. If in doubt, leave it to its default of ``True``.
  1306. ``ManyToManyField``
  1307. -------------------
  1308. .. class:: ManyToManyField(to, **options)
  1309. A many-to-many relationship. Requires a positional argument: the class to
  1310. which the model is related, which works exactly the same as it does for
  1311. :class:`ForeignKey`, including :ref:`recursive <recursive-relationships>` and
  1312. :ref:`lazy <lazy-relationships>` relationships.
  1313. Related objects can be added, removed, or created with the field's
  1314. :class:`~django.db.models.fields.related.RelatedManager`.
  1315. Database Representation
  1316. ~~~~~~~~~~~~~~~~~~~~~~~
  1317. Behind the scenes, Django creates an intermediary join table to represent the
  1318. many-to-many relationship. By default, this table name is generated using the
  1319. name of the many-to-many field and the name of the table for the model that
  1320. contains it. Since some databases don't support table names above a certain
  1321. length, these table names will be automatically truncated and a uniqueness hash
  1322. will be used, e.g. ``author_books_9cdf``. You can manually provide the name of
  1323. the join table using the :attr:`~ManyToManyField.db_table` option.
  1324. .. _manytomany-arguments:
  1325. Arguments
  1326. ~~~~~~~~~
  1327. :class:`ManyToManyField` accepts an extra set of arguments -- all optional --
  1328. that control how the relationship functions.
  1329. .. attribute:: ManyToManyField.related_name
  1330. Same as :attr:`ForeignKey.related_name`.
  1331. .. attribute:: ManyToManyField.related_query_name
  1332. Same as :attr:`ForeignKey.related_query_name`.
  1333. .. attribute:: ManyToManyField.limit_choices_to
  1334. Same as :attr:`ForeignKey.limit_choices_to`.
  1335. .. attribute:: ManyToManyField.symmetrical
  1336. Only used in the definition of ManyToManyFields on self. Consider the
  1337. following model::
  1338. from django.db import models
  1339. class Person(models.Model):
  1340. friends = models.ManyToManyField("self")
  1341. When Django processes this model, it identifies that it has a
  1342. :class:`ManyToManyField` on itself, and as a result, it doesn't add a
  1343. ``person_set`` attribute to the ``Person`` class. Instead, the
  1344. :class:`ManyToManyField` is assumed to be symmetrical -- that is, if I am
  1345. your friend, then you are my friend.
  1346. If you do not want symmetry in many-to-many relationships with ``self``, set
  1347. :attr:`~ManyToManyField.symmetrical` to ``False``. This will force Django to
  1348. add the descriptor for the reverse relationship, allowing
  1349. :class:`ManyToManyField` relationships to be non-symmetrical.
  1350. .. attribute:: ManyToManyField.through
  1351. Django will automatically generate a table to manage many-to-many
  1352. relationships. However, if you want to manually specify the intermediary
  1353. table, you can use the :attr:`~ManyToManyField.through` option to specify
  1354. the Django model that represents the intermediate table that you want to
  1355. use.
  1356. The most common use for this option is when you want to associate
  1357. :ref:`extra data with a many-to-many relationship
  1358. <intermediary-manytomany>`.
  1359. .. note::
  1360. If you don't want multiple associations between the same instances, add
  1361. a :class:`~django.db.models.UniqueConstraint` including the from and to
  1362. fields. Django's automatically generated many-to-many tables include
  1363. such a constraint.
  1364. .. note::
  1365. Recursive relationships using an intermediary model can't determine the
  1366. reverse accessors names, as they would be the same. You need to set a
  1367. :attr:`~ForeignKey.related_name` to at least one of them. If you'd
  1368. prefer Django not to create a backwards relation, set ``related_name``
  1369. to ``'+'``.
  1370. If you don't specify an explicit ``through`` model, there is still an
  1371. implicit ``through`` model class you can use to directly access the table
  1372. created to hold the association. It has three fields to link the models.
  1373. If the source and target models differ, the following fields are
  1374. generated:
  1375. * ``id``: the primary key of the relation.
  1376. * ``<containing_model>_id``: the ``id`` of the model that declares the
  1377. ``ManyToManyField``.
  1378. * ``<other_model>_id``: the ``id`` of the model that the
  1379. ``ManyToManyField`` points to.
  1380. If the ``ManyToManyField`` points from and to the same model, the following
  1381. fields are generated:
  1382. * ``id``: the primary key of the relation.
  1383. * ``from_<model>_id``: the ``id`` of the instance which points at the
  1384. model (i.e. the source instance).
  1385. * ``to_<model>_id``: the ``id`` of the instance to which the relationship
  1386. points (i.e. the target model instance).
  1387. This class can be used to query associated records for a given model
  1388. instance like a normal model::
  1389. Model.m2mfield.through.objects.all()
  1390. .. attribute:: ManyToManyField.through_fields
  1391. Only used when a custom intermediary model is specified. Django will
  1392. normally determine which fields of the intermediary model to use in order
  1393. to establish a many-to-many relationship automatically. However,
  1394. consider the following models::
  1395. from django.db import models
  1396. class Person(models.Model):
  1397. name = models.CharField(max_length=50)
  1398. class Group(models.Model):
  1399. name = models.CharField(max_length=128)
  1400. members = models.ManyToManyField(
  1401. Person,
  1402. through="Membership",
  1403. through_fields=("group", "person"),
  1404. )
  1405. class Membership(models.Model):
  1406. group = models.ForeignKey(Group, on_delete=models.CASCADE)
  1407. person = models.ForeignKey(Person, on_delete=models.CASCADE)
  1408. inviter = models.ForeignKey(
  1409. Person,
  1410. on_delete=models.CASCADE,
  1411. related_name="membership_invites",
  1412. )
  1413. invite_reason = models.CharField(max_length=64)
  1414. ``Membership`` has *two* foreign keys to ``Person`` (``person`` and
  1415. ``inviter``), which makes the relationship ambiguous and Django can't know
  1416. which one to use. In this case, you must explicitly specify which
  1417. foreign keys Django should use using ``through_fields``, as in the example
  1418. above.
  1419. ``through_fields`` accepts a 2-tuple ``('field1', 'field2')``, where
  1420. ``field1`` is the name of the foreign key to the model the
  1421. :class:`ManyToManyField` is defined on (``group`` in this case), and
  1422. ``field2`` the name of the foreign key to the target model (``person``
  1423. in this case).
  1424. When you have more than one foreign key on an intermediary model to any
  1425. (or even both) of the models participating in a many-to-many relationship,
  1426. you *must* specify ``through_fields``. This also applies to
  1427. :ref:`recursive relationships <recursive-relationships>`
  1428. when an intermediary model is used and there are more than two
  1429. foreign keys to the model, or you want to explicitly specify which two
  1430. Django should use.
  1431. .. attribute:: ManyToManyField.db_table
  1432. The name of the table to create for storing the many-to-many data. If this
  1433. is not provided, Django will assume a default name based upon the names of:
  1434. the table for the model defining the relationship and the name of the field
  1435. itself.
  1436. .. attribute:: ManyToManyField.db_constraint
  1437. Controls whether or not constraints should be created in the database for
  1438. the foreign keys in the intermediary table. The default is ``True``, and
  1439. that's almost certainly what you want; setting this to ``False`` can be
  1440. very bad for data integrity. That said, here are some scenarios where you
  1441. might want to do this:
  1442. * You have legacy data that is not valid.
  1443. * You're sharding your database.
  1444. It is an error to pass both ``db_constraint`` and ``through``.
  1445. .. attribute:: ManyToManyField.swappable
  1446. Controls the migration framework's reaction if this :class:`ManyToManyField`
  1447. is pointing at a swappable model. If it is ``True`` - the default -
  1448. then if the :class:`ManyToManyField` is pointing at a model which matches
  1449. the current value of ``settings.AUTH_USER_MODEL`` (or another swappable
  1450. model setting) the relationship will be stored in the migration using
  1451. a reference to the setting, not to the model directly.
  1452. You only want to override this to be ``False`` if you are sure your
  1453. model should always point toward the swapped-in model - for example,
  1454. if it is a profile model designed specifically for your custom user model.
  1455. If in doubt, leave it to its default of ``True``.
  1456. :class:`ManyToManyField` does not support :attr:`~Field.validators`.
  1457. :attr:`~Field.null` has no effect since there is no way to require a
  1458. relationship at the database level.
  1459. ``OneToOneField``
  1460. -----------------
  1461. .. class:: OneToOneField(to, on_delete, parent_link=False, **options)
  1462. A one-to-one relationship. Conceptually, this is similar to a
  1463. :class:`ForeignKey` with :attr:`unique=True <Field.unique>`, but the
  1464. "reverse" side of the relation will directly return a single object.
  1465. This is most useful as the primary key of a model which "extends"
  1466. another model in some way; :ref:`multi-table-inheritance` is
  1467. implemented by adding an implicit one-to-one relation from the child
  1468. model to the parent model, for example.
  1469. One positional argument is required: the class to which the model will be
  1470. related. This works exactly the same as it does for :class:`ForeignKey`,
  1471. including all the options regarding :ref:`recursive <recursive-relationships>`
  1472. and :ref:`lazy <lazy-relationships>` relationships.
  1473. If you do not specify the :attr:`~ForeignKey.related_name` argument for the
  1474. ``OneToOneField``, Django will use the lowercase name of the current model as
  1475. default value.
  1476. With the following example::
  1477. from django.conf import settings
  1478. from django.db import models
  1479. class MySpecialUser(models.Model):
  1480. user = models.OneToOneField(
  1481. settings.AUTH_USER_MODEL,
  1482. on_delete=models.CASCADE,
  1483. )
  1484. supervisor = models.OneToOneField(
  1485. settings.AUTH_USER_MODEL,
  1486. on_delete=models.CASCADE,
  1487. related_name="supervisor_of",
  1488. )
  1489. your resulting ``User`` model will have the following attributes:
  1490. .. code-block:: pycon
  1491. >>> user = User.objects.get(pk=1)
  1492. >>> hasattr(user, "myspecialuser")
  1493. True
  1494. >>> hasattr(user, "supervisor_of")
  1495. True
  1496. A ``RelatedObjectDoesNotExist`` exception is raised when accessing the reverse
  1497. relationship if an entry in the related table doesn't exist. This is a subclass
  1498. of the target model's :exc:`Model.DoesNotExist
  1499. <django.db.models.Model.DoesNotExist>` exception and can be accessed as an
  1500. attribute of the reverse accessor. For example, if a user doesn't have a
  1501. supervisor designated by ``MySpecialUser``::
  1502. try:
  1503. user.supervisor_of
  1504. except User.supervisor_of.RelatedObjectDoesNotExist:
  1505. pass
  1506. .. _onetoone-arguments:
  1507. Additionally, ``OneToOneField`` accepts all of the extra arguments
  1508. accepted by :class:`ForeignKey`, plus one extra argument:
  1509. .. attribute:: OneToOneField.parent_link
  1510. When ``True`` and used in a model which inherits from another
  1511. :term:`concrete model`, indicates that this field should be used as the
  1512. link back to the parent class, rather than the extra
  1513. ``OneToOneField`` which would normally be implicitly created by
  1514. subclassing.
  1515. See :doc:`One-to-one relationships </topics/db/examples/one_to_one>` for usage
  1516. examples of ``OneToOneField``.
  1517. Field API reference
  1518. ===================
  1519. .. class:: Field
  1520. ``Field`` is an abstract class that represents a database table column.
  1521. Django uses fields to create the database table (:meth:`db_type`), to map
  1522. Python types to database (:meth:`get_prep_value`) and vice-versa
  1523. (:meth:`from_db_value`).
  1524. A field is thus a fundamental piece in different Django APIs, notably,
  1525. :class:`models <django.db.models.Model>` and :class:`querysets
  1526. <django.db.models.query.QuerySet>`.
  1527. In models, a field is instantiated as a class attribute and represents a
  1528. particular table column, see :doc:`/topics/db/models`. It has attributes
  1529. such as :attr:`null` and :attr:`unique`, and methods that Django uses to
  1530. map the field value to database-specific values.
  1531. A ``Field`` is a subclass of
  1532. :class:`~django.db.models.lookups.RegisterLookupMixin` and thus both
  1533. :class:`~django.db.models.Transform` and
  1534. :class:`~django.db.models.Lookup` can be registered on it to be used
  1535. in ``QuerySet``\s (e.g. ``field_name__exact="foo"``). All :ref:`built-in
  1536. lookups <field-lookups>` are registered by default.
  1537. All of Django's built-in fields, such as :class:`CharField`, are particular
  1538. implementations of ``Field``. If you need a custom field, you can either
  1539. subclass any of the built-in fields or write a ``Field`` from scratch. In
  1540. either case, see :doc:`/howto/custom-model-fields`.
  1541. .. attribute:: description
  1542. A verbose description of the field, e.g. for the
  1543. :mod:`django.contrib.admindocs` application.
  1544. The description can be of the form::
  1545. description = _("String (up to %(max_length)s)")
  1546. where the arguments are interpolated from the field's ``__dict__``.
  1547. .. attribute:: descriptor_class
  1548. A class implementing the :py:ref:`descriptor protocol <descriptors>`
  1549. that is instantiated and assigned to the model instance attribute. The
  1550. constructor must accept a single argument, the ``Field`` instance.
  1551. Overriding this class attribute allows for customizing the get and set
  1552. behavior.
  1553. To map a ``Field`` to a database-specific type, Django exposes several
  1554. methods:
  1555. .. method:: get_internal_type()
  1556. Returns a string naming this field for backend specific purposes.
  1557. By default, it returns the class name.
  1558. See :ref:`emulating-built-in-field-types` for usage in custom fields.
  1559. .. method:: db_type(connection)
  1560. Returns the database column data type for the :class:`Field`, taking
  1561. into account the ``connection``.
  1562. See :ref:`custom-database-types` for usage in custom fields.
  1563. .. method:: rel_db_type(connection)
  1564. Returns the database column data type for fields such as ``ForeignKey``
  1565. and ``OneToOneField`` that point to the :class:`Field`, taking
  1566. into account the ``connection``.
  1567. See :ref:`custom-database-types` for usage in custom fields.
  1568. There are three main situations where Django needs to interact with the
  1569. database backend and fields:
  1570. * when it queries the database (Python value -> database backend value)
  1571. * when it loads data from the database (database backend value -> Python
  1572. value)
  1573. * when it saves to the database (Python value -> database backend value)
  1574. When querying, :meth:`get_db_prep_value` and :meth:`get_prep_value` are used:
  1575. .. method:: get_prep_value(value)
  1576. ``value`` is the current value of the model's attribute, and the method
  1577. should return data in a format that has been prepared for use as a
  1578. parameter in a query.
  1579. See :ref:`converting-python-objects-to-query-values` for usage.
  1580. .. method:: get_db_prep_value(value, connection, prepared=False)
  1581. Converts ``value`` to a backend-specific value. By default it returns
  1582. ``value`` if ``prepared=True`` and :meth:`~Field.get_prep_value` if is
  1583. ``False``.
  1584. See :ref:`converting-query-values-to-database-values` for usage.
  1585. When loading data, :meth:`from_db_value` is used:
  1586. .. method:: from_db_value(value, expression, connection)
  1587. Converts a value as returned by the database to a Python object. It is
  1588. the reverse of :meth:`get_prep_value`.
  1589. This method is not used for most built-in fields as the database
  1590. backend already returns the correct Python type, or the backend itself
  1591. does the conversion.
  1592. ``expression`` is the same as ``self``.
  1593. See :ref:`converting-values-to-python-objects` for usage.
  1594. .. note::
  1595. For performance reasons, ``from_db_value`` is not implemented as a
  1596. no-op on fields which do not require it (all Django fields).
  1597. Consequently you may not call ``super`` in your definition.
  1598. When saving, :meth:`pre_save` and :meth:`get_db_prep_save` are used:
  1599. .. method:: get_db_prep_save(value, connection)
  1600. Same as the :meth:`get_db_prep_value`, but called when the field value
  1601. must be *saved* to the database. By default returns
  1602. :meth:`get_db_prep_value`.
  1603. .. method:: pre_save(model_instance, add)
  1604. Method called prior to :meth:`get_db_prep_save` to prepare the value
  1605. before being saved (e.g. for :attr:`DateField.auto_now`).
  1606. ``model_instance`` is the instance this field belongs to and ``add``
  1607. is whether the instance is being saved to the database for the first
  1608. time.
  1609. It should return the value of the appropriate attribute from
  1610. ``model_instance`` for this field. The attribute name is in
  1611. ``self.attname`` (this is set up by :class:`~django.db.models.Field`).
  1612. See :ref:`preprocessing-values-before-saving` for usage.
  1613. Fields often receive their values as a different type, either from
  1614. serialization or from forms.
  1615. .. method:: to_python(value)
  1616. Converts the value into the correct Python object. It acts as the
  1617. reverse of :meth:`value_to_string`, and is also called in
  1618. :meth:`~django.db.models.Model.clean`.
  1619. See :ref:`converting-values-to-python-objects` for usage.
  1620. Besides saving to the database, the field also needs to know how to
  1621. serialize its value:
  1622. .. method:: value_from_object(obj)
  1623. Returns the field's value for the given model instance.
  1624. This method is often used by :meth:`value_to_string`.
  1625. .. method:: value_to_string(obj)
  1626. Converts ``obj`` to a string. Used to serialize the value of the field.
  1627. See :ref:`converting-model-field-to-serialization` for usage.
  1628. When using :class:`model forms <django.forms.ModelForm>`, the ``Field``
  1629. needs to know which form field it should be represented by:
  1630. .. method:: formfield(form_class=None, choices_form_class=None, **kwargs)
  1631. Returns the default :class:`django.forms.Field` of this field for
  1632. :class:`~django.forms.ModelForm`.
  1633. By default, if both ``form_class`` and ``choices_form_class`` are
  1634. ``None``, it uses :class:`~django.forms.CharField`. If the field has
  1635. :attr:`~django.db.models.Field.choices` and ``choices_form_class``
  1636. isn't specified, it uses :class:`~django.forms.TypedChoiceField`.
  1637. See :ref:`specifying-form-field-for-model-field` for usage.
  1638. .. method:: deconstruct()
  1639. Returns a 4-tuple with enough information to recreate the field:
  1640. 1. The name of the field on the model.
  1641. 2. The import path of the field (e.g. ``"django.db.models.IntegerField"``).
  1642. This should be the most portable version, so less specific may be better.
  1643. 3. A list of positional arguments.
  1644. 4. A dict of keyword arguments.
  1645. This method must be added to fields prior to 1.7 to migrate its data
  1646. using :doc:`/topics/migrations`.
  1647. Registering and fetching lookups
  1648. ================================
  1649. ``Field`` implements the :ref:`lookup registration API <lookup-registration-api>`.
  1650. The API can be used to customize which lookups are available for a field class
  1651. and its instances, and how lookups are fetched from a field.
  1652. .. versionchanged:: 4.2
  1653. Support for registering lookups on :class:`~django.db.models.Field`
  1654. instances was added.
  1655. .. _model-field-attributes:
  1656. =========================
  1657. Field attribute reference
  1658. =========================
  1659. Every ``Field`` instance contains several attributes that allow
  1660. introspecting its behavior. Use these attributes instead of ``isinstance``
  1661. checks when you need to write code that depends on a field's functionality.
  1662. These attributes can be used together with the :ref:`Model._meta API
  1663. <model-meta-field-api>` to narrow down a search for specific field types.
  1664. Custom model fields should implement these flags.
  1665. Attributes for fields
  1666. =====================
  1667. .. attribute:: Field.auto_created
  1668. Boolean flag that indicates if the field was automatically created, such
  1669. as the ``OneToOneField`` used by model inheritance.
  1670. .. attribute:: Field.concrete
  1671. Boolean flag that indicates if the field has a database column associated
  1672. with it.
  1673. .. attribute:: Field.hidden
  1674. Boolean flag that indicates if a field is used to back another non-hidden
  1675. field's functionality (e.g. the ``content_type`` and ``object_id`` fields
  1676. that make up a ``GenericForeignKey``). The ``hidden`` flag is used to
  1677. distinguish what constitutes the public subset of fields on the model from
  1678. all the fields on the model.
  1679. .. note::
  1680. :meth:`Options.get_fields()
  1681. <django.db.models.options.Options.get_fields()>`
  1682. excludes hidden fields by default. Pass in ``include_hidden=True`` to
  1683. return hidden fields in the results.
  1684. .. attribute:: Field.is_relation
  1685. Boolean flag that indicates if a field contains references to one or
  1686. more other models for its functionality (e.g. ``ForeignKey``,
  1687. ``ManyToManyField``, ``OneToOneField``, etc.).
  1688. .. attribute:: Field.model
  1689. Returns the model on which the field is defined. If a field is defined on
  1690. a superclass of a model, ``model`` will refer to the superclass, not the
  1691. class of the instance.
  1692. Attributes for fields with relations
  1693. ====================================
  1694. These attributes are used to query for the cardinality and other details of a
  1695. relation. These attribute are present on all fields; however, they will only
  1696. have boolean values (rather than ``None``) if the field is a relation type
  1697. (:attr:`Field.is_relation=True <Field.is_relation>`).
  1698. .. attribute:: Field.many_to_many
  1699. Boolean flag that is ``True`` if the field has a many-to-many relation;
  1700. ``False`` otherwise. The only field included with Django where this is
  1701. ``True`` is ``ManyToManyField``.
  1702. .. attribute:: Field.many_to_one
  1703. Boolean flag that is ``True`` if the field has a many-to-one relation, such
  1704. as a ``ForeignKey``; ``False`` otherwise.
  1705. .. attribute:: Field.one_to_many
  1706. Boolean flag that is ``True`` if the field has a one-to-many relation, such
  1707. as a ``GenericRelation`` or the reverse of a ``ForeignKey``; ``False``
  1708. otherwise.
  1709. .. attribute:: Field.one_to_one
  1710. Boolean flag that is ``True`` if the field has a one-to-one relation, such
  1711. as a ``OneToOneField``; ``False`` otherwise.
  1712. .. attribute:: Field.related_model
  1713. Points to the model the field relates to. For example, ``Author`` in
  1714. ``ForeignKey(Author, on_delete=models.CASCADE)``. The ``related_model`` for
  1715. a ``GenericForeignKey`` is always ``None``.