ICalendar Database Schema

Question

Where can I find the iCalendar database schema? The best I can find is an XML schema .

I could use this, I suppose, but this is a lot of work, and I hope someone has already done this.

Answer 1

Summing up the comments and adding my two cents:

• There is no such scheme as the iCalendar database schema.
• Since iCalendar is just a BLOB, in the simplest case, you can just save it as a single string field.
• Since you want to receive a query over a time range, you will probably need at least separate fields for this.
• , iCalendar RRULEs
  • / -
  • khal . , -, RRULES.

Answer 2

JSON-LD, ? , "":

{
  "@context": {
    "ical": "http://www.w3.org/2002/12/cal/ical#",
    "xsd": "http://www.w3.org/2001/XMLSchema#",
    "ical:dtstart": {
      "@type": "xsd:dateTime"
    }
  },
  "ical:summary": "Lady Gaga Concert",
  "ical:location": "New Orleans Arena, New Orleans, Louisiana, USA",
  "ical:dtstart": "2011-04-09T20:00:00Z"
}