Medical Item table (tblItems)
- Dragos Dobre
Diagram
Fields
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 |
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/