lolalola
lolalola

Reputation: 3823

magento database

i need found in magento database information about users: description , status (login or not). Where i can find this information in data base?

Thanks

Upvotes: 1

Views: 1423

Answers (2)

Lee Z
Lee Z

Reputation: 11

Here's a good tutorial I found about EAV in Magento:

http://fishpig.co.uk/2010/06/07/magento-database-structure-eav/

You can also see a diagram of the Magento database by Googling Magento Database.

Upvotes: 1

Paolo
Paolo

Reputation: 22638

Magento uses an EAV structure so finding information can be tricky.

There is a slightly out-of-date but useful overview diagram here: http://inchoo.net/wp-content/uploads/2008/10/magento_v116-database_diagram.pdf

To answer part of your question, I don't think Magento stores the login status in the database, that would be stored in the session. Other details like description/username will be in one of the entity value tables.

Upvotes: 2

Related Questions