[Feature] Add filename and manifest file meta system table

### Search before asking

- [x] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar.

### Motivation

subtask of #7158

### Solution

_No response_

### Anything else?

_No response_

### Are you willing to submit a PR?

- [ ] I'm willing to submit a PR!

Start by reading the parent issue #7158 and the surrounding Paimon system-table implementation; this issue names no file, test, or entry point. Clarify the intended metadata and schema for filename and manifest files, then define done as both meta system tables being implemented and covered by the relevant tests.

Written by the indexing model from the issue text.