, 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