CINXE.COM
<!DOCTYPE html><html><head> <meta charset="utf-8"> <base data-ice="baseUrl"> <title data-ice="title">Reference | Sequelize</title> <link type="text/css" rel="stylesheet" href="css/style.css"> <link type="text/css" rel="stylesheet" href="css/prettify-tomorrow.css"> <script src="/v5/script/prettify/prettify.js"></script> <script src="/v5/script/manual.js"></script> <link rel="stylesheet" href="./inject/css/0-style.css"><link rel="stylesheet" href="./inject/css/0-theme.css"><meta name="description" content="An easy-to-use multi SQL dialect ORM for Node.js"><meta property="twitter:card" content="summary"><meta property="twitter:title" content="Sequelize"><meta property="twitter:description" content="An easy-to-use multi SQL dialect ORM for Node.js"><meta name="robots" content="noindex"></head> <body class="layout-container" data-ice="rootContainer"> <header> <a href="./" style="display: flex; align-items: center;"><img src="/v5/./image/brand_logo.png" style="width:34px;"></a> <a class='api-reference-link' href='/v5/identifiers'>API Reference</a> <a href='/v5/source'>Source</a> <div class="search-box"> <span> <img src="/v5/./image/search.png"> <span class="search-input-edge"></span><input class="search-input"><span class="search-input-edge"></span> </span> <ul class="search-result"></ul> </div> <a style="" href="https://github.com/sequelize/sequelize"><img width="30px" src="/v5/./image/github.png" style="width: 30px;"></a> <a href="https://sequelize.org/slack"> <img src="/v5/manual/asset/slack.svg" style="width: 60px; margin-left: -15px;"> </a> </header> <nav class="navigation" data-ice="nav"><div> <ul> <li data-ice="doc" style="margin-top: 15px;"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/model.js~model'>Model</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/query-interface.js~queryinterface'>QueryInterface</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/sequelize.js~sequelize'>Sequelize</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/transaction.js~transaction'>Transaction</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-variable">V</span><span data-ice="name"><span><a href='/v5/variable/#static-variable-DataTypes'>DataTypes</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-variable">V</span><span data-ice="name"><span><a href='/v5/variable/#static-variable-Deferrable'>Deferrable</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-variable">V</span><span data-ice="name"><span><a href='/v5/variable/#static-variable-IndexHints'>IndexHints</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-variable">V</span><span data-ice="name"><span><a href='/v5/variable/#static-variable-Op'>Op</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-variable">V</span><span data-ice="name"><span><a href='/v5/variable/#static-variable-QueryTypes'>QueryTypes</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-variable">V</span><span data-ice="name"><span><a href='/v5/variable/#static-variable-TableHints'>TableHints</a></span></span></li> <li data-ice="doc"><a class='nav-dir-path' data-ice='dirPath' href='/v5/identifiers#associations'>associations</a><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/associations/base.js~association'>Association</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/associations/belongs-to-many.js~belongstomany'>BelongsToMany</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/associations/belongs-to.js~belongsto'>BelongsTo</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/associations/has-many.js~hasmany'>HasMany</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/associations/has-one.js~hasone'>HasOne</a></span></span></li> <li data-ice="doc"><a class='nav-dir-path' data-ice='dirPath' href='/v5/identifiers#dialects-sqlite'>dialects/sqlite</a><span data-ice="kind" class="kind-function">F</span><span data-ice="name"><span><a href='/v5/function/#static-function-describeTable'>describeTable</a></span></span></li> <li data-ice="doc"><a class='nav-dir-path' data-ice='dirPath' href='/v5/identifiers#errors'>errors</a><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/association-error.js~associationerror'>AssociationError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/base-error.js~baseerror'>BaseError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/bulk-record-error.js~bulkrecorderror'>BulkRecordError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/connection-error.js~connectionerror'>ConnectionError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/database-error.js~databaseerror'>DatabaseError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/eager-loading-error.js~eagerloadingerror'>EagerLoadingError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/empty-result-error.js~emptyresulterror'>EmptyResultError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/instance-error.js~instanceerror'>InstanceError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/optimistic-lock-error.js~optimisticlockerror'>OptimisticLockError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/query-error.js~queryerror'>QueryError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/sequelize-scope-error.js~sequelizescopeerror'>SequelizeScopeError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/validation-error.js~validationerror'>ValidationError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/validation-error.js~validationerroritem'>ValidationErrorItem</a></span></span></li> <li data-ice="doc"><a class='nav-dir-path' data-ice='dirPath' href='/v5/identifiers#errors-connection'>errors/connection</a><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/connection/access-denied-error.js~accessdeniederror'>AccessDeniedError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/connection/connection-acquire-timeout-error.js~connectionacquiretimeouterror'>ConnectionAcquireTimeoutError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/connection/connection-refused-error.js~connectionrefusederror'>ConnectionRefusedError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/connection/connection-timed-out-error.js~connectiontimedouterror'>ConnectionTimedOutError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/connection/host-not-found-error.js~hostnotfounderror'>HostNotFoundError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/connection/host-not-reachable-error.js~hostnotreachableerror'>HostNotReachableError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/connection/invalid-connection-error.js~invalidconnectionerror'>InvalidConnectionError</a></span></span></li> <li data-ice="doc"><a class='nav-dir-path' data-ice='dirPath' href='/v5/identifiers#errors-database'>errors/database</a><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/database/exclusion-constraint-error.js~exclusionconstrainterror'>ExclusionConstraintError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/database/foreign-key-constraint-error.js~foreignkeyconstrainterror'>ForeignKeyConstraintError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/database/timeout-error.js~timeouterror'>TimeoutError</a></span></span></li> <li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/database/unknown-constraint-error.js~unknownconstrainterror'>UnknownConstraintError</a></span></span></li> <li data-ice="doc"><a class='nav-dir-path' data-ice='dirPath' href='/v5/identifiers#errors-validation'>errors/validation</a><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/errors/validation/unique-constraint-error.js~uniqueconstrainterror'>UniqueConstraintError</a></span></span></li> <li data-ice="doc"><a class='nav-dir-path' data-ice='dirPath' href='/v5/variable/#static-variable-DataTypes'>datatypes</a><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~array'>ARRAY</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~virtual'>VIRTUAL</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~uuidv4'>UUIDV4</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~uuidv1'>UUIDV1</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~uuid'>UUID</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~tinyint'>TINYINT</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~time'>TIME</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~text'>TEXT</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~string'>STRING</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~smallint'>SMALLINT</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~real'>REAL</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~range'>RANGE</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~number'>NUMBER</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~now'>NOW</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~mediumint'>MEDIUMINT</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~macaddr'>MACADDR</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~jsontype'>JSONTYPE</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~jsonb'>JSONB</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~integer'>INTEGER</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~inet'>INET</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~hstore'>HSTORE</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~geometry'>GEOMETRY</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~geography'>GEOGRAPHY</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~float'>FLOAT</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~enum'>ENUM</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~double'>DOUBLE</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~decimal'>DECIMAL</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~dateonly'>DATEONLY</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~date'>DATE</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~citext'>CITEXT</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~cidr'>CIDR</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~char'>CHAR</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~boolean'>BOOLEAN</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~blob'>BLOB</a></span></span></li><li data-ice="doc"><span data-ice="kind" class="kind-class">C</span><span data-ice="name"><span><a href='/v5/class/lib/data-types.js~bigint'>BIGINT</a></span></span></li></ul> </div> </nav> <div class="content" data-ice="content"><h1>References</h1> <div class="identifiers-wrap"> <div> <div data-ice="dirSummaryWrap"> <div data-ice="dirSummary"><table class="summary" data-ice="summary"> <thead><tr><td data-ice="title" colspan="3">summary</td></tr></thead> <tbody> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/model.js~model'>Model</a></span></span> </p> </div> <div> <div data-ice="description"><p>A Model represents a table in the database.</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/query-interface.js~queryinterface'>QueryInterface</a></span></span> </p> </div> <div> <div data-ice="description"><p>The interface that Sequelize uses to talk to all databases</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/sequelize.js~sequelize'>Sequelize</a></span></span> </p> </div> <div> <div data-ice="description"><p>This is the main class, the entry point to sequelize.</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/transaction.js~transaction'>Transaction</a></span></span> </p> </div> <div> <div data-ice="description"><p>The transaction object is used to identify a running transaction.</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-variable">V</span> <span class="code" data-ice="name"><span><a href='/v5/variable/#static-variable-DataTypes'>DataTypes</a></span></span><span class="code" data-ice="signature">: <span>*</span></span> </p> </div> <div> <div data-ice="description"><p>A convenience class holding commonly used data types.</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-variable">V</span> <span class="code" data-ice="name"><span><a href='/v5/variable/#static-variable-Deferrable'>Deferrable</a></span></span><span class="code" data-ice="signature">: <span>*</span></span> </p> </div> <div> <div data-ice="description"><p>A collection of properties related to deferrable constraints.</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-variable">V</span> <span class="code" data-ice="name"><span><a href='/v5/variable/#static-variable-IndexHints'>IndexHints</a></span></span><span class="code" data-ice="signature">: <span>*</span></span> </p> </div> <div> <div data-ice="description"><p>An enum of index hints to be used in mysql for querying with index hints</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-variable">V</span> <span class="code" data-ice="name"><span><a href='/v5/variable/#static-variable-Op'>Op</a></span></span><span class="code" data-ice="signature">: {"eq": <span>*</span>, "ne": <span>*</span>, "gte": <span>*</span>, "gt": <span>*</span>, "lte": <span>*</span>, "lt": <span>*</span>, "not": <span>*</span>, "is": <span>*</span>, "in": <span>*</span>, "notIn": <span>*</span>, "like": <span>*</span>, "notLike": <span>*</span>, "iLike": <span>*</span>, "notILike": <span>*</span>, "startsWith": <span>*</span>, "endsWith": <span>*</span>, "substring": <span>*</span>, "regexp": <span>*</span>, "notRegexp": <span>*</span>, "iRegexp": <span>*</span>, "notIRegexp": <span>*</span>, "between": <span>*</span>, "notBetween": <span>*</span>, "overlap": <span>*</span>, "contains": <span>*</span>, "contained": <span>*</span>, "adjacent": <span>*</span>, "strictLeft": <span>*</span>, "strictRight": <span>*</span>, "noExtendRight": <span>*</span>, "noExtendLeft": <span>*</span>, "and": <span>*</span>, "or": <span>*</span>, "any": <span>*</span>, "all": <span>*</span>, "values": <span>*</span>, "col": <span>*</span>, "placeholder": <span>*</span>, "join": <span>*</span>}</span> </p> </div> <div> <div data-ice="description"><p>Operator symbols to be used when querying data</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-variable">V</span> <span class="code" data-ice="name"><span><a href='/v5/variable/#static-variable-QueryTypes'>QueryTypes</a></span></span><span class="code" data-ice="signature">: <span>*</span></span> </p> </div> <div> <div data-ice="description"><p>An enum of query types used by <code>sequelize.query</code></p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-variable">V</span> <span class="code" data-ice="name"><span><a href='/v5/variable/#static-variable-TableHints'>TableHints</a></span></span><span class="code" data-ice="signature">: <span>*</span></span> </p> </div> <div> <div data-ice="description"><p>An enum of table hints to be used in mssql for querying with table hints</p> </div> </div> </td> <td> </td> </tr> </tbody> </table> </div> </div> <div data-ice="dirSummaryWrap"> <h2 data-ice="dirPath" id="associations">associations</h2> <div data-ice="dirSummary"><table class="summary" data-ice="summary"> <thead><tr><td data-ice="title" colspan="3">summary</td></tr></thead> <tbody> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/associations/base.js~association'>Association</a></span></span> </p> </div> <div> <div data-ice="description"><p>Creating associations in sequelize is done by calling one of the belongsTo / hasOne / hasMany / belongsToMany functions on a model (the source), and providing another model as the first argument to the function (the target).</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/associations/belongs-to-many.js~belongstomany'>BelongsToMany</a></span></span> </p> </div> <div> <div data-ice="description"><p>Many-to-many association with a join table.</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/associations/belongs-to.js~belongsto'>BelongsTo</a></span></span> </p> </div> <div> <div data-ice="description"><p>One-to-one association</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/associations/has-many.js~hasmany'>HasMany</a></span></span> </p> </div> <div> <div data-ice="description"><p>One-to-many association</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/associations/has-one.js~hasone'>HasOne</a></span></span> </p> </div> <div> <div data-ice="description"><p>One-to-one association</p> </div> </div> </td> <td> </td> </tr> </tbody> </table> </div> </div> <div data-ice="dirSummaryWrap"> <h2 data-ice="dirPath" id="dialects-sqlite">dialects/sqlite</h2> <div data-ice="dirSummary"><table class="summary" data-ice="summary"> <thead><tr><td data-ice="title" colspan="3">summary</td></tr></thead> <tbody> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-function">F</span> <span class="code" data-ice="name"><span><a href='/v5/function/#static-function-describeTable'>describeTable</a></span></span><span class="code" data-ice="signature">(qi: <span><a href='/v5/class/lib/query-interface.js~queryinterface'>QueryInterface</a></span>, tableName: <span><a href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String">string</a></span>, options: <span><a href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Object">Object</a></span>): <span><a href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Promise">Promise</a></span><<span><a href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Object">Object</a></span>></span> </p> </div> <div> <div data-ice="description"><p>Describe a table structure</p> </div> </div> </td> <td> </td> </tr> </tbody> </table> </div> </div> <div data-ice="dirSummaryWrap"> <h2 data-ice="dirPath" id="errors">errors</h2> <div data-ice="dirSummary"><table class="summary" data-ice="summary"> <thead><tr><td data-ice="title" colspan="3">summary</td></tr></thead> <tbody> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/association-error.js~associationerror'>AssociationError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when an association is improperly constructed (see message for details)</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/base-error.js~baseerror'>BaseError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Sequelize provides a host of custom error classes, to allow you to do easier debugging.</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/bulk-record-error.js~bulkrecorderror'>BulkRecordError</a></span></span><span class="code" data-ice="signature">(error: <span><a href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Error">Error</a></span>, record: <span><a href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Object">Object</a></span>)</span> </p> </div> <div> <div data-ice="description"><p>Thrown when bulk operation fails, it represent per record level error.</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/connection-error.js~connectionerror'>ConnectionError</a></span></span> </p> </div> <div> <div data-ice="description"><p>A base class for all connection related errors.</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/database-error.js~databaseerror'>DatabaseError</a></span></span> </p> </div> <div> <div data-ice="description"><p>A base class for all database related errors.</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/eager-loading-error.js~eagerloadingerror'>EagerLoadingError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when an include statement is improperly constructed (see message for details)</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/empty-result-error.js~emptyresulterror'>EmptyResultError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when a record was not found, Usually used with rejectOnEmpty mode (see message for details)</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/instance-error.js~instanceerror'>InstanceError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when a some problem occurred with Instance methods (see message for details)</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/optimistic-lock-error.js~optimisticlockerror'>OptimisticLockError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when attempting to update a stale model instance</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/query-error.js~queryerror'>QueryError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when a query is passed invalid options (see message for details)</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/sequelize-scope-error.js~sequelizescopeerror'>SequelizeScopeError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Scope Error.</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/validation-error.js~validationerror'>ValidationError</a></span></span><span class="code" data-ice="signature">(message: <span><a href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String">string</a></span>, errors: <span><a href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array">Array</a></span>)</span> </p> </div> <div> <div data-ice="description"><p>Validation Error.</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/validation-error.js~validationerroritem'>ValidationErrorItem</a></span></span> </p> </div> <div> <div data-ice="description"><p>Validation Error Item Instances of this class are included in the <code>ValidationError.errors</code> property.</p> </div> </div> </td> <td> </td> </tr> </tbody> </table> </div> </div> <div data-ice="dirSummaryWrap"> <h2 data-ice="dirPath" id="errors-connection">errors/connection</h2> <div data-ice="dirSummary"><table class="summary" data-ice="summary"> <thead><tr><td data-ice="title" colspan="3">summary</td></tr></thead> <tbody> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/connection/access-denied-error.js~accessdeniederror'>AccessDeniedError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when a connection to a database is refused due to insufficient privileges</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/connection/connection-acquire-timeout-error.js~connectionacquiretimeouterror'>ConnectionAcquireTimeoutError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when connection is not acquired due to timeout</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/connection/connection-refused-error.js~connectionrefusederror'>ConnectionRefusedError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when a connection to a database is refused</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/connection/connection-timed-out-error.js~connectiontimedouterror'>ConnectionTimedOutError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when a connection to a database times out</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/connection/host-not-found-error.js~hostnotfounderror'>HostNotFoundError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when a connection to a database has a hostname that was not found</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/connection/host-not-reachable-error.js~hostnotreachableerror'>HostNotReachableError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when a connection to a database has a hostname that was not reachable</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/connection/invalid-connection-error.js~invalidconnectionerror'>InvalidConnectionError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when a connection to a database has invalid values for any of the connection parameters</p> </div> </div> </td> <td> </td> </tr> </tbody> </table> </div> </div> <div data-ice="dirSummaryWrap"> <h2 data-ice="dirPath" id="errors-database">errors/database</h2> <div data-ice="dirSummary"><table class="summary" data-ice="summary"> <thead><tr><td data-ice="title" colspan="3">summary</td></tr></thead> <tbody> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/database/exclusion-constraint-error.js~exclusionconstrainterror'>ExclusionConstraintError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when an exclusion constraint is violated in the database</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/database/foreign-key-constraint-error.js~foreignkeyconstrainterror'>ForeignKeyConstraintError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when a foreign key constraint is violated in the database</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/database/timeout-error.js~timeouterror'>TimeoutError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when a database query times out because of a deadlock</p> </div> </div> </td> <td> </td> </tr> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/database/unknown-constraint-error.js~unknownconstrainterror'>UnknownConstraintError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when constraint name is not found in the database</p> </div> </div> </td> <td> </td> </tr> </tbody> </table> </div> </div> <div data-ice="dirSummaryWrap"> <h2 data-ice="dirPath" id="errors-validation">errors/validation</h2> <div data-ice="dirSummary"><table class="summary" data-ice="summary"> <thead><tr><td data-ice="title" colspan="3">summary</td></tr></thead> <tbody> <tr data-ice="target"> <td> <span class="access" data-ice="access">public</span> <span class="override" data-ice="override"></span> </td> <td> <div> <p> <span data-ice="kind-icon" class="kind-class">C</span> <span class="code" data-ice="name"><span><a href='/v5/class/lib/errors/validation/unique-constraint-error.js~uniqueconstrainterror'>UniqueConstraintError</a></span></span> </p> </div> <div> <div data-ice="description"><p>Thrown when a unique constraint is violated in the database</p> </div> </div> </td> <td> </td> </tr> </tbody> </table> </div> </div> </div> <div class="identifier-dir-tree" data-ice="dirTreeWrap"> <div class="identifier-dir-tree-header">Directories</div> <div class="identifier-dir-tree-content" data-ice="dirTree"><div style="padding-left: 0em"><a href="#associations">associations</a></div> <div style="padding-left: 1em"><a href="#dialects-sqlite">sqlite</a></div> <div style="padding-left: 0em"><a href="#errors">errors</a></div> <div style="padding-left: 1em"><a href="#errors-connection">connection</a></div> <div style="padding-left: 1em"><a href="#errors-database">database</a></div> <div style="padding-left: 1em"><a href="#errors-validation">validation</a></div></div> </div> </div> </div> <footer class="footer"> Generated by <a href="https://esdoc.org">ESDoc<span data-ice="esdocVersion">(1.1.0)</span><img src="/v5/./image/esdoc-logo-mini-black.png"></a> </footer> <script src="/v5/script/search_index.js"></script> <script src="/v5/script/search.js"></script> <script src="/v5/script/pretty-print.js"></script> <script src="/v5/script/inherited-summary.js"></script> <script src="/v5/script/test-summary.js"></script> <script src="/v5/script/inner-link.js"></script> <script src="/v5/script/patch-for-local.js"></script> </body></html>