|
Group: Forum Members
Last Active: Sun 31 May 2020
Posts: 25,
Visits: 56
|
Is there a document detailing the design of the database?
Basically I want to create a custom front end app to do certain admin features to my products that are specific to my needs (using MS Access wth an ODBC connection).
To do this safely I need to understand the design of the database.
For example, in examining the tables, I see in VKatrisProductsVersions that I could have 6 entries for a particular product however the entries appear identical in every way.
eg:
P_ID P_OrderVersionsBy P_VersionsSortDirection P_VersionDisplayType P_Type T_Taxrate CAT_ID LANG_ID P_Live CAT_Live V_Live V_ID V_Name V_Desc V_CodeNumber V_Price V_Tax V_Weight V_DeliveryTime V_Quantity V_QuantityWarnLevel V_DownLoadInfo V_DownloadType V_RRP V_OrderByValue V_Type V_CustomerGroupID P_Name P_Desc P_StrapLine P_PageTitle P_Featured P_SupplierID P_CustomerGroupID P_Reviews P_AverageRating P_DateCreated V_CustomizationType V_CustomizationDesc V_CustomizationCost T_TaxRate2 CAT_CustomerGroupID
58 d - d m 0 28 1 -1 -1 -1 96 PRODUCTNAME SKU_NAME 30 1 1.2 5 0 0 n 40 1 v Dandelion Pear txt 0 y 26/08/2015 3:29:00 PM n 0
58 d - d m 0 28 1 -1 -1 -1 96 PRODUCTNAME SKU_NAME 30 1 1.2 5 0 0 n 40 1 v Dandelion Pear txt 0 y 26/08/2015 3:29:00 PM n 0
58 d - d m 0 28 1 -1 -1 -1 96 PRODUCTNAME SKU_NAME 30 1 1.2 5 0 0 n 40 1 v Dandelion Pear txt 0 y 26/08/2015 3:29:00 PM n 0
58 d - d m 0 28 1 -1 -1 -1 96 PRODUCTNAME SKU_NAME 30 1 1.2 5 0 0 n 40 1 v Dandelion Pear txt 0 y 26/08/2015 3:29:00 PM n 0
58 d - d m 0 28 1 -1 -1 -1 96 PRODUCTNAME SKU_NAME 30 1 1.2 5 0 0 n 40 1 v Dandelion Pear txt 0 y 26/08/2015 3:29:00 PM n 0
58 d - d m 0 28 1 -1 -1 -1 96 PRODUCTNAME SKU_NAME 30 1 1.2 5 0 0 n 40 1 v Dandelion Pear txt 0 y 26/08/2015 3:29:00 PM n 0
Does anyone have any information on where to go to learn more about the DB design (eg a doc explaining what each table is for and how it is used). Someone designed it right? I don't want to break my DB.
Cheers
Guy
|