uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

sys_ticket

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	tic_id	Integer			nextval('"URX_PUBLIC".sys_ticket_id_seq'::regclass)	Identificador
	tic_user_id	Integer				Usuário
	tic_number	Integer			nextval('"URX_PUBLIC".sys_ticket_number_seq'::regclass)	Incidente Nº.
	tic_type_id	SmallInt			1	Tipo
	tic_method	SmallInt			0	Método
	tic_priority_id	SmallInt			3	Prioridade
	tic_delete_bit	SmallInt			0	Bit de Exclusão
	tic_line_nr	SmallInt				Linha Nº.
	tic_layer_tx	VarChar(50)				Camada
	tic_file_tx	VarChar(255)				Nome do Arquivo
	tic_user_agent_tx	VarChar(255)				Navegador
	tic_ip_address	VarChar(20)				Endereço IP
	tic_desc_tx	Text				Descrição
	tic_submited_args	hstore				Argumentos Submetidos
	tic_query_string	hstore				Query String

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_sys_ticket_sys_ticket_type	URX_PUBLIC.sys_ticket_type	URX_PUBLIC.sys_ticket	tic_type_id	tic_type_id
fk_sys_ticket_sys_user	URX_PUBLIC.sys_user	URX_PUBLIC.sys_ticket	use_id	tic_user_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_sys_ticket_status_sys_ticket	URX_PUBLIC.sys_ticket	URX_PUBLIC.sys_ticket_status	tic_id	tic_status_ticket_id

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

Used in Diagrams

Diagram Name

diagramA