tables_fields:internal_tables

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
tables_fields:internal_tables [2020/01/07 01:05] – ↷ Links adapted because of a move operation loutables_fields:internal_tables [2022/03/11 14:44] (current) – [Name store join] Gary Willetts
Line 1: Line 1:
 {{indexmenu_n>40}} {{indexmenu_n>40}}
- +====== 24.04. Internal tables ======
-====== 20.04. Internal tables ====== +
 **These are tables that are used internally that you most likely shouldn't be interested in ** **These are tables that are used internally that you most likely shouldn't be interested in **
 \\ \\
 \\ \\
 ===Internal tables===  ===Internal tables=== 
 +   * [[tables_fields:internal_tables#insuranceProvider]]  
    * [[tables_fields:internal_tables#item_store_join]]      * [[tables_fields:internal_tables#item_store_join]]  
 +   * [[tables_fields:internal_tables#nameInsuranceJoin]]
    * [[tables_fields:internal_tables#name_store_join]]    * [[tables_fields:internal_tables#name_store_join]]
    * [[tables_fields:internal_tables#name_group]]    * [[tables_fields:internal_tables#name_group]]
Line 20: Line 20:
    * [[tables_fields:internal_tables#transaction_notes]]    * [[tables_fields:internal_tables#transaction_notes]]
    * [[tables_fields:internal_tables#units]]    * [[tables_fields:internal_tables#units]]
 +
 +=== 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 28: 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 that 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 119: Line 144:
 \\ \\
 \\ \\
-|  //  Previous:  **[[tables_fields:foreign_keys|20.03. Foreign keys]]** | | Next: **[[admin:|21. Technical Administration]]** //  |+|  //  Previous:  **[[tables_fields:foreign_keys]]** | | Next: **[[admin:]]** //  |
  
  
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2020/01/07 01:05
  • by lou