Home | Projects | Banking System | Table: City Mast

Table: City Mast

Font size: Decrease font Enlarge font

Table Name : City_mast

Create Table City_mast

City_code Varchar(8),
City_name Varchar(25),
City_type Varchar(1),
City_Dial_code Varchar(10),
Short_name Varchar(10),
State_code Varchar(8),
Country_code Varchar(3)

City_code : Fixed lenght city_code of 8 character, the city_code in incremental and starts from 00000001 to 99999999

City_name : Name of the City.

City_type : Type of city stored as 1 digit identifier for city type eg A- District, B- Tehsil, C- Village.

City_Dial_code : Tele phone dial code of the city

Short_name :Short Name for the City, these short name in certain system is also a self decriptive code eg in railways system, airline, courier etc.

State_code : Code of the state of the city.

Country_code : Code of the country


Following are the integrity constratints for the table City_mast

Primary Key >> City_codeForeign Key >> State_code (state_mast table)

Foreign Key >> State_code (state_mast table)

Foreign Key >> Country_ code (country_mast table)

Subscribe to comments feed Comments (0 posted)

total: | displaying:

Post your comment

  • Bold
  • Italic
  • Underline
  • Quote

Please enter the code you see in the image:

  • Email to a friend Email to a friend
  • Print version Print version
  • Plain text Plain text

Tagged as:

No tags for this article

Rate this article