Knack Data Model
Knack is een low-code platform om online databases te bouwen.
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'.
Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/knack
Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.
Platform
- Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
- Type: een applicatie die via de API toegankelijk is.
- De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
- Gegevens kunnen zowel worden geschreven als gelezen.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Status van het platform: https://status.knack.com/.
- Language of its user community: English.
Cijfers
| Figure | Count |
|---|---|
| Tables | 45 |
| Columns | 1,257 |
Poster met datamodel
In dit datamodel zijn nog geen sleutels gedefinieerd; de met punten gescheiden relaties worden afgeleid uit de namen van de kolommen.
Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden
Object
Applications, ObjectFieldValidations, ObjectFields, ObjectInboundConnections, ObjectOutboundConnections, ObjectRuleCriteria, ObjectRuleValues, ObjectRules, Objects, SceneViews, Scenes, Accounts, Payments
Overige
Companies, Contacts, ContactsExpanded, Journals
A_B_C (zonder relaties)
Bedrijf (zonder relaties)
Datum (zonder relaties)
Dagboek (zonder relaties)
Journals, JournalsMultiple_Choice
NATIVEPLATFORMSCALARREQUESTS (zonder relaties)
Volgorde (zonder relaties)
Product (zonder relaties)
Products, Products, ProductsExpanded
Test (zonder relaties)
Testcase (zonder relaties)
TestcaseIUD, TestcaseIUDExpanded
Testpho (zonder relaties)
Relaties
- Applications → Accounts (kandidaat): Derived from the column account_id.
- ObjectFieldValidations → Applications (kandidaat): Derived from the column application_id.
- ObjectFieldValidations → Objects (kandidaat): Derived from the column object_id.
- ObjectFields → Applications (kandidaat): Derived from the column application_id.
- ObjectFields → Objects (kandidaat): Derived from the column object_id.
- ObjectInboundConnections → Applications (kandidaat): Derived from the column application_id.
- ObjectInboundConnections → Objects (kandidaat): Derived from the column object_id.
- ObjectOutboundConnections → Applications (kandidaat): Derived from the column application_id.
- ObjectOutboundConnections → Objects (kandidaat): Derived from the column object_id.
- ObjectRuleCriteria → Applications (kandidaat): Derived from the column application_id.
- ObjectRuleCriteria → Objects (kandidaat): Derived from the column object_id.
- ObjectRuleValues → Applications (kandidaat): Derived from the column application_id.
- ObjectRuleValues → Objects (kandidaat): Derived from the column object_id.
- ObjectRules → Applications (kandidaat): Derived from the column application_id.
- ObjectRules → Objects (kandidaat): Derived from the column object_id.
- Objects → Applications (kandidaat): Derived from the column application_id.
- SceneViews → Applications (kandidaat): Derived from the column application_id.
- SceneViews → Scenes (kandidaat): Derived from the column scene_id.
- Scenes → Applications (kandidaat): Derived from the column application_id.
- Contacts → Companies (kandidaat): Derived from the column Company_id.
- ContactsExpanded → Companies (kandidaat): Derived from the column Company_id.
- Journals → Companies (kandidaat): Derived from the column Company_id.
- Payments → Accounts (kandidaat): Derived from the column Account_id.
Tabellen
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: Scalaire verzoeken op het native platform
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
Attributen
De kenmerken van dit platform staan op de pagina Attributes.
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: