/[clipping]/doc/plan.html
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /doc/plan.html

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1.1.1 - (show annotations) (vendor branch)
Fri Jan 16 22:46:52 2004 UTC (20 years, 2 months ago) by dpavlin
Branch: MAIN, phperl
CVS Tags: r20040116, HEAD
Changes since 1.1: +0 -0 lines
File MIME type: text/html
initial import of downloaded version

1 <H1>Software Plan</H1>
2
3
4 <H2>1. Database</H2>
5
6 <H3>1.1. Tables</H3>
7
8 <UL>
9
10 <LI> <B>customer</B>
11
12 <UL>
13
14 <LI> name (varchar)
15
16 <LI> phone (varchar)
17
18 <LI> email (varchar)
19
20 <LI> notes (text)
21
22 </UL>
23
24 <LI> <B>source</B>
25
26 <UL>
27
28 <LI> description (varchar)
29
30 <LI> notes (text)
31
32 </UL>
33
34 <LI> <B>type</B>
35
36 <UL>
37
38 <LI> description (varchar)
39
40 <LI> notes (text)
41
42 </UL>
43
44 <LI> <B>news</B>
45
46 <UL>
47
48 <LI> section (varchar)
49
50 <LI> page/url (varchar)
51
52 <LI> title (varchar)
53
54 <LI> abstract (text)
55
56 <LI> full text (if available) (text)
57
58 <LI> c_source (FK)
59
60 <LI> c_customer (FK)
61
62 <LI> c_type (FK)
63
64 </UL>
65
66 </UL>
67
68 <H3>1.2. Views</H3>
69
70 <UL>
71
72 <LI> View customer
73
74 <LI> View source
75
76 <LI> View type
77
78 <LI> View news
79
80 </UL>
81
82 <H3>1.3. Functions</H3>
83
84 <UL>
85
86 <LI> <B>customer</B>
87
88 <UL>
89
90 <LI> select (sp_sel_c_customer)
91 <LI> insert (sp_ins_c_customer)
92 <LI> delete (sp_del_c_customer)
93 <LI> update (sp_upd_c_customer)
94
95 </UL>
96
97
98 <LI> <B>source</B>
99
100 <UL>
101
102 <LI> select (sp_sel_c_source)
103 <LI> insert (sp_ins_c_source)
104 <LI> delete (sp_del_c_source)
105 <LI> update (sp_upd_c_source)
106
107 </UL>
108
109
110 <LI> <B>type</B>
111
112 <UL>
113
114 <LI> select (sp_sel_c_type)
115 <LI> insert (sp_ins_c_type)
116 <LI> delete (sp_del_c_type)
117 <LI> update (sp_upd_c_type)
118
119 </UL>
120
121
122 <LI> <B>news</B>
123
124 <UL>
125
126 <LI> select (sp_sel_c_news)
127 <LI> insert (sp_ins_c_news)
128 <LI> delete (sp_del_c_news)
129 <LI> update (sp_upd_c_news)
130
131 </UL>
132
133
134 </UL>
135
136 <H2>2. Modules</H2>
137
138 <UL>
139
140 <LI> customer (c_customer.pm)
141
142 <LI> source (c_source.pm)
143
144 <LI> type (c_type.pm)
145
146 <LI> news (c_news.pm)
147
148 </UL>

  ViewVC Help
Powered by ViewVC 1.1.26