Symfony Profiler

SHOW FULL TABLES 
WHERE 
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_clients' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_clients' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_accounts_head' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_accounts_head' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_accounts_head' */
WHERE 
  k.table_name = 'acc_accounts_head' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_accounts_head' */ WHERE k.table_name = 'acc_accounts_head' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_check' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_check' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'after_sales_service_order' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'after_sales_service_order' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_actual_closing_balance' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_actual_closing_balance' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_entity' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_entity' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'employee_details' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'employee_details' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'product_by_code' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'product_by_code' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'applicant_details' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'applicant_details' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_loan' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_loan' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'sales_order' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'sales_order' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'after_sales_service_delivery' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'after_sales_service_delivery' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'expense_invoice' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'expense_invoice' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'production_entry_item' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'production_entry_item' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'inv_products' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'inv_products' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_suppliers' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_suppliers' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'bank_list' */
WHERE 
  k.table_name = 'bank_list' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'bank_list' */ WHERE k.table_name = 'bank_list' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'secondary_sales_order' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'secondary_sales_order' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'production' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'production' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'insurance_pay_request' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'insurance_pay_request' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'financial_budget' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'financial_budget' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'production_schedule' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'production_schedule' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'bill_of_lading' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'bill_of_lading' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'primary_client_inventory_storage' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'primary_client_inventory_storage' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'sales_invoice' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'sales_invoice' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'planning_item' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'planning_item' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'bill_of_entry' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'bill_of_entry' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'payroll_policy' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'payroll_policy' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'product_package' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'product_package' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'fixed_asset_product' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'fixed_asset_product' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'purchase_order' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'purchase_order' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'product_mrp' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'product_mrp' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'production_process_settings' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'production_process_settings' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'assessment_and_confirmation' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'assessment_and_confirmation' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'project_material' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'project_material' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'product_mrp_document' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'product_mrp_document' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'bank_accounts' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'bank_accounts' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'irr_item' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'irr_item' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_transactions' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_transactions' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  ENGINE, 
  AUTO_INCREMENT, 
  TABLE_COLLATION, 
  TABLE_COMMENT, 
  CREATE_OPTIONS 
FROM 
  information_schema.TABLES 
WHERE 
  TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'acc_actual_closing_balance'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'acc_actual_closing_balance';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'cash_flow_projection' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'cash_flow_projection' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'lc_entry' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'lc_entry' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'delivery_schedule' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'delivery_schedule' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'purchase_invoice' 
ORDER BY 
  ORDINAL_POSITION ASC