SELECT

'aptos' AS database_name,

t.table_catalog,

t.table_schema,

t.table_name,

t.table_type,

t.auto_clustering_on,

c.column_name,

c.ordinal_position,

c.is_nullable,

c.data_type,

c.character_maximum_length,

c.numeric_precision,

c.numeric_scale,

c.comment as column_comment

FROM

aptos.information_schema.tables t

aptos.information_schema.columns c

ON

t.table_catalog = c.table_catalog

AND t.table_schema = c.table_schema

AND t.table_name = c.table_name

WHERE

t.table_schema IN ('CORE', 'DEFI', 'NFT', 'PRICE', 'STATS')

ORDER BY

t.table_schema,

t.table_name,

c.ordinal_position;