Russian Qt Forum

    model->setHeaderData(0, Qt::Horizontal, tr("IFI"));
    model->setHeaderData(1, Qt::Horizontal, tr("Name"));
    model->setHeaderData(2, Qt::Horizontal, tr("Address"));
... и такая лапша на каждую таблицу, на каждое поле, не считая размеры и прочее оформление

<< QstField("LastName", FieldVisible,  "Фамилия", 100)
<< QstField("FirstName", FieldVisible,  "Имя", 100)
<< QstField("ParentName", FieldVisible,  "Отчество", 100)
<< QstField("vcBirthDate", FieldVisible,  "Дата\nрождения", 90)
<< QstField("Phone", FieldVisible,  "Контактный\nтелефон", 120)
<< QstField("[E-Mail]", FieldVisible,  "e-mail", 120)

void uoMainWindow::createTables()
{
	QString dbName = qApp->applicationDirPath() + QDir::separator()+"main.db";
#ifdef Q_OS_LINUX
	QDir home = QDir::home();
	if (!home.exists(".uoReceptor")) {
		home.mkpath(".uoReceptor");
	}
	dbName = home.absolutePath() + "/.uoReceptor/" + QDir::separator()+"main.db";
#endif


	m_dbMan->setupDataBase(dbName);
	m_receptTable = m_dbMan->addRefTable("ШаблоныPецептов","Шаблоны рецептов",6,120);
	m_receptTable->setOption(codeType_Number, true);
	m_receptTable->addField("Комментарий", fieldType_String,150);
	m_templField = m_receptTable->addField("Шаблон", fieldType_TextHTML);
	uoMdiObserver::instance()->m_receptTableId = m_receptTable->m_baseNom;

	uoDbRefTable* tmlpTabl = m_dbMan->addRefTable("Лекарства","Лекарства",6, 70);
	tmlpTabl->addField("ЛатИмя",fieldType_String,70)->m_descr = "Латинское наименование";
	tmlpTabl->addField("Описание",fieldType_Text);
	tmlpTabl->setOption(codeType_Number, true);

	tmlpTabl = m_dbMan->addRefTable("Симптомы","Симптомы",6, 100);
	tmlpTabl->setOption(codeType_Number, true);
	tmlpTabl->addField("Описание",fieldType_Text);

	tmlpTabl = m_dbMan->addRefTable("Заболевания","Заболевания",6, 100);
	tmlpTabl->setOption(codeType_Number, true);
	tmlpTabl->addField("Описание",fieldType_Text);

	m_dbMan->restructuring();//  Реструктуризация
	m_dbMan->createGuiFactory(this);
	m_receptTemplDocWidget = new QDockWidget(tr("Recept template"), this);
	m_receptTemplDocWidget->setAllowedAreas(Qt::LeftDockWidgetArea | Qt::RightDockWidgetArea);

	uoUrl url = m_receptTable->getUoUrlByForm(uoFormT_Tree);
	url.setWithElem(true);
	m_docTreeFormRecept = m_dbMan->getForm(url);
	if (m_docTreeFormRecept) {
		m_docTreeFormRecept->setParent(m_receptTemplDocWidget);
		m_receptTemplDocWidget->setWidget(m_docTreeFormRecept);
		addDockWidget(Qt::LeftDockWidgetArea, m_receptTemplDocWidget);
		m_actionShowDocRecept = m_receptTemplDocWidget->toggleViewAction();
	}
}

	tmlpTabl->addField("ЛатИмя",fieldType_String,70)->m_descr = "Латинское наименование";
	tmlpTabl->addField("Описание",fieldType_Text);
	tmlpTabl->setOption(codeType_Number, true);

	tmlpTabl = m_dbMan->addRefTable("Симптомы","Симптомы",6, 100);
	tmlpTabl->setOption(codeType_Number, true);
	tmlpTabl->addField("Описание",fieldType_Text);

	tmlpTabl = m_dbMan->addRefTable("Заболевания","Заболевания",6, 100);
	tmlpTabl->setOption(codeType_Number, true);
	tmlpTabl->addField("Описание",fieldType_Text);

select TABLE_NAME, TABLE_COMMENT 
from information_schema.tables 
WHERE (table_schema = 'ASRGTS') AND (TABLE_COMMENT LIKE 'Справочник%');

SELECT COLUMN_NAME, DATA_TYPE,  CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, COLUMN_COMMENT
FROM information_schema.columns 
WHERE (table_name = 'CONTRACTS') AND (table_schema = 'ASRGTS');

SET TERM ^ ;

CREATE PROCEDURE GET_FIELD_TYPE(
  TABLE_NAME CHAR(255) CHARACTER SET UTF8 COLLATE UTF8,
  FIELD_NAME CHAR(255) CHARACTER SET UTF8 COLLATE UTF8)
RETURNS(
  FIELD_POSITION SMALLINT,
  FIELD_TYPE_NAME CHAR(50) CHARACTER SET UTF8 COLLATE UTF8)
AS
BEGIN
FOR SELECT RDB$RELATION_FIELDS.RDB$FIELD_POSITION,
RDB$TYPES.RDB$TYPE_NAME
FROM RDB$RELATION_FIELDS
INNER JOIN RDB$FIELDS ON
(RDB$RELATION_FIELDS.RDB$FIELD_SOURCE = RDB$FIELDS.RDB$FIELD_NAME)
INNER JOIN RDB$TYPES ON
(RDB$FIELDS.RDB$FIELD_TYPE = RDB$TYPES.RDB$TYPE)
WHERE
((RDB$RELATION_FIELDS.RDB$RELATION_NAME=:TABLE_NAME)
AND
(RDB$TYPES.RDB$FIELD_NAME = 'RDB$FIELD_TYPE')
AND (RDB$RELATION_FIELDS.RDB$FIELD_NAME=:FIELD_NAME))
INTO FIELD_POSITION, FIELD_TYPE_NAME
DO 
SUSPEND;
END^

SET TERM ; ^

CREATE TABLE IF NOT EXISTS columns_description(
  TABLE_NAME VARCHAR(255) NOT NULL COMMENT 'Имя таблицы',
  COLUMN_NAME VARCHAR(255) NOT NULL COMMENT 'Имя колонки',
  DESCRIPTION VARCHAR(255) DEFAULT NULL COMMENT 'Описание',
  WIDTH DECIMAL(10, 0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ширина',
  HIDDEN TINYINT(1) NOT NULL DEFAULT 0 COMMENT 'Спрятать',
  READONLY TINYINT(1) NOT NULL DEFAULT 0 COMMENT 'Только чтение',
  UNIQUE INDEX UK_columns_description (TABLE_NAME, COLUMN_NAME)
)
ENGINE = INNODB
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = 'Описание колонок БД'
SELECT TABLE_NAME, 
       COLUMN_NAME, 
       COLUMN_COMMENT AS DESCRIPTION, 
       10*CHARACTER_MAXIMUM_LENGTH AS WIDTH
FROM information_schema.COLUMNS 
WHERE (TABLE_SCHEMA = database()) AND (TABLE_NAME in ( 
    SELECT TABLE_NAME 
    FROM information_schema.TABLES 
    WHERE (TABLE_TYPE = 'BASE TABLE') AND (TABLE_SCHEMA = database())
));

CREATE OR REPLACE SQL SECURITY INVOKER VIEW columns_schema
AS SELECT `c`.`TABLE_NAME` AS `TABLE_NAME`
     , `c`.`COLUMN_NAME` AS `COLUMN_NAME`
     , `c`.`DATA_TYPE` AS `DATA_TYPE`
     , `c`.`CHARACTER_MAXIMUM_LENGTH` AS `CHARACTER_MAXIMUM_LENGTH`
     , `c`.`NUMERIC_PRECISION` AS `NUMERIC_PRECISION`
     , `c`.`NUMERIC_SCALE` AS `NUMERIC_SCALE`
     , `c`.`COLUMN_COMMENT` AS `COLUMN_COMMENT`
     , `d`.`DESCRIPTION` AS `DESCRIPTION`
     , `d`.`HIDDEN` AS `HIDDEN`
     , `d`.`WIDTH` AS `WIDTH`
     , `d`.`READONLY` AS `READONLY`
FROM
  (`information_schema`.`COLUMNS` `c`
JOIN `columns_description` `d`
ON (((`c`.`TABLE_NAME` = `d`.`TABLE_NAME`) AND (`c`.`COLUMN_NAME` = `d`.`COLUMN_NAME`))))
WHERE
  (`c`.`TABLE_SCHEMA` = database());

select * from columns_schema where TABLE_NAME='CONTRACTS';