/[debian]/quickappoint/branches/upstream/current/doc/quickappoint.txt
ViewVC logotype

Contents of /quickappoint/branches/upstream/current/doc/quickappoint.txt

Parent Directory Parent Directory | Revision Log Revision Log


Revision 140 - (show annotations)
Sat Feb 25 17:48:32 2006 UTC (15 years, 5 months ago) by gregoa
File MIME type: text/plain
File size: 5720 byte(s)
[svn-inject] Installing original source of quickappoint
1 quickappoint=# \d appointment
2 Table "public.appointment"
3 Column | Type | Modifiers
4 ------------------+------------------------+-------------------------------------------------------------
5 id | integer | not null default nextval('public.appointment_id_seq'::text)
6 title | character varying(32) | not null
7 description | text |
8 location | character varying(128) |
9 minvalue | smallint | not null default 0
10 maxvalue | smallint | not null default 10
11 approvaldesc | boolean | not null default false
12 cssname | character varying(256) |
13 creator_personid | integer |
14 creation_date | date | default now()
15 expire_date | date |
16 Indexes:
17 "appointment_pkey" primary key, btree (id)
18 Check constraints:
19 "min_max_check" CHECK ("minvalue" < "maxvalue")
20 Foreign-key constraints:
21 "appointment_creator_personid_fkey" FOREIGN KEY (creator_personid) REFERENCES person(id) ON UPDATE CASCADE ON DELETE SET NULL
22
23 quickappoint=# \d permission
24 Table "public.permission"
25 Column | Type | Modifiers
26 -------------------+---------+------------------------
27 personid | bigint | not null
28 appointmentid | bigint | not null
29 manageproposal | boolean | not null default false --------------- < delete!!!
30 manageappointment | boolean | not null default false
31 manageperson | boolean | not null default false
32 insertproposal | boolean | not null default false
33 updateproposal | boolean | not null default false
34 deleteproposal | boolean | not null default false
35 Indexes:
36 "permission_pkey" primary key, btree (personid, appointmentid)
37 Foreign-key constraints:
38 "permission_personid_fkey" FOREIGN KEY (personid) REFERENCES person(id) ON UPDATE CASCADE ON DELETE CASCADE
39 "permission_appointmentid_fkey" FOREIGN KEY (appointmentid) REFERENCES appointment(id) ON UPDATE CASCADE ON DELETE CASCADE
40
41 quickappoint=# \d person
42 Table "public.person"
43 Column | Type | Modifiers
44 ----------------+-----------------------+--------------------------------------------------------
45 id | integer | not null default nextval('public.person_id_seq'::text)
46 username | character varying(16) | not null
47 password | character varying(32) | not null default ''::character varying
48 fullname | character varying(64) |
49 email | character varying(64) |
50 manageperson | boolean | not null default false
51 addappointment | boolean | not null default false
52 Indexes:
53 "person_pkey" primary key, btree (id)
54 "person_username_key" unique, btree (username)
55
56 quickappoint=# \d proposal
57 Table "public.proposal"
58 Column | Type | Modifiers
59 ---------------+------------------------+----------------------------------------------------------
60 id | integer | not null default nextval('public.proposal_id_seq'::text)
61 appointmentid | bigint | not null
62 date | date | not null
63 time | time without time zone |
64 status | smallint | not null default 0 ------------------ << delete !!
65 accepted | boolean |
66 Indexes:
67 "proposal_pkey" primary key, btree (id)
68 "proposal_appointmentid_key" unique, btree (appointmentid, date, "time")
69 Foreign-key constraints:
70 "proposal_appointmentid_fkey" FOREIGN KEY (appointmentid) REFERENCES appointment(id) ON UPDATE CASCADE ON DELETE CASCADE
71
72 quickappoint=# \d response
73 Table "public.response"
74 Column | Type | Modifiers
75 ------------+----------+-----------
76 personid | bigint | not null
77 proposalid | bigint | not null
78 value | smallint | not null
79 comment | text |
80 Indexes:
81 "response_proposalid_key" unique, btree (proposalid, personid)
82 Foreign-key constraints:
83 "response_personid_fkey" FOREIGN KEY (personid) REFERENCES person(id) ON UPDATE CASCADE ON DELETE CASCADE
84 "response_proposalid_fkey" FOREIGN KEY (proposalid) REFERENCES proposal(id) ON UPDATE CASCADE ON DELETE CASCADE
85
86 quickappoint=#
87
88
89 todo:
90 * email-benachrichtigungen
91 * erklaerung zu approvaldesc beim anlegen
92 * drop down liste für locales.
93 * Nach Änderungen der locale-Einstellungen werden diese derzeit erst nach einer Neuanmeldung aktiv.
94 * Auswertung (siehe unten)
95 * Lange Personenliste...
96 * Garbage Collection...
97 * delete column proposal.status and permission.manageproposal
98 * document the database changes in this file...
99 * Wochentage sind derzeit nur englisch
100 * Weitere Übersetzung.
101 * vorschlag nach expire date:
102 - wenn es akzeptierte termine gibt -> übersichtliche anzeige derselben
103 - wenn nicht: defaultmäßig anzeige einer Auswertung und trotzdem noch möglichkeit, auf die appointment.php seite zu kommen und dort zu werkeln (vielleicht aber auch nür für den manager)
104
105 =======
106
107 kann quickapoint auch rechnen- man gibt deadline fur die
108 terminprafernezen ein und dann mittelts und schickt den termin
109 automatisch an die runde ? ware doch suss.
110
111 =======
112
113 debianpaket: wwwconfig-common anschauen --> deprecated ==>
114
115 dbconfig-common
116 http://people.debian.org/%7Eseanius/policy/dbconfig-common.html
117
118 Web Application Policy
119 http://people.debian.org/%7Eseanius/policy/webapp-policy.html
120
121 Database Application Policy
122 http://people.debian.org/%7Eseanius/policy/dbapp-policy.html

  ViewVC Help
Powered by ViewVC 1.1.26