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