I'm trying to list all fields (in all tables in an enterprise gdb) and the cv domains that they use.

    +------------+------------+-------------+
    | table_name | field_name | domain_name |
    +------------+------------+-------------+
    | table_1    | field_1    | domain_A    |
    | table_1    | field_2    | null        |
    | table_1    | field_3    | domain_B    |
    | table_1    | field_4    | domain_B    |
    | table_2    | field_1    | null        |
    | table_2    | field_2    | domain_C    |
    | table_2    | field_3    | domain_A    |
    +------------+------------+-------------+

I've tried using the third example on this page: [Query geodatabase system tables with SQL][1]. It gets me the table names and the associated domains. But it's missing the field name:

    SELECT reltypes.name AS type,
       origin_items.name AS "Origin Name", dest_items.name AS "Dest Name"
    FROM sde.gdb_items origin_items,
       sde.gdb_itemrelationships relationships,
       sde.gdb_items dest_items,
       sde.gdb_itemrelationshiptypes reltypes
    WHERE
       origin_items.UUID = relationships.originid AND
       dest_items.UUID = relationships.destid AND
       relationships.type = reltypes.UUID AND
       reltypes.name = 'DomainInDataset' AND
       origin_items.name LIKE 'PUBWORKS.%'
    ORDER BY  origin_items.name

**How can I make a list of all fields and their domains, for each table using SQL?** Keep in mind that a domain can be used by more than one field, per table (or even by multiple tables).

  [1]: http://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/query-system-tables-with-sql.htm

Environment is Oracle 12c 10.3.1 Geodatabase.