Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revisionBoth sides next revision | ||
admin:tables_fields [2016/05/26 03:02] – [Main tables] Craig Drown | admin:tables_fields [2021/03/31 14:46] – Gary Willetts | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Field descriptions ===== | + | {{indexmenu_n>199}} |
- | {{entry>80.Admin/ | + | ====== |
- | + | \\ \\ For descriptions | |
- | The following tables list the main 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 | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[admin: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | + | ||
- | ==== Foreign Keys ==== | + | |
- | [[admin: | + | |
- | + | ||
- | + | ||
- | ==== Other tables ==== | + | |
- | + | ||
- | ^ Table ^ Description | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.:tables_fields: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.: | + | |
- | | [[.:tables_fields: | + | |
- | | [[.: | + | |
- | | [[.: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 | | Long | | | | + | |
- | | store_ID | | Long | | | | + | |
- | | item_ID | | Long | | | | + | |
- | | 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 | | Long | | | | + | |
- | | store_ID | | Long | | | | + | |
- | | name_ID | | Long | | | | + | |
- | | inactive | true means name is not visible in this store. False means it is visible | bool | | | | + | |
- | + | ||
- | ^ Name group ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | key | | Long | | | | + | |
- | | name | | Alpha | 40 | | | + | |
- | + | ||
- | ^ Name note ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | note_type | | Alpha | 3 | | | + | |
- | | entry_date | | Date | | | | + | |
- | | note | | Text | | | | + | |
- | | name_key | | Alpha | 8 | | | + | |
- | | key | | Long | | | | + | |
- | + | ||
- | + | ||
- | ^ Permissions ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | item_dept_key | | Long | | | | + | |
- | | name_group_key | | Long Ind | | | | + | |
- | + | ||
- | + | ||
- | ^ Permissions ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | name_group_key | Stores which name groups have permission to be supplied which item departments | Long | | | | + | |
- | | item_dept_key | | Long | | | | + | |
- | + | ||
- | ^ 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_key | | Long | | | | + | |
- | | key | | Long | | | | + | |
- | | last_updated | | Date | | | | + | |
- | + | ||
- | ^ Ship method ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | key | | Long | | | | + | |
- | | method | | Alpha | 80 | | | + | |
- | + | ||
- | + | ||
- | + | ||
- | ^ Transaction category ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | key | | Long | | | | + | |
- | | category | | Alpha | 80 | | | + | |
- | | type | | Alpha | 3 | | | + | |
- | + | ||
- | + | ||
- | ^ Transaction Notes ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | key | | Long | | | | + | |
- | | note | | Text | | | | + | |
- | + | ||
- | ^ Units ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | key | | Long | | | | + | |
- | | units | | Alpha | 60 | | | + | |
- | | comment | | Text | | | | + | |
- | + | ||
- | + | ||
- | ^ Web favourites ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | name_key | | Alpha | 8 | | | + | |
- | | Item_key | | Alpha | 8 | | | + | |
- | | type | | Alpha | 3 | | | + | |
- | + | ||
- | + | ||
- | ^ Web messages ^^^^^ | + | |
- | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | + | |
- | | key | | Long | | | | + | |
- | | active | | Boolean | | | | + | |
- | | show_until_date | | Date | | | | + | |
- | | headline | | Text | | | | + | |
- | | message | | Text | | | | + | |
- | + | ||
- | + | ||
- | // Previous: [[.: | + | |
---- struct data ---- | ---- struct data ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||