The ARF_SITE
table stores information about the ATG Commerce sites you have configured. See information about the site configurations that are recorded in the table in the ATG Multisite Administration Guide.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
| smallint | No | Identifier; primary key. | |
| varchar | 40 | No | The natural identifier of the site. |
| varchar | 254 | No | The name assigned to the site. This value is used when no locale is specified for a report. |
| varchar | 254 | Yes | The name assigned to the site. This value is used when an English language locale is specified for a report. |
| varchar | 254 | Yes | A description of the site. This description is used when no locale is specified for a report. |
| varchar | 254 | Yes | A description of the site. This description is used when an English language locale is specified for a report. |
| varchar | 254 | Yes | The application context path of the site. For example, |
| timestamp | Yes | The date and time that the site was launched. | |
| timestamp | Yes | The date and time that the site was closed. | |
| one-digit | No | Indicates whether the site is enabled. 0= No 1 = Yes | |
| varchar | 254 | Yes | The name of the default currency used by the site. For example, United States Dollars. |
| char | 3 | Yes | The ISO currency code of the default currency used by the site. For example, USD. |
| varchar | 254 | Yes | The default language used by the site. For example, English. |
| char | 2 | Yes | The two-character ISO language code of the default language used by the site. For example, |
| char | 3 | Yes | The three-character ISO language code of the default language used by the site. For example, |
| varchar | 254 | Yes | The name of the default catalog that is configured for the site. |
| timestamp | Yes | The date and time that the site record was last changed. | |
| timestamp | Yes | The date and time that the site record was created. | |
| timestamp | Yes | The date and time that the site record was marked as deleted. This value is null unless the record is marked as deleted. | |
| one-digit | No | Indicates that this record is the most recent record for the site. 0 = No 1 = Yes | |
| one-digit | No | Indicates that this record has been deleted. 0= No 1 = Yes |