:

:

 

 

 

28 2006 .

 

N 65

 

 

, 29.01.2004 N 40/2 " " :

1. :

1.1. ( N 1).

1.2. ( N 2).

1.3. , ( N 3).

2. "" ( ..) " ", ( 462863302 N 399 31 2006 ) ( ).

3. - ...

 

 

..

 

 

 

 

 

N 1

28.02.2006 . N 65

 

 

- TradeName



Nu

ID

int

4

 

 

NAME

nvarchar

200

V

Latin

nvarchar

200

V

-

ToTradeNameShort

int

4

V

ToInternationalName

int

4

V

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- TradeName_Short



Nu

ID

int

4

 

 

NAME

nvarchar

200

V

 

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- InternationalName



Nu

ID

int

4

 

NAME

nvarchar

50

 

-

Latin

nvarchar

50

V

 

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- DrugForm



Nu

ID

int

4

 

 

NAME

nvarchar

50

 

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- Dose



Nu

ID

int

4

 

 

NAME

nvarchar

60

 

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- Quantity



Nu

ID

int

4

 

 

NAME

nvarchar

50

V

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- Wrapping



Nu

ID

int

4

 

 

NAME

char

50

 

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- Packing



Nu

ID

int

4

 

NAME

nvarchar

60

 

 

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- StorageLife



Nu

ID

int

4

 

 

NAME

nvarchar

50

 

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

() - Manufacture



Nu

ID

int

4

 

 

NAME

nvarchar

120

 

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- State



Nu

ID

int

4

 

 

NAME

nvarchar

50

 

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- ATS



Nu

ID

int

4

 

 

CODE

nvarchar

50

V

NAME

nvarchar

100

V

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- GroupName



Nu

ID

int

4

 

 

NAME

nvarchar

150

V

ToParent

int

4

 


""

Number

int

4

 


""

[Level]

int

4

V

-
""

[ [Position]]]

int

4

V

TreeKey

nvarchar

200

V

""

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

(-10) - ILLNESS



Nu

ID

int

4

 

 

class

nchar

10

V

subclass

nchar

10

V

[group]

nchar

10

V

code

nvarchar

50

V

subcode

nvarchar

50

V

name

nvarchar

255

V

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- ILLNESS_TYPE_USE



Nu

ID

int

4

 

 

NAME

nvarchar

50

V

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- Info



Nu

ID

int

4

 

 

VersionDB

int

4

V

DateDB

datetime

8

V



VersionRegistry

int

4

V



DateRegistry

datetime

8

V

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- InfoHelp



Nu

ID

int

4

 

 

[FILE]

nvarchar

200

V

TITLE_ID

int

4

V

SUBTITLE

nvarchar

200

V

HELP

ntext

16

V

INFOHELP_TYPE_ID

int

4

V

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- InfoHelp_Type



Nu

ID

int

4

 

 

NAME

nvarchar

50

V

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- Narcotic



Nu

ID

int

4

 

 

NAME

char

10

 

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- Toxin



Nu

ID

int

4

 

 

NAME

nvarchar

50

 

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- TradeUnit



Nu

ID

int

4

 

 

Code

int

4

V


ToTradeName

int

4

V


_ToLatinName

int

4

V

 

_ToTradeType

int

4

V

 

ToDrugForm

int

4

V

ToDose

int

4

V

ToPacking

int

4

V

ToWrapping

int

4

V

_ToManufacture

int

4

V

 

_ToState

int

4

V

 

ToManufactureState

int

4

V




BarCode

bigint

8

V

-

RegistryNumber

nvarchar

50

V

RegistryDate

datetime

8

V

_ToRegister

int

4

V

 

ToRegistryState_old

int

4

V

 

ToRegistryState

int

4

V




.

PriceRU

decimal

9

V

PriceCUR

decimal

9

V

PriceFederal

decimal

9

V


PriceMosObl

decimal

9

V


TypeCur

nchar

10

V

PriceNumber

nvarchar

50

V


PriceDate

datetime

8

V


ToStorageLife

int

4

V

Vital

int

4

 

VitalPrivilege

int

4

 


VitalMosObl

int

4

 


Recipe

int

4

 

Assortment1

int

4

 

N 1

Formular

int

4

 

ToNarcotic

int

4

V


ToToxin

int

4

V


ListA

int

4

 

ListB

int

4

 

Privilege1

int

4

 

AnnulDate

datetime

8

V


ActualDate

datetime

8

V

NDS

float

8

 

NP

float

8

 

ToQuantity

int

4

V


Weight

decimal

9

V

Height

int

4

V

Width

int

4

V

Lenght

int

4

V

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- TradeUnit_C1



Nu

ID

int

4

 

 

TRADENAMESHORT_ID

int

4

 

 

LINE

tinyint

1

V

 

DRUGFORM_ID

int

4

V

 

DOSE_ID

int

4

V

 

QUANTITY_ID

int

4

V

 

MANUFACTURESTATE_ID

int

4

V

 

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- TradeUnit_C1_LINK



Nu

ID

int

4

 

 

TRADEUNIT_ID

int

4

V

 

TRADEUNIT_C1_ID

int

4

V

 

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- Group



Nu

ID

int

4

 

 

ToTradeUnit

int

4

V

ToTradeName

int

4

V

ToGroupName

int

4

V

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

, - ILLNESS_TRADEN



Nu

ID

int

4

 

 

ILLNESS_ID

int

4

V

ToTradeName

int

4

V

TYPE_USE_ID

int

4

V



CATEGORY

nchar

10

V




USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- ATS_TRADENAME



Nu

ID

int

4

 

 

ATS_ID

int

4

V

ToTradeName

int

4

V

 

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

() - ManufactureState



Nu

ID

int

4

 

0 -
1 -

TYPE

int

4

 

 

ToManufacture

int

4

V

ToState

int

4

V

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- InfoHelp_Join



Nu

ID

int

4

 

 

INFOHELP_ID

int

4

V

MANUFACTURE_ID

int

4

V

TRADENAME_ID

int

4

V

DRUGFORM_ID

int

4

V

DOSE_ID

int

4

V

INTERNATIONAL_ID

int

4

V

MANUFACTURER_ID

int

4

V

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- InfoHelp_Join_TradeUnit



Nu

ID

int

4

 

 

TRADEUNIT_ID

int

4

 

INFOHELP_JOIN_ID

int

4

 

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

- InfoHelp_Title



Nu

ID

int

4

 

 

NAME

nvarchar

100

V

USER_ID

int

4

V

 

EXEC_DATE

datetime

8

V

 

 

 

 

 

 

N 2

28.02.2006 . N 65

 

 

*., :

 

N
/

-

1.

int

4


(
TradeUnit)

2.

TRADENAME_ID

int

4


(
TradeName)

3.


nvarchar

200

4.


nvarchar

200


5.


int

4


(
InternationalName)

6.


nvarchar

50


7.


nvarchar

50


8.


nvarchar

200


9.

int

4

(
GROUP)

10.

nvarchar

150


11.

nvarchar

150

12.

nvarchar

50

13.

()

nvarchar

60



()

14.

nvarchar

50

15.

char

50

16.

nvachar

60

17.

nvarchar

120

18.


nvarchar

50

19.

bigint

8

20.

nvarchar

120

21.


nvarchar

50

22.

nvarchar

100

23.

N

nvarchar

50

N

24.

datetime

8

25.

decimal

9


()

26.

decimal

9


()

27.


decimal

9


()

28.



decimal

9


()

29.

nchar

10

30.

float

8

31.

float

8

32.

N

nvarchar

50

N

33.


datetime

8


34.

int

4

35.

int

4

36.


int

4

37.



int

4


38.

int

4

39.

char

10

40.


nvarchar

50

41.

int

4

42.

int

4

43.

datetime

8

44.

decimal

9

45.

int

4

46.

int

4

47.

int

4

48.

datetime

8

 

 

 

 

 

N 3

28.02.2006 . N 65

 

,

 

 

1. .

2. .

3. .

4. (-10).

5. -- ().

 

 

1. .

2. .

3. .

4. .

5. .

6. .

7. .

8. .

9. .

10. .

11. .

 

 



- // , , , , , , //

@Mail.ru

Copyright www.hippocratic.ru, 2012 - 2018