Hello,
I am trying to find out what file_source from the table oc_share is referencing to.
For some reason I am unable to find any foreign key relationships.
Hope you can help me.
MariaDB [nextcloud]> describe oc_share;
±--------------±-------------±-----±----±--------±---------------+
| Field | Type | Null | Key | Default | Extra |
±--------------±-------------±-----±----±--------±---------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| share_type | smallint(6) | NO | | 0 | |
| share_with | varchar(255) | YES | | NULL | |
| uid_owner | varchar(64) | NO | | | |
| uid_initiator | varchar(64) | YES | | NULL | |
| parent | int(11) | YES | | NULL | |
| item_type | varchar(64) | NO | MUL | | |
| item_source | varchar(255) | YES | | NULL | |
| item_target | varchar(255) | YES | | NULL | |
| file_source | int(11) | YES | MUL | NULL | |
| file_target | varchar(512) | YES | | NULL | |
| permissions | smallint(6) | NO | | 0 | |
| stime | bigint(20) | NO | | 0 | |
| accepted | smallint(6) | NO | | 0 | |
| expiration | datetime | YES | | NULL | |
| token | varchar(32) | YES | MUL | NULL | |
| mail_send | smallint(6) | NO | | 0 | |
| password | varchar(255) | YES | | NULL | |
| share_name | varchar(64) | YES | | NULL | |
±--------------±-------------±-----±----±--------±---------------+
Cheers,
Ori