I wanted to consult your opinion about this structure of tables that I found coming from a known developer, then the structure
CREATE TABLE 'tabla' (
'C0' int(15) NOT NULL,
'C1' varchar(500) NOT NULL,
'C2' varchar(500) NOT NULL,
'C3' varchar(500) NOT NULL,
'C4' varchar(500) NOT NULL,
'C5' varchar(500) NOT NULL,
'C6' varchar(500) NOT NULL,
'C7' varchar(500) NOT NULL,
'C8' varchar(500) NOT NULL,
'C9' varchar(500) NOT NULL,
'C10' varchar(500) NOT NULL,
'C11' varchar(500) NOT NULL,
'C12' varchar(500) NOT NULL,
'C13' varchar(500) NOT NULL,
'C14' varchar(500) NOT NULL,
'C15' varchar(500) NOT NULL,
'C16' varchar(500) NOT NULL,
'C17' varchar(500) NOT NULL,
'C18' varchar(500) NOT NULL,
'C19' varchar(500) NOT NULL,
'C20' varchar(500) NOT NULL,
'C21' varchar(500) NOT NULL,
'C22' varchar(500) NOT NULL,
'C23' varchar(500) NOT NULL,
'C24' varchar(500) NOT NULL,
'C25' varchar(500) NOT NULL,
'C26' varchar(500) NOT NULL,
'C27' varchar(500) NOT NULL,
'C28' varchar(500) NOT NULL,
'C29' varchar(500) NOT NULL,
'C30' varchar(500) NOT NULL,
'C31' varchar(500) NOT NULL,
'C32' varchar(500) NOT NULL,
'C33' varchar(500) NOT NULL,
'C34' varchar(500) NOT NULL,
'C35' varchar(500) NOT NULL,
'C36' varchar(500) NOT NULL,
'C37' varchar(500) NOT NULL,
'C38' varchar(500) NOT NULL,
'C39' varchar(500) NOT NULL,
'C40' varchar(500) NOT NULL,
'C41' varchar(500) NOT NULL,
'C42' varchar(500) NOT NULL,
'C43' varchar(500) NOT NULL,
'C44' varchar(500) NOT NULL,
'C45' varchar(500) NOT NULL,
'C46' varchar(500) NOT NULL,
'C47' varchar(500) NOT NULL,
'C48' varchar(500) NOT NULL,
'C49' varchar(500) NOT NULL,
'C50' varchar(500) NOT NULL,
'C51' varchar(500) NOT NULL,
'C52' varchar(500) NOT NULL,
'C53' varchar(500) NOT NULL,
'C54' varchar(500) NOT NULL,
'C55' varchar(500) NOT NULL,
'C56' varchar(500) NOT NULL,
'C57' varchar(500) NOT NULL,
'C58' varchar(500) NOT NULL,
'C59' varchar(500) NOT NULL,
'C60' varchar(500) NOT NULL,
'C61' varchar(500) NOT NULL,
'C62' varchar(500) NOT NULL,
'C63' varchar(500) NOT NULL,
'C64' varchar(500) NOT NULL,
'C65' varchar(500) NOT NULL,
'C66' varchar(500) NOT NULL,
'C67' varchar(500) NOT NULL,
'C68' varchar(500) NOT NULL,
'C69' varchar(500) NOT NULL,
'C70' varchar(500) NOT NULL,
'C71' varchar(500) NOT NULL,
'C72' varchar(500) NOT NULL,
'C73' varchar(500) NOT NULL,
'C74' varchar(500) NOT NULL,
'C75' varchar(500) NOT NULL,
'C76' varchar(500) NOT NULL,
'C77' varchar(500) NOT NULL,
'C78' varchar(500) NOT NULL,
'C79' varchar(500) NOT NULL,
'C80' varchar(500) NOT NULL,
'C81' varchar(500) NOT NULL,
'C82' varchar(500) NOT NULL,
'C83' varchar(500) NOT NULL,
'C84' varchar(500) NOT NULL,
'C85' varchar(500) NOT NULL,
'C86' varchar(500) NOT NULL,
'C87' varchar(500) NOT NULL,
'C88' varchar(500) NOT NULL,
'C89' varchar(500) NOT NULL,
'C90' varchar(500) NOT NULL,
'C91' varchar(500) NOT NULL,
'C92' varchar(500) NOT NULL,
'C93' varchar(500) NOT NULL,
'C94' varchar(500) NOT NULL,
'C95' varchar(500) NOT NULL,
'C96' varchar(500) NOT NULL,
'C97' varchar(500) NOT NULL,
'C98' varchar(500) NOT NULL,
'C99' varchar(500) NOT NULL,
'C100' varchar(500) NOT NULL,
'C101' varchar(100) NOT NULL,
'C102' varchar(25) NOT NULL,
'C103' varchar(500) NOT NULL,
'C104' varchar(100) NOT NULL,
'C105' varchar(25) NOT NULL,
'C106' varchar(500) NOT NULL,
'C107' varchar(100) NOT NULL,
'C108' varchar(25) NOT NULL,
'C109' varchar(100) NOT NULL,
'C110' varchar(25) NOT NULL,
'C111' varchar(500) NOT NULL,
'C112' varchar(25) NOT NULL,
'C113' varchar(200) NOT NULL,
'C114' varchar(100) NOT NULL,
'C115' varchar(100) NOT NULL,
'C116' varchar(100) NOT NULL,
'C117' varchar(100) NOT NULL,
'C118' varchar(100) NOT NULL,
'C119' varchar(100) NOT NULL,
'C120' varchar(100) NOT NULL,
'C121' varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
ALTER TABLE 'tabla'
ADD PRIMARY KEY ('C0');
ALTER TABLE 'tabla'
MODIFY 'C0' int(15) NOT NULL AUTO_INCREMENT;
In this table there are many numeric and text data, even percentages with two decimal places "12.03%", but as you can see, all your columns are varchar (500), what mistakes are being made here?
If it is not the right place for this question, please apologize.