tbl_countrystatecitymaster

1743 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
enumid serial 10 √ nextval('tbl_countrystatecitymaster_enumid_seq'::regclass)

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single geographical entry (Country, State, or City).
enumtypeid int4 10 √ null

FK: public.tbl_enumtype.id (Presumed Foreign Key)
Meaning: Categorizes the entry as a Country (1), State (2), or City (3).
Logic: Used to determine the level in the hierarchy.
enumname varchar 100 √ null

The name of the geographical entity.
Format: Varchar/Text
Example: India, Gujarat, Nadiad.
enumparentid int4 10 √ null

FK: public.tbl_countrystatecitymaster.enumid (Self-Referencing Foreign Key)
Meaning: The parent ID in the hierarchy.
Logic: Links a State to its Country (e.g., Gujarat.enumparentid = India.enumid) or a City to its State.

Indexes

Constraint Name Type Sort Column(s)
tbl_countrystatecitymaster_pk_tbl_countrystatecitymaster Primary key Asc enumid

Relationships

Close relationships within degrees of separation