uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

ope_service_type

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	ser_type_id	SmallInt			nextval('"URX_PUBLIC".ope_service_type_id_seq'::regclass)	Identificador
	ser_type_group_id	SmallInt				Grupo de Serviços
	ser_type_vector_id	SmallInt				Vetor
	ser_type_category_id	SmallInt				Categoria
	ser_type_delete_bit	SmallInt			0	Bit de Exclusão
	ser_type_warranty_qty	SmallInt				Quantidade de unidades de tempo de garantia
	ser_type_warranty_unit	SmallInt				Unidade de tempo de garantia
	ser_type_cad_pra	VarChar(15)				Referência da Base Legada - Praga (cadaprag.cad_pra)
	ser_type_cad_cod	VarChar(3)				Referência da Base Legada - Praga (cadaprag.cad_cod)
	ser_type_label	VarChar(50)				Rótulo
	ser_type_sales_commission	Numeric(10, 2)			0	Comissão do Vendedor (%)
	ser_type_match	character varying[]				LISTA DE PALAVRAS CHAVE

Indexes
Name	Table	Columns	Unique	Clustered
ix_ope_service_type_group_id	URX_PUBLIC.ope_service_type	ser_type_group_id
ix_ope_service_type_label	URX_PUBLIC.ope_service_type	ser_type_label

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ope_service_type_category	URX_PUBLIC.ope_service_type_category	URX_PUBLIC.ope_service_type	ser_type_category_id	ser_type_category_id
fk_ope_service_type_group	URX_PUBLIC.ope_service_type_group	URX_PUBLIC.ope_service_type	ser_type_group_id	ser_type_group_id
fk_ope_service_type_vector	URX_PUBLIC.ope_vector	URX_PUBLIC.ope_service_type	vec_id	ser_type_vector_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ope_price_service_type	URX_PUBLIC.ope_service_type	URX_PUBLIC.ope_price	ser_type_id	pri_service_type_id
fk_ope_service_item_service_type	URX_PUBLIC.ope_service_type	URX_PUBLIC.ope_service_item	ser_type_id	ser_item_type_id
fk_ope_service_recall_item_service_type	URX_PUBLIC.ope_service_type	URX_PUBLIC.ope_service_recall_item	ser_type_id	ser_recall_item_ser_type_id
fk_ope_service_type_chemical_service_type	URX_PUBLIC.ope_service_type	URX_PUBLIC.ope_service_type_chemical	ser_type_id	ser_type_che_service_type_id
fk_ope_service_type_pre_doc_ser_type	URX_PUBLIC.ope_service_type	URX_PUBLIC.ope_service_type_pre_doc	ser_type_id	ser_type_pre_doc_ser_type_id
fk_ope_service_type_product_service_type	URX_PUBLIC.ope_service_type	URX_PUBLIC.ope_service_type_product	ser_type_id	ser_type_pro_service_type_id
fk_ope_service_type_unit_type	URX_PUBLIC.ope_service_type	URX_PUBLIC.ope_service_type_unit	ser_type_id	ser_type_unit_type_id
fk_pro_activity_type_ope_service_type	URX_PUBLIC.ope_service_type	URX_PUBLIC.pro_activity_type	ser_type_id	act_type_service_type_id
fk_tel_evaluation_question_ope_service_type	URX_PUBLIC.ope_service_type	URX_PUBLIC.tel_evaluation_question	ser_type_id	eva_question_service_type_id

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

Used in Diagrams

Diagram Name

diagramA