# subject: Subject
- Name: `subject`
- Catalog: `AfasOnline`
- Schema: `SubjectConnector`
- Label: Subject
- Partition-specific: false
- Select: true
- Insert: false
- Update: false
- Delete: false
- Select Service URL (OData-specific): `/subjectconnector/{subject_id}/{file_id}`
- Insert Service URL (OData-specific): `/subjectconnector/{subject_id}/{file_id}`
- Update Service URL (OData-specific): `/subjectconnector/{subject_id}/{file_id}`
- Delete Service URL (OData-specific): `/subjectconnector/{subject_id}/{file_id}`
- Field Selection Method (OData-specific): NotRequired
## Parameters of Table Function
| Name | Data Type | Required | Default Value | Documentation |
|---|:---:|:---:|:---:|---|
| `file_id` | `guid` | ☑ | | |
| `subject_id` | `int32` | ☑ | | |
## Table Columns
The columns of the table `subject` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `filedata` | `byte[]` | File Data | ☑ | |
| `filename` | `string` | File Name | ☑ | |
| `mimetype` | `string` | MIME Type | ☑ | |