Skip to content

Data Profile: eqkt

Generated: 2025-11-26 23:27:46.811829 Schema: raw.eqkt Total Rows: 415,661 Columns: 8 Completeness: 81.46%

Source Files

File Rows Size
20251105001908_eqkt_6120.csv 415,661 51.2 MB
Total 415,661 51.2 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 MANDT integer INTEGER No 0.00% 0
2 EQUNR string VARCHAR(27) No 0.00% 0
3 SPRAS string VARCHAR(1) No 0.00% 0
4 EQKTX string VARCHAR(60) No 0.00% 0
5 KZLTX string VARCHAR(1) Yes 97.76% 0
6 TXASP string VARCHAR(1) Yes 50.55% 0
7 EQKTU string VARCHAR(60) No 0.00% 0
8 TEXTCHANGEDDATETIME string VARCHAR(21) No 0.00% 0

Detailed Column Profiles

1. MANDT

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

100

2. EQUNR

Type: string → VARCHAR(27)
Nullable: No

Metric Value
Total Rows 415,661
Non-null 415,661 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 18
Avg Length 0.0
Buffered Length 27 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 415,661 - Parse Success: 415,661 / 415,661

Sample Values: 

000000000001105442, 000000000001112425, 000000000001186506, 000000000001186858, 000000000001190302

3. SPRAS

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 415,661
Non-null 415,661 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 415,661 - Parse Success: 415,661 / 415,661

Sample Values: 

D

4. EQKTX

Type: string → VARCHAR(60)
Nullable: No

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

Sample Values: 

G4ZR W                                  , Tank 1                                  , G4ER I-CYBLE/P                          , G6ER I-CYBLE/P                          , Pellets Silo für Forecast

5. KZLTX

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 415,661
Non-null 9,296 (2.2%)
Null 406,365 (97.76%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 415,661 - Parse Success: 415,661 / 415,661

Sample Values: 

X

6. TXASP

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 415,661
Non-null 205,543 (49.4%)
Null 210,118 (50.55%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 415,661 - Parse Success: 415,661 / 415,661

Sample Values: 

X

7. EQKTU

Type: string → VARCHAR(60)
Nullable: No

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

Sample Values: 

G4ZR W                                  , TANK 1                                  , G4ER I-CYBLE/P                          , G6ER I-CYBLE/P                          , PELLETS SILO FÜR FORECAST

8. TEXTCHANGEDDATETIME

Type: string → VARCHAR(21)
Nullable: No

Metric Value
Total Rows 415,661
Non-null 415,661 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 14
Avg Length 0.0
Buffered Length 21 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 415,661 - Parse Success: 415,661 / 415,661

Sample Values: 

0, 20250530104510, 20241128124917, 20241128124604, 20241128124634

PostgreSQL DDL

See eqkt_schema.sql

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