uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

sys_transaction

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	tra_dt	TimeStampWithTimeZone				Data
	tra_id	Integer			nextval('sys_transaction_id_seq'::regclass)	Identificador
	tra_user_id	Integer				Usuário
	tra_is_active	Boolean			false	Está Ativa
	tra_is_ajax	Boolean			false	É Ajax
	tra_icon_name	VarChar(40)				Arquivo de Imagem
	tra_ip_address	VarChar(15)				Endereço IP
	tra_protocol	VarChar(5)				Protocolo
	tra_request	hstore				Lista de Argumentos e Respectivos Valores
	tra_query_string	hstore				Query String

Indexes
Name	Table	Columns	Unique	Clustered
ix_sys_transaction_request	URX_PUBLIC.sys_transaction	tra_request
ix_sys_transaction_sys_user	URX_PUBLIC.sys_transaction	tra_user_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_sys_transaction_sys_user	URX_PUBLIC.sys_user	URX_PUBLIC.sys_transaction	use_id	tra_user_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_sys_transaction_create_sys_transaction	URX_PUBLIC.sys_transaction	URX_PUBLIC.sys_transaction_create	tra_id	tra_create_transaction_id
fk_sys_user_bookmark_sys_transaction	URX_PUBLIC.sys_transaction	URX_PUBLIC.sys_user_bookmark	tra_id	use_bookmark_transaction_id

Triggers
Name	Table	On Delete	On Insert	On Update	Execute	For Each	SQL
tg_tra_dt	URX_PUBLIC.sys_transaction				BEFORE	FOR EACH ROW	"URX_PUBLIC"."_u ...

Used in Diagrams

Diagram Name

diagramA