clipping/doc/plan.html

<H1>Software Plan</H1>


<H2>1. Database</H2>

<H3>1.1. Tables</H3>

<UL>

   <LI> <B>customer</B>

   <UL>

     <LI> name (varchar)

     <LI> phone (varchar)

     <LI> email (varchar)

     <LI> notes (text)

   </UL>

   <LI> <B>source</B>

   <UL>

     <LI> description (varchar)

     <LI> notes (text)

   </UL>

   <LI> <B>type</B>

   <UL>

     <LI> description (varchar)

     <LI> notes (text)

   </UL>

   <LI> <B>news</B>

   <UL>

     <LI> section (varchar)

     <LI> page/url (varchar)

     <LI> title (varchar)

     <LI> abstract (text)

     <LI> full text (if available) (text)

     <LI> c_source (FK)

     <LI> c_customer (FK)

     <LI> c_type (FK)

   </UL>

</UL>

<H3>1.2. Views</H3>

<UL>

   <LI> View customer

   <LI> View source

   <LI> View type

   <LI> View news

</UL>

<H3>1.3. Functions</H3>

<UL>

   <LI> <B>customer</B>

   <UL>

     <LI> select (sp_sel_c_customer)
     <LI> insert (sp_ins_c_customer)
     <LI> delete (sp_del_c_customer)
     <LI> update (sp_upd_c_customer)

   </UL>


   <LI> <B>source</B>

   <UL>

     <LI> select (sp_sel_c_source)
     <LI> insert (sp_ins_c_source)
     <LI> delete (sp_del_c_source)
     <LI> update (sp_upd_c_source)

   </UL>


   <LI> <B>type</B>

   <UL>

     <LI> select (sp_sel_c_type)
     <LI> insert (sp_ins_c_type)
     <LI> delete (sp_del_c_type)
     <LI> update (sp_upd_c_type)

   </UL>


   <LI> <B>news</B>

   <UL>

     <LI> select (sp_sel_c_news)
     <LI> insert (sp_ins_c_news)
     <LI> delete (sp_del_c_news)
     <LI> update (sp_upd_c_news)

   </UL>


</UL>

<H2>2. Modules</H2>

<UL>

   <LI> customer (c_customer.pm)

   <LI> source (c_source.pm)

   <LI> type (c_type.pm)

   <LI> news (c_news.pm)

</UL>
1	dpavlin	1.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>