Skip to content

Data Profile: sap_anlage

Generated: 2025-11-27 00:23:44.631876 Schema: raw_results.sap_anlage Total Rows: 70,055 Columns: 7 Completeness: 100.00%

Source Files

File Rows Size
sap_anlage.csv 70,055 5.0 MB
Total 70,055 5.0 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 OBJECTID integer INTEGER No 0.00% 0
2 recz integer INTEGER No 0.00% 0
3 anlage integer INTEGER No 0.00% 0
4 loevm string VARCHAR(6) No 0.00% 0
5 anlart string VARCHAR(6) No 0.00% 0
6 vstelle numeric NUMERIC(12,2) No 0.00% 0
7 MD_prozessiert timestamp TIMESTAMP No 0.00% 0

Detailed Column Profiles

1. OBJECTID

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 70,055
Non-null 70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values: 

69918, 69969, 69983, 70005, 70009

2. recz

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 70,055
Non-null 70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values: 

69918, 69969, 69983, 70005, 70009

3. anlage

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 70,055
Non-null 70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values: 

2047343, 2047350, 2047358, 2047360, 2047368

4. loevm

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 70,055
Non-null 70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values: 

NULL, X

5. anlart

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 70,055
Non-null 70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values: 

NBA, NHE, XWAS, XABF, UZAE

6. vstelle

Type: numeric → NUMERIC(12,2)
Nullable: No

Metric Value
Total Rows 70,055
Non-null 70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values: 

2204023.0, 2204642.0, 2204678.0, 2210837.0, 2210839.0

7. MD_prozessiert

Type: timestamp → TIMESTAMP
Nullable: No

Metric Value
Total Rows 70,055
Non-null 70,055 (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: 70,055 - Parse Success: 70,055 / 70,055

Sample Values: 

2025-11-02 00:00:00

PostgreSQL DDL

See sap_anlage_schema.sql

Generated by process-csv-to-postgres v1.0.0