[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Epnadmin-fr] Calendar // Planning
From: |
Marc C |
Subject: |
[Epnadmin-fr] Calendar // Planning |
Date: |
Mon, 18 Oct 2004 14:53:57 +0100 |
User-agent: |
KMail/1.7 |
Bonjour
après avoir regardé webCalendar de plus près et le module calendar
d'eGroupware (issu de webCalendar) voila,ci-joint, le schéma de données pour
gérer les événements planifiable (sessions, salles, animateurs).
Qu'en pensez vous ?
Définition SQL
------------------
CREATE TABLE calendar (
cal_id int(11) NOT NULL,
cal_start datetime,
cal_stop datetime,
cal_event_id int(11),
cal_event_type char(1),
/* Type d'evenement S=Session,R=Room,F=Facilitator Activity */
cal_event_comment varchar(250),
cal_mod_id int(11),
cal_mod_type char(1),
PRIMARY KEY(cal_id)
);
CREATE TABLE calendar_repeat (
cal_id int(11) NOT NULL,
cal_type varchar(20),
cal_stop date,
cal_frequency tinyint(4),
cal_days char(7),
PRIMARY KEY(cal_id)
);
CREATE TABLE calendar_repeat_not (
cal_id int(11) NOT NULL,
cal_date date,
PRIMARY KEY(cal_id)
);
CREATE TABLE calendar_template (
cal_template_name varchar(50) NOT NULL,
cal_start datetime NOT NULL,
cal_stop datetime,
PRIMARY KEY(cal_template_name,cal_start)
);
CREATE TABLE facilitator_activity (
id_facilitator int(11) NOT NULL,
id_calendar int(11) NOT NULL,
id_activity_type char(2),
/* Type d'activite ON=At Work, OF=Holiday, OU=Sick,
FO=Learning,RE=Reception,CO=Conception,SU=Support,ME=Meeting */
id_related int(11),
id_related_type char(1),
/* R=Room,I=Initiation */
PRIMARY KEY(id_facilitator,id_calendar)
);
CREATE TABLE session (
se_id int(11) NOT NULL,
se_id_room int(11),
se_id_calendar int(11),
se_id_initiation int(11),
se_name varchar(255),
se_is_autoinscription char(1),
se_nbparticipants int(11),
se_status varchar(255),
se_id_facilitator_1 int(11),
se_id_facilitator_2 int(11),
se_id_facilitator_3 int(11),
se_id_site int(11),
se_comment text,
PRIMARY KEY(se_id)
);
epnadmin-calendar.png
Description: PNG image
pgpCwhjRcBPgX.pgp
Description: PGP signature
- [Epnadmin-fr] Calendar // Planning,
Marc C <=