Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revisionLast revisionBoth sides next revision | ||
| tables_fields:internal_tables [2020/02/19 23:08] – [Internal tables] will | tables_fields:internal_tables [2022/03/11 14:44] – [Item store join] Gary Willetts | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{indexmenu_n> | {{indexmenu_n> | ||
| - | + | ====== | |
| - | ====== | + | |
| **These are tables that are used internally that you most likely shouldn' | **These are tables that are used internally that you most likely shouldn' | ||
| \\ | \\ | ||
| \\ | \\ | ||
| ===Internal tables=== | ===Internal tables=== | ||
| + | * [[tables_fields: | ||
| * [[tables_fields: | * [[tables_fields: | ||
| * [[tables_fields: | * [[tables_fields: | ||
| Line 21: | Line 20: | ||
| * [[tables_fields: | * [[tables_fields: | ||
| * [[tables_fields: | * [[tables_fields: | ||
| + | |||
| + | === Insurance provider === | ||
| + | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | ||
| + | | ID | | Alpha | | | | ||
| + | | providerName | The insurance provider name. | Text | | | | ||
| + | | comment | | Text | | | | ||
| + | | prescriptionValidityDays | The number of days that can expire from when a prescription is created and when it is paid for. | Long Integer | | | | ||
| + | | isActive | If false, no policies associated with this insurance provider can be used to pay for any new or outstanding prescriptions. | Boolean | | | | ||
| === Item store join === | === Item store join === | ||
| + | Contains item related values that differ across stores. Most notably, defines whether an item is visible in a particular store. | ||
| + | |||
| ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | ^ 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||||| | | Note that records are created for each item- there should always be one record for each item in each store||||| | ||
| Line 29: | Line 38: | ||
| | item_ID | | Text | | | | | item_ID | | Text | | | | ||
| | inactive | true means item is not visible in this store. False means it is visible | bool | | | | | inactive | true means item is not visible in this store. False means it is visible | bool | | | | ||
| + | |||
| + | === Name insurance join === | ||
| + | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | ||
| + | | ID | | Alpha | | | | ||
| + | | insuranceProviderID | | Alpha | | | | ||
| + | | nameID | | Alpha | | | | ||
| + | | isActive | If false, insurance policy cannot be used to pay for any outstanding or new prescriptions. | | | | ||
| + | | policyNumberFamily | | Alpha | | | | ||
| + | | policyNumberPerson | | Alpha | | | | ||
| + | | discountRate | The percent of the prescription cost that is payable by this policy. | Real | | | | ||
| + | | expiryDate | The date after which this policy will be inactive. | Date | | | | ||
| + | | policyNumberFull | The full policy number (family policy number + personal policy number) | Alpha | | | | ||
| + | | enteredByID | The ID of the user who created this policy | Alpha | | | | ||
| === Name store join === | === Name store join === | ||
| + | Contains name (customer, supplier, manufacturer etc.) related values the differ across stores. Most notably, defines whether a name is visible in a particular store. | ||
| + | |||
| ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | ^ 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||||| | | Note that records are only created as needed- that is a missing record implies the name is invisible for that store||||| | ||
| Line 120: | Line 144: | ||
| \\ | \\ | ||
| \\ | \\ | ||
| - | | // Previous: | + | | // Previous: |
| ---- struct data ---- | ---- struct data ---- | ||
| + | pagestatus.status | ||
| ---- | ---- | ||