SHP01T301
SEO 中繼資料
BusinessVersion: 2
ApprovedVersion: 2 | Review: Approved
No note.
Draft Review
Manage EntityType definition review here.
- Current Status
- Approved
- Submitted
- 2026-07-24 03:29:30Z by Sql-20260724
- Reviewed
- 2026-07-24 03:29:30Z by Sql-20260724
- Comment
- No review comment.
No draft.
Source Query
Add Attribute
Add Source Join
Add Source Mapping
Draft can configure mapping before approval.
Source SQL Preview
API 查詢即以此 SQL 對讀取複本執行（ADR 0008）。
SELECT
[M].[SeoMetaId] AS [SeoMetaId],
[M].[SeoTitle] AS [SeoTitle],
[M].[SeoMetaDescription] AS [SeoMetaDescription],
[M].[SeoCanonical] AS [SeoCanonical],
[M].[SeoMetaRobots] AS [SeoMetaRobots]
FROM [SHP01T301] [M]
;
Projection Query JSON Preview
[
{
"SeoMetaId": "SeoMetaId-001",
"SeoTitle": "SeoTitle sample",
"SeoMetaDescription": "SeoMetaDescription sample",
"SeoCanonical": "SeoCanonical sample",
"SeoMetaRobots": "SeoMetaRobots sample",
"UpdatedAt": "2026-04-08T09:30:00Z"
}
]
Attributes
| Code | Name | Type | Required | PrimaryKey | Active |
|---|---|---|---|---|---|
| SeoMetaId | SeoMetaId | string | Y | Y | Y |
| CompanyId | CompanyId | string | Y | N | N |
| Source | Source | string | N | N | N |
| Locale | Locale | string | N | N | N |
| ClientId | ClientId | string | N | N | N |
| SeoTitle | SeoTitle | string | N | N | Y |
| SeoMetaDescription | SeoMetaDescription | string | N | N | Y |
| SeoCanonical | SeoCanonical | string | N | N | Y |
| SeoMetaRobots | SeoMetaRobots | string | N | N | Y |
| ExternalSource | ExternalSource | string | N | N | N |
| ExternalId | ExternalId | string | N | N | N |
| ExtraData | ExtraData | string | N | N | N |
Source Joins
No joins.
Source Mappings
| Attribute | Alias | SourceField | Transform | Version | Active |
|---|---|---|---|---|---|
| ClientId - ClientId | M | ClientId | Direct | 1 | Y |
| CompanyId - CompanyId | M | CompanyId | Direct | 1 | Y |
| ExternalId - ExternalId | M | ExternalId | Direct | 1 | Y |
| ExternalSource - ExternalSource | M | ExternalSource | Direct | 1 | Y |
| ExtraData - ExtraData | M | ExtraData | Direct | 1 | Y |
| Locale - Locale | M | Locale | Direct | 1 | Y |
| SeoCanonical - SeoCanonical | M | SeoCanonical | Direct | 1 | Y |
| SeoMetaDescription - SeoMetaDescription | M | SeoMetaDescription | Direct | 1 | Y |
| SeoMetaId - SeoMetaId | M | SeoMetaId | Direct | 1 | Y |
| SeoMetaRobots - SeoMetaRobots | M | SeoMetaRobots | Direct | 1 | Y |
| SeoTitle - SeoTitle | M | SeoTitle | Direct | 1 | Y |
| Source - Source | M | Source | Direct | 1 | Y |