Attachment field relation

English Forum Questions
1

Hi everyone,
I recently discovered Nocobase and I think it’s really fantastic.
I’m doing some tests on my local PC and can’t figure out something related to the dataset’s attachments.

I have a main table with an attachment field. When I upload the file, I see that it’s saved to the default local storage.
I read that this table should contain a JSON field with the file details, but I don’t see it.
I read that there’s a dedicated table that contains all the attachments, but I can’t find a relationship key between these tables, and I can’t reconstruct the path to complete my integrations.

My main table structure

1
11491×724 34.9 KB

Main table data


{
"createdAt": 
"2025-09-02T08:15:59.937Z",
"updatedAt": 
"2025-09-02T08:15:59.937Z",
"id": 
"5",
"createdById": 
"1",
"updatedById": 
"1",
"name": 
"nm,",
"description": 
null,
"voiceid": 
"678",
"language": 
"hjk",
"prompt": 
null
}

Storage table data


{
"id": 
"12",
"createdAt": 
"2025-09-02T08:15:53.369Z",
"updatedAt": 
"2025-09-02T08:15:53.375Z",
"title": 
"pippo",
"filename": 
"pippo-1zjjh0.txt",
"extname": 
".txt",
"size": 
19118,
"mimetype": 
"text/plain",
"path": 
"",
"meta": 
{
},
"url": 
null,
"createdById": 
"1",
"updatedById": 
"1",
"storageId": 
"1"
}

Is there another table that relates these records?
Thanks in advance for your reply

2

Hi Enriweb77,

For files stored on local storage, they are saved under the storage/uploads folder. Currently, there isn’t an accessible file table available, so there’s no dedicated table to query file details or relationships at the moment.

3

Thanks for your reply.
If I need to create a workflow that sends the file URL as a parameter, how do you recommend I do it?