OFEVENTOPROC

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
OFEVENTOPROCCOMPL.CODCOLIGADA FKOFEVENTOPROCCOMPL_OFEVENTOPR
OFPENDEVENTO.CODCOLIGADA FKOFPENDEVENTO_OFEVENTOPROCR
OFTIPOEVENTOPROC.CODCOLIGADA FKOFEVENTOPROC_OFTIPOEVENTOPROR
OFPROCESSO.CODCOLIGADA FKOFEVENTOPROC_OFPROCESSOR
IDPROCESSO int 4 null
OFEVENTOPROCCOMPL.IDPROCESSO FKOFEVENTOPROCCOMPL_OFEVENTOPR
OFPENDEVENTO.IDPROCESSO FKOFPENDEVENTO_OFEVENTOPROCR
OFPROCESSO.IDPROCESSO FKOFEVENTOPROC_OFPROCESSOR
IDEVENTO smallint 2 null
OFEVENTOPROCCOMPL.IDEVENTO FKOFEVENTOPROCCOMPL_OFEVENTOPR
OFPENDEVENTO.IDEVENTO FKOFPENDEVENTO_OFEVENTOPROCR
TIPO smallint 2 null
OFTIPOEVENTOPROC.CODTIPO FKOFEVENTOPROC_OFTIPOEVENTOPROR
STATUS char 1 null
DATA datetime 16,3 √ null
DATATERMINO datetime 16,3 √ null
LOCAL varchar 60 √ null
DESCRICAO varchar 100 √ null
SUMARIO MEMO 2147483647 √ null
CODCFO varchar 25 √ null
IDCONTATO smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKOFEVENTOPROC Primary key Asc/Asc/Asc CODCOLIGADA + IDPROCESSO + IDEVENTO

Relationships

Close relationships within degrees of separation