uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

kno_notice

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	not_point	geography(, 4326)				Coordenadas Geográficas
	not_dt	TimeStampWithTimeZone				Data-hora
	not_id	Integer			nextval('"URX_PUBLIC".kno_notice_id_seq'::regclass)	Identificador
	not_unit_id	Integer				Unidade
	not_user_id	Integer				Remetente
	not_file_id	Integer				Arquivo
	not_module_id	Integer				Módulo
	not_service_id	Integer				Serviço
	not_type_id	SmallInt				Tipo
	not_display	SmallInt			0	Publicada
	not_delete_bit	SmallInt			0	Bit de Exclusão
	not_title	VarChar(255)				Título
	not_text	Text				Conteúdo

Indexes
Name	Table	Columns	Unique	Clustered
ix_kno_notice_dt	URX_PUBLIC.kno_notice	not_dt
ix_kno_notice_kno_notice_type	URX_PUBLIC.kno_notice	not_type_id
ix_kno_notice_sys_file	URX_PUBLIC.kno_notice	not_file_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_kno_notice_kno_notice_type	URX_PUBLIC.kno_notice_type	URX_PUBLIC.kno_notice	not_type_id	not_type_id
fk_kno_notice_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.kno_notice	ser_id	not_service_id
fk_kno_notice_sys_file	URX_PUBLIC.sys_file	URX_PUBLIC.kno_notice	fil_id	not_file_id
fk_kno_notice_sys_module	URX_PUBLIC.sys_module	URX_PUBLIC.kno_notice	mod_id	not_module_id
fk_kno_notice_sys_user	URX_PUBLIC.sys_user	URX_PUBLIC.kno_notice	use_id	not_user_id
fk_kno_notice_unit	URX_PUBLIC.adm_unit	URX_PUBLIC.kno_notice	uni_person_id	not_unit_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_kno_notice_user_notice	URX_PUBLIC.kno_notice	URX_PUBLIC.kno_notice_user	not_id	not_user_notice_id

Triggers
Name	Table	On Delete	On Insert	On Update	Execute	For Each	SQL
tg_kno_notice_create	URX_PUBLIC.kno_notice				AFTER	FOR EACH ROW	"URX_PUBLIC"."_u ...
tg_not_dt	URX_PUBLIC.kno_notice				BEFORE	FOR EACH ROW	"URX_PUBLIC"."_u ...

Used in Diagrams

Diagram Name

diagramA