| ?????? | ??? | ?????? | ????????? | ?????? |
|---|---|---|---|---|
| TRIGGERID | CHAR | 36 | ?????? | ?????????????????????????????? |
| TRIGGERNAME | VARCHAR | 128 | ?????? | ?????????????????? |
| SCHEMAID | CHAR | 36 | ?????? | ????????????????????????????????????(SYSSCHEMAS. SCHEMAID?????????) |
| CREATIONTIMESTAMP | TIMESTAMP | ?????? | ????????????????????????????????? | |
| EVENT | CHAR | 1 | ?????? | 'U'???????????? 'D'????????????'I'????????????????????? |
| FIRINGTIME | CHAR | 1 | ?????? | 'B'????????? 'A'?????????????????? |
| TYPE | CHAR | 1 | ?????? | 'R'?????????'S'?????????????????? |
| STATE | CHAR | 1 | ?????? | 'E'????????????'D'????????????????????? |
| TABLEID | CHAR | 36 | ?????? | ????????????????????????????????????????????? |
| WHENSTMTID | CHAR | 36 | ??? | WHEN??????????????????????????????(???????????????????????????????????????) |
| ACTIONSTMTID | CHAR | 36 | ??? | ??????????????????SQL??????????????????????????????????????????????????? (SYSSTATEMENTS. STMTID?????????) |
| REFERENCEDCOLUMNS | org.apache.derby.catalog. ReferencedColumns: ????????????????????????API??????????????? | ??? | UPDATE??????????????????????????????????????? | |
| TRIGGERDEFINITION | LONG VARCHAR | ??? | ????????????SQL?????????????????? | |
| REFERENCINGOLD | BOOLEAN | true | whether or not the OLDREFERENCINGNAME, if non-null, refers to the OLD row or table | |
| REFERENCINGNEW | BOOLEAN | ??? | ???????????????????????????NEWREFERENCINGNAME???????????????????????????????????????????????? | |
| OLDREFERENCINGNAME | VARCHAR | 128 | ??? | REFERENCING OLD AS???????????????????????????????????? |
| NEWREFERENCINGNAME | VARCHAR | 128 | ??? | REFERENCING NEW AS???????????????????????????????????? |
??????????????????SQL?????????????????????SQL??????????????????????????????SYSSTATEMENTS????????????????????????ACTIONSTMTID???WHENSTMTID??????SYSSTATEMENTS.STMTID???????????????????????????????????????????????????????????????????????????????????????????????????????????????