Database documentation - does it exist?

Next topic

Author	Message
Per-Espen Kindblad	Friday 13 January 2006 3:14:24 am I'm looking for a description of the database, what the different tables are (meant to do), with relations etc. I guess someone has this..or eZ systems got some docs on this..but I can't find anything in the ez-doc. Can someone confirm that this does exist? ..or else I have to write a paperback about the ez database as well, hehe ;) ..hmm..too many book-projects nowadays. Per-Espen
Esteban Rodriguez	Friday 13 January 2006 5:06:24 am Hi, There's a database schema loaded up in the old docs: http://ez.no/products/ez_publish_cms/documentation/reference/database_diagram that might help, Esteban I have great faith in fools; self-confidence my friends call it. http://presencia.net
Per-Espen Kindblad	Friday 13 January 2006 5:20:34 am Thanks, but a diagram is not the problem, this can be automatic generated by using different script. I'm searching for table-explanations etc. Btw. the link does not exist. The image is "gone": http://ez.no/var/ezno/storage/images-versioned/324759/1-eng-GB/database_diagram_031.gif
Frederik Holljen	Friday 13 January 2006 5:23:47 am The image is there, it just doesn't show with IE because of some IE bug.
Per-Espen Kindblad	Friday 13 January 2006 5:45:47 am It does not help to change the code, or help to change width or height for the image in the code, but if ez resizes the image(the database-diagram-gif), it will work. The image is tooo large ;) (not in kb, but in width and height for IE to display it). Per-Espen

eZ debug

Timing:	Jan 18 2025 16:04:13
Script start
Timing:	Jan 18 2025 16:04:13
Module start 'layout'
Timing:	Jan 18 2025 16:04:13
Module start 'content'
Timing:	Jan 18 2025 16:04:14
Module end 'content'
Timing:	Jan 18 2025 16:04:14
Script end

Main resources:

Total runtime	0.8095 sec
Peak memory usage	4,096.0000 KB
Database Queries	65

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0038	587.9375	152.6250
Module start 'layout'	0.0039	0.0025	740.5625	39.4453
Module start 'content'	0.0064	0.8014	780.0078	600.8359
Module end 'content'	0.8078	0.0017	1,380.8438	12.1563
Script end	0.8095		1,393.0000

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	0.3706	16	0.0002
Check MTime	0.0012	0.1508	16	0.0001
Mysql Total
Database connection	0.0005	0.0594	1	0.0005
Mysqli_queries	0.7574	93.5579	65	0.0117
Looping result	0.0005	0.0645	63	0.0000
Template Total	0.7844	96.9	2	0.3922
Template load	0.0018	0.2185	2	0.0009
Template processing	0.7826	96.6720	2	0.3913
Template load and register function	0.0001	0.0115	1	0.0001
states
state_id_array	0.0008	0.1001	1	0.0008
state_identifier_array	0.0010	0.1277	2	0.0005
Override
Cache load	0.0015	0.1867	27	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0725	3	0.0002
Fetch class attribute name	0.0010	0.1221	8	0.0001
XML
Image XML parsing	0.0013	0.1560	3	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0019	10	0.0000
General
dbfile	0.0009	0.1100	25	0.0000
String conversion	0.0000	0.0010	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
5	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
5	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
6	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 19 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs