Master Data — Dữ liệu & bảng đọc/ghi
Bảng/record thường đọc
| Mảng | Dữ liệu |
|---|---|
| Enterprise/BU/Site | Enterprise, BusinessUnit, Org/Site, service area, custom URL, Enterprise Setting (HeightUnit/WeightUnit). |
| Account/Contact | Account, BusinessUnitAccount, Contact, Account Holder, profile image. |
| Attendee | Attendee, measurements (Height/Weight), requirement (SchoolYear/Level/SwimmingCompetency), consent answers, profile avatar/image. |
| Subscription Config | Attendee_Subscription, Attendee_ProductSet, Subscription/SubscriptionExtra/ProductSet scope. |
| Customization | Customization items (Reference_Enabled/_Text/_Required/_Options), CustomConsent1..3, consent/medical customization. |
| Program setup | Term, ProgramCategory, Program, TermProgramSet, TermProgramSetCapacity, TermProduct/session. |
| Site links | OrgProgramCategory (site–category selection), booking rule options, payment option config. |
| Staff links | Employee, OrgEmployee, EmployeePermissionTemplate, TrackingCode (colorCode). |
| Images | Upload/crop metadata, built-in avatar/system image URL. |
Ghi chú bảng đọc/ghi
| Giao dịch | Record | Ghi chú |
|---|---|---|
| Gán Subscription cho attendee | Attendee_Subscription ✏️ WRITE | Một active duy nhất/attendee; thay gán = replace; chỉ Subscription active cùng BU. |
| Enable/Edit/Disable ProductSet | Attendee_ProductSet ✏️ WRITE | Enable tạo row active; Disable soft-disable; không đổi ProductSet. |
| Cấu hình requirement/consent | Customization rows 📖 READ | _Enabled gate mọi surface; _Text label chung; _Required chỉ áp dụng khi enabled. |
| Capacity program-level | TermProgramSetCapacity 📖 READ | Filter theo TermProgramSetId + Date; missing → unlimited. |
| Site-category selection | OrgProgramCategory ✏️ WRITE/READ | StatusId 500 = selected; 0 = unselected; IsActive giữ true. |
| Auto-link staff/site | OrgEmployee ✏️ WRITE | Tạo khi staff mới RoleId=Staff; idempotent; chỉ Org active. |
| Tracking code màu | TrackingCode.colorCode ✏️ WRITE/READ | Color picker → save qua /api/trackingCode; hiện swatch ở cột Color. |
Domain đọc Master Data
| Domain | Đọc để làm gì |
|---|---|
| Booking | Session availability, capacity, attendee/account context, booking rules. |
| Subscription | Term/schedule/product setup, account/attendee enrollment context. |
| Finance | Invoice account/attendee/site/BU metadata, split/routing context. |
| Payment | BU/provider settings, account payment customer, category availability. |
| Staff | Employee/staff links, timetable/site context. |
| Incident Management | Affected attendee/contact/site context. |
Liên quan
- Kiến trúc & dữ liệu — Enterprise/BU/Site/Account/Attendee.
- Booking, Subscription — domain đọc master data làm nguồn.