KSTATUS

14 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
KATVORDEM.CODCOLIGADA FKKATVORDEM_KSTATUSR
KITEMORDEM.CODCOLIGADA FKKITEMORDEM_KSTATUSR
KORDEM.CODCOLIGADA FKKORDEM_KSTATUSR
KSTATUSFLUXO.CODCOLIGADA FKKSTATUSFLUXOORIGEM_STATUSR
CODSTATUS int 4 null
KATVORDEM.STATUS FKKATVORDEM_KSTATUSR
KITEMORDEM.STATUS FKKITEMORDEM_KSTATUSR
KORDEM.STATUS FKKORDEM_KSTATUSR
KSTATUSFLUXO.CODSTATUSDESTINO FKKSTATUSFLUXODESTINO_KSTATUSR
KSTATUSFLUXO.CODSTATUSORIGEM FKKSTATUSFLUXOORIGEM_STATUSR
DSCSTATUS DKDESCRICAO 80 √ null
CODSTATUSANTERIOR int 4 √ null
CODSTATUSPOSTERIOR int 4 √ null
FLAG int 4 √ 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)
PKKSTATUS Primary key Asc/Asc CODCOLIGADA + CODSTATUS

Relationships

Close relationships within degrees of separation