Data Profile: t499s¶
Generated: 2025-11-25 04:34:49.063889 Schema: raw.t499s Total Rows: 562 Columns: 5 Completeness: 99.86%
Source Files¶
| File | Rows | Size |
|---|---|---|
| 20251105002047_t499s_6120.csv | 562 | 0.0 MB |
| Total | 562 | 0.0 MB |
Column Summary¶
| # | Column | Type | PostgreSQL | Nullable | Nulls | Unique |
|---|---|---|---|---|---|---|
| 1 | MANDT | integer | INTEGER | No | 0.00% | 0 |
| 2 | WERKS | string | VARCHAR(6) | No | 0.00% | 0 |
| 3 | STAND | string | VARCHAR(15) | No | 0.00% | 0 |
| 4 | KTEXT | string | VARCHAR(60) | No | 0.00% | 0 |
| 5 | ADDRNUM | string | VARCHAR(15) | Yes | 0.71% | 0 |
Detailed Column Profiles¶
1. MANDT¶
Type: integer → INTEGER
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 562 |
| Non-null | 562 (100.0%) |
| Unique | 0 (0.0%) |
| Min Length | 0 |
| Max Length | 20 |
| Avg Length | 0.0 |
| Buffered Length | 30 (50% buffer) |
Type Inference: - Confidence: 100% - Rows Analyzed: 562 - Parse Success: 562 / 562
Sample Values:
2. WERKS¶
Type: string → VARCHAR(6)
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 562 |
| Non-null | 562 (100.0%) |
| Unique | 0 (0.0%) |
| Min Length | 0 |
| Max Length | 4 |
| Avg Length | 0.0 |
| Buffered Length | 6 (50% buffer) |
Type Inference: - Confidence: 100% - Rows Analyzed: 562 - Parse Success: 562 / 562
Sample Values:
3. STAND¶
Type: string → VARCHAR(15)
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 562 |
| Non-null | 562 (100.0%) |
| Unique | 0 (0.0%) |
| Min Length | 0 |
| Max Length | 10 |
| Avg Length | 0.0 |
| Buffered Length | 15 (50% buffer) |
Type Inference: - Confidence: 100% - Rows Analyzed: 562 - Parse Success: 562 / 562
Sample Values:
4. KTEXT¶
Type: string → VARCHAR(60)
Nullable: No
| Metric | Value |
|---|---|
| Total Rows | 562 |
| Non-null | 562 (100.0%) |
| Unique | 0 (0.0%) |
| Min Length | 0 |
| Max Length | 40 |
| Avg Length | 0.0 |
| Buffered Length | 60 (50% buffer) |
Type Inference: - Confidence: 100% - Rows Analyzed: 562 - Parse Success: 562 / 562
Sample Values:
Untergeschoss , 8. Stock Gang innerhalb Wohnung , 9. Stock Bad innerhalb Wohnung , Estrich , Externer Standort
5. ADDRNUM¶
Type: string → VARCHAR(15)
Nullable: Yes
| Metric | Value |
|---|---|
| Total Rows | 562 |
| Non-null | 558 (99.3%) |
| Null | 4 (0.71%) |
| Unique | 0 (0.0%) |
| Min Length | 0 |
| Max Length | 10 |
| Avg Length | 0.0 |
| Buffered Length | 15 (50% buffer) |
Type Inference: - Confidence: 100% - Rows Analyzed: 562 - Parse Success: 562 / 562
Sample Values:
PostgreSQL DDL¶
See t499s_schema.sql
Generated by process-csv-to-postgres v1.0.0