ข้ามไปที่เนื้อหา

S7 — ระบบคุ้มครองพยาน (Witness Protection) — Database Schema

แหล่งที่มา (machine-readable)

โครงสร้างดึงสดจาก live DB. คำอธิบาย = docx/markdown ที่ curate. ข้อมูลแบบ machine-readable อยู่ใน schema.json · ดัชนีรวมทุกระบบ: ../catalog.json

ภาพรวม

Metric Value
System S7
Host / DB 10.136.27.149 / PSDBPRDDB
Schema WITNESS
Migrated to single DB ✅ ใช่
Tables 109
Columns 1475 (450 มีคำอธิบาย)
Explicit FK 4

Table Inventory

Table Columns FK Description
Area 9 0
AttachFile 12 0
AttachStatement 10 0
Budget 12 0
BudgetType 9 0
BudgetYear 13 0
CaseType 9 0
Department 16 0
District 12 0
Document13 25 0
DxcServicesApi 16 0
DxcServicesParamMap 4 0
Expense 20 0
ExpenseCategory 11 0
ExpenseCategory_copy 11 0
ExpenseCutOffType 9 0
ExpenseDetails 27 0
ExpenseDetails__Estimate 26 0
ExpenseMaster 3 0
ExpenseType 15 0
Expense_Estimate 21 0
Honorable_Meeting_Agenda 14 4
LegalProcess 9 0
LegalProcessFollowUp 13 0
LegalProcessStatus 9 0
LogActivitiesDXC 10 0
LogCallServiceCenter 8 0
LogChangeProtectedDate 12 0
LogGetApi 8 0
LogMscSetApi 13 0
LogPetitionProcess 16 0
Log_Activity 12 0
Map2 6 0
MapPetitionProtection 48 0
MeetingRoom 8 0
MeetingRoomOnAgenda 10 0
Menu 15 0
Notification 6 0
NotificationType 4 0
OLE DB Destination 48 0
OTP 6 0
Offense 11 0
PetitionCompensation 37 0
PetitionDamageAndClaims 21 0
PetitionFromPortal 3 0
PetitionProtection 46 0
PetitionProtectionOrder 14 0
PetitionProtectionOrderApproved 31 0
Petitioner 61 0
PetitionsUsersOwner 10 0
PrintFileVersion 17 0
ProtectionBudgetAllocate 16 0
ProtectionIntendant 13 0
ProtectionLegalProcess 10 0
ProtectionPurpose 19 0
ProtectionRelatePerson 25 0
ProtectionTeam 11 0
ProtectionTraceCase 12 0
ProtectionTraceCaseNotification 13 0
ProtectionType 7 0
Province 15 0
ProvincePolygon 3 0
Region 9 0
Roles 10 0
RolesPermission 4 0
SubDistrict 13 0
Table_1 2 0
Title 9 0
Tm_BloodType 9 0
Tm_Career 10 0
Tm_Damage 2 0
Tm_ExpenseSaveType 8 0
Tm_ExpenseTypeUnit 8 0
Tm_Gender 8 0
Tm_LawyerSuggesting 10 0
Tm_MaritalStatus 10 0
Tm_Nationality 10 0
Tm_Notification 9 0
Tm_Positions 8 0
Tm_ProtectPlace 10 0
Tm_ProtectionTeam 10 0
Tm_ProtectionTeamPerson 17 0
Tm_ProtectionTeamUser 4 0
Tm_ProtectionTraceCaseResult 9 0
Tm_ProtectionTraceCaseType 9 0
Tm_ProtectorType 9 0
Tm_Race 9 0
Tm_ReasonToEndOfProtect 9 0
Tm_RelatePosition 11 0
Tm_Religion 9 0
Tm_ResolutionOnAgenda 10 0
Tm_SendFile 10 0
Tm_SendPlace 10 0
Tm_ThreeMonths 3 0
Tm_WaitToApproveByDirector 10 0
Tm_WaitToApproveByDirectorDeputyGeneral 10 0
Tm_WaitToApproveByDirectorGeneral 10 0
Tm_WayToProtect 10 0
Tm_WitnessDepend 10 0
Tm_WitnessProtectDepartment 10 0
Tm_WitnessStatus 10 0
Tm_WitnessStatusTimeLine 10 0
UserRoles 3 0
Users 26 0
Users_External 19 0
Users_Honorable 16 0
Witness 72 0
WitnessOther 12 0
WitnessRelateType 9 0

หน้าที่เกี่ยวข้อง