i f   n o t   E x i s t s ( S E L E C T   *   F R O M   i n f o r m a t i o n _ s c h e m a . t a b l e s   w h e r e   T a b l e _ n a m e   =   ' P l a n n i n g P r o g r a m D e t a i l ' ) 
 
 b e g i n 
 
 	 c r e a t e   t a b l e   d b o . P l a n n i n g P r o g r a m D e t a i l 
 
 	 ( 
 
 	 	 I D   i n t   P r i m a r y   k e y , 
 
 	 	 M a t _ I D 	 b i g i n t   r e f e r e n c e s   d b o . M a t t e r ( I D )   n o t   n u l l , 
 
 	 	 P P _ I D 	 i n t   r e f e r e n c e s   d b o . P l a n n i n g P r o g r a m ( I D )   n o t   n u l l , 
 
 	 	 P P I _ I D 	 i n t   r e f e r e n c e s   d b o . P l a n n i n g P r o g r a m D e t a i l ( I D )   n u l l , 
 
 	 	 D o m _ I D _ R o w T y p e 	 i n t   r e f e r e n c e s   d b o . d o m a i n ( I D )   n o t   n u l l ,   - -   A9'D*  1/JA  (1F'EG  71-  E*EE  ~1HG  A9'DJ*  E*EE  ~1HG
 
 	 	 T i t l e 	 n v a r c h a r ( 1 0 0 0 ) , 
 
 	 	 P r o _ I D _ P h a s e 	 i n t   r e f e r e n c e s   d b o . o t h e r P r o p e r t i e s ( I D )   n o t   n u l l ,   - -   (1F'EG  12  ,E9  1/F  EF'(9  ~'/G  3'2  ,E9  "H1( (G1G  (1/'1) 
 
 	 	 S t a r t D a y 	 i n t , 
 
 	 	 E n d D a y 	 i n t , 
 
 	 	 [ O r d e r ] 	 i n t   n o t   n u l l , 
 
 	 	 D e s c r i p t i o n 	 n v a r c h a r ( 1 0 0 0 ) 
 
 	 ) 
 
 e n d 