Spacewalk DB Schema - Table-RHNFILEDOWNLOAD

Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Jobs Sanity Check Index DDL scrips

Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers Partitions

RHNFILEDOWNLOAD

Columns

Name	Type	Nullable	Default value	Comment
FILE_ID	NUMBER(38)	N
LOCATION	VARCHAR2(2000)	N
TOKEN	VARCHAR2(48)	Y
REQUESTOR_IP	VARCHAR2(15)	N
START_TIME	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
USER_ID	NUMBER(38)	Y

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_FILEDL_FID_FK	FILE_ID	RHNFILE	RHN_FILE_ID_PK	NO ACTION
RHN_FILEDL_UID_FK	USER_ID	WEB_CONTACT	WEB_CONTACT_PK	SET NULL

Options:

Option	Settings
Tablespace	USERS
Index Organized	No
Generated by Oracle	No
Clustered	No
Nested	No
Temporary	No

Indexes:

Index Name	Type	Unuqueness	Columns	DDL script
RHN_FILEDL_START_IDX	NORMAL	NONUNIQUE	START_TIME	DDL script
RHN_FILEDL_TOKEN_IDX	NORMAL	NONUNIQUE	TOKEN	DDL script
RHN_FILEDL_UID_FID_IDX	NORMAL	NONUNIQUE	USER_ID , FILE_ID	DDL script