Table TD_SECTION_TITLE in DWST@WHSE.ISC-AIT.UPENN.EDU

Tables

*Section Title contains the descriptive name of a particular course.*
Col #	Column Name	Data Type	Not Null?	Data Def.	Comments
1	TITLE_KEY	INTEGER	Y		The primary key of the table.
2	SECTION_TITLE	VARCHAR2(105 BYTE)			The title of the course.

**Indexes on TD_SECTION_TITLE**
Uniqueness	Index Name	Columns
UNIQUE	SYS_C00511920	TITLE_KEY
NON-UNIQUE	TD_SECTION_TITLE_FUNCTION_IDX	NVL("SECTION_TITLE",'A')
NON-UNIQUE	TD_SECTION_TITLE_IDX	SECTION_TITLE

Triggers on TD_SECTION_TITLE

Trigger Name

Status

Triggering Event

When Clause

Trigger Type

Body

TD_SECTION_TITLE_PK_TRIG

ENABLED

INSERT

BEFORE EACH ROW

BEGIN

    SELECT TD_SECTION_TITLE_PK_SEQ.NEXTVAL INTO :NEW.TITLE_KEY FROM dual;

   EXCEPTION
     WHEN OTHERS THEN
       -- Consider logging the error and then re-raise
       RAISE;
END ;

**PK, UK, & Check Constraints on TD_SECTION_TITLE**
Name	Type	Condition	Status	Columns
SYS_C00511920	Primary Key		ENABLED	TITLE_KEY

**Granted Privileges on TD_SECTION_TITLE**
Column	Grantee	Grantable Privilege(s)	Non-Grantable Privilege(s)
	ESTEMMLE		SELECT
	DWADMIN		ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK
	YALINGX		SELECT
	DWST_SUPPORT		SELECT
	TUITION_DIST_RL		SELECT

--------- TD_SECTION_TITLE does not reference any objects ---------

**Objects which reference table TD_SECTION_TITLE**
Object Owner	Object Name	Object Type
DWST	TD_DISTRIBUTION_FACT	Table (FK)
DWST	TD_INSTRUCTOR_SECTION_FACT	Table (FK)
DWST	TD_STUDENT_REGISTRATION_FACT	Table (FK)
DWST	TD_SECTION_TITLE_PK_TRIG	Trigger