[EN] Internal structure of FM Calendar 1.5.x

Cette note est disponible en Français ici.


The internal structure of FM Calendar consists of four tables:

tables description
event 1 record per event
calendar 1 record per calendar
userPrefs 1 record per user and per computer
config only one record for javascript, html and css

You can use your event table instead of the one proposed by FM Calendar, like for calendar table.

EVENT table

Extract of the table structure "event":

fields type description
id text primary key (uuid)
idCal text foreign key (uuid), an event is attached to a calendar
title text title of event
startDate date start date of event
startTime time start time of event
endDate date end date of event
endTime time end time of event
allDay text flag for "all day" event
url text optional, url of event
note text description of event
location text location of event

CALENDAR table

Extract of the table structure "calendar":

fields type description
id text primary key (uuid)
name text name of calendar
color text color name of calendar ( Red, Orange, Yellow, Green, Blue, Purple, Brown, Other ) [*]
colorRGB text RGB color of calendar, in hex syntax
cColorRGB calculation translated the field "color", if it contains "Other" then it uses the RGB color of the field "colorRGB".
colorDot calculation  show a dot in color

[*] In English in file "FMCalendar_en" and in French in file "FMCalendar_fr".

USERPREFS table

Extract of the table structure "userPrefs":

fields type description
id text key primary (uuid)
timeStart text user preference for calendar's time start
timeEnd text user preference for calendar's time end
showCalPicker number user preference whether to show the mini-calendar
showWeekends number user preference whether to show week-end
defaultCalendar text contains the default calendar id
calendarList text contains the list of id's calendar to display

CONFIG table

Extract of the table structure "config":

fields type description
config.js text contains the javascript code configuration
cDisplayHtml calculation  contains the HTML code to display the calendar
gUser global text id of user
glk_event global text id of event to edit
glk_calendar global text id of calendar to edit