Oracle ATG Web Commerce - Tables Used in the Site Repository

Tables Used in the Site Repository

The following tables are used in the SiteRepository.

site_template

Primary key: site_template1_p

Property	Column	Nullable	Type	Length
`id`	`id`	no	varchar	40
`name`	`name`	no	varchar	254
`description`	`description`	no	varchar	254
`itemMappingID`	`item_mapping_id`	yes	varchar	40

site_configuration

Primary key: site_configurat1_p

Property	Column	Nullable	Type	Length
`id`	`Id`	no	varchar	40
`name`	`name`	no	varchar	254
`description`	`description`	no	varchar	254
`siteTemplate`	`template`	yes	varchar	40
`productionURL`	`production_url`	yes	varchar	254
`enabled`	`enable`	no	one-digit
`siteDownURL`	`site_down_url`	yes	varchar	254
`openDate`	`open_date`	yes	datetime
`preOpeningURL`	`pre_opening_url`	yes	varchar	254
`closingDate`	`closing_date`	yes	datetime
`postClosingURL`	`post_closing_url`	yes	varchar	254
`modificationTime`	`modification_time`	yes	datetime
`creationTime`	`creation_time`	yes	datetime
`author`	`author`	yes	varchar	254
`lastModifiedBy`	`last_modified_by`	yes	varchar	254
`siteIcon`	`site_icon`	yes	varchar	254
`favicon`	`favicon`	yes	varchar	254
`sitePriority`	`site_priority`	yes	integer
`contextRoot`	`context_root`	yes	varchar	254

site_additional_urls

Primary Key: siteadditio_url1_p

Property	Column	Nullable	Type	Length
`additionalProductionURLs`	`additional_production _url`	yes	varchar	254

site_group

Primary Key: site_group1_p

Property	Column	Nullable	Type	Length
`id`	`id`	no	varchar	254
`displayName`	`display_name`	yes	varchar	254

site_group_sites

Primary Key: site_group_sites_p

Property	Column	Nullable	Type	Length
`site`	`site_id`	no	varchar	40

site_group_shareable_types

Primary Key: site_group_share_p

Property	Column	Nullable	Type	Length
`shareableTypes`	`shareable_types`	no	varchar (enum string)	254

site_type

Primary Key: site_type_p

Property	Column	Nullable	Type	Length
`siteType`	`site_type`	no	varchar (enum string)	254