uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

sys_user_session

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	use_session_start_dt	TimeStamp				Data-Hora de Início da Sessão
	use_session_finish_dt	TimeStamp				Data-Hora de Término da Sessão
	use_session_user_id	Integer				Usuário
	use_session_disconnect_mode	SmallInt				Modo de desconexão: 1 => user requested logout 2 => session expired (javascript request) 3 => user was banned 4 => user asking to recover his password was forced to disconnect 5 => cookie was removed 6 => lost connection 7 => session expired (php's oneMinuteJob)
	use_session_ip_address	VarChar(20)				Endereço IP
	use_session_id	VarChar(255)				Sessão
	use_session_is_mobile	Boolean			false	A conexão foi realizada utilizando o aplicativo

Indexes
Name	Table	Columns	Unique	Clustered
ix_use_session_user_id	URX_PUBLIC.sys_user_session	use_session_user_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_use_session_user_id	URX_PUBLIC.sys_user	URX_PUBLIC.sys_user_session	use_id	use_session_user_id

Parent Relations (none)

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

Used in Diagrams

Diagram Name

diagramA