PLM Features Increasing stockid size

Find columns with IMPLICIT stockmaster.stockid child foreign key columns which will also need to be increased in size.

1. columns named stockid (same as parent)

Use SQL query to obtain columns named "stockid" and manually remove those with explicit fk constraints from the list.

SELECT
    TABLE_NAME, 
    COLUMN_NAME, 
    DATA_TYPE
FROM 
    information_schema.COLUMNS
WHERE 
    COLUMN_NAME = 'stockid'
    AND TABLE_SCHEMA = DATABASE()
    AND TABLE_NAME != 'stockmaster';

+------------------------------+-------------+-----------+
| TABLE_NAME                   | COLUMN_NAME | DATA_TYPE |
+------------------------------+-------------+-----------+
| assetmanager                 | stockid     | varchar   |
| ediitemmapping               | stockid     | varchar   |
| employees                    | stockid     | varchar   |
| lastcostrollup               | stockid     | char      |
| loctransfercancellations     | stockid     | varchar   |
| pickserialdetails            | stockid     | varchar   |
| pricematrix                  | stockid     | varchar   |
| relateditems                 | stockid     | varchar   |
| salesanalysis                | stockid     | varchar   |
| sellthroughsupport           | stockid     | varchar   |
| shipmentcharges              | stockid     | varchar   |
| stockdescriptiontranslations | stockid     | varchar   |
| stockserialmoves             | stockid     | varchar   |
| supplierdiscounts            | stockid     | varchar   |
| tenderitems                  | stockid     | varchar   |
| woserialnos                  | stockid     | varchar   |
+------------------------------+-------------+-----------+
16 implicit foreign key columns

2. columns named stkcode (because stkcode was also found used as an explicit fk constraint name)

Use SQL query to obtain list of constraints named "stkcode".

SELECT 
    TABLE_NAME, 
    COLUMN_NAME, 
    DATA_TYPE
FROM 
    information_schema.COLUMNS
WHERE 
    COLUMN_NAME = 'stkcode'
    AND TABLE_SCHEMA = DATABASE()
    AND TABLE_NAME != 'stockmaster';

+-------------------------+-------------+-----------+
| TABLE_NAME              | COLUMN_NAME | DATA_TYPE |
+-------------------------+-------------+-----------+
| recurrsalesorderdetails | stkcode     | varchar   |
| salesorderdetails       | stkcode     | varchar   |
+-------------------------+-------------+-----------+
2 rows in set

3. columns defined as "varchar(20)" (same as stockid definition)

4. columns with "code" in their name (like "stkcode")

5. columns with "id" in their name (like "stockid")