Database table for calendar

Support
1

Which database table contains entries for the calendar? Additionally, is there a documentation of what’s the purpose of each table?

Situation
Clinical log rules got corrupt and this lead to a couplelof issues with the db

OpenEMR Version
I’m using OpenEMR version 5.0.1

Browser:
I’m using: Firefox

Operating System
I’m using: Ubuntu 16

Search
Did you search the forum for similar questions? Yes

Logs
Did you check the logs?
Was there anything pertinent in them?
Please paste them here (surround with three backticks (```) for readability.
You can also turn on User Debugging under Administration->Globals->Logging User Debugging Options=>All

What I am trying to do:
For now, what matters most to me is that I get the appointments in the calendar. Can someone point me to the correct table to restore? Alternatively, is there a documentation of what’s the purpose of each table?

2

Unless you post the specific error(s) community cannot help.

3

I put the question on the top now

4

New tables may be missing but here is the list.

1 Like
5

A few things: I noticed that you are using Ubuntu 16. You definitely want to upgrade to Ubuntu 18, but not 20. 501 has trouble working with Ubuntu 20.04 because of the MySQL version.

The tables that handle the calendar and appointments are listed here:

image

The events table lists the appointments and it references the categories table. Many of the columns in the postcalandar table use a “pc_” in the column title.

I hope this helps.

1 Like
6

openemr_postcalendar_events is the one I was looking for. Thanks