S6 — OCIPA (ช่วยเหลือผู้เสียหาย/จำเลย) — Database Schema (Legacy)¶
LEGACY DB — ยังไม่ได้ย้ายเข้า Single DB
ฐานข้อมูลนี้คือระบบเดิมที่ยังรันอยู่บนเครื่อง legacy (10.136.27.43 / DB RLPD02) — ยังไม่ได้ migrate เข้า single DB PSDBPRDDB (10.136.27.149). เอกสารนี้สร้างจาก live DB โดยตรง (scripts/gen_legacy_db_docs.py) เพื่อใช้วางแผนการย้าย ดู Legacy DB Inventory
แหล่งที่มา
คอลัมน์ / ชนิด / constraint / คำอธิบาย ดึงสดจาก DB จริง (คำอธิบาย = MS_Description ที่ฝังในฐานข้อมูล) — authoritative
Entity Relationship Diagram¶
Schema ใหญ่ — แยกเป็นไดอะแกรมตามกลุ่มงาน
มี 224 ตาราง / 306 FK — แสดงรวมไดอะแกรมเดียวอ่านไม่ไหว จึงแยกเป็น sub-diagram ตามกลุ่มงาน (functional cluster) ด้านล่าง. ตาราง master/lookup ที่ใช้ร่วม (เช่น User, Province, Person) จะปรากฏซ้ำในหลายไดอะแกรมในฐานะ parent. ตาราง FK ฉบับเต็ม (ครบทุกความสัมพันธ์) อยู่ท้ายหน้า
ชื่อ entity ใน diagram
Mermaid ไม่รองรับอักขระไทยใน entity id จึงใช้ชื่อ ASCII แทนในบางตาราง: OCIPAFinance__OCIPAJobPaymentInformation = OCIPAFinance_ย้ายไปที่OCIPAJobPaymentInformation
คดีอาญา (Criminal Case) (68 ความสัมพันธ์)¶
erDiagram
Court ||--o{ CriminalCaseAccusedCaseDetail : "CourtID"
CriminalCaseComplainant ||--o{ CriminalCaseAccusedCaseDetail : "CriminalComplainantID"
CriminalCaseComplainant ||--o{ CriminalCaseAllegedOffenderCaseDetail : "CriminalComplainantID"
CaseCategory ||--o{ CriminalCaseCategory : "CaseCategoryID"
CriminalCaseRegistration ||--o{ CriminalCaseCategory : "CriminalCaseID"
CardType ||--o{ CriminalCaseComplainant : "CardTypeID"
CriminalCaseRegistration ||--o{ CriminalCaseComplainant : "CriminalCaseID"
MaritalStatus ||--o{ CriminalCaseComplainant : "MaritalStatusID"
Nationality ||--o{ CriminalCaseComplainant : "NationalityID"
Person ||--o{ CriminalCaseComplainant : "PersonID"
Race ||--o{ CriminalCaseComplainant : "RaceID"
Religion ||--o{ CriminalCaseComplainant : "ReligionID"
ArchivalCopy ||--o{ CriminalCaseComplainantArchivalCopy : "ArchivalCopyID"
CriminalCaseComplainant ||--o{ CriminalCaseComplainantArchivalCopy : "CriminalComplainantID"
AttachFile ||--o{ CriminalCaseComplainantAttachFile : "AttachFileID"
CriminalCaseComplainant ||--o{ CriminalCaseComplainantAttachFile : "CriminalComplainantID"
CriminalCaseComplainant ||--o{ CriminalCaseComplainantMeta : "CriminalComplainantID"
CriminalCaseComplainant ||--o{ CriminalCaseComplaintFamilyMember : "CriminalComplainantID"
Person ||--o{ CriminalCaseComplaintFamilyMember : "FamilyMemberID"
Career ||--o{ CriminalCaseComplaintIncome : "CareerID"
CriminalCaseComplainant ||--o{ CriminalCaseComplaintIncome : "CriminalComplainantID"
Province ||--o{ CriminalCaseComplaintIncome : "WorkProvinceID"
CriminalCaseComplainant ||--o{ CriminalCaseComplaintMaritail_ : "CriminalComplainantID"
MaritalStatus ||--o{ CriminalCaseComplaintMaritail_ : "MaritalStatusID"
CriminalCaseComplainant ||--o{ CriminalCaseComplaintNoIncome : "CriminalComplainantID"
CriminalCaseComplainant ||--o{ CriminalCaseComplaintParent : "CriminalComplainantID"
Address ||--o{ CriminalCaseContactPerson : "AddressID"
Person ||--o{ CriminalCaseContactPerson : "PersonID"
RelateType ||--o{ CriminalCaseContactPerson : "RelateTypeID"
CriminalCaseComplainant ||--o{ CriminalCaseDamage : "CriminalComplainantID"
Damage ||--o{ CriminalCaseDamage : "DamageID"
CriminalCaseComplainant ||--o{ CriminalCaseDisabled : "CriminalComplainantID"
Disabled ||--o{ CriminalCaseDisabled : "DisabledID"
CriminalCaseComplainant ||--o{ CriminalCaseGuilt : "CriminalComplainantID"
Guilt ||--o{ CriminalCaseGuilt : "GuiltID"
CriminalCaseInjured ||--o{ CriminalCaseHealthPrivilege : "InjuredID"
HealthPrivilege ||--o{ CriminalCaseHealthPrivilege : "PrivilegeID"
CriminalCaseComplainant ||--o{ CriminalCaseInjured : "CriminalComplainantID"
CourtLevel ||--o{ CriminalCaseJudgement : "CourtLevelID"
CriminalCaseComplainant ||--o{ CriminalCaseJudgement : "CriminalComplainantID"
CriminalCaseRegistration ||--o{ CriminalCaseNote : "CriminalCaseID"
CriminalCaseComplainant ||--o{ CriminalCaseNote : "CriminalComplainantID"
User ||--o{ CriminalCaseNote : "UserID"
Office ||--o{ CriminalCaseOffice : "CrimeSceneOfficeID"
CriminalCaseRegistration ||--o{ CriminalCaseOffice : "CriminalCaseID"
User ||--o{ CriminalCaseOffice : "UserID"
CriminalCaseComplainant ||--o{ CriminalCasePassAway : "CriminalComplainantID"
User ||--o{ CriminalCaseRegistration : "AcceptByUserID"
CaseRegistration ||--o{ CriminalCaseRegistration : "CaseRegistrationID"
Channel ||--o{ CriminalCaseRegistration : "ChannelID"
CriminalCaseStatus ||--o{ CriminalCaseRegistration : "CriminalCaseStatusID"
Office ||--o{ CriminalCaseRegistration : "OfficeID"
Office ||--o{ CriminalCaseRegistration : "SceneOfficeID"
Province ||--o{ CriminalCaseRegistration : "SceneProvinceID"
CriminalCaseComplainant ||--o{ CriminalCaseRoadAccident : "CriminalComplainantID"
CriminalCaseComplainant ||--o{ CriminalCaseRoadAccidentFinancialAssistance : "CriminalComplainantID"
RoadAccidentFinancialAssistance ||--o{ CriminalCaseRoadAccidentFinancialAssistance : "FinancialAssistanceID"
CriminalCaseComplainant ||--o{ CriminalCaseSubGuilt : "CriminalComplainantID"
SubGuilt ||--o{ CriminalCaseSubGuilt : "SubGuiltID"
CriminalCaseComplainant ||--o{ CriminalCaseVictimCaseDetail : "CriminalComplainantID"
Subdistrict ||--o{ CriminalCaseVictimCaseDetail : "LocaleSubdistrictID"
PoliceStation ||--o{ CriminalCaseVictimCaseDetail : "PoliceStationID"
CriminalCaseComplainant ||--o{ CriminalComplainantInspect : "CriminalComplainantID"
Inspect ||--o{ CriminalComplainantInspect : "InspectID"
InspectValueList ||--o{ CriminalComplainantInspect : "InspectValueListID"
User ||--o{ CriminalRPLDSystemReference : "CreateByUserID"
CriminalCaseRegistration ||--o{ CriminalRPLDSystemReference : "CriminalCaseID"
RLPDSystemReference ||--o{ CriminalRPLDSystemReference : "RLPDSystemID"งานช่วยเหลือ OCIPA (Job & Workflow) (58 ความสัมพันธ์)¶
erDiagram
PaymentType ||--o{ OCIPAFinance__OCIPAJobPaymentInformation : "PaymentTypeID"
FinanceStatus ||--o{ OCIPAFinance__OCIPAJobPaymentInformation : "StatusID"
Person ||--o{ OCIPAFinanceBeneficiary : "PersonID"
OCIPAFinance__OCIPAJobPaymentInformation ||--o{ OCIPAFinanceStatusHistory : "OCIPARegisterID"
FinanceStatus ||--o{ OCIPAFinanceStatusHistory : "StatusID"
User ||--o{ OCIPAFinanceStatusHistory : "UserID"
CriminalCaseRegistration ||--o{ OCIPAJob : "CriminalCaseID"
CriminalCaseComplainant ||--o{ OCIPAJob : "CriminalComplainantID"
JobStatus ||--o{ OCIPAJob : "JobStatusID"
JobType ||--o{ OCIPAJob : "JobTypeID"
CriminalCaseComplainant ||--o{ OCIPAJobChangWorkStepHistory : "CriminalComplainantID"
User ||--o{ OCIPAJobChangWorkStepHistory : "UserID"
OCIPAWorkStep ||--o{ OCIPAJobChangWorkStepHistory : "WorkStepID"
Compensation ||--o{ OCIPAJobComplainantCompensation : "CompensationID"
CriminalCaseComplainant ||--o{ OCIPAJobComplainantCompensation : "CriminalComplainantID"
OCIPAJobEntity ||--o{ OCIPAJobComplainantCompensation : "JobEntityID"
CriminalCaseComplainant ||--o{ OCIPAJobCriminalComplainant_ : "CriminalComplainantID"
JobType ||--o{ OCIPAJobCriminalComplainant_ : "JobTypeID"
AttachFile ||--o{ OCIPAJobCriminalComplainantAttachFile : "AttachFileID"
OCIPAWorkStep ||--o{ OCIPAJobCriminalComplainantAttachFile : "WorkStepID"
OCIPAJob ||--o{ OCIPAJobDetention : "JobID"
JobType ||--o{ OCIPAJobEntity : "JobTypeID"
BookOfMeeting ||--o{ OCIPAJobForConsiderationOfMeeting : "BookOfMeetingID"
OCIPAJobEntity ||--o{ OCIPAJobForConsiderationOfMeeting : "JobEntityID"
CourtLevel ||--o{ OCIPAJobImprisonment : "CourtLevelID"
User ||--o{ OCIPAJobMapLawyer : "UserID"
MedicalExpense ||--o{ OCIPAJobMedicalExpense : "MedicalExpenseID"
OCIPAJobEntity ||--o{ OCIPAJobOfficeOwner : "JobEntityID"
Office ||--o{ OCIPAJobOfficeOwner : "OfficeID"
User ||--o{ OCIPAJobOfficeOwner : "UpdateByUserID"
Compensation ||--o{ OCIPAJobOfficerApproveCompensation : "CompensationID"
OCIPAJobEntity ||--o{ OCIPAJobOfficerApproveCompensation : "JobEntityID"
OfficerRole ||--o{ OCIPAJobOfficerApproveCompensation : "OfficerRoleID"
OCIPAJobEntity ||--o{ OCIPAJobOfficerOpinion : "JobEntityID"
OfficerRole ||--o{ OCIPAJobOfficerOpinion : "OfficerRoleID"
Opinion ||--o{ OCIPAJobOfficerOpinion : "OpinionID"
OCIPAJobEntity ||--o{ OCIPAJobOfficerProceedAsRequired : "JobEntityID"
OfficerMapJobAttribute ||--o{ OCIPAJobOfficerProceedAsRequired : "OfficerAttributeID"
OCIPAJobEntity ||--o{ OCIPAJobOfficerSubOpinion : "JobEntityID"
OfficerRole ||--o{ OCIPAJobOfficerSubOpinion : "OfficerRoleID"
SubOpinion ||--o{ OCIPAJobOfficerSubOpinion : "SubOpinionID"
PaymentMethod ||--o{ OCIPAJobPaymentInformation : "PaymentMethodID"
PaymentStatus ||--o{ OCIPAJobPaymentInformation : "PeymentStatusID"
User ||--o{ OCIPAJobPaymentInformation : "UpdateByUserID"
Address ||--o{ OCIPAJobProxy : "AddressID"
CardType ||--o{ OCIPAJobProxy : "CardTypeID"
Person ||--o{ OCIPAJobProxy : "PersonID"
RelateType ||--o{ OCIPAJobProxy : "RelateTypeID"
User ||--o{ OCIPAJobStandard : "CreateByUserID"
RLPDStandardOptionMapGovAgen ||--o{ OCIPAJobStandard : "MappingID"
JobStatus ||--o{ OCIPAJobStatusHistory : "JobStatusID"
User ||--o{ OCIPAJobStatusHistory : "UserID"
TerminationReason ||--o{ OCIPAJobTermination : "TerminationReasonID"
OCIPAJobEntity ||--o{ OCIPAJobWaiting : "JobEntityID"
OCIPACluster ||--o{ OCIPAWorkStep : "ClusterID"
JobType ||--o{ OCIPAWorkStepPath : "OCIPAJobTypeID"
OCIPAWorkStep ||--o{ OCIPAWorkStepPath : "WorkStepID"
OCIPAWorkStep ||--o{ OCIPAWorkStepProcesss : "OCIPAWorkStepID"การรับเรื่อง/ธุรกรรมคดี (Case Registration) (42 ความสัมพันธ์)¶
erDiagram
CaseRegistrationStatus ||--o{ CaseRegistration : "CaseRegistrationStatusID"
CourtType ||--o{ CaseRegistration : "CaseTypeID"
Channel ||--o{ CaseRegistration : "ChannelID"
Office ||--o{ CaseRegistration : "OfficeID"
Province ||--o{ CaseRegistration : "SceneProvinceID"
AttachFile ||--o{ CaseRegistrationAttachFile : "AttachFileID"
CaseRegistration ||--o{ CaseRegistrationAttachFile : "CaseRegistrationID"
CaseCategory ||--o{ CaseRegistrationCategory : "CaseCategoryID"
CaseRegistration ||--o{ CaseRegistrationCategory : "CaseRegistrationID"
CaseSubCategory ||--o{ CaseRegistrationCategory : "CaseSubCategoryID"
CardType ||--o{ CaseRegistrationComplainant : "CardTypeID"
CaseRegistration ||--o{ CaseRegistrationComplainant : "CaseRegistrationID"
Person ||--o{ CaseRegistrationComplainant : "PersonID"
CaseRegistrationComplainant ||--o{ CaseRegistrationComplainantAddress : "ComplainantID"
AttachFile ||--o{ CaseRegistrationComplainantAttachFile : "AttachFileID"
CaseRegistration ||--o{ CaseRegistrationComplainantAttachFile : "CaseRegistrationID"
CaseRegistrationComplainant ||--o{ CaseRegistrationComplainantAttachFile : "ComplainantID"
Address ||--o{ CaseRegistrationContactAddress : "AddressID"
CaseRegistrationContactPerson ||--o{ CaseRegistrationContactAddress : "ContactID"
CaseRegistration ||--o{ CaseRegistrationContactPerson : "CaseRegistrationID"
CaseRegistrationComplainant ||--o{ CaseRegistrationContactPerson : "ComplainantID"
RelateType ||--o{ CaseRegistrationContactPerson : "RelateTypeID"
Address ||--o{ CaseRegistrationProxyAddress : "AddressID"
CaseRegistrationProxyPerson ||--o{ CaseRegistrationProxyAddress : "ProxyID"
CaseType ||--o{ CaseRegistrationProxyPerson : "CardTypeID"
CaseRegistrationComplainant ||--o{ CaseRegistrationProxyPerson : "ComplainantID"
Person ||--o{ CaseRegistrationProxyPerson : "PersonID"
RelateType ||--o{ CaseRegistrationProxyPerson : "RelateTypeID"
CaseRegistration ||--o{ CaseRegistrationSystemReference : "CaseRegistrationID"
RLPDSystemReference ||--o{ CaseRegistrationSystemReference : "RLPDSystemID"
User ||--o{ CaseRegistrationSystemReference : "UserID"
Office ||--o{ CaseRunning : "OfficeID"
RLPDSystemReference ||--o{ CaseRunning : "RLPDSystemID"
CaseCategory ||--o{ CaseSubCategory : "CaseCategoryID"
CaseTransactionStatus ||--o{ CaseTransaction : "CaseTransactionStatusID"
AttachFile ||--o{ CaseTransactionAttachFile : "AttachFileID"
CaseTransaction ||--o{ CaseTransactionAttachFile : "CaseID"
CaseTransaction ||--o{ CaseTransactionChangeHistory : "CaseID"
CaseTransactionStatus ||--o{ CaseTransactionChangeHistory : "CaseTransactionStatusID"
User ||--o{ CaseTransactionChangeHistory : "UserID"
CaseTransaction ||--o{ CaseTransactionProxyPerson : "CaseID"
RelateType ||--o{ CaseTransactionProxyPerson : "RelateTypeID"เรื่องร้องเรียน (Complaint) (24 ความสัมพันธ์)¶
erDiagram
Compensation ||--o{ CompensationMapComplainant : "CompensationID"
CaseRegistrationComplainant ||--o{ Complainant : "ComplainantID"
ComplaintCaseRegistration ||--o{ Complainant : "ComplaintID"
CaseRegistration ||--o{ ComplainantConsent : "CaseRegistrationID"
Consent ||--o{ ComplainantConsent : "ConsentID"
ComplaintStatus ||--o{ Complaint : "ComplaintSatusID"
ComplaintSubject ||--o{ Complaint : "ComplaintSubjectID"
AttachFile ||--o{ ComplaintCaseAttachFile : "AttachFileID"
ComplaintCaseRegistration ||--o{ ComplaintCaseAttachFile : "ComplaintID"
ComplaintCaseRegistration ||--o{ ComplaintCaseChief : "ComplaintID"
ComplaintCaseRegistration ||--o{ ComplaintCaseDetail : "ComplainantID"
ComplaintCaseRegistration ||--o{ ComplaintCaseLog : "ComplaintID"
User ||--o{ ComplaintCaseLog : "UserID"
CaseRegistrationComplainant ||--o{ ComplaintCaseProxy : "ComplainantID"
CaseRegistrationProxyPerson ||--o{ ComplaintCaseProxy : "ProxyID"
CaseRegistration ||--o{ ComplaintCaseRegistration : "CaseRegistrationID"
ComplaintCaseRegistration ||--o{ ComplaintCaseStatusHistory : "ComplaintID"
ComplaintStatus ||--o{ ComplaintCaseStatusHistory : "ComplaintStatus"
User ||--o{ ComplaintCaseStatusHistory : "UserID"
ComplaintCaseRegistration ||--o{ ComplaintCaseTerminate : "ComplaintID"
User ||--o{ ComplaintCaseTerminate : "UserID"
Complaint ||--o{ ComplaintReply : "ComplaintID"
ComplaintReply ||--o{ ComplaintReply : "ComplaintReplyID"
User ||--o{ ComplaintReply : "UserID"ให้คำปรึกษา (Counsel) (12 ความสัมพันธ์)¶
erDiagram
CaseRegistration ||--o{ CounselCase : "CaseRegistrationID"
MainCaseType ||--o{ CounselCase : "MainCaseTypeID"
User ||--o{ CounselCase : "UserID"
CaseRegistration ||--o{ CounselCaseChangeHistory : "CaseRegistrationID"
CounselStatus ||--o{ CounselCaseChangeHistory : "CounselStatusID"
CaseRegistration ||--o{ CounselCaseGroupPerson : "CaseRegistrationID"
Person ||--o{ CounselCaseGroupPerson : "PersonID"
CaseRegistration ||--o{ CounselCaseOpinion : "CaseRegistrationID"
ConsultantOpinion ||--o{ CounselCaseOpinion : "ConsultantOpinionID"
CounselCase ||--o{ CounselCaseReview : "CaseRegistrationID"
CaseRegistration ||--o{ CounselCaseTerminate : "CaseRegistrationID"
CounselCauseOfTerminate ||--o{ CounselCaseTerminate : "CounselCauseOfTerminateID"การเงิน/จ่ายเงิน (Finance & Payment) (11 ความสัมพันธ์)¶
erDiagram
Bank ||--o{ BankTranferInformation : "BankID"
PaymentInformation ||--o{ BankTranferInformation : "PaymentInfoID"
PaymentInformation ||--o{ ChequePaymentInformation : "PaymentInfoID"
FinanceUploadTransaction ||--o{ FinanceTransactionApproveUpload : "RelatedBatchID"
FinanceTransactionApproveUpload ||--o{ FinanceTransactionApproveUpload : "TransactionID"
User ||--o{ FinanceUploadTransaction : "UserID"
PaymentMethod ||--o{ PaymentInformation : "PaymentMethodID"
OCIPAJob ||--o{ PaymentOrder : "JobID"
PaymentMethod ||--o{ PaymentOrder : "PaymentMethodID"
PaymentInformation ||--o{ ReplyDocumentInformation : "PaymentInfoID"
ReplyDocument ||--o{ ReplyDocumentInformation : "ReplyDocumentID"ความเห็น/เจ้าหน้าที่/มาตรฐาน (Opinion & Officer) (13 ความสัมพันธ์)¶
erDiagram
JobAttribute ||--o{ OfficerMapJobAttribute : "JobAttributeID"
OfficerRole ||--o{ OfficerMapJobAttribute : "OfficerRoleID"
OCIPAJobApply ||--o{ OfficerMapOpinion : "OCIPAJobApplyID"
OfficerRole ||--o{ OfficerMapOpinion : "OfficerRoleID"
Opinion ||--o{ OfficerMapOpinion : "OpinionID"
OfficerRole ||--o{ OfficerMapRole : "OfficeRoleID"
User ||--o{ OfficerMapRole : "UserID"
OCIPAJobApply ||--o{ OpinionMappingSubOpinion : "OCIPAJobApplyID"
Opinion ||--o{ OpinionMappingSubOpinion : "OpinionID"
SubOpinion ||--o{ OpinionMappingSubOpinion : "SubOpinionID"
RLPDStandard ||--o{ RLPDStandardOption : "RLPDStandardID"
GovernmentAgency ||--o{ RLPDStandardOptionMapGovAgen : "GovernmentAgencyID"
RLPDStandardOption ||--o{ RLPDStandardOptionMapGovAgen : "StandardOptionID"การประชุม/คณะกรรมการ (Meeting & Delegation) (8 ความสัมพันธ์)¶
erDiagram
BookOfMeeting ||--o{ DelegationListOfMeeting : "BookOfMeetingID"
Delegation ||--o{ DelegationListOfMeeting : "DelegationID"
Term ||--o{ DelegationMeeting : "TermID"
AttachFile ||--o{ DelegationMeetingAttachFile : "AttachFileID"
DelegationMeeting ||--o{ DelegationMeetingAttachFile : "DelegationMeetingID"
BookOfMeeting ||--o{ DelegationMeetingBook : "BookOfMeetingID"
DelegationMeeting ||--o{ DelegationMeetingBook : "DelegationMeetingID"
Province ||--o{ SubCommittee : "ProvinceID"ตรวจสอบ/เชื่อมโยง (Inspect & Linkage) (6 ความสัมพันธ์)¶
erDiagram
InspectValueType ||--o{ Inspect : "InspectValueType"
Inspect ||--o{ InspectLinkageService : "InspectID"
CriminalCaseComplainant ||--o{ InspectLog : "CriminalcomplainantID"
User ||--o{ InspectLog : "UserID"
InspectValueType ||--o{ InspectValueList : "InspectValueTypeID"
User ||--o{ LinkageAccessToken : "UserID"โอนคดี/อ้างอิงระบบ (Transfer & System Ref) (7 ความสัมพันธ์)¶
erDiagram
Office ||--o{ OfficeMapRLPDSystem : "OfficeID"
RLPDSystemReference ||--o{ OfficeMapRLPDSystem : "RLPDSystemID"
CaseRegistrationSystemReference ||--o{ TransferCase : "CaseRegistrationSystemReferenceID"
CaseRegistrationSystemReference ||--o{ TransferCaseTracking : "CaseRegistrationSystemReferenceID"
RLPDSystemReference ||--o{ UserMapRLPDSystem : "RLPDSystemID"
User ||--o{ UserMapRLPDSystem : "UserID"
RLPDSystemReference ||--o{ VerdictRunning : "RLPDSystemID"หน่วยงาน (Office & Org) (4 ความสัมพันธ์)¶
erDiagram
Province ||--o{ Department_ : "ProvinceID"
Department_ ||--o{ DepartmentAddress_ : "DepartmentID"
Province ||--o{ Office : "ProvinceID"
Office ||--o{ OfficeAddress : "OfficeID"ผู้ใช้/สิทธิ/ระบบ (User, Permission, System) (35 ความสัมพันธ์)¶
erDiagram
User ||--o{ DatabaseProcess : "UserID"
User ||--o{ DatabaseProcessHistory : "UserID"
FormType ||--o{ Form : "FormTypeID"
Form ||--o{ FormMapComplainantType : "FormID"
OCIPAJobApply ||--o{ FormMapComplainantType : "OCIPAJobApplyID"
Inbox ||--o{ InboxDetail : "InboxID"
Inbox ||--o{ InboxMapOffice : "InboxID"
Office ||--o{ InboxMapOffice : "OfficeID"
Inbox ||--o{ InboxMapUser : "InboxID"
User ||--o{ InboxMapUser : "UserID"
UserLogin ||--o{ SingleLogin : "UserID"
SysGroupModule ||--o{ SysGroupMapModule : "GroupID"
SysModule ||--o{ SysGroupMapModule : "ModuleID"
SysModule ||--o{ SysPermission : "ModuleID"
SysOperation ||--o{ SysPermission : "OperationID"
SysPermission ||--o{ SysRoleMapPermission : "PermissionID"
SysRole ||--o{ SysRoleMapPermission : "RoleID"
SysModule ||--o{ SysScreen : "ModuleID"
User ||--o{ TransactonLog : "UserID"
Office ||--o{ User : "OfficeID"
Position ||--o{ User : "PositionID"
UserStatus ||--o{ User : "UserStatusID"
UserType ||--o{ User : "UserTypeID"
User ||--o{ UserEmail : "UserID"
UserAccountType ||--o{ UserLogin : "UserAccountTypeCode"
User ||--o{ UserLogin : "UserID"
User ||--o{ UserLoginHistory : "UserID"
Office ||--o{ UserMapOffice_ : "OfficeID"
User ||--o{ UserMapOffice_ : "UserID"
SysPermission ||--o{ UserMapPermission : "PermissionID"
UserAccountType ||--o{ UserMapPermission : "UserAccountTypeCode"
User ||--o{ UserMapPermission : "UserID"
User ||--o{ UserMapRole : "AssignID"
SysRole ||--o{ UserMapRole : "RoleID"
User ||--o{ UserMapRole : "UserID"ข้อมูลหลัก/พื้นที่ (Master & Geography) (18 ความสัมพันธ์)¶
erDiagram
District ||--o{ Address : "DisctrictID"
Province ||--o{ Address : "ProvinceID"
Subdistrict ||--o{ Address : "SubdistrictID"
ArchivalCopy ||--o{ AttachFileTemp : "ArchivalCopyID"
CourtGroup ||--o{ Court : "CourtGroupID"
CourtLevel ||--o{ Court : "CourtLevelID"
Province ||--o{ Court : "ProvinceID"
Province ||--o{ District : "ProvinceID"
JobType ||--o{ JobTypeMappingOCIPAJobApply : "JobTypeID"
OCIPAJobApply ||--o{ JobTypeMappingOCIPAJobApply : "OCIPAJobApplyID"
OCIPAJobEntity ||--o{ LossOfIncome : "JobEntityID"
OfficerRole ||--o{ LossOfIncome : "OfficerRoleID"
Province ||--o{ PoliceStation : "ProvinceID"
Province ||--o{ ProvinceExtension : "ProvinceID"
ProvinceType ||--o{ ProvinceExtension : "ProvinceTypeCode"
Province ||--o{ ProvinceMSC : "BelongJFSProvinceID"
PoliceStation ||--o{ ReportPoliceStatisticOfComplaints : "PoliceStationID"
District ||--o{ Subdistrict : "DistrictID"Foreign Key Relationships (306)¶
| Child | Column | Parent | Column | ON UPDATE | ON DELETE |
|---|---|---|---|---|---|
| Address | DisctrictID | District | DistrictID | NO_ACTION | NO_ACTION |
| Address | ProvinceID | Province | ProvinceID | NO_ACTION | NO_ACTION |
| Address | SubdistrictID | Subdistrict | SubdistrictID | NO_ACTION | NO_ACTION |
| AttachFileTemp | ArchivalCopyID | ArchivalCopy | ArchivalCopyID | NO_ACTION | NO_ACTION |
| BankTranferInformation | BankID | Bank | BankID | NO_ACTION | NO_ACTION |
| BankTranferInformation | PaymentInfoID | PaymentInformation | PaymentInfoID | NO_ACTION | NO_ACTION |
| CaseRegistration | CaseRegistrationStatusID | CaseRegistrationStatus | CaseRegistrationStatusID | NO_ACTION | NO_ACTION |
| CaseRegistration | CaseTypeID | CourtType | CourtTypeID | NO_ACTION | NO_ACTION |
| CaseRegistration | ChannelID | Channel | ChannelID | NO_ACTION | NO_ACTION |
| CaseRegistration | OfficeID | Office | OfficeID | NO_ACTION | NO_ACTION |
| CaseRegistration | SceneProvinceID | Province | ProvinceID | NO_ACTION | NO_ACTION |
| CaseRegistrationAttachFile | AttachFileID | AttachFile | AttachFileID | NO_ACTION | NO_ACTION |
| CaseRegistrationAttachFile | CaseRegistrationID | CaseRegistration | CaseRegistrationID | NO_ACTION | NO_ACTION |
| CaseRegistrationCategory | CaseCategoryID | CaseCategory | CaseCategoryID | NO_ACTION | NO_ACTION |
| CaseRegistrationCategory | CaseRegistrationID | CaseRegistration | CaseRegistrationID | NO_ACTION | NO_ACTION |
| CaseRegistrationCategory | CaseSubCategoryID | CaseSubCategory | CaseSubCategoryID | NO_ACTION | NO_ACTION |
| CaseRegistrationComplainant | CardTypeID | CardType | CardTypeID | NO_ACTION | NO_ACTION |
| CaseRegistrationComplainant | CaseRegistrationID | CaseRegistration | CaseRegistrationID | NO_ACTION | NO_ACTION |
| CaseRegistrationComplainant | PersonID | Person | PersonID | NO_ACTION | NO_ACTION |
| CaseRegistrationComplainantAddress | ComplainantID | CaseRegistrationComplainant | ComplainantID | NO_ACTION | NO_ACTION |
| CaseRegistrationComplainantAttachFile | AttachFileID | AttachFile | AttachFileID | NO_ACTION | NO_ACTION |
| CaseRegistrationComplainantAttachFile | CaseRegistrationID | CaseRegistration | CaseRegistrationID | NO_ACTION | NO_ACTION |
| CaseRegistrationComplainantAttachFile | ComplainantID | CaseRegistrationComplainant | ComplainantID | NO_ACTION | NO_ACTION |
| CaseRegistrationContactAddress | AddressID | Address | AddressID | NO_ACTION | NO_ACTION |
| CaseRegistrationContactAddress | ContactID | CaseRegistrationContactPerson | ContactID | NO_ACTION | NO_ACTION |
| CaseRegistrationContactPerson | CaseRegistrationID | CaseRegistration | CaseRegistrationID | NO_ACTION | NO_ACTION |
| CaseRegistrationContactPerson | ComplainantID | CaseRegistrationComplainant | ComplainantID | NO_ACTION | NO_ACTION |
| CaseRegistrationContactPerson | RelateTypeID | RelateType | RelateTypeID | NO_ACTION | NO_ACTION |
| CaseRegistrationProxyAddress | AddressID | Address | AddressID | NO_ACTION | CASCADE |
| CaseRegistrationProxyAddress | ProxyID | CaseRegistrationProxyPerson | ProxyID | NO_ACTION | NO_ACTION |
| CaseRegistrationProxyPerson | CardTypeID | CaseType | CaseTypeID | NO_ACTION | NO_ACTION |
| CaseRegistrationProxyPerson | ComplainantID | CaseRegistrationComplainant | ComplainantID | NO_ACTION | NO_ACTION |
| CaseRegistrationProxyPerson | PersonID | Person | PersonID | NO_ACTION | NO_ACTION |
| CaseRegistrationProxyPerson | RelateTypeID | RelateType | RelateTypeID | NO_ACTION | NO_ACTION |
| CaseRegistrationSystemReference | CaseRegistrationID | CaseRegistration | CaseRegistrationID | NO_ACTION | NO_ACTION |
| CaseRegistrationSystemReference | RLPDSystemID | RLPDSystemReference | RLPDSystemID | NO_ACTION | NO_ACTION |
| CaseRegistrationSystemReference | UserID | User | UserID | NO_ACTION | NO_ACTION |
| CaseRunning | OfficeID | Office | OfficeID | NO_ACTION | NO_ACTION |
| CaseRunning | RLPDSystemID | RLPDSystemReference | RLPDSystemID | NO_ACTION | NO_ACTION |
| CaseSubCategory | CaseCategoryID | CaseCategory | CaseCategoryID | NO_ACTION | NO_ACTION |
| CaseTransaction | CaseTransactionStatusID | CaseTransactionStatus | CaseTransactionStatusID | NO_ACTION | NO_ACTION |
| CaseTransactionAttachFile | AttachFileID | AttachFile | AttachFileID | NO_ACTION | NO_ACTION |
| CaseTransactionAttachFile | CaseID | CaseTransaction | CaseID | NO_ACTION | NO_ACTION |
| CaseTransactionChangeHistory | CaseID | CaseTransaction | CaseID | NO_ACTION | NO_ACTION |
| CaseTransactionChangeHistory | CaseTransactionStatusID | CaseTransactionStatus | CaseTransactionStatusID | NO_ACTION | NO_ACTION |
| CaseTransactionChangeHistory | UserID | User | UserID | NO_ACTION | NO_ACTION |
| CaseTransactionProxyPerson | CaseID | CaseTransaction | CaseID | NO_ACTION | NO_ACTION |
| CaseTransactionProxyPerson | RelateTypeID | RelateType | RelateTypeID | NO_ACTION | NO_ACTION |
| ChequePaymentInformation | PaymentInfoID | PaymentInformation | PaymentInfoID | NO_ACTION | NO_ACTION |
| CompensationMapComplainant | CompensationID | Compensation | CompensationID | NO_ACTION | NO_ACTION |
| Complainant | ComplainantID | CaseRegistrationComplainant | ComplainantID | NO_ACTION | NO_ACTION |
| Complainant | ComplaintID | ComplaintCaseRegistration | ComplaintID | NO_ACTION | NO_ACTION |
| ComplainantConsent | CaseRegistrationID | CaseRegistration | CaseRegistrationID | NO_ACTION | NO_ACTION |
| ComplainantConsent | ConsentID | Consent | ConsentID | NO_ACTION | NO_ACTION |
| Complaint | ComplaintSatusID | ComplaintStatus | ComplaintStatusID | NO_ACTION | NO_ACTION |
| Complaint | ComplaintSubjectID | ComplaintSubject | ComplaintSubjectID | NO_ACTION | NO_ACTION |
| ComplaintCaseAttachFile | AttachFileID | AttachFile | AttachFileID | NO_ACTION | NO_ACTION |
| ComplaintCaseAttachFile | ComplaintID | ComplaintCaseRegistration | ComplaintID | NO_ACTION | NO_ACTION |
| ComplaintCaseChief | ComplaintID | ComplaintCaseRegistration | ComplaintID | NO_ACTION | NO_ACTION |
| ComplaintCaseDetail | ComplainantID | ComplaintCaseRegistration | ComplaintID | NO_ACTION | NO_ACTION |
| ComplaintCaseLog | ComplaintID | ComplaintCaseRegistration | ComplaintID | NO_ACTION | NO_ACTION |
| ComplaintCaseLog | UserID | User | UserID | NO_ACTION | NO_ACTION |
| ComplaintCaseProxy | ComplainantID | CaseRegistrationComplainant | ComplainantID | NO_ACTION | NO_ACTION |
| ComplaintCaseProxy | ProxyID | CaseRegistrationProxyPerson | ProxyID | NO_ACTION | NO_ACTION |
| ComplaintCaseRegistration | CaseRegistrationID | CaseRegistration | CaseRegistrationID | NO_ACTION | NO_ACTION |
| ComplaintCaseStatusHistory | ComplaintID | ComplaintCaseRegistration | ComplaintID | NO_ACTION | NO_ACTION |
| ComplaintCaseStatusHistory | ComplaintStatus | ComplaintStatus | ComplaintStatusID | NO_ACTION | NO_ACTION |
| ComplaintCaseStatusHistory | UserID | User | UserID | NO_ACTION | NO_ACTION |
| ComplaintCaseTerminate | ComplaintID | ComplaintCaseRegistration | ComplaintID | NO_ACTION | NO_ACTION |
| ComplaintCaseTerminate | UserID | User | UserID | NO_ACTION | NO_ACTION |
| ComplaintReply | ComplaintID | Complaint | ComplaintID | NO_ACTION | NO_ACTION |
| ComplaintReply | ComplaintReplyID | ComplaintReply | ComplaintReplyID | NO_ACTION | NO_ACTION |
| ComplaintReply | UserID | User | UserID | NO_ACTION | NO_ACTION |
| CounselCase | CaseRegistrationID | CaseRegistration | CaseRegistrationID | NO_ACTION | NO_ACTION |
| CounselCase | MainCaseTypeID | MainCaseType | MainCaseTypeID | NO_ACTION | NO_ACTION |
| CounselCase | UserID | User | UserID | NO_ACTION | NO_ACTION |
| CounselCaseChangeHistory | CaseRegistrationID | CaseRegistration | CaseRegistrationID | NO_ACTION | NO_ACTION |
| CounselCaseChangeHistory | CounselStatusID | CounselStatus | CounselStatusID | NO_ACTION | NO_ACTION |
| CounselCaseGroupPerson | CaseRegistrationID | CaseRegistration | CaseRegistrationID | NO_ACTION | NO_ACTION |
| CounselCaseGroupPerson | PersonID | Person | PersonID | NO_ACTION | NO_ACTION |
| CounselCaseOpinion | CaseRegistrationID | CaseRegistration | CaseRegistrationID | NO_ACTION | NO_ACTION |
| CounselCaseOpinion | ConsultantOpinionID | ConsultantOpinion | ConsultantOpinionID | NO_ACTION | NO_ACTION |
| CounselCaseReview | CaseRegistrationID | CounselCase | CaseRegistrationID | NO_ACTION | NO_ACTION |
| CounselCaseTerminate | CaseRegistrationID | CaseRegistration | CaseRegistrationID | NO_ACTION | NO_ACTION |
| CounselCaseTerminate | CounselCauseOfTerminateID | CounselCauseOfTerminate | CounselCauseOfTerminateID | NO_ACTION | NO_ACTION |
| Court | CourtGroupID | CourtGroup | CourtGroupID | NO_ACTION | NO_ACTION |
| Court | CourtLevelID | CourtLevel | CourtLevelID | NO_ACTION | NO_ACTION |
| Court | ProvinceID | Province | ProvinceID | NO_ACTION | NO_ACTION |
| CriminalCaseAccusedCaseDetail | CourtID | Court | CourtID | NO_ACTION | NO_ACTION |
| CriminalCaseAccusedCaseDetail | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseAllegedOffenderCaseDetail | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseCategory | CaseCategoryID | CaseCategory | CaseCategoryID | NO_ACTION | NO_ACTION |
| CriminalCaseCategory | CriminalCaseID | CriminalCaseRegistration | CriminalCaseID | NO_ACTION | NO_ACTION |
| CriminalCaseComplainant | CardTypeID | CardType | CardTypeID | NO_ACTION | NO_ACTION |
| CriminalCaseComplainant | CriminalCaseID | CriminalCaseRegistration | CriminalCaseID | NO_ACTION | NO_ACTION |
| CriminalCaseComplainant | MaritalStatusID | MaritalStatus | MaritalStatusID | NO_ACTION | NO_ACTION |
| CriminalCaseComplainant | NationalityID | Nationality | NationalityID | NO_ACTION | NO_ACTION |
| CriminalCaseComplainant | PersonID | Person | PersonID | NO_ACTION | NO_ACTION |
| CriminalCaseComplainant | RaceID | Race | RaceID | NO_ACTION | NO_ACTION |
| CriminalCaseComplainant | ReligionID | Religion | ReligionID | NO_ACTION | NO_ACTION |
| CriminalCaseComplainantArchivalCopy | ArchivalCopyID | ArchivalCopy | ArchivalCopyID | NO_ACTION | NO_ACTION |
| CriminalCaseComplainantArchivalCopy | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseComplainantAttachFile | AttachFileID | AttachFile | AttachFileID | NO_ACTION | NO_ACTION |
| CriminalCaseComplainantAttachFile | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseComplainantMeta | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseComplaintFamilyMember | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseComplaintFamilyMember | FamilyMemberID | Person | PersonID | NO_ACTION | NO_ACTION |
| CriminalCaseComplaintIncome | CareerID | Career | CareerID | NO_ACTION | NO_ACTION |
| CriminalCaseComplaintIncome | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseComplaintIncome | WorkProvinceID | Province | ProvinceID | NO_ACTION | NO_ACTION |
| CriminalCaseComplaintMaritail_ | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseComplaintMaritail_ | MaritalStatusID | MaritalStatus | MaritalStatusID | NO_ACTION | NO_ACTION |
| CriminalCaseComplaintNoIncome | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseComplaintParent | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseContactPerson | AddressID | Address | AddressID | NO_ACTION | NO_ACTION |
| CriminalCaseContactPerson | PersonID | Person | PersonID | NO_ACTION | NO_ACTION |
| CriminalCaseContactPerson | RelateTypeID | RelateType | RelateTypeID | NO_ACTION | NO_ACTION |
| CriminalCaseDamage | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseDamage | DamageID | Damage | DamageID | NO_ACTION | NO_ACTION |
| CriminalCaseDisabled | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseDisabled | DisabledID | Disabled | DisabledID | NO_ACTION | NO_ACTION |
| CriminalCaseGuilt | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseGuilt | GuiltID | Guilt | GuiltID | NO_ACTION | NO_ACTION |
| CriminalCaseHealthPrivilege | InjuredID | CriminalCaseInjured | InjuredID | NO_ACTION | NO_ACTION |
| CriminalCaseHealthPrivilege | PrivilegeID | HealthPrivilege | PrivilegeID | NO_ACTION | NO_ACTION |
| CriminalCaseInjured | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseJudgement | CourtLevelID | CourtLevel | CourtLevelID | NO_ACTION | NO_ACTION |
| CriminalCaseJudgement | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseNote | CriminalCaseID | CriminalCaseRegistration | CriminalCaseID | NO_ACTION | NO_ACTION |
| CriminalCaseNote | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseNote | UserID | User | UserID | NO_ACTION | NO_ACTION |
| CriminalCaseOffice | CrimeSceneOfficeID | Office | OfficeID | NO_ACTION | NO_ACTION |
| CriminalCaseOffice | CriminalCaseID | CriminalCaseRegistration | CriminalCaseID | NO_ACTION | NO_ACTION |
| CriminalCaseOffice | UserID | User | UserID | NO_ACTION | NO_ACTION |
| CriminalCasePassAway | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseRegistration | AcceptByUserID | User | UserID | NO_ACTION | NO_ACTION |
| CriminalCaseRegistration | CaseRegistrationID | CaseRegistration | CaseRegistrationID | NO_ACTION | NO_ACTION |
| CriminalCaseRegistration | ChannelID | Channel | ChannelID | NO_ACTION | NO_ACTION |
| CriminalCaseRegistration | CriminalCaseStatusID | CriminalCaseStatus | CriminalCaseStatusID | NO_ACTION | NO_ACTION |
| CriminalCaseRegistration | OfficeID | Office | OfficeID | NO_ACTION | NO_ACTION |
| CriminalCaseRegistration | SceneOfficeID | Office | OfficeID | NO_ACTION | NO_ACTION |
| CriminalCaseRegistration | SceneProvinceID | Province | ProvinceID | NO_ACTION | NO_ACTION |
| CriminalCaseRoadAccident | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseRoadAccidentFinancialAssistance | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseRoadAccidentFinancialAssistance | FinancialAssistanceID | RoadAccidentFinancialAssistance | FinancialAssistanceID | NO_ACTION | NO_ACTION |
| CriminalCaseSubGuilt | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseSubGuilt | SubGuiltID | SubGuilt | SubGuiltID | NO_ACTION | NO_ACTION |
| CriminalCaseVictimCaseDetail | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalCaseVictimCaseDetail | LocaleSubdistrictID | Subdistrict | SubdistrictID | NO_ACTION | NO_ACTION |
| CriminalCaseVictimCaseDetail | PoliceStationID | PoliceStation | PoliceStationID | NO_ACTION | NO_ACTION |
| CriminalComplainantInspect | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| CriminalComplainantInspect | InspectID | Inspect | InspectID | NO_ACTION | NO_ACTION |
| CriminalComplainantInspect | InspectValueListID | InspectValueList | InspectValueListID | NO_ACTION | NO_ACTION |
| CriminalRPLDSystemReference | CreateByUserID | User | UserID | NO_ACTION | NO_ACTION |
| CriminalRPLDSystemReference | CriminalCaseID | CriminalCaseRegistration | CriminalCaseID | NO_ACTION | NO_ACTION |
| CriminalRPLDSystemReference | RLPDSystemID | RLPDSystemReference | RLPDSystemID | NO_ACTION | NO_ACTION |
| DatabaseProcess | UserID | User | UserID | NO_ACTION | NO_ACTION |
| DatabaseProcessHistory | UserID | User | UserID | NO_ACTION | NO_ACTION |
| DelegationListOfMeeting | BookOfMeetingID | BookOfMeeting | BookOfMeetingID | NO_ACTION | NO_ACTION |
| DelegationListOfMeeting | DelegationID | Delegation | DelegationID | NO_ACTION | NO_ACTION |
| DelegationMeeting | TermID | Term | TermID | NO_ACTION | NO_ACTION |
| DelegationMeetingAttachFile | AttachFileID | AttachFile | AttachFileID | NO_ACTION | NO_ACTION |
| DelegationMeetingAttachFile | DelegationMeetingID | DelegationMeeting | DelegationMeetingID | NO_ACTION | NO_ACTION |
| DelegationMeetingBook | BookOfMeetingID | BookOfMeeting | BookOfMeetingID | NO_ACTION | NO_ACTION |
| DelegationMeetingBook | DelegationMeetingID | DelegationMeeting | DelegationMeetingID | NO_ACTION | NO_ACTION |
| Department_ | ProvinceID | Province | ProvinceID | NO_ACTION | NO_ACTION |
| DepartmentAddress_ | DepartmentID | Department_ | DepartmentID | NO_ACTION | NO_ACTION |
| District | ProvinceID | Province | ProvinceID | NO_ACTION | NO_ACTION |
| FinanceTransactionApproveUpload | RelatedBatchID | FinanceUploadTransaction | BatchID | NO_ACTION | NO_ACTION |
| FinanceTransactionApproveUpload | TransactionID | FinanceTransactionApproveUpload | TransactionID | NO_ACTION | NO_ACTION |
| FinanceUploadTransaction | UserID | User | UserID | NO_ACTION | NO_ACTION |
| Form | FormTypeID | FormType | FormTypeID | NO_ACTION | NO_ACTION |
| FormMapComplainantType | FormID | Form | FormID | NO_ACTION | NO_ACTION |
| FormMapComplainantType | OCIPAJobApplyID | OCIPAJobApply | OCIPAJobApplyID | NO_ACTION | NO_ACTION |
| InboxDetail | InboxID | Inbox | InboxID | NO_ACTION | NO_ACTION |
| InboxMapOffice | InboxID | Inbox | InboxID | NO_ACTION | NO_ACTION |
| InboxMapOffice | OfficeID | Office | OfficeID | NO_ACTION | NO_ACTION |
| InboxMapUser | InboxID | Inbox | InboxID | NO_ACTION | NO_ACTION |
| InboxMapUser | UserID | User | UserID | NO_ACTION | NO_ACTION |
| Inspect | InspectValueType | InspectValueType | InspectValueTypeID | NO_ACTION | NO_ACTION |
| InspectLinkageService | InspectID | Inspect | InspectID | NO_ACTION | NO_ACTION |
| InspectLog | CriminalcomplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| InspectLog | UserID | User | UserID | NO_ACTION | NO_ACTION |
| InspectValueList | InspectValueTypeID | InspectValueType | InspectValueTypeID | NO_ACTION | NO_ACTION |
| JobTypeMappingOCIPAJobApply | JobTypeID | JobType | OCIPAJobTypeID | NO_ACTION | NO_ACTION |
| JobTypeMappingOCIPAJobApply | OCIPAJobApplyID | OCIPAJobApply | OCIPAJobApplyID | NO_ACTION | NO_ACTION |
| LinkageAccessToken | UserID | User | UserID | NO_ACTION | NO_ACTION |
| LossOfIncome | JobEntityID | OCIPAJobEntity | JobEntityID | NO_ACTION | NO_ACTION |
| LossOfIncome | OfficerRoleID | OfficerRole | OfficerRoleID | NO_ACTION | NO_ACTION |
| OCIPAFinance_ย้ายไปที่OCIPAJobPaymentInformation | PaymentTypeID | PaymentType | PaymentTypeID | NO_ACTION | NO_ACTION |
| OCIPAFinance_ย้ายไปที่OCIPAJobPaymentInformation | StatusID | FinanceStatus | FinanceStatusID | NO_ACTION | NO_ACTION |
| OCIPAFinanceBeneficiary | PersonID | Person | PersonID | NO_ACTION | NO_ACTION |
| OCIPAFinanceStatusHistory | OCIPARegisterID | OCIPAFinance_ย้ายไปที่OCIPAJobPaymentInformation | JobID | NO_ACTION | NO_ACTION |
| OCIPAFinanceStatusHistory | StatusID | FinanceStatus | FinanceStatusID | NO_ACTION | NO_ACTION |
| OCIPAFinanceStatusHistory | UserID | User | UserID | NO_ACTION | NO_ACTION |
| OCIPAJob | CriminalCaseID | CriminalCaseRegistration | CriminalCaseID | NO_ACTION | NO_ACTION |
| OCIPAJob | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| OCIPAJob | JobStatusID | JobStatus | JobStatusID | NO_ACTION | NO_ACTION |
| OCIPAJob | JobTypeID | JobType | OCIPAJobTypeID | NO_ACTION | NO_ACTION |
| OCIPAJobChangWorkStepHistory | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| OCIPAJobChangWorkStepHistory | UserID | User | UserID | NO_ACTION | NO_ACTION |
| OCIPAJobChangWorkStepHistory | WorkStepID | OCIPAWorkStep | WorkStepID | NO_ACTION | NO_ACTION |
| OCIPAJobComplainantCompensation | CompensationID | Compensation | CompensationID | NO_ACTION | NO_ACTION |
| OCIPAJobComplainantCompensation | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| OCIPAJobComplainantCompensation | JobEntityID | OCIPAJobEntity | JobEntityID | NO_ACTION | NO_ACTION |
| OCIPAJobCriminalComplainant_ | CriminalComplainantID | CriminalCaseComplainant | CriminalComplainantID | NO_ACTION | NO_ACTION |
| OCIPAJobCriminalComplainant_ | JobTypeID | JobType | OCIPAJobTypeID | NO_ACTION | NO_ACTION |
| OCIPAJobCriminalComplainantAttachFile | AttachFileID | AttachFile | AttachFileID | NO_ACTION | NO_ACTION |
| OCIPAJobCriminalComplainantAttachFile | WorkStepID | OCIPAWorkStep | WorkStepID | NO_ACTION | NO_ACTION |
| OCIPAJobDetention | JobID | OCIPAJob | JobID | NO_ACTION | NO_ACTION |
| OCIPAJobEntity | JobTypeID | JobType | OCIPAJobTypeID | NO_ACTION | NO_ACTION |
| OCIPAJobForConsiderationOfMeeting | BookOfMeetingID | BookOfMeeting | BookOfMeetingID | NO_ACTION | NO_ACTION |
| OCIPAJobForConsiderationOfMeeting | JobEntityID | OCIPAJobEntity | JobEntityID | NO_ACTION | NO_ACTION |
| OCIPAJobImprisonment | CourtLevelID | CourtLevel | CourtLevelID | NO_ACTION | NO_ACTION |
| OCIPAJobMapLawyer | UserID | User | UserID | NO_ACTION | NO_ACTION |
| OCIPAJobMedicalExpense | MedicalExpenseID | MedicalExpense | MedicalExpenseID | NO_ACTION | NO_ACTION |
| OCIPAJobOfficeOwner | JobEntityID | OCIPAJobEntity | JobEntityID | NO_ACTION | NO_ACTION |
| OCIPAJobOfficeOwner | OfficeID | Office | OfficeID | NO_ACTION | NO_ACTION |
| OCIPAJobOfficeOwner | UpdateByUserID | User | UserID | NO_ACTION | NO_ACTION |
| OCIPAJobOfficerApproveCompensation | CompensationID | Compensation | CompensationID | NO_ACTION | NO_ACTION |
| OCIPAJobOfficerApproveCompensation | JobEntityID | OCIPAJobEntity | JobEntityID | NO_ACTION | NO_ACTION |
| OCIPAJobOfficerApproveCompensation | OfficerRoleID | OfficerRole | OfficerRoleID | NO_ACTION | NO_ACTION |
| OCIPAJobOfficerOpinion | JobEntityID | OCIPAJobEntity | JobEntityID | NO_ACTION | NO_ACTION |
| OCIPAJobOfficerOpinion | OfficerRoleID | OfficerRole | OfficerRoleID | NO_ACTION | NO_ACTION |
| OCIPAJobOfficerOpinion | OpinionID | Opinion | OpinionID | NO_ACTION | NO_ACTION |
| OCIPAJobOfficerProceedAsRequired | JobEntityID | OCIPAJobEntity | JobEntityID | NO_ACTION | NO_ACTION |
| OCIPAJobOfficerProceedAsRequired | OfficerAttributeID | OfficerMapJobAttribute | OfficerAttributeID | NO_ACTION | NO_ACTION |
| OCIPAJobOfficerSubOpinion | JobEntityID | OCIPAJobEntity | JobEntityID | NO_ACTION | NO_ACTION |
| OCIPAJobOfficerSubOpinion | OfficerRoleID | OfficerRole | OfficerRoleID | NO_ACTION | NO_ACTION |
| OCIPAJobOfficerSubOpinion | SubOpinionID | SubOpinion | SubOpinionID | NO_ACTION | NO_ACTION |
| OCIPAJobPaymentInformation | PaymentMethodID | PaymentMethod | PaymentMethodlID | NO_ACTION | NO_ACTION |
| OCIPAJobPaymentInformation | PeymentStatusID | PaymentStatus | PaymentStatusID | NO_ACTION | NO_ACTION |
| OCIPAJobPaymentInformation | UpdateByUserID | User | UserID | NO_ACTION | NO_ACTION |
| OCIPAJobProxy | AddressID | Address | AddressID | NO_ACTION | NO_ACTION |
| OCIPAJobProxy | CardTypeID | CardType | CardTypeID | NO_ACTION | NO_ACTION |
| OCIPAJobProxy | PersonID | Person | PersonID | NO_ACTION | NO_ACTION |
| OCIPAJobProxy | RelateTypeID | RelateType | RelateTypeID | NO_ACTION | NO_ACTION |
| OCIPAJobStandard | CreateByUserID | User | UserID | NO_ACTION | NO_ACTION |
| OCIPAJobStandard | MappingID | RLPDStandardOptionMapGovAgen | MappingID | NO_ACTION | NO_ACTION |
| OCIPAJobStatusHistory | JobStatusID | JobStatus | JobStatusID | NO_ACTION | NO_ACTION |
| OCIPAJobStatusHistory | UserID | User | UserID | NO_ACTION | NO_ACTION |
| OCIPAJobTermination | TerminationReasonID | TerminationReason | TerminationReasonID | NO_ACTION | NO_ACTION |
| OCIPAJobWaiting | JobEntityID | OCIPAJobEntity | JobEntityID | NO_ACTION | NO_ACTION |
| OCIPAWorkStep | ClusterID | OCIPACluster | ClusterID | NO_ACTION | NO_ACTION |
| OCIPAWorkStepPath | OCIPAJobTypeID | JobType | OCIPAJobTypeID | NO_ACTION | NO_ACTION |
| OCIPAWorkStepPath | WorkStepID | OCIPAWorkStep | WorkStepID | NO_ACTION | NO_ACTION |
| OCIPAWorkStepProcesss | OCIPAWorkStepID | OCIPAWorkStep | WorkStepID | NO_ACTION | NO_ACTION |
| Office | ProvinceID | Province | ProvinceID | NO_ACTION | NO_ACTION |
| OfficeAddress | OfficeID | Office | OfficeID | NO_ACTION | NO_ACTION |
| OfficeMapRLPDSystem | OfficeID | Office | OfficeID | NO_ACTION | NO_ACTION |
| OfficeMapRLPDSystem | RLPDSystemID | RLPDSystemReference | RLPDSystemID | NO_ACTION | NO_ACTION |
| OfficerMapJobAttribute | JobAttributeID | JobAttribute | JobAttributeID | NO_ACTION | NO_ACTION |
| OfficerMapJobAttribute | OfficerRoleID | OfficerRole | OfficerRoleID | NO_ACTION | NO_ACTION |
| OfficerMapOpinion | OCIPAJobApplyID | OCIPAJobApply | OCIPAJobApplyID | NO_ACTION | NO_ACTION |
| OfficerMapOpinion | OfficerRoleID | OfficerRole | OfficerRoleID | NO_ACTION | NO_ACTION |
| OfficerMapOpinion | OpinionID | Opinion | OpinionID | NO_ACTION | NO_ACTION |
| OfficerMapRole | OfficeRoleID | OfficerRole | OfficerRoleID | NO_ACTION | NO_ACTION |
| OfficerMapRole | UserID | User | UserID | NO_ACTION | NO_ACTION |
| OpinionMappingSubOpinion | OCIPAJobApplyID | OCIPAJobApply | OCIPAJobApplyID | NO_ACTION | NO_ACTION |
| OpinionMappingSubOpinion | OpinionID | Opinion | OpinionID | NO_ACTION | NO_ACTION |
| OpinionMappingSubOpinion | SubOpinionID | SubOpinion | SubOpinionID | NO_ACTION | NO_ACTION |
| PaymentInformation | PaymentMethodID | PaymentMethod | PaymentMethodlID | NO_ACTION | NO_ACTION |
| PaymentOrder | JobID | OCIPAJob | JobID | NO_ACTION | NO_ACTION |
| PaymentOrder | PaymentMethodID | PaymentMethod | PaymentMethodlID | NO_ACTION | NO_ACTION |
| PoliceStation | ProvinceID | Province | ProvinceID | NO_ACTION | NO_ACTION |
| ProvinceExtension | ProvinceID | Province | ProvinceID | NO_ACTION | NO_ACTION |
| ProvinceExtension | ProvinceTypeCode | ProvinceType | ProvinceTypeCode | NO_ACTION | NO_ACTION |
| ProvinceMSC | BelongJFSProvinceID | Province | ProvinceID | NO_ACTION | NO_ACTION |
| ReplyDocumentInformation | PaymentInfoID | PaymentInformation | PaymentInfoID | NO_ACTION | NO_ACTION |
| ReplyDocumentInformation | ReplyDocumentID | ReplyDocument | ReplyDocumentID | NO_ACTION | NO_ACTION |
| ReportPoliceStatisticOfComplaints | PoliceStationID | PoliceStation | PoliceStationID | NO_ACTION | NO_ACTION |
| RLPDStandardOption | RLPDStandardID | RLPDStandard | RLPDStandardID | NO_ACTION | NO_ACTION |
| RLPDStandardOptionMapGovAgen | GovernmentAgencyID | GovernmentAgency | GovernmentAgencyID | NO_ACTION | NO_ACTION |
| RLPDStandardOptionMapGovAgen | StandardOptionID | RLPDStandardOption | StandardOptionID | NO_ACTION | NO_ACTION |
| SingleLogin | UserID | UserLogin | UserID | NO_ACTION | NO_ACTION |
| SubCommittee | ProvinceID | Province | ProvinceID | NO_ACTION | NO_ACTION |
| Subdistrict | DistrictID | District | DistrictID | NO_ACTION | NO_ACTION |
| SysGroupMapModule | GroupID | SysGroupModule | GroupID | NO_ACTION | NO_ACTION |
| SysGroupMapModule | ModuleID | SysModule | ModuleID | NO_ACTION | NO_ACTION |
| SysPermission | ModuleID | SysModule | ModuleID | NO_ACTION | NO_ACTION |
| SysPermission | OperationID | SysOperation | OperationID | NO_ACTION | NO_ACTION |
| SysRoleMapPermission | PermissionID | SysPermission | PermissionID | NO_ACTION | NO_ACTION |
| SysRoleMapPermission | RoleID | SysRole | RoleID | NO_ACTION | NO_ACTION |
| SysScreen | ModuleID | SysModule | ModuleID | NO_ACTION | NO_ACTION |
| TransactonLog | UserID | User | UserID | NO_ACTION | NO_ACTION |
| TransferCase | CaseRegistrationSystemReferenceID | CaseRegistrationSystemReference | CaseRegistrationSystemReferenceID | NO_ACTION | NO_ACTION |
| TransferCaseTracking | CaseRegistrationSystemReferenceID | CaseRegistrationSystemReference | CaseRegistrationSystemReferenceID | NO_ACTION | NO_ACTION |
| User | OfficeID | Office | OfficeID | NO_ACTION | NO_ACTION |
| User | PositionID | Position | PositionID | NO_ACTION | NO_ACTION |
| User | UserStatusID | UserStatus | UserStatusID | NO_ACTION | NO_ACTION |
| User | UserTypeID | UserType | UserTypeID | NO_ACTION | NO_ACTION |
| UserEmail | UserID | User | UserID | NO_ACTION | NO_ACTION |
| UserLogin | UserAccountTypeCode | UserAccountType | UserAccountTypeCode | NO_ACTION | NO_ACTION |
| UserLogin | UserID | User | UserID | NO_ACTION | NO_ACTION |
| UserLoginHistory | UserID | User | UserID | NO_ACTION | NO_ACTION |
| UserMapOffice_ | OfficeID | Office | OfficeID | NO_ACTION | NO_ACTION |
| UserMapOffice_ | UserID | User | UserID | NO_ACTION | NO_ACTION |
| UserMapPermission | PermissionID | SysPermission | PermissionID | NO_ACTION | NO_ACTION |
| UserMapPermission | UserAccountTypeCode | UserAccountType | UserAccountTypeCode | NO_ACTION | NO_ACTION |
| UserMapPermission | UserID | User | UserID | NO_ACTION | NO_ACTION |
| UserMapRLPDSystem | RLPDSystemID | RLPDSystemReference | RLPDSystemID | NO_ACTION | NO_ACTION |
| UserMapRLPDSystem | UserID | User | UserID | NO_ACTION | NO_ACTION |
| UserMapRole | AssignID | User | UserID | NO_ACTION | NO_ACTION |
| UserMapRole | RoleID | SysRole | RoleID | NO_ACTION | NO_ACTION |
| UserMapRole | UserID | User | UserID | NO_ACTION | NO_ACTION |
| VerdictRunning | RLPDSystemID | RLPDSystemReference | RLPDSystemID | NO_ACTION | NO_ACTION |