By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
OWNER | CONSTRAINT_NAME | CONSTRAINT_TYPE | TABLE_NAME | SEARCH_CONDITION_VC | R_OWNER | R_CONSTRAINT_NAME | DELETE_RULE | STATUS | DEFERRABLE | DEFERRED | VALIDATED | GENERATED | BAD | RELY | LAST_CHANGE | INDEX_OWNER | INDEX_NAME | INVALID | VIEW_RELATED | ORIGIN_CON_ID |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MAXIMO | SYS_C0019778 | C | WORKORDER | "WONUM" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019779 | C | WORKORDER | "STATUS" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019780 | C | WORKORDER | "STATUSDATE" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019781 | C | WORKORDER | "ESTDUR" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019782 | C | WORKORDER | "ESTLABHRS" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019783 | C | WORKORDER | "ESTMATCOST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019784 | C | WORKORDER | "ESTLABCOST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019785 | C | WORKORDER | "ESTTOOLCOST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019786 | C | WORKORDER | "ACTLABHRS" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019787 | C | WORKORDER | "ACTMATCOST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019788 | C | WORKORDER | "ACTLABCOST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019789 | C | WORKORDER | "ACTTOOLCOST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019790 | C | WORKORDER | "HASCHILDREN" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019791 | C | WORKORDER | "OUTLABCOST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019792 | C | WORKORDER | "OUTMATCOST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019793 | C | WORKORDER | "OUTTOOLCOST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019794 | C | WORKORDER | "HISTORYFLAG" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019795 | C | WORKORDER | "DOWNTIME" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019796 | C | WORKORDER | "CHARGESTORE" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019797 | C | WORKORDER | "ESTSERVCOST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019798 | C | WORKORDER | "ACTSERVCOST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019799 | C | WORKORDER | "DISABLED" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019800 | C | WORKORDER | "ESTATAPPRLABHRS" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019801 | C | WORKORDER | "ESTATAPPRLABCOST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019802 | C | WORKORDER | "ESTATAPPRMATCOST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019803 | C | WORKORDER | "ESTATAPPRTOOLCOST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019804 | C | WORKORDER | "ESTATAPPRSERVCOST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019805 | C | WORKORDER | "HASFOLLOWUPWORK" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019806 | C | WORKORDER | "ORGID" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019807 | C | WORKORDER | "SITEID" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019808 | C | WORKORDER | "ISTASK" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019809 | C | WORKORDER | "WOCLASS" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019810 | C | WORKORDER | "WOACCEPTSCHARGES" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019811 | C | WORKORDER | "PARENTCHGSSTATUS" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019812 | C | WORKORDER | "WORKORDERID" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019813 | C | WORKORDER | "LANGCODE" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019814 | C | WORKORDER | "INTERRUPTIBLE" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019815 | C | WORKORDER | "HASLD" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019816 | C | WORKORDER | "WOISSWAP" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019817 | C | WORKORDER | "NEWCHILDCLASS" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019818 | C | WORKORDER | "SUSPENDFLOW" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019819 | C | WORKORDER | "FLOWCONTROLLED" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019820 | C | WORKORDER | "FLOWACTIONASSIST" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019821 | C | WORKORDER | "ROWSTAMP" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019822 | C | WORKORDER | "IGNORESRMAVAIL" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019823 | C | WORKORDER | "IGNOREDIAVAIL" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019824 | C | WORKORDER | "NESTEDJPINPROCESS" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019825 | C | WORKORDER | "PLUSCISMOBILE" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019826 | C | WORKORDER | "PLUSCLOOP" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019827 | C | WORKORDER | "INCTASKSINSCHED" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019828 | C | WORKORDER | "REQASSTDWNTIME" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019829 | C | WORKORDER | "APPTREQUIRED" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019830 | C | WORKORDER | "AOS" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019831 | C | WORKORDER | "AMS" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019832 | C | WORKORDER | "LOS" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019833 | C | WORKORDER | "LMS" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019834 | C | WORKORDER | "REPAIRLOCFLAG" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019835 | C | WORKORDER | "PLUSSISGIS" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019836 | C | WORKORDER | "PLUSTMALERT" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019837 | C | WORKORDER | "PLUSTFULLCOVERAGE" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019838 | C | WORKORDER | "PLUSTREPORD" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019839 | C | WORKORDER | "PLUSTDRIVERREQ" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019840 | C | WORKORDER | "PLUSTWORKASSIGN" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019841 | C | WORKORDER | "PLUSTLOCK" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019842 | C | WORKORDER | "PLUSTACTMPPRICE" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019843 | C | WORKORDER | "PLUSTMPTYPE" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019844 | C | WORKORDER | "CGWOBILLABLE" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019845 | C | WORKORDER | "CGWOASSETUPDATE" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |
MAXIMO | SYS_C0019846 | C | WORKORDER | "DJPAPPLIED" IS NOT NULL | null | null | null | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | null | null | 24-NOV-20 | null | null | null | null | 0 |