OpenACS Calendar Tables

Please see the OpenACS documentation on the calendar package for more information.

 

 

Table

Cols

Rows

Description

[acs_activities]

5

3561

Represents what happens during an event

[acs_activity_object_map]

2

0

Maps between an activity and multiple ACS objects.

[acs_event_party_map]

2

0

Maps a many-to-many relationship between events and parties.

[acs_events]

13

1551

A relationship between a time span and an activity.

[cal_item_types]

3

0

Not used anymore

[cal_items]

3

1551

Table cal_items maps the ownership relation between an cal_item_id to calendars. Each cal_item is owned by a calendar

[calendars]

5

17


Table calendars maps the many to many relationship betweens calendar and its owners.

[cal_party_prefs]

8

0

Table cal_user_prefs would stores custom information about each indivdual user. This would include time zone which is the first day of the week, monday or sunday, and the likes.

[recurrence_interval_types]

2

7

Day, Week, Month, etc. recurrence intervals

[recurrences]

7

4

Desribes how an event recurs (interval type, number of intervals, end of recurrence, ...)

[timespans]

2

3015

Establishes a relationship between timespan_id and multiple time intervals. Represents a range of moments at which an event can occur.

[time_intervals]

3

3016

A time interval is represented by two points in time.

  Contact Us
  Project Open Business Solutions S.L.

Calle Aprestadora 19, 12o-2a

08902 Hospitalet de Llobregat (Barcelona)

Spain

 Tel Europe: +34 609 953 751
 Tel US: +1 415 200 2465
 Mail: info@project-open.com