N o te :  T h e   S tr e e t  P r e m is e s   T a b le   a n d   th e   L o g in   T a b le s   a r e   n o t  s h o w n .
P e r m it
    P e r ID : 
in t
C o m p a n y
   
P e r Is s u e :  D a te
   
C o m ID :    in t
   
P e r C o m ID :    in t
C o m p a n yT yp e
1
1
1
   
C o m N a m e :    S tr in g
0 ..n
   
P e r W o r k T y p e :    E n u m
   
C o T T y p e :    E n u m
   
C o m T y p e :    E n u m
0 ..n
   
P e r D ig S a fe :    S tr in g
1
0 ..n
   
C o m L ic e n s e :    S tr in g
   
P e r A p p r o v e d :    E n u m
   C o m S tr e e t: 
S tr in g
   
P e r V a lid F r o m :  D a te
   
C o m C ity :    S tr in g
   
P e r V a lid U n til:  D a te
C o n t a c t
   
C o m S ta te :  S tr in g
   
P e r S tr e e tW o r k T y p e :    E n u m
    C o n C o m p a n y ID : 
in t
   
C o m Z ip :  S tr in g
0 ..n
   P e r S tr e e tID : 
in t
0 ..n
   
C o n N a m e :    S tr in g
   
C o m P h o n e :    S tr in g
0 ..n
   
P e r S ta r tP r e m is e s :  in t
   
C o n E m a il:    S tr in g
   
C o m F a x:    S tr in g
   
P e r E n d P r e m is e s :    in t
   
C o n P h o n e :    S tr in g
   
C o m E m a il:  S tr in g
   
P e r W o r k A r e a L e n g th :    in t
   
C o n P a g e r :    S tr in g
    C o m A c tiv e : 
E n u m
   
P e r W o r k A r e a W id th :  in t
   
P e r P u r p o s e :    S tr in g
   
P e r A p p lic a tio n F e e :    in t
   
P e r T e le p h o n e M a n h o le s :    in t
C o m p a n yW o r k T yp e
   
P e r W a te r M a n h o le s :    in t
W o r k T yp e
   
P e r S e w e r M a n h o le s :    in t
   
C W T C o m p a n y ID :    in t
1 ..n
   
W o T T y p e :    E n u m
   
P e r E le c tr ic M a n h o le s :    in t
   
C W T T y p e :    E n u m
1 ..n
1
1
   
P e r C a tc h B a s in s :    in t
    P e r W a te r G a te s : 
in t
C o m p a n yS t r e e t W o r k T yp e
   
P e r G a s G a te s :  in t
S t r e e t W o r k T yp e
   
P e r O th e r O p e n in g s :    in t
   
C S T C o m p a n y ID :    in t
1 ..n
   
C S T T y p e :    E n u m
   
S W T T y p e :    E n u m
   
P e r T im e S ta m p :  D a te
1 ..n
1
1
    P e r A c tiv e : 
E n u m
   
P e r L a s tE d itD a te :    D a te
A d m in
   
P e r L a s tE d itU s e r :  S tr in g
   
P e r D r a w in g F ile :    S tr in g
   
A d m B a s ic F e e :    in t
   
P e r F ile C o n te n tT y p e :    S tr in g
   
A d m F r o m 1 :    in t
   
P e r F ile L e n g th :    in t
   
A d m T o 1 :    in t
   
A d m A d d F e e 1 :    in t
   
A d m F r o m 2 :    in t
   
A d m T o 2 :    in t
   
A d m A d d F e e 2 :    in t
   
A d m F r o m 3 :    in t
R e s t r ic t io n
   
A d m T o 3 :    in t
S t r e e t
   
R e s ID :    in t
   
A d m A d d F e e 3 :    in t
   
S tr ID :    in t
   
R e s S tr e e tID :  in t
   
A d m M in N o tify :  in t
   
S tr N a m e :    S tr in g
1
0 ..n
   
R e s W h o le S tr e e t:    E n u m
   
A d m Is s u e W e e k e n d :    E n u m
   
R e s S ta r tP r e m is e s :  in t
   
A d m W e e k e n d F r o m 1 :    S tr in g
   
R e s E n d P r e m is e s :    in t
   
A d m W e e k e n d F r o m 2 :    S tr in g
   
R e s S ta r tD a te :  D a te
   
A d m W e e k e n d F r o m 3 :    S tr in g
   
R e s E n d D a te :    D a te
   
A d m W e e k e n d T o 1 :    S tr in g
   
R e s C o m m e n t:    S tr in g
   
A d m W e e k e n d T o 2 :    S tr in g
    R e s A c tiv e : 
E n u m
   
A d m W e e k e n d T o 3 :    S tr in g
   
A d m Is s u e H o lid a y s :    E n u m
   
A d m W o r k T y p e C h e c k in g :    E n u m
   
A d m S tr e e tW o r k T y p e C h e c k in g :    E n u m
   
A d m P r e m is e s C h e c k in g :    E n u m
F A Q
   
A d m D r a w in g F ile R e q u ir e d :    E n u m
   
A d m M a xim u m V a lid D a y s :    in t
   
F a q Q u e s tio n :    S tr in g
H o lid a y
   
A d m E m a ilN o tific a tio n :    E n u m
   
F a q A n s w e r :    S tr in g
   
A d m M a ilS e r v e r :    S tr in g
   
H o lN a m e :    S tr in g
   
F a q ID :    in t
   
A d m E m a ilA d d r e s s :    S tr in g
   
H o lD a te :    D a te
   
F a q P o s itio n :    in t
Figure 14: Main Database Tables and Relationships 
59 




Java Web Hosting Application Development Using Java Technologies Hosting




 
TotalRoute.net Business web hosting division of Vision Web Hosting Inc. All rights reserved.