1 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public'; | | 63 | 63 | 4 |
2 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'user_routes' AND table_schema = 'public' ORDER BY position | | 3 | 3 | 6 |
3 | SELECT "UserRoutes"."id" AS "UserRoutes__id", "UserRoutes"."user_path" AS "UserRoutes__user_path", "UserRoutes"."real_path" AS "UserRoutes__real_path" FROM "user_routes" AS "UserRoutes" WHERE 1 = 1 | | 0 | 0 | 0 |
4 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'configurations' AND table_schema = 'public' ORDER BY position | | 16 | 16 | 3 |
5 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'articles' AND table_schema = 'public' ORDER BY position | | 23 | 23 | 3 |
6 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'media' AND table_schema = 'public' ORDER BY position | | 11 | 11 | 2 |
7 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'article_custom_field_values' AND table_schema = 'public' ORDER BY position | | 4 | 4 | 2 |
8 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'v_article_media' AND table_schema = 'public' ORDER BY position | | 13 | 13 | 2 |
9 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'v_article_tags' AND table_schema = 'public' ORDER BY position | | 6 | 6 | 2 |
10 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'categories' AND table_schema = 'public' ORDER BY position | | 22 | 22 | 3 |
11 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'article_categories' AND table_schema = 'public' ORDER BY position | | 2 | 2 | 2 |
12 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'flashes' AND table_schema = 'public' ORDER BY position | | 12 | 12 | 3 |
13 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'name_days' AND table_schema = 'public' ORDER BY position | | 3 | 3 | 2 |
14 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'forum_messages' AND table_schema = 'public' ORDER BY position | | 7 | 7 | 3 |
15 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'registered_users' AND table_schema = 'public' ORDER BY position | | 14 | 14 | 3 |
16 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'registered_user_groups' AND table_schema = 'public' ORDER BY position | | 6 | 6 | 2 |
17 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'custom_field_values_registered_users' AND table_schema = 'public' ORDER BY position | | 4 | 4 | 2 |
18 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'forum_message_files' AND table_schema = 'public' ORDER BY position | | 7 | 7 | 2 |
19 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'custom_field_values_forum_messages' AND table_schema = 'public' ORDER BY position | | 4 | 4 | 2 |
20 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'custom_fields' AND table_schema = 'public' ORDER BY position | | 7 | 7 | 2 |
21 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'custom_field_groups' AND table_schema = 'public' ORDER BY position | | 3 | 3 | 2 |
22 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'units' AND table_schema = 'public' ORDER BY position | | 4 | 4 | 2 |
23 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'categories_registered_user_groups' AND table_schema = 'public' ORDER BY position | | 3 | 3 | 2 |
24 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'categories_users' AND table_schema = 'public' ORDER BY position | | 3 | 3 | 2 |
25 | SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null,
column_default AS default, ordinal_position AS position, character_maximum_length AS char_length,
character_octet_length AS oct_length FROM information_schema.columns
WHERE table_name = 'v_category_articles' AND table_schema = 'public' ORDER BY position | | 18 | 18 | 3 |