Skip to content

loyalty / bảng đơn lẻ (3) ​

Trang sinh tự động

Sinh từ ad83b0aea — chạy 820 migration lên PostgreSQL 17 rồi đọc pg_catalog. Mô tả bảng và cột lấy từ COMMENT ON. Không sửa tay: lần chạy docgen sau sẽ ghi đè.

3 bảng. Quay lại loyalty.

P4-11. Affiliate link per (owner, app, Campaign[/Campaign Product]) with opaque code; ACTIVE|DISABLED. OWN read.

public.affiliate_links · 14 cột · 5 check · 1 unique · 4 index · 1 policy · 3 trigger · RLS bật

CộtKiểuKhoáMô tả
iduuidNOT NULLPK
owner_account_iduuidNOT NULLFK → app_memberships
owner_appapp_codeNOT NULLFK → app_memberships
codetextNOT NULL
target_campaign_iduuidNOT NULLFK → campaign_products
target_campaign_product_iduuidFK → campaign_products
statustextNOT NULL
disabled_attimestamptz
disabled_byuuidFK → accounts
disabled_reasontext
correlation_idcorrelation_refNOT NULL
created_attimestamptzNOT NULL
updated_attimestamptzNOT NULL
versionintegerNOT NULL

Khoá chính: id

Trỏ ra (4):

  • disabled_by → accounts · ON DELETE RESTRICT
  • owner_account_id, owner_app → app_memberships · ON DELETE RESTRICT
  • target_campaign_id → campaigns · ON DELETE RESTRICT
  • target_campaign_product_id, target_campaign_id → campaign_products · ON DELETE RESTRICT

Được trỏ tới (2): attribution_assignments, attribution_touches

member_tier_history ​

U28-P3-01. APPEND_ONLY_RETAIN customer Tier history of the new model: head = current Tier (occurred_at = reachedAt); from/to names are snapshots at record time (rename/delete never rewrites them).

public.member_tier_history · 19 cột · 9 check · 1 unique · 7 index · 2 policy · 3 trigger · RLS bật

CộtKiểuKhoáMô tả
iduuidNOT NULLPK
account_iduuidNOT NULLFK → member_tier_history
audiencetextNOT NULLFK → tier_definitions
previous_iduuidFK → member_tier_history
occurred_attimestamptzNOT NULL
reasontextNOT NULL
sourcetextNOT NULL
from_definition_iduuidFK → tier_definitions
from_nametext
to_definition_iduuidNOT NULLFK → tier_definitions
to_nametextNOT NULL
set_version_iduuidNOT NULLFK → tier_set_versions
effective_rankbigintNOT NULL
source_pointsbigint
source_reftext
source_iduuid
reevaluation_iduuidFK → tier_reevaluations
correlation_idcorrelation_refNOT NULL
created_attimestamptzNOT NULL

Khoá chính: id

Trỏ ra (6):

  • account_id → accounts · ON DELETE RESTRICT
  • from_definition_id, audience → tier_definitions · ON DELETE RESTRICT
  • previous_id, account_id → member_tier_history · ON DELETE RESTRICT
  • reevaluation_id → tier_reevaluations · ON DELETE RESTRICT
  • set_version_id → tier_set_versions · ON DELETE RESTRICT
  • to_definition_id, audience → tier_definitions · ON DELETE RESTRICT

Được trỏ tới (1): member_tier_history

sale_role_transfers ​

FU-866. One User -> Sale Tier transfer per USER_REQUEST application (SA-12, A-TIER-05): status, what was carried (valid rank only, lots keep their expiry) and acknowledged_at = the person saw the result (GAP-865). Written only by tier.perform_sale_transfer / tier.sale_transition_acknowledge; never deleted.

public.sale_role_transfers · 18 cột · 7 check · 1 unique · 2 index · 0 policy · 5 trigger · RLS bật

CộtKiểuKhoáMô tả
iduuidNOT NULLPK
application_iduuidNOT NULLFK → sale_applications
account_iduuidNOT NULLFK → accounts
statustextNOT NULL
attemptsintegerNOT NULL
failure_codetext
from_tier_version_iduuidFK → tier_versions
to_tier_version_iduuidFK → tier_versions
assignment_iduuidFK → tier_assignments
evaluation_iduuidFK → tier_evaluations
carried_rankbigint
carried_lotsinteger
completed_attimestamptz
acknowledged_attimestamptz
correlation_idcorrelation_refNOT NULL
created_attimestamptzNOT NULL
updated_attimestamptzNOT NULL
versionintegerNOT NULL

Khoá chính: id

Trỏ ra (6):

  • account_id → accounts · ON DELETE RESTRICT
  • application_id → sale_applications · ON DELETE RESTRICT
  • assignment_id → tier_assignments · ON DELETE RESTRICT
  • evaluation_id → tier_evaluations · ON DELETE RESTRICT
  • from_tier_version_id → tier_versions · ON DELETE RESTRICT
  • to_tier_version_id → tier_versions · ON DELETE RESTRICT

Được trỏ tới: không có

Sinh từ ad83b0aea · 820 migration · PostgreSQL 17