Clarification on Partition_Column in Teradata

Database
Enthusiast

Clarification on Partition_Column in Teradata

I have a table with below DDL:

CREATE SET TABLE X,NO FALLBACK ,

NO BEFORE JOURNAL,

NO AFTER JOURNAL,

CHECKSUM = DEFAULT,

DEFAULT MERGEBLOCKRATIO

(

A INTEGER,

B VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,

C VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,

D VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,

E VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,

F VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,

G VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,

PARTITION_COLUMN INTEGER)

PRIMARY INDEX ( A)

PARTITION BY RANGE_N(PARTITION_COLUMN BETWEEN 100000000 AND 307000000 EACH 100000 ,

311020100 AND 315998900 EACH 500 ,

316100000 AND 317020000 EACH 100000 ,

317020100 AND 317021600 EACH 100 ,

317022000 AND 317027000 EACH 1000 ,

317030000 AND 317051700 EACH 100 ,

317053000 AND 317071000 EACH 1000 ,

317071100 AND 317071190 EACH 10 ,

317072000 AND 317072000 EACH 1 ,

317072210 AND 317072250 EACH 10 ,

317073700 AND 317077900 EACH 100 ,

317078000 AND 317089100 EACH 1000 ,

317120000 AND 317126000 EACH 1000 ,

317130100 AND 317152800 EACH 100 ,

317153100 AND 317158900 EACH 500 ,

317170000 AND 317171000 EACH 500 ,

317171100 AND 317171190 EACH 10 ,

317172000 AND 317189100 EACH 1000 ,

317220000 AND 317250900 EACH 500 ,

317251100 AND 317251900 EACH 100 ,

317252000 AND 317260200 EACH 1000 ,

317270000 AND 317288800 EACH 1000 ,

317320000 AND 317350300 EACH 10000 ,

317351100 AND 317488000 EACH 10000 ,

317520100 AND 318000507 EACH 1000 ,

320000000 AND 320000000 EACH 1 ,

324600000 AND 998000000 EACH 1000000 ,

NO RANGE OR UNKNOWN);

Can anybody let me know what is the use of PARTITION_COLUMN and how does it work.

Also what does each 1000/100 implies here?

Regards