RdsDiagram
ProductRelationships
PCR
PirPcr
tblErrorCode
ErrorCodeId: INTEGER
ProductFamilyId: INTEGER
ErrorCode: CHARACTER(50)
IsCurrent: BOOLEAN
tblFaultAdjective
FaultAdjectiveId: INTEGER
FaultAdjective: CHARACTER(50)
IsCurrent: BOOLEAN
tblFamilyNounAdjectiveRelationship
FamilyNounAdjectiveId: INTEGER
ProductFamilyId: INTEGER
FaultNounId: INTEGER
FaultAdjectiveId: INTEGER
IsCurrent: BOOLEAN
tblProductFamily
ProductFamilyId: INTEGER
ProductFamily: CHARACTER(100)
IsCurrent: BOOLEAN
tblProductsWithFamily
ProductWithFamilyId: INTEGER
ProductFamilyId: INTEGER
ProductId: INTEGER
IsCurrent: BOOLEAN
tblFaultNoun
FaultNounId: INTEGER
FaultNoun: INTEGER
IsCurrent: BOOLEAN
tblAcceptance
PirPcrId: INTEGER
QtyReceived: SMALLINT
DateDeviceRecieved: DATE
DateDeviceReceivedTzOffset: FLOAT(0)
PreFaultNounId: INTEGER
ErrorCodeId: INTEGER
PreFaultAdjectiveId: INTEGER
EmailTo: CHARACTER(500)
EmailCc: CHARACTER(500)
CustomerCareSpecialistUID: INTEGER
AssignedInvestigateManagerUID: INTEGER
AssignedInvestigateEngineerUID: INTEGER
AssignedInvestigateReviewerUID: INTEGER
ParentProRef: CHARACTER(50)
RejectReason: CHARACTER(500)
Location: CHARACTER(200)
FirstSigned: DATE
DeviceType: CHARACTER(20)
tblInvestigate
PirPcrId: INTEGER
InvestigationStartDate: DATE
InvestigationStartDateTzOffset: INTEGER
CapaReference: CHARACTER(50)
FailureInvestigationReference: CHARACTER(20)
InvestigationSimilarToPirID: INTEGER
PostFaultNounId: INTEGER
PostFaultAdjectiveId: INTEGER
PF_PN_N_A_PostAcceptCount: INTEGER
PF_PN_N_A_PostReviewedCount: INTEGER
FP_GN_N_APostAcceptCount: INTEGER
FP_GN_A_PostReviewedCount: INTEGER
PN_PostAcceptCount: INTEGER
PN_PostReviewedCount: INTEGER
HourMeter: FLOAT(0)
TemplateId: INTEGER
InformationOption: CHARACTER(20)
tblPirPcr
PirPcrId: INTEGER
A4_Ref: CHARACTER(80)
Others....: FLOAT(0)
vwProductsWithFamily
ProductWithFamilyId: INTEGER
ProductFamilyId: INTEGER
ProductId: INTEGER
IsCurrent: BOOLEAN
Product: CHARACTER(80)