uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

adm_calendar_holliday

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	cal_holliday_city_id	Integer				Município
	cal_holliday_unit_id	Integer				Unidade
	cal_holliday_id	SmallInt			nextval('"URX_PUBLIC".adm_calendar_holliday_id_seq'::regclass)	Identificador
	cal_holliday_state_id	SmallInt				Estado
	cal_holliday_day	SmallInt				Dia
	cal_holliday_month	SmallInt				Mês
	cal_holliday_order	SmallInt				Nº de Ordem: 1º ao 4º
	cal_holliday_week_day	SmallInt				Dia da Semana
	cal_holliday_enable	SmallInt			1	Ativo
	cal_holliday_type	SmallInt				Escopo
	cal_holliday_delete_bit	SmallInt			0	Bit de Exclusão
	cal_holliday_reference	VarChar(255)				Legislação
	cal_holliday_label	VarChar(80)				Rótulo

Indexes
Name	Table	Columns	Unique	Clustered
ix_adm_calendar_holliday_delete_bit	URX_PUBLIC.adm_calendar_holliday	cal_holliday_delete_bit
ix_adm_calendar_holliday_enable	URX_PUBLIC.adm_calendar_holliday	cal_holliday_enable
ix_adm_calendar_holliday_sys_cep_state	URX_PUBLIC.adm_calendar_holliday	cal_holliday_state_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_adm_calendar_holliday_sys_cep_city	URX_PUBLIC.sys_cep_city	URX_PUBLIC.adm_calendar_holliday	cep_city_id	cal_holliday_city_id
fk_adm_calendar_holliday_sys_cep_state	URX_PUBLIC.sys_cep_state	URX_PUBLIC.adm_calendar_holliday	cep_state_id	cal_holliday_state_id
fk_adm_calendar_holliday_unit	URX_PUBLIC.adm_unit	URX_PUBLIC.adm_calendar_holliday	uni_person_id	cal_holliday_unit_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_adm_calendar_special_adm_calendar_holliday	URX_PUBLIC.adm_calendar_holliday	URX_PUBLIC.adm_calendar_special	cal_holliday_id	cal_special_id

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

Used in Diagrams

Diagram Name

diagramA