Pages (Table)

pages (Table)

Pages can be organized in hierarchical pages tree structure, where some pages can be "parents" of other pages. Pages higher in tree structure are called master ("parent") pages; pages lower in tree structure are called "child" pages.

Applies To

AdServer Database

Parameters

Parameter name	Description
page_id	A Long unique page autonumber
page_master_id	A Long variable containing "parent" page number
page_category_id	A Long variable containing category number
page_code_name	A Text variable containing page code name
page_name	A Text variable containing page name
writer_id	A Long variable containing writer
write_dt	A Date variable containing date of write
change_dt	A Date variable containing date of change

Example

default_page (page_id = 0; page_master_id = Null) - root of the pages
+ aliaweb (page_id = 1; page_master_id = 0) - child of default page
++ finance (page_id = 2; page_master_id = 1) - child of aliaweb page
+++ finance_title_page (page_id = 3; page_master_id = 2) - child of finance page
...
...
...

Remarks

Relationship between parent and child item of the tree above is created by page_id parameter of "parent" page and page_master_id parameter of "child" page. If Null is entered for page_master_id parameter, the page becomes a tree structure root.

Hierarchical tree structure is usefull for example when user defines only one default banner for all pages, defined in structure. User can also specify, that campaign belongs to entered zone and it's all subzones.

Page code name parameter contains page name writed without spaces and in lower case convention. It is a symbolic page name used for example in banner retrieving.

Examples

Minimal structure for any web or internet portal is:
default_page (page_id = 0; page_master_id = Null) - root of the pages
+ page_1 (page_id = 1; page_master_id = 0) - child of default page
+ page_2 (page_id = 2; page_master_id = 0) - child of default page
+ page_3 (page_id = 3; page_master_id = 0) - child of default page
...
...
...
for all pages.

Following example shows default page definition:

Parameter name	Default Value
page_id	0
page_master_id	Null
page_category_id	15
page_code_name	"default_page"
page_name	"Default page"
writer_id	-2
write_dt	Now()
change_dt	Null