Both sides previous revision Previous revision Next revision | Previous revision Next revisionBoth sides next revision |
admin:tables_feilds [2019/09/04 15:02] – ↷ Links adapted because of a move operation lou | admin:tables_feilds [2019/09/04 15:51] – ↷ Links adapted because of a move operation lou |
---|
| |
^ Table ^ Description ^ | ^ Table ^ Description ^ |
| [[tables:field_desc:transaction|Transactions]] | A transaction record is stored for each invoice | | | [[tables:main_tables:transaction|Transactions]] | A transaction record is stored for each invoice | |
| [[tables:field_desc:trans_line|Transaction lines]] | one transaction line record is created for each line on an invoice | | | [[tables:main_tables:trans_line|Transaction lines]] | one transaction line record is created for each line on an invoice | |
| [[tables:field_desc:item|Items]] | An item record is created for each product or service purchased or supplied | | | [[tables:main_tables:item|Items]] | An item record is created for each product or service purchased or supplied | |
| [[tables:field_desc:item_line|item_line]] | Each batch of stock at a particular location has one item_line record | | | [[tables:main_tables:item_line|item_line]] | Each batch of stock at a particular location has one item_line record | |
| [[tables:field_desc:name|Names]] | Each patient, customer or supplier has one name record | | | [[tables:main_tables:name|Names]] | Each patient, customer or supplier has one name record | |
| [[tables:field_desc:purchase_order|Purchase Orders]] | One record is created for each purchase order to a supplier | | | [[tables:main_tables:purchase_order|Purchase Orders]] | One record is created for each purchase order to a supplier | |
| [[tables:field_desc:purchase_order_lines|Purchase Order Lines]] | Each record is an order for one item on a purchase order | | | [[tables:main_tables:purchase_order_lines|Purchase Order Lines]] | Each record is an order for one item on a purchase order | |
| [[tables:field_desc:quote|Quotes and Quote Lines]] | Quotations submitted by suppliers | | | [[tables:main_tables:quote|Quotes and Quote Lines]] | Quotations submitted by suppliers | |
| [[tables:field_desc:tender|Tenders and Tender Lines]] | Tenders created to invite quote submissions from suppliers | | | [[tables:main_tables:tender|Tenders and Tender Lines]] | Tenders created to invite quote submissions from suppliers | |
| [[tables:field_desc:requisition|Requistions]] | Tables that store customer submitted stock and order data | | | [[tables:main_tables:requisition|Requistions]] | Tables that store customer submitted stock and order data | |
| [[tables:field_desc:stock_take|Stock take and Stock take lines]] | Stock takes and their related records | | | [[tables:main_tables:stock_take|Stock take and Stock take lines]] | Stock takes and their related records | |
| [[tables:other_tables:store|Store]] | Information about a particular virtual store | | | [[tables:other_tables:store|Store]] | Information about a particular virtual store | |
| [[tables:field_desc:drug_register|Drug_Register]] | Drug Registration records (for use in the Drug Registration module) | | | [[tables:main_tables:drug_register|Drug_Register]] | Drug Registration records (for use in the Drug Registration module) | |
| [[tables:field_desc:aggregator|Agreggator]] | Stored metrics for use in reports | | | [[tables:main_tables:aggregator|Agreggator]] | Stored metrics for use in reports | |
| |
==== Foreign Keys ==== | ==== Foreign Keys ==== |
[[tables:field_desc:foreign_keys|Get your Foreign Keys here.]] | [[tables:foreign_keys|Get your Foreign Keys here.]] |
| |
| |
| [[tables:other_tables:name_category|Name category tables]] | Tables that store the categories that can be assigned to names (customers, suppliers, donors, manufacturers etc.) | | | [[tables:other_tables:name_category|Name category tables]] | Tables that store the categories that can be assigned to names (customers, suppliers, donors, manufacturers etc.) | |
| [[tables:other_tables:prescriber|Prescribers]] | One record for each prescriber | | | [[tables:other_tables:prescriber|Prescribers]] | One record for each prescriber | |
| [[tables:field_desc:regimen|Regimen records, Regimen and Regimen Lines]] | Everything to do with storing ARV regimen records | | | [[tables:other_tables:regimen|Regimen records, Regimen and Regimen Lines]] | Everything to do with storing ARV regimen records | |
| [[tables:other_tables:reminder|Reminders]] | A reminder is an event with a due date- like a to-do | | | [[tables:other_tables:reminder|Reminders]] | A reminder is an event with a due date- like a to-do | |
| [[tables:other_tables:store|Stores]] | Stores and join tables that control access per-store | | | [[tables:other_tables:store|Stores]] | Stores and join tables that control access per-store | |
==== Tables used internally that you most likely shouldn't be interested in ==== | ==== Tables used internally that you most likely shouldn't be interested in ==== |
^ Table ^ Description ^ | ^ Table ^ Description ^ |
| [[tables:field_desc:number|Number and Number re-use]] | Stores serial numbers such as invoice numbers | | | [[tables:main_tables:number|Number and Number re-use]] | Stores serial numbers such as invoice numbers | |
| Preferences | The data for each preference is in binary format. You're not interested. | | | Preferences | The data for each preference is in binary format. You're not interested. | |
| |