Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:tables_fields [2019/08/28 05:15] – ↷ Links adapted because of a move operation lou | admin:tables_fields [2021/10/08 11:15] (current) – Gary Willetts | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{indexmenu_n> | + | {{indexmenu_n> |
- | + | ====== | |
- | ===== Field descriptions | + | \\ \\ For descriptions |
- | The following tables list the main data tables in mSupply (there are some others, but we're not telling you about those!). This information will help you if you are building your own reports. | + | \\ |
- | + | \\ | |
- | Note that if a field is indexed, finding information (querying) using that field will be very quick. | + | | // |
- | + | ||
- | ==== Main tables | + | |
- | + | ||
- | ^ Table ^ Description | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.tables_fields: | + | |
- | | [[admin: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | + | ||
- | ==== Foreign Keys ==== | + | |
- | [[admin: | + | |
- | + | ||
- | + | ||
- | ==== Other tables ==== | + | |
- | + | ||
- | ^ Table ^ Description | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.:tables_fields: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | + | ||
- | ==== Tables used internally that you most likely shouldn' | + | |
- | ^ Table ^ Description | + | |
- | | [[.: | + | |
- | | Preferences | The data for each preference is in binary format. You're not interested. | | + | |
- | + | ||
- | ^ Item store join ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | Note that records are created for each item- there should always be one record for each item in each store||||| | + | |
- | | id | | Text | | | | + | |
- | | store_ID | | Text | | | | + | |
- | | item_ID | | Text | | | | + | |
- | | inactive | true means item is not visible in this store. False means it is visible | bool | | | | + | |
- | + | ||
- | ^ Name store join ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | Note that records are only created as needed- that is a missing record implies the name is invisible for that store||||| | + | |
- | | id | | Text | | | | + | |
- | | store_ID | | Text | | | | + | |
- | | name_ID | | Text | | | | + | |
- | | inactive | true means name is not visible in this store. False means it is visible | bool | | | | + | |
- | + | ||
- | ^ Name group ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | id | | Text | | | | + | |
- | | name | | Alpha | 40 | | | + | |
- | + | ||
- | ^ Name note ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | note_type | | Alpha | 3 | | | + | |
- | | entry_date | | Date | | | | + | |
- | | note | | Text | | | | + | |
- | | name_key | | Alpha | 8 | | | + | |
- | | id | | Text | | | | + | |
- | + | ||
- | ^ Permissions ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | item_dept_id | | Text | | | | + | |
- | | name_group_id | Stores which name groups have permission to be supplied which item departments | Text | | | | + | |
- | + | ||
- | ^ Prefs ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | item | Internally used: storing preferences of text type(Now deprecated in favour of pref blob) | Alpha | 20 | | | + | |
- | | value | | Alpha | 60 | | | + | |
- | + | ||
- | ^ Reports ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | report_name | | Alpha | 80 | | | + | |
- | | report_blob | | BLOB | | | | + | |
- | | owner_ID | | Text | | | | + | |
- | | id | | Text | | | | + | |
- | | last_updated | | Date | | | | + | |
- | + | ||
- | ==== Ship method ==== | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | id | | Text | | | | + | |
- | | method | | Alpha | 80 | | | + | |
- | + | ||
- | ==== Sync out ==== | + | |
- | + | ||
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | id | | Text | | | | + | |
- | | type | I=insert, U=update, D=delete, M=merge, T=transfer | Alpha | 2 | | | + | |
- | | record_id | ID of the record to be synced | Text | | | | + | |
- | | to_from_id | sync site ID to send the record | Long | | | | + | |
- | | store_id | if store-specific data, the store ID for the record. For example a remote sync site might have multiple stores. If this sync_out record if for a transact record, the Store_ID that it's for. | + | |
- | | record_data | (deprecated) | BLOB | | | | + | |
- | | table_num | Internal table number of the record | Long | | | | + | |
- | | sequence | Integer for correct sync ordering | Long | | | | + | |
- | | table_id_num | Internal field number for the ID field of the record' | + | |
- | | merge_ID_to_keep | ID of record being kept in merge | Text | | | | + | |
- | | merge_ID_to_delete | ID of record being deleted in merge | Text | | | | + | |
- | + | ||
- | ==== Transaction category ==== | + | |
- | + | ||
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | id | | Text | | | | + | |
- | | category | | Alpha | 80 | | | + | |
- | | type | " | + | |
- | + | ||
- | ==== Transaction Notes ==== | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | id | | + | |
- | | note | | Text | | | | + | |
- | + | ||
- | ==== Units ==== | + | |
- | + | ||
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | id | | Text | | | | + | |
- | | units | | Alpha | 60 | | | + | |
- | | comment | | Text | | | | + | |
- | + | ||
- | // Previous: [[clients:east_timor_assets|Asset Management for East Timor]] | + | |
---- struct data ---- | ---- struct data ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||