uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

sys_person

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	per_id	Integer			nextval('"URX_PUBLIC".sys_person_id_seq'::regclass)	Identificador
	per_organization	Integer				Organização Pai
	per_notify_to	Integer				Avisar em caso de acidente
	per_former_organization	Integer				Contato Original
	per_birth_date	Date				Data de Nascimento ou Fundação
	per_id_issued_date	Date				Data de Emissão
	per_nat	SmallInt				Naturalidade
	per_civil_status	SmallInt			0	Estado Civil
	per_type	SmallInt			0	Tipo
	per_gender	SmallInt			1	Sexo
	per_delete_bit	SmallInt			0	Bit de Exclusão
	per_name	VarChar(100)				Nome Completo
	per_mother_name	VarChar(50)				Nome da Mãe
	per_email	VarChar(50)				E-mail
	per_import_table_name	VarChar(50)				Tabela de Importação
	per_nick_name	VarChar(50)				Apelido
	per_organization_label	VarChar(50)				Rótulo do Relacionamento
	per_father_name	VarChar(50)				Nome do Pai
	per_passport_number	VarChar(30)				Número do Passaporte
	per_id_issued_by	VarChar(20)				Órgão Emissor
	per_id_number	VarChar(15)				Número da Identidade
	per_legal_number	VarChar(14)				CPF ou CNPJ
	per_import_cod	VarChar(6)				Código de Importação
	per_nac	VarChar(2)				Nacionalidade

Indexes
Name	Table	Columns	Unique	Clustered
ix_per_name	URX_PUBLIC.sys_person	per_name
ix_sys_person_notify_to	URX_PUBLIC.sys_person	per_notify_to
ix_sys_person_per_name	URX_PUBLIC.sys_person	per_name
ix_sys_person_sys_cep_state	URX_PUBLIC.sys_person	per_nat
ix_sys_person_sys_country	URX_PUBLIC.sys_person	per_nac
ix_sys_person_sys_person	URX_PUBLIC.sys_person	per_organization

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_sys_person_notify_to	URX_PUBLIC.sys_person	URX_PUBLIC.sys_person	per_id	per_notify_to
fk_sys_person_sys_cep_state	URX_PUBLIC.sys_cep_state	URX_PUBLIC.sys_person	cep_state_id	per_nat
fk_sys_person_sys_country	URX_PUBLIC.sys_country	URX_PUBLIC.sys_person	cou_code_iso2	per_nac
fk_sys_person_sys_person	URX_PUBLIC.sys_person	URX_PUBLIC.sys_person	per_id	per_organization

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_abi_employee_sys_person	URX_PUBLIC.sys_person	URX_PUBLIC.abi_employee	per_id	emp_id
fk_adm_unit_sys_person	URX_PUBLIC.sys_person	URX_PUBLIC.adm_unit	per_id	uni_person_id
fk_fin_account_sys_person	URX_PUBLIC.sys_person	URX_PUBLIC.fin_account	per_id	acc_person_id
fk_fin_credit_card_sys_person	URX_PUBLIC.sys_person	URX_PUBLIC.fin_credit_card	per_id	cre_person_id
fk_fin_supplier_sys_person	URX_PUBLIC.sys_person	URX_PUBLIC.fin_supplier	per_id	sup_id
fk_sel_customer_sys_person	URX_PUBLIC.sys_person	URX_PUBLIC.sel_customer	per_id	cus_id
fk_sys_address_sys_person	URX_PUBLIC.sys_person	URX_PUBLIC.sys_address	per_id	add_person_id
fk_sys_person_notify_to	URX_PUBLIC.sys_person	URX_PUBLIC.sys_person	per_id	per_notify_to
fk_sys_person_sys_person	URX_PUBLIC.sys_person	URX_PUBLIC.sys_person	per_id	per_organization
fk_sys_person_aggregate	URX_PUBLIC.sys_person	URX_PUBLIC.sys_person_aggregate	per_id	per_aggregate_min_id
fk_sys_phone_sys_person	URX_PUBLIC.sys_person	URX_PUBLIC.sys_phone	per_id	pho_person_id
fk_sys_user_sys_person	URX_PUBLIC.sys_person	URX_PUBLIC.sys_user	per_id	use_id

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

Used in Diagrams

Diagram Name

diagramA