uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

abi_employee_certificate

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	emc_employee_id	Integer				Funcionário
	emc_image_id	Integer				Imagem do Certificado
	emc_valid_date	Date				Data de Validade
	emc_issued_date	Date				Data de Emissão
	emc_start_date	Date				Data de Início
	emc_finish_date	Date				Data de Conclusão
	emc_id	SmallInt			nextval('"URX_PUBLIC".abi_employee_certificate_id_seq'::regclass)	Identificador
	emc_delete_bit	SmallInt			0	Bit de Exclusão
	emc_certificate_id	SmallInt				Certificado
	emc_is_endorsed	SmallInt			0	Certificado é Endossado
	emc_model	SmallInt			0	Modelo
	emc_issued_by	VarChar(255)				Instituição que Emitiu Certificado
	emc_number	VarChar(25)				Nº do Certificado ou Identificação do Lote (Febre Amarela)
	emc_language	VarChar(2)				Idioma
	emc_rule	VarChar(50)				Norma

Indexes
Name	Table	Columns	Unique	Clustered
ix_abi_employee_certificate_abi_certificate	URX_PUBLIC.abi_employee_certificate	emc_certificate_id
ix_abi_employee_certificate_abi_employee	URX_PUBLIC.abi_employee_certificate	emc_employee_id
ix_abi_employee_certificate_sys_file	URX_PUBLIC.abi_employee_certificate	emc_image_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_abi_employee_certificate_abi_certificate	URX_PUBLIC.abi_certificate	URX_PUBLIC.abi_employee_certificate	cer_id	emc_certificate_id
fk_abi_employee_certificate_abi_employee	URX_PUBLIC.abi_employee	URX_PUBLIC.abi_employee_certificate	emp_id	emc_employee_id
fk_abi_employee_certificate_sys_file	URX_PUBLIC.sys_file	URX_PUBLIC.abi_employee_certificate	fil_id	emc_image_id

Parent Relations (none)

Triggers
Name	Table	On Delete	On Insert	On Update	Execute	For Each	SQL
tg_abi_employee_certificate_create	URX_PUBLIC.abi_employee_certificate				AFTER	FOR EACH ROW	"URX_PUBLIC"."_u ...

Used in Diagrams

Diagram Name

diagramA