SZEXAMEPRESCRICAO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SZLABMATERIALEXAME.CODCOLIGADA FKSZEXAMEPRESCRICAO_SZLABMATER
SZITEMPRESCRICAO.CODCOLIGADA FKSZEXAMEPRESCRICAO_SZITEMPRER
SZPRESCRICAO.CODCOLIGADA FKSZEXAMEPRESCRICAO_SZPRESCRIR
SZLABEXAME.CODCOLIGADA FKSZEXAMEPRESCRICAO_SZLABEXAMER
CODPRESCRICAO int 4 null
SZITEMPRESCRICAO.CODPRESCRICAO FKSZEXAMEPRESCRICAO_SZITEMPRER
SZPRESCRICAO.CODPRESCRICAO FKSZEXAMEPRESCRICAO_SZPRESCRIR
CODPRESCRICAOITEM int 4 null
SZITEMPRESCRICAO.SEQUENCIAL FKSZEXAMEPRESCRICAO_SZITEMPRER
CODEXAMEPRESCRICAO int 4 null
CODEXAME int 4 null
SZLABEXAME.CODEXAME FKSZEXAMEPRESCRICAO_SZLABEXAMER
DESCRICAO varchar 300 null
CODMATERIAL varchar 10 √ null
SZLABMATERIALEXAME.CODMATERIAL FKSZEXAMEPRESCRICAO_SZLABMATER
PRIORIDADE int 4 null
DATA datetime 16,3 √ null
HORA varchar 5 √ null
TIPO int 4 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
STATUS char 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSZEXAMEPRESCRICAO Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODPRESCRICAO + CODPRESCRICAOITEM + CODEXAMEPRESCRICAO

Relationships

Close relationships within degrees of separation