Entry

Database: MySql: PHPRunner: Table: Split: How to possibly divide 1 large table in smaller subtables?

May 19th, 2005 09:15
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 19 May 2021 - 07:23 pm ------------------------
Database: MySql: PHPRunner: Table: Split: How to possibly divide 1 
large table in smaller subtables?
---
You might use this method when you have to fit all the columns on 1
input screen.
If there are many columns to fill in (e.g. 20 or 30 columns in 1
table), and say this columns appear underneath each other, so that they
use instead 2 or more screens (which means that a user must scroll down
to input, which you might want to avoid) you can then split this table
in parts, so that it fits on the screen.
The less relevant columns you move then to subtables, and link back
via the foreign key.
===
Steps: Overview:
 1. -Split your table in smaller tables in MySql
 2. -Start the PHPRunner program
 3. -Show this tables in PHPRunner
     1. -Open the database
          e.g.
           database1
     2. -Enable checkbox of the
         involved tables
          e.g.
           tableFriendDataMainOld
            and
           tableFriendDataMainNew
           tableAddressS
           tableFriendDataExtra
     3. -Indicate that there is a
         master-detail relation between
         the splitted tables
         1. The master is:
            1. tableFriendDataMainNew
         2. The detail tables are:
            1. tableAddressS
               1. primary key = columnFriendDataMainIdI
               2. foreign key = columnFriendDataMainIdI
               3. -Enable checkbox 'Display master table info on detail
                   page'
            2. tableFriendDataExtra
               1. primary key = columnFriendDataMainIdI
               2. foreign key = columnFriendDataMainIdI
               3. -Enable checkbox 'Display master table info on detail
                   page'
     4. -Build the project
     5. -View the result in your browser
         1. Show the master-detail links
            1. -Select the master table
                1. The master is:
                   1. tableFriendDataMainNew
            2. -Add a new record
                1. -Click on link 'Add new'
                2. -Fill in some data in the fields
                     e.g.
                      columnFirstName = 'test'
                      columnLastName = 'test'
                3. -Save the result
                    1. -Click button 'Save record'
                4. -Goto back to the list
                5. -You see now that the table
                    'tableFriendDataMainNew' has
                    2 links to the subtables
                    1. tableaddresss
                    2. tablefrienddataextra
                6. Thus you splitted your originally
                   larger table in (two) smaller
                   subtables, as planned.
---
---
Internet: see also:
---
Database: MySql: Table: Split: How to divide 1 large table in smaller 
subtables? [foreign key]
http://www.faqts.com/knowledge_base/view.phtml/aid/36325/fid/52
---
PHPRunner: Screen: Add: New: Field:Total: How many fields are totally 
shown in add new input screen?
http://www.faqts.com/knowledge_base/view.phtml/aid/36364/fid/1805
---
Database: MySql: PHPRunner: Link: Can you give an overview of links?
http://www.faqts.com/knowledge_base/view.phtml/aid/35950/fid/1805
----------------------------------------------------------------------