Knack Data Model
Knack est une plateforme low-code permettant de créer des bases de données en ligne.
Authentication Authentication can be done using one of the following two alternatives:
- Using the user log on code and password to access Knack views.
- Using an API key to access Knack objects. The API key can be found on the 'API & Code' page in Knack available through the settings gear on the top-left corner next to the word 'Integration'. The URL for the API key is https://builder.knack.com/SAMPLE/integration#settings/api, with 'SAMPLE' replaced by your slug. The slug is the word before 'knack.com' when running your app.
Usage Limits Invantive SQL executes API calls to retrieve and upload data. The number of API calls allowed per hour depends on your Knack plan. The default usage limits vary depending on plan between 1.000 and 25.000 calls per day, with a limit of 10 calls per second. Invantive SQL ensures that within your session the number of calls allowed per hour is not exceeded. To get an impression of how Invantive SQL translates into API calls, please query the data dictionary view 'sessionios', such as with 'select * from sessionios@datadictionary'.
Configurez cette plateforme dans Invantive Cloud : https://cloud.invantive.com/knack
Les comparaisons de texte sur cette plateforme tiennent compte de la casse.
Plate-forme
- Utilisable depuis : Invantive Cloud et les produits Invantive installés sur votre ordinateur ou votre serveur.
- Type : une application accessible via son API.
- Les données sont regroupées par catégorie, par exemple par entreprise ou par administration.
- Les données peuvent être aussi bien écrites que lues.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- État de la plateforme : https://status.knack.com/.
- Language of its user community: English.
Chiffres
| Figure | Count |
|---|---|
| Tables | 45 |
| Columns | 1,257 |
Affiche sur le modèle de données
Ce modèle de données ne déclare pour l'instant aucune clé ; les relations indiquées par des points sont dérivées des noms de colonnes.
Sur une table de l'affiche : Zoom avant et arrière, les touches fléchées permettent de se déplacer, la touche 0 permet de revenir à la taille normale.
L'affiche sous forme de texte : tableaux par thème et leurs relations
Objet
Applications, ObjectFieldValidations, ObjectFields, ObjectInboundConnections, ObjectOutboundConnections, ObjectRuleCriteria, ObjectRuleValues, ObjectRules, Objects, SceneViews, Scenes, Accounts, Payments
Autre
Companies, Contacts, ContactsExpanded, Journals
A_B_C (sans relations)
Société (sans relations)
Date (sans relations)
Journal (sans relations)
Journals, JournalsMultiple_Choice
NATIVEPLATFORMSCALARREQUESTS (sans relations)
Commande (sans relations)
Produit (sans relations)
Products, Products, ProductsExpanded
Tester (sans relations)
Testcase (sans relations)
TestcaseIUD, TestcaseIUDExpanded
Testpho (sans relations)
Relations
- Applications → Accounts (candidat): Derived from the column account_id.
- ObjectFieldValidations → Applications (candidat): Derived from the column application_id.
- ObjectFieldValidations → Objects (candidat): Derived from the column object_id.
- ObjectFields → Applications (candidat): Derived from the column application_id.
- ObjectFields → Objects (candidat): Derived from the column object_id.
- ObjectInboundConnections → Applications (candidat): Derived from the column application_id.
- ObjectInboundConnections → Objects (candidat): Derived from the column object_id.
- ObjectOutboundConnections → Applications (candidat): Derived from the column application_id.
- ObjectOutboundConnections → Objects (candidat): Derived from the column object_id.
- ObjectRuleCriteria → Applications (candidat): Derived from the column application_id.
- ObjectRuleCriteria → Objects (candidat): Derived from the column object_id.
- ObjectRuleValues → Applications (candidat): Derived from the column application_id.
- ObjectRuleValues → Objects (candidat): Derived from the column object_id.
- ObjectRules → Applications (candidat): Derived from the column application_id.
- ObjectRules → Objects (candidat): Derived from the column object_id.
- Objects → Applications (candidat): Derived from the column application_id.
- SceneViews → Applications (candidat): Derived from the column application_id.
- SceneViews → Scenes (candidat): Derived from the column scene_id.
- Scenes → Applications (candidat): Derived from the column application_id.
- Contacts → Companies (candidat): Derived from the column Company_id.
- ContactsExpanded → Companies (candidat): Derived from the column Company_id.
- Journals → Companies (candidat): Derived from the column Company_id.
- Payments → Accounts (candidat): Derived from the column Account_id.
Tableaux
Knack.DataDictionary
- ApplicationById: Application by ID
- Applications: Applications
- ObjectFieldValidations: Knack Field Validations
- ObjectFieldValidationsByApplicationId: Knack Field Validations by Application ID
- ObjectFields: Knack Object Fields
- ObjectFieldsByApplicationId: Knack Object Fields by Application ID
- ObjectInboundConnections: Knack Object Inbound Connections
- ObjectInboundConnectionsByApplicationId: Knack Object Inbound Connections by Application ID
- ObjectOutboundConnections: Knack Object Outbound Connections
- ObjectOutboundConnectionsByApplicationId: Knack Object Outbound Connections by Application ID
- ObjectRuleCriteria: Knack Object Rule Criteria
- ObjectRuleCriteriaByApplicationId: Knack Object Rule Criteria by Application ID
- ObjectRuleValues: Knack Object Rule Values
- ObjectRuleValuesByApplicationId: Knack Object Rule Values by Application ID
- ObjectRules: Knack Object Rules
- ObjectRulesByApplicationId: Knack Object Rules by Application ID
- Objects: Knack Objects
- ObjectsByApplicationId: Knack Objects by Application ID
- SceneViews: Knack Scene Views
- SceneViewsByApplicationId: Knack Scene Views by Application ID
- Scenes: Knack Scenes
- ScenesByApplicationId: Knack Scenes by Application ID
Knack.Journal_Details
Knack.Journals
- Journals: Table
Knack.Native
- NATIVEPLATFORMSCALARREQUESTS : Demandes scalaires sur plateforme native
Knack.Objects
- A_B_C: A B Cs
- Accounts: Accounts
- Companies: Companies
- CompaniesExpanded: Companies
- Contacts: Contacts
- ContactsExpanded: Contacts
- DateTest: DateTests
- Journals: Journals
- JournalsMultiple_Choice: Multiple choices for Journals
- OrdersObject: OrdersObjects
- Payments: Payments
- Products: Products
- ProductsExpanded: Products
- Test: Tests
- TestExpanded: Tests
- TestcaseIUD: TestcaseIUDs
- TestcaseIUDExpanded: TestcaseIUDs
- testpho: testphos
Knack.Product_Details
Knack.ProductsMenu
- Products: Table
Attributs
Les caractéristiques de cette plateforme sont présentées sur la page Attributes.
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :