Medical Item table (tblItems)

Diagram

 

Fields

Name

Type

Mandatory

Default

Explanation

Name

Type

Mandatory

Default

Explanation

ItemID

int (PK)

YES

 

 

ItemCode

nvarchar(6)

YES

 

 

ItemName

nvarchar(100)

YES

 

 

ItemType

char(1)

YES

 

One of the values: Drug, Medical Consumable

ItemPackage

nvarchar(255)

NO

 

Example: ‘1000 TABLETS’,

ItemPrice

decimal(18, 2)

YES

 

Price of the medical item. Ex. 10

ItemCareType

char(1)

YES

 

One of the values: In-patient, Out-patient, Both

ItemFrequency

smallint

NO

 

The minimum number of days between providing the medical item.

ItemPatCat

tinyint

YES

 

Value binary codded: 1 - Valid, 0 - Not Valid
Representation: Kid | Adult | Women | Men
Formula: Kid*8+Adult*4+Women*2+Men

ItemUUID

uniqueidentifier

YES

New UUID

 

ValidityFrom

datetime

YES

Current date

 

ValidityTo

datetime

NO

 

 

LegacyID

int

NO

 

 

AuditUserID

int

YES

 

 

RowID

timestamp

NO

 

 

 

 

Did you encounter a problem or do you have a suggestion?

Please contact our Service Desk



This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. https://creativecommons.org/licenses/by-sa/4.0/