The data of your properties will be stored in the table cmsPropertyData

Here are some posts about the database schema for a older Umbraco version. But most is still actual:

http://blog.hendyracher.co.uk/umbraco-database-part-1/
http://blog.hendyracher.co.uk/umbraco-database-part-2/ ;

Can I ask why you need this information ?

Dave

well i am attempting to get certain content out of umbraco and shown instead on another website we manage. In our case its a specific "section" of umbraco content that would be more apt on a dedicated jobs site we have.

initially i was looking at the approach of posting from Umbraco utilising the ContentService.Published event within a RegisterEvents class.

This works in that i can get existing content out, but i cannot seem to access children/ancestors within this event, so i do not know how i would recognise new content once it had been published as again i cannot seem to access parent/children ids....

so my other idea was to try the other way and from the jobs website, import the relevant data from the umbraco database via a web service for example. Then presumably i could target the "top" level i want and access the content tree under this node. Im not sure yet how i would render this content within the other site but hopefully i could more easily get the content tree i require.

Havent found much in the way of documentation/help on doing this....

would you have any suggestions?

I don't know what version of Umbraco you are using. But from 6.1.x and 7.x you can use the UmbracoApiController. That way you can create a REST API to make your data accesable for other sites.

Documentation can be found here : http://our.umbraco.org/documentation/Reference/WebApi/

Dave

is working on a reply...