.


:




:

































 

 

 

 





, 2 3.

RL, RT, RR, RO , 2.

RL_RS , , , 3.

RA RA03, RA04, , RA19 RA02, , , 2. 2 RA_RA02 RA02, RA03, RA04, , RA19. RA_RA02 RA , . .

 

 

3.15

3.7 RA_RA02

.
RA02 VARCHAR(255) PK
RA03 VARCHAR(255)   ( , . .)
RA04 DECIMAL(12,6)  
RA05 DECIMAL(12,6)  
RA06 DECIMAL(5,1)  
RA07 DECIMAL(5,1)  
RA08 DECIMAL(4,1)  
RA09 CHAR(14)   (, , )
RA10 DECIMAL(3,1)    
RA11 DECIMAL(3,1)  
RA12 DECIMAL(3,1)  
RA13 DECIMAL(3,1)  
RA14 CHAR(13)   (, )
RA15 DECIMAL(3,1)    
RA16 INTEGER      
RA17 CHAR(13)   (, )
RA18 DECIMAL(3,1)    
RA19 INTEGER    

RS RS03, RS04, RS05 RS02, , , 2. 2 RS_RS02 RS02, RS03, RS04, RS05. RS_RS02 RS , . .

3.8 RS_RS02

.
RS02 VARCHAR(255) PK
RS03 VARCHAR(32)   (, , )
RS04 CHAR(8)   ( )
RS05 VARCHAR(255)   . : (RS0501), (RS0502), (RS0503)

 

RL, RT, RR, RO, RL_RS, RA_RA02, RS_RS02 , 3.

RS_RS02, RT RR , , , RS_RS02. RS02, RS03, RS04, RS05 . RT , . RR , . RT RR RS_RS02 .

, 3.16. 3 ( , ).

1 , .

RL RL08 RL_RL08. RL09 RL_RL09, RL_RL08. RL10 RL_RL10, RL_RL08.

3.9 RL_RL08

.
RL01 VARCHAR(255) PK
RL0801 VARCHAR(255) PK
RL0802 DATETIME  
RL0803 DATETIME  

 

RL_RL08 , RL01 RL0801. .

3.10 RL_RL09

.
RL01 VARCHAR(255) PK
RL0801 VARCHAR(255) PK
RL0902 INTEGER PK ,
RL0903 DECIMAL(12,6)   ,

 

3.16

RL_RL09 , RL01, RL0801 RL0902. .

3.11 RL_RL10

.
RL01 VARCHAR(255) PK
RL0801 VARCHAR(255) PK
RL1002 INTEGER PK ,
RL1003 DECIMAL(12,6)   ,

RL_RL10 , RL01, RL0801 RL1002. .

RS_RT_RR RS05 RS_RS05.

 

3.12 RS_RS05

.
RS02 VARCHAR(255) PK
RS0501 VARCHAR(255) PK
RS0502 DECIMAL(10,3)  
RS0503 DECIMAL(10,3)  

 

RS_RS05 , RS02, RS0501. .

RS_RT_RR RT07, RT09 RT_RT07, RT_RT09. RT08 RT_RT08, RT_RT07.

3.13 RT_RT07

.
RS02 VARCHAR(255) PK
RT0701 VARCHAR(255) PK
RT0702 DECIMAL(4,1)  
RT0703 DECIMAL(10,3)  

RT_RT07 , RS02, RT0701. .

3.14 RT_RT08

.
RS02 VARCHAR(255) PK
RT0701 VARCHAR(255) PK
RT0802 DECIMAL(10,3) PK
RT0803 DECIMAL(4,1)  

RT_RT08 , RS02, RT0701, RT0802. .

3.15 RT_RT09

.
RS02 VARCHAR(255) PK
RT0901 INTEGER PK
RT0902 DECIMAL(4,1)  

RT_RT09 , RS02, RT0901. .

RS_RT_RR RR08 RR_RR08. RR09 RR_RR09, RR_RR08.

3.16 RR_RR08

.
RS02 VARCHAR(255) PK
RR0801 VARCHAR(255) PK
RR0802 DECIMAL(4,1)  
RR0803 DECIMAL(10,3)  
RR0804 DECIMAL(4,1)  
RR0805 DECIMAL(4,1)   /
RR0806 DECIMAL(4,1)  

RR_RR08 , RS02, RR0801. .

 

3.17 RR_RR09

.
RS02 VARCHAR(255) PK
RR0801 VARCHAR(255) PK
RR0902 DECIMAL(10,3) PK
RR0903 DECIMAL(4,1)  

 

RR_RR09 , RS02, RR0801, RR0902. .

, 3.17. 3.

 

 

3.17 3





:


: 2018-10-18; !; : 460 |


:

:

,
==> ...

1880 - | 1653 -


© 2015-2024 lektsii.org - -

: 0.024 .