Jump to content

Where is in ps_address province ?

Recommended Posts

Hi there,


i need to know where to find Country Province in prestashop database via phpmyadmin.

I've found some usefull results in the table ps_address as shown below:

id_address int(10) UNSIGNEDNoNoneAUTO_INCREMENT Change  Drop
id_country int(10) UNSIGNEDNoNone Change  Drop
id_state int(10) UNSIGNEDYesNULL Change  Drop
id_customer int(10) UNSIGNEDNo0 Change  Drop
id_manufacturer int(10) UNSIGNEDNo0 Change  Drop
id_supplier int(10) UNSIGNEDNo0 Change  Drop
id_warehouse int(10) UNSIGNEDNo0 Change  Drop
alias varchar(32) utf8_general_ciNoNone Change  Drop
company varchar(255) utf8_general_ciYesNULL Change  Drop
lastname varchar(255) utf8_general_ciNoNone Change  Drop
firstname varchar(255) utf8_general_ciNoNone Change  Drop
address1 varchar(128) utf8_general_ciNoNone Change  Drop
address2 varchar(128) utf8_general_ciYesNULL Change  Drop
postcode varchar(12) utf8_general_ciYesNULL Change  Drop
city varchar(64) utf8_general_ci No	None

but i haven't see province

Anyone knows where to find this ???

Maybe it is in another table ?

Share this post

Link to post
Share on other sites

Hey tristan,

province ( italian name ) is id_state in DB.

It's  State in english....that is a sub-region of a country....



Edited by Fabry (see edit history)

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More