Fug603Base
Updated 2024-10-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Axelar @ https://flipsidecrypto.xyz/studio/queries/c7d09119-c368-4783-a7f4-9958ea32c350
-- forked from Aurora @ https://flipsidecrypto.xyz/studio/queries/130bc73f-04e7-4120-98e4-20f815e60bd0
-- forked from Arbitrum @ https://flipsidecrypto.xyz/studio/queries/bb072797-6b95-424d-85e4-c2ac9d37574c
-- forked from Aptos @ https://flipsidecrypto.xyz/studio/queries/7c81781b-bc2f-4a79-aae9-a43a164f2572
-- forked from Avalanche @ https://flipsidecrypto.xyz/studio/queries/a844bf29-8677-48be-8a12-45cf32d3fd7c
SELECT
'base' 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
base.information_schema.tables t
JOIN
base.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
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived