ope_service - Table

uranux_desenv [uranux.xml]

Home

Tables

Schemas

Diagrams

Foreign Keys

Indexes

ope_service

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	ser_id	Integer			nextval('"URX_PUBLIC".ope_service_id_seq'::regclass)	Identificador
	ser_contract_id	Integer				Contrato
	ser_attendant	Integer				Atendente
	ser_customer	Integer				Cliente
	ser_operator	Integer				Atendente
	ser_unit_id	Integer				Unidade
	ser_number	Integer				Serviço Nº.
	ser_former_customer	Integer				Cliente Original
	ser_planned_date	Date				Data de execução planejada
	ser_group_id	SmallInt				Grupo de Serviços
	ser_status_id	SmallInt				Última Situação
	ser_require_certificate	SmallInt			0	Requer Certificado
	ser_way_id	SmallInt				Via de Entrada
	ser_payment_way	SmallInt				Forma de pagamento
	ser_is_imediate	SmallInt			0	Fechado na Hora
	ser_payment_qty	SmallInt			1	Número de parcelas
	ser_payment_first	SmallInt			30	Nº de dias da primeira parcela
	ser_planned_duration	SmallInt				Duração Estimada
	ser_is_canceled	SmallInt			0	Cancelado
	ser_control_type	SmallInt				Forma de Controle Obrigatório quando ser_group_id in ('Combate a Pragas', 'Jardinagem Profissional')
	ser_description	Text				Descrição
	ser_remarks	Text				Observações
	ser_desc_legacy	Text				Descrição do legado
	ser_payment_mode	SmallInt			2	Modo de Pagamento
	ser_payment_start	SmallInt			1	Início do Pagamento
	ser_payment_conc	SmallInt			0	Liquidar na Conclusão do Serviço
	ser_items	VarChar(255)				Itens do Serviço
	ser_payment_legacy	VarChar(80)				Forma de pagamento importada
	ser_control_non_chemical	VarChar(50)				Tipo de ação não química desenvolvida
	ser_start_time	VarChar(5)				Hora de início
	ser_finish_time	VarChar(5)				Hora de término
	ser_value	Numeric(10, 2)			0	Valor
	ser_discount_value	Numeric(10, 2)			0	Valor do desconto
	ser_total_value	Numeric(10, 2)			0	Valor total
	ser_first_value	Numeric(10, 2)			0	Valor da entrada
	ser_parcel_value	Numeric(10, 2)			0	Valor das parcelas

Indexes
Name	Table	Columns	Unique	Clustered
ix_ope_service_attendant	URX_PUBLIC.ope_service	ser_attendant
ix_ope_service_customer	URX_PUBLIC.ope_service	ser_customer
ix_ope_service_number	URX_PUBLIC.ope_service	ser_number
ix_ope_service_payment_option	URX_PUBLIC.ope_service	ser_payment_way
ix_ope_service_planned_date	URX_PUBLIC.ope_service	ser_planned_date
ix_ope_service_total_value	URX_PUBLIC.ope_service	ser_total_value
ix_ope_service_way_in	URX_PUBLIC.ope_service	ser_way_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ope_service_attendant	URX_PUBLIC.abi_employee	URX_PUBLIC.ope_service	emp_id	ser_attendant
fk_ope_service_customer	URX_PUBLIC.sel_customer	URX_PUBLIC.ope_service	cus_id	ser_customer
fk_ope_service_fin_contract	URX_PUBLIC.fin_contract	URX_PUBLIC.ope_service	con_id	ser_contract_id
fk_ope_service_group	URX_PUBLIC.ope_service_type_group	URX_PUBLIC.ope_service	ser_type_group_id	ser_group_id
fk_ope_service_operator	URX_PUBLIC.abi_employee	URX_PUBLIC.ope_service	emp_id	ser_operator
fk_ope_service_payment_way	URX_PUBLIC.fin_transaction_type	URX_PUBLIC.ope_service	tra_type_id	ser_payment_way
fk_ope_service_status_list	URX_PUBLIC.ope_service_status_list	URX_PUBLIC.ope_service	ser_status_id	ser_status_id
fk_ope_service_unit	URX_PUBLIC.adm_unit	URX_PUBLIC.ope_service	uni_person_id	ser_unit_id
fk_ope_service_way_in	URX_PUBLIC.sel_way_in	URX_PUBLIC.ope_service	way_id	ser_way_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_fin_billing_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.fin_billing	ser_id	bil_service_id
fk_fin_invoice_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.fin_invoice	ser_id	inv_service_id
fk_kno_notice_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.kno_notice	ser_id	not_service_id
fk_ope_analysis_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.ope_analysis	ser_id	ana_service_id
fk_ope_document_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.ope_document	ser_id	doc_service_id
fk_ope_service_item_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.ope_service_item	ser_id	ser_item_service_id
fk_ope_service_recall_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.ope_service_recall	ser_id	ser_recall_service_id
fk_ope_service_seller_service	URX_PUBLIC.ope_service	URX_PUBLIC.ope_service_seller	ser_id	ser_seller_service_id
fk_ope_service_status_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.ope_service_status	ser_id	ser_status_service_id
fk_ope_service_vector_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.ope_service_vector	ser_id	ser_vector_service_id
fk_ope_work_order_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.ope_work_order	ser_id	wor_order_service_id
fk_pro_activity_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.pro_activity	ser_id	act_service_id
fk_pro_project_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.pro_project	ser_id	pro_service_id
fk_sel_commission_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.sel_commission	ser_id	com_service_id
fk_sel_quotation_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.sel_quotation	ser_id	quo_service_id
fk_sto_request_service	URX_PUBLIC.ope_service	URX_PUBLIC.sto_request	ser_id	req_service_id
fk_sto_request_grain_service	URX_PUBLIC.ope_service	URX_PUBLIC.sto_request_grain	ser_id	req_grain_service_id
fk_tel_followup_service	URX_PUBLIC.ope_service	URX_PUBLIC.tel_followup	ser_id	fol_service_id

Triggers
Name	Table	On Delete	On Insert	On Update	Execute	For Each	SQL
tg_ope_service_create	URX_PUBLIC.ope_service				AFTER	FOR EACH ROW	"URX_PUBLIC"."_u ...
tg_ope_service_number	URX_PUBLIC.ope_service				BEFORE	FOR EACH ROW	"URX_PUBLIC"."_u ...
tg_ope_service_payment_quantity	URX_PUBLIC.ope_service				BEFORE	FOR EACH ROW	"URX_PUBLIC"."_u ...
tg_prevent_update_ope_service	URX_PUBLIC.ope_service				BEFORE	FOR EACH ROW	"URX_PUBLIC"."_u ...

diagramA