Home | Projects | Banking System | Table: City Mast

Table: City Mast

By
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 (14 posted)

avatar
asad 20/07/2018 01:59:37
nice post
avatar
I have read many more blogs and all of them base on the differ topic. I think this one is good way to know the information about the world. So Lfe is gift of God and try to use it with good works of life.
avatar
cheap burberry scarf 18/10/2018 07:55:26
Short Name for the City, these short name in certain system is also a self decriptive code eg in railways system, airline, courier etc.
avatar
Honey and Cinnamon 15/08/2018 14:58:11
A great website with interesting and unique material what else would you need.
avatar
Triticale 15/08/2018 18:15:00
Very nice blog and articles. I am realy very happy to visit your blog. Now I am found which I actually want. I check your blog everyday and try to learn something from your blog. Thank you and waiting for your new post.
avatar
Mulberries 15/08/2018 18:22:21
I want to say thanks to you. I have bookmark your site for future updates.
avatar
Benefits of Breakfast 15/08/2018 18:28:24
Hi buddies, it is great written piece entirely defined, continue the good work constantly.
avatar
Fenugreek 15/08/2018 18:35:42
It is imperative that we read blog post very carefully. I am already done it and find that this post is really amazing.
avatar
Rice 16/08/2018 23:54:36
I curious more interest in some of them hope you will give more information on this topics in your next articles.
avatar
Black Radish 17/08/2018 00:16:23
Excellent Blog! I would like to thank for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. I wanted to thank you for this websites! Thanks for sharing. Great websites!
avatar
Boost Blood Levels 17/08/2018 00:35:32
I've been looking for info on this topic for a while. I'm happy this one is so great. Keep up the excellent work
1 2 next total: 13 | displaying: 1 - 10

Post your comment

  • Bold
  • Italic
  • Underline
  • Quote

Please enter the code you see in the image:

Captcha
  • 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

0