Difference between revisions of "Main:Database index"

From Memento Database Wiki
Jump to navigation Jump to search
m
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{stamp|2021-09-16|4.10.2|1.10.2}}
+
{{stamp|2021-11-04|4.10.2|1.10.2}}
 
{{banner-menu}}
 
{{banner-menu}}
== The ''Database index'' into Memento Database ==
 
'''''<insert Brief index introduction -- TBD>'''''
 
  
 +
==Preamble on database terminology ==
 +
This is to get us on the same page regarding terms Memento users have used previously versus the terms chosen by Memento for its products. [[#The Database index, allowing quick access to Memento Database information|Jump to the database index]]
  
=== Navigation index ===
+
=== Memento terms and database industry terms ===
 +
Sometimes some of us tend to use one set of terms for things, and some might use another set of terms for the same things, like "record" or (less often) "row" for a Memento entry and ...
 +
'''''Yada'''''
  
 +
The Memento Database application comprises ''libraries'' (often known outside Memento as tables), ''entries'' (often known outside Memento as rows), and ''fields'' (often known outside Memento as columns). A common generic term, recognized everwhere for either entries or rows is ''records''.
 +
 +
In the Memento forum, "field" and "record" are often used and "column" and "row" is seldom used. So, it's best to stick with either Memento's "entry" (since it's their forum, after all), but when others use or seem to prefer the database industry's "record", we'll all know what is meant by that, and we can accommodate them when interacting with them, message by message in the forum.
 +
 +
=== Databases and Libraries ===
 +
Likewise, within the database industry overall, "database" is used to mean the entire set of data used by a hopefully identified user or group of users to accomplish the users' personal or professional objectives, comprising libraries, entries, and fields. So, a person might use one database at home and another at work, and though many libraries will be different between libraries (like Customers at work and Groceries at home), some libraries might be used both at home and at work, often the most common and generic libraries, like People or Organizations.
 +
 +
When a user's objectives are so small that a single library is enough, then in that case the database is the library. However, when a user's objectives require that libraries be linked together to accomplish the objectives, now the entire set of linked libraries constitute the database. That's why, whenever we go into Edit Library > Export to create a .template file, there's an option to include linked libraries. This makes the template a database export rather than merely a library export. For more on database exports, see [[How:Export a database|Export a database]].
 +
 +
Libraries can be linked so they can work together as a database. So, each library has a structure of fields & other things (see below for what things make up its structure), and each database has a structure of libraries & links between them (see About:Database structure#Examples for an example).
 +
 +
== The ''Database index'', allowing quick access to Memento Database information ==
 +
Yada
 +
 +
=== Introduction ===
 
{| class="wikitable" font-size="100%"
 
{| class="wikitable" font-size="100%"
! Topics !! Overviews !! Specifications !! About
+
! Topics !! Overviews !! About
 
|-
 
|-
| width "20" | <big>'''Memento Database'''</big>
+
| style="width:25%;" | <big>'''Memento Database'''</big>
| width "20" | [[Memento Database]]
+
| style="width:25%;" | [[Memento Database]]
 
[[Memento Wiki]]
 
[[Memento Wiki]]
 
<br/>[[Glossary]]
 
<br/>[[Glossary]]
 
<br/>[[Useful links]]
 
<br/>[[Useful links]]
 
<br/>[[Releases]]
 
<br/>[[Releases]]
| width "30" | [[User Interface]]
+
| style="width:25%;" | [[How:Getting Started]]
| width "30" | [[How:Getting Started]]
 
 
<br/>[[About:Bill's mementos]]
 
<br/>[[About:Bill's mementos]]
 
<br/>[[About:Bill's tutorials]]
 
<br/>[[About:Bill's tutorials]]
 
<br/>[[About:Bill's examples]]
 
<br/>[[About:Bill's examples]]
<br/>[[How:Simple To Do List]]
+
<br/>[[Tutorial:Simple To Do List]]
 
<br/>[[Tutorial:Simple To Do List Enhancements]]
 
<br/>[[Tutorial:Simple To Do List Enhancements]]
 
<br/>[[About:Color codes]]
 
<br/>[[About:Color codes]]
 
<br/>[[CaseStudy:Designing Memento databases:Photographic equipment]]
 
<br/>[[CaseStudy:Designing Memento databases:Photographic equipment]]
 +
|}
 +
 +
=== Displays in the Memento mobile edition ===
 +
{| class="wikitable"
 +
! Topics !! Overviews !! Specs !! Guidance
 
|-
 
|-
| <big>'''Libraries<br/> & templates'''</big>
+
| style="width:25%;" |
 
+
| style="width:25%;" | [[Screens & cards]]
| [[Library]]
+
| style="width:25%;" | [[Libraries List screen]]
[[Library Template]]
 
| [[Libraries List screen]]
 
 
[[Library Edit screen]]
 
[[Library Edit screen]]
<br/>[[Library Groups]]
+
<br/>[[Library Entries List screen|Entries List screen]]
<br/>[[Library Protection]]
+
<br/>[[Entry Edit card]]
| [[How:Add a Library]]
+
<br/>[[Entry View card]]
|-
+
<br/>[[File Manager card]]
| <big>'''Fields, pages,<br/>& subheaders'''</big>
+
<br/>[[Attached Files card]]
 +
<br/>[[Charting data]]
 +
| style="width:25%;" |
 +
|}
  
| [[Field]]
+
=== Displays in the Memento desktop edition ===
[[Field Edit card]]
+
{| class="wikitable"
<br/>[[Field Role]]
+
! Topics !! Overviews !! Specs !! Guidance
<br/>[[Field Type]]
+
|-
<br/>[[Page]]
+
| style="width:25%;" |
|
+
| style="width:25%;" | [[Windows & panes]]
<big>'''''Text'' fields'''</big>
+
| style="width:25%;" |
:[[Text field|Text]]
+
| style="width:25%;" |
:[[Rich Text field|Rich text (HTML)]]
+
|}
:[[Phone Number field|Phone number]]
 
:[[Email Address field|Email address]]
 
:[[Hyperlink field|Hyperlink]]
 
:[[Password field|Password]]
 
:[[Barcode field|Barcode]]
 
 
 
<big>'''''Numeric'' fields'''</big>
 
:[[Integer field|Integer]]
 
:[[Integer values field|Integer values]]
 
:[[Currency field|Currency]]
 
:[[Real number field|Real number]]
 
:[[Rating field|Reading]]
 
 
 
<big>'''''Choice'' fields'''</big>
 
:[[Boolean field|Boolean]]
 
:[[Single-choice List field|Single-choice list]]
 
:[[Radio Buttons field|Radio buttons]]
 
:[[Multiple-choice List field|Multiple-choice list]]
 
:[[Checkboxes field|Checkboxes]]
 
:[[List field|Dynamic List]]
 
 
 
<big>'''''Calculated expression'' fields'''</big>
 
:[[JavaScript field|JavaScript]]
 
:[[Calculation field|Calculation]]
 
 
 
<big>'''''Date'' fields'''</big>
 
:[[Date field|Date]]
 
:[[DateTime field|DateTime]]
 
 
 
<big>'''''Time'' fields'''</big>
 
:[[Time field|Time]]
 
:[[DateTime field|DateTime]]
 
 
 
<big>'''''Linking'' fields'''</big>
 
:[[Link To Entry field|Link to entry]]
 
:[[Link To File field|Link to file]]
 
 
 
<big>'''''Media'' fields'''</big>
 
:[[Audio field|Audio]]
 
:[[Image field|Image]]
 
:[[Signature field|Signature]]
 
 
 
<big>'''''Miscellaneous'' fields'''</big>
 
:[[Contact field|Contact]]
 
:[[Location field|Location]]
 
:[[Tags field|Tags]]
 
  
<hr><big>'''''Special content'' fields'''</big>
 
:[[Audio field]]
 
:[[Barcode field]]
 
:[[Contact field]]
 
:[[Location field]]
 
:[[Rich Text field]]
 
:[[Signature field]]
 
  
| [[How:Field Dependencies|Field Dependencies]]
+
=== Scripting, Calculation, & App Integration ===
[[Tips:Using JavaScript in Memento|Using JavaScript in Memento]]
+
{| class="wikitable"
 +
! Topics !! Overviews !! Specs !! Guidance
 
|-
 
|-
| <big>'''Entries<br/>& entry lists'''</big>
+
| style="width:25%;" | [[Scripting]]
 
+
| style="width:25%;" | [[Calculation field]]
| [[Entry]]
 
[[Data analysis]]
 
| [[Entry View card]]
 
[[Entry Edit card]]
 
<br/>[[Libraries List screen]]
 
<br/>[[Library Entries List screen|Entries List screen]]
 
| [[How:Access a Previous Entry]]
 
[[How:Slice & Dice Library Data]]
 
|-
 
| <big>'''Scripting, Calculation,<br/>& App Integration'''</big>
 
 
 
| [[Scripting]]
 
| [[Calculation field]]
 
 
[[JavaScript field]]
 
[[JavaScript field]]
 
<br/>[[Memento JavaScript Library]]
 
<br/>[[Memento JavaScript Library]]
Line 125: Line 82:
 
<br/>[[Data Sources]]
 
<br/>[[Data Sources]]
 
<br/>[[Triggers]]
 
<br/>[[Triggers]]
| [[Tasker Integration]]
+
| style="width:25%;" | [[Tasker Integration]]
 
[[Trigger Examples]]
 
[[Trigger Examples]]
 
<br/>[[How:Write scripts in JavaScript for Memento]]
 
<br/>[[How:Write scripts in JavaScript for Memento]]
 
<br/>[[Tips:Using JavaScript in Memento]]
 
<br/>[[Tips:Using JavaScript in Memento]]
 +
| style="width:25%;" |
 +
|}
 +
 +
=== Installation & settings ===
 +
{| class="wikitable"
 +
! Topics !! Overviews !! Specs !! Guidance
 
|-
 
|-
| <big>'''Installation<br/> & settings'''</big>
+
| style="width:25%;" |
|  
+
| style="width:25%;" | [[Memento Settings]]
| [[Memento Settings]]
+
| style="width:25%;" |
 +
| style="width:25%;" |
 +
|}
 +
 
 +
=== Import, export, synchronization, backup, & restore ===
 +
{| class="wikitable"
 +
! Topics !! Overviews !! Specs !! Guidance
 
|-
 
|-
| <big>'''Import, export,<br/>synchronization,<br/> backup, restore'''</big>
+
| style="width:25%;" | [[Backup & Restore]]
 +
| style="width:25%;" | [[Importing and exporting data]]
 +
[[Formatting Templates screen]]
 +
| style="width:25%;" | [[Tips:File Attachments]]
 +
| style="width:25%;" |
 +
|}
  
| [[Backup & Restore]]
+
=== Cloud, platforms, & collaboration ===
| [[Importing and exporting data]]
+
{| class="wikitable"
[[Formatting Templates screen]]
+
! Topics !! Overviews !! Specs !! Guidance
| [[Tips:File Attachments]]
 
 
|-
 
|-
| <big>'''Cloud, platforms,<br/> & collaboration'''</big>
+
| style="width:25%;" | [[Platforms]]
 +
[[Cloud storage and Teamwork]]
 +
| style="width:25%;" | [[Cloud Library Status card]]
 +
| style="width:25%;" |
 +
| style="width:25%;" |
 +
|}
  
| [[Platforms]]
+
=== Security ===
[[Cloud storage and Teamwork]]
+
{| class="wikitable"
| [[Cloud Library Status card]]
+
! Topics !! Overviews !! Specs !! Guidance
 
|-
 
|-
| <big>'''Security'''</big>
+
| style="width:25%;" | [[Privacy Policy]]
 +
[[Library Protection]]
 +
| style="width:25%;" |
 +
| style="width:25%;" |
 +
| style="width:25%;" |
 +
|}
  
| [[Privacy Policy]]
+
=== Products ===
[[Library Protection]]
+
{| class="wikitable"
 +
! Topics !! Overviews !! Specs !! Guidance
 
|-
 
|-
| <big>'''Products'''</big>
+
| style="width:25%;" | [[Memento Clients]]
 
 
| [[Memento Clients]]
 
 
[[Private Server]]
 
[[Private Server]]
 
<br/>[[Team for Business]]
 
<br/>[[Team for Business]]
| || [[Tips:Team for Business]]
+
| style="width:25%;" | || [[Tips:Team for Business]]
 +
| style="width:25%;" |
 
|}
 
|}
  
Line 163: Line 146:
  
 
<small>[[#The Memento Wiki|Jump to the top]]</small>
 
<small>[[#The Memento Wiki|Jump to the top]]</small>
 +
  
 
[[Category:en]] [[Category:Using]]
 
[[Category:en]] [[Category:Using]]

Latest revision as of 01:39, 5 November 2021

« Page as of 2021-11-04, editions Mobile 4.10.2, Desktop 1.10.2 »

Template:Banner-menu

Preamble on database terminology

This is to get us on the same page regarding terms Memento users have used previously versus the terms chosen by Memento for its products. Jump to the database index

Memento terms and database industry terms

Sometimes some of us tend to use one set of terms for things, and some might use another set of terms for the same things, like "record" or (less often) "row" for a Memento entry and ... Yada

The Memento Database application comprises libraries (often known outside Memento as tables), entries (often known outside Memento as rows), and fields (often known outside Memento as columns). A common generic term, recognized everwhere for either entries or rows is records.

In the Memento forum, "field" and "record" are often used and "column" and "row" is seldom used. So, it's best to stick with either Memento's "entry" (since it's their forum, after all), but when others use or seem to prefer the database industry's "record", we'll all know what is meant by that, and we can accommodate them when interacting with them, message by message in the forum.

Databases and Libraries

Likewise, within the database industry overall, "database" is used to mean the entire set of data used by a hopefully identified user or group of users to accomplish the users' personal or professional objectives, comprising libraries, entries, and fields. So, a person might use one database at home and another at work, and though many libraries will be different between libraries (like Customers at work and Groceries at home), some libraries might be used both at home and at work, often the most common and generic libraries, like People or Organizations.

When a user's objectives are so small that a single library is enough, then in that case the database is the library. However, when a user's objectives require that libraries be linked together to accomplish the objectives, now the entire set of linked libraries constitute the database. That's why, whenever we go into Edit Library > Export to create a .template file, there's an option to include linked libraries. This makes the template a database export rather than merely a library export. For more on database exports, see Export a database.

Libraries can be linked so they can work together as a database. So, each library has a structure of fields & other things (see below for what things make up its structure), and each database has a structure of libraries & links between them (see About:Database structure#Examples for an example).

The Database index, allowing quick access to Memento Database information

Yada

Introduction

Topics Overviews About
Memento Database Memento Database

Memento Wiki
Glossary
Useful links
Releases

How:Getting Started


About:Bill's mementos
About:Bill's tutorials
About:Bill's examples
Tutorial:Simple To Do List
Tutorial:Simple To Do List Enhancements
About:Color codes
CaseStudy:Designing Memento databases:Photographic equipment

Displays in the Memento mobile edition

Topics Overviews Specs Guidance
Screens & cards Libraries List screen

Library Edit screen
Entries List screen
Entry Edit card
Entry View card
File Manager card
Attached Files card
Charting data

Displays in the Memento desktop edition

Topics Overviews Specs Guidance
Windows & panes


Scripting, Calculation, & App Integration

Topics Overviews Specs Guidance
Scripting Calculation field

JavaScript field
Memento JavaScript Library
Actions
Data Sources
Triggers

Tasker Integration

Trigger Examples
How:Write scripts in JavaScript for Memento
Tips:Using JavaScript in Memento

Installation & settings

Topics Overviews Specs Guidance
Memento Settings

Import, export, synchronization, backup, & restore

Topics Overviews Specs Guidance
Backup & Restore Importing and exporting data

Formatting Templates screen

Tips:File Attachments

Cloud, platforms, & collaboration

Topics Overviews Specs Guidance
Platforms

Cloud storage and Teamwork

Cloud Library Status card

Security

Topics Overviews Specs Guidance
Privacy Policy

Library Protection

Products

Topics Overviews Specs Guidance
Memento Clients

Private Server
Team for Business

Tips:Team for Business

Jump to the index

Jump to the top