How to get Relations between Tables in ERPNext

access_console.log

bench --site your_site_name console

copy_paste_sql_code.log

# Get all doctypes
doctypes = frappe.db.sql("SELECT name FROM `tabDocType` WHERE istable=0 AND issingle=0", as_dict=1)

# For each doctype, get link fields
for d in doctypes:
    dt = frappe.get_meta(d.name)
    links = dt.get_link_fields()
    if links:
        print(f"DocType: {d.name}")
        for link in links:
            print(f"  → Links to {link.options} via field {link.fieldname}")
        print("")

How to exit console:
type: exit()
then press "Enter" button