Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
EU_IDENTIFIER NUMBER(9,0) No null 1 System-generated unique identifier for this external user record (sequence: SIT209_SEQ).
TOKEN VARCHAR2(50 BYTE) No null 2 A unique identifier (from NAP or similar) for this external user.
START_DATE DATE No null 3 The start date/time of the tracking period over which the count of service accesses by this external user will be accumulated.
END_DATE DATE No null 4 The expiration date/time of this token.
ACCESS_COUNT NUMBER(4,0) No 5 The count of the number of times SIT/209 services have been accessed by this external user over the tracking period (from BEGIN_DATE to END_DATE).
CONSTRAINT_NAME CONSTRAINT_TYPE SEARCH_CONDITION R_OWNER R_TABLE_NAME R_CONSTRAINT_NAME DELETE_RULE STATUS DEFERRABLE VALIDATED GENERATED BAD RELY LAST_CHANGE INDEX_OWNER INDEX_NAME INVALID VIEW_RELATED
EU_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 21-NOV-13 22:39:42 SIT209 EU_PK null null
EU_UK Unique null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 21-NOV-13 22:39:42 SIT209 EU_UK null null
SYS_C00220153 Check "EU_IDENTIFIER" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 21-NOV-13 22:39:42 null null null null
SYS_C00220154 Check "TOKEN" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 21-NOV-13 22:39:42 null null null null
SYS_C00220155 Check "START_DATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 21-NOV-13 22:39:42 null null null null
SYS_C00220156 Check "END_DATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 21-NOV-13 22:39:42 null null null null
SYS_C00220157 Check "ACCESS_COUNT" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 21-NOV-13 22:39:42 null null null null



Columns


COLUMN_NAME COLUMN_POSITION
EU_IDENTIFIER 1
COLUMN_NAME COLUMN_POSITION
TOKEN 1
COLUMN_NAME COLUMN_POSITION
EU_IDENTIFIER null
COLUMN_NAME COLUMN_POSITION
TOKEN null
COLUMN_NAME COLUMN_POSITION
START_DATE null
COLUMN_NAME COLUMN_POSITION
END_DATE null
COLUMN_NAME COLUMN_POSITION
ACCESS_COUNT null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
SELECT FAMWEBREADONLY NO SIT209 EXTERNAL_USERS
NAME VALUE
NUM_ROWS 1
BLOCKS 5
AVG_ROW_LEN 34
SAMPLE_SIZE 1
LAST_ANALYZED 13-JAN-15 22:00:15
LAST_ANALYZED_SINCE 13-JAN-15 22:00:15



Column Statistics


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME
BRI_EU_TRG BEFORE EACH ROW SIT209 INSERT ENABLED EXTERNAL_USERS




TRIGGER SIT209.BRI_EU_TRG
 BEFORE
  INSERT
 ON SIT209.EXTERNAL_USERS
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
BEGIN
  if Inserting then
    -- Set EU_IDENTIFIER on insert if not supplied.
    begin
      if :new.eu_identifier IS NULL then
        :new.eu_identifier := sit209.sit209_util.getNextKeyValue('SIT209.SIT209_SEQ');
      end if;
    end;
  end if;
END;
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
SIT209 BRI_EU_TRG TRIGGER SIT209 EXTERNAL_USERS TABLE



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
NAME VALUE
CREATED 21-NOV-13 22:39:42
LAST_DDL_TIME 04-JAN-18 16:39:59
OWNER SIT209
TABLE_NAME EXTERNAL_USERS
TABLESPACE_NAME SIT209_DATA
CLUSTER_NAME null
IOT_NAME null
STATUS VALID
PCT_FREE 10
PCT_USED null
INI_TRANS 1
MAX_TRANS 255
INITIAL_EXTENT 65536
NEXT_EXTENT null
MIN_EXTENTS 1
MAX_EXTENTS 2147483645
PCT_INCREASE null
FREELISTS null
FREELIST_GROUPS null
LOGGING YES
BACKED_UP N
NUM_ROWS 1
BLOCKS 5
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 34
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 1
LAST_ANALYZED 13-JAN-15 22:00:15
PARTITIONED NO
IOT_TYPE null
OBJECT_ID_TYPE null
TABLE_TYPE_OWNER null
TABLE_TYPE null
TEMPORARY N
SECONDARY N
NESTED NO
BUFFER_POOL DEFAULT
ROW_MOVEMENT ENABLED
GLOBAL_STATS YES
USER_STATS NO
DURATION null
SKIP_CORRUPT DISABLED
MONITORING YES
CLUSTER_OWNER null
DEPENDENCIES DISABLED
COMPRESSION DISABLED
DROPPED NO
COMMENTS A table of external users that keeps track of the number of times an external user has accessed SIT/209 services within a given time period (start-date to end-date).  Table is primarily used to identify excessive use (abuse, denial of service attacks, etc.), in a short period of time, of SIT/209 services.
PARTITION_NAME LAST_ANALYZED NUM_ROWS BLOCKS SAMPLE_SIZE HIGH_VALUE




INDEX_OWNER INDEX_NAME UNIQUENESS STATUS INDEX_TYPE TEMPORARY PARTITIONED FUNCIDX_STATUS JOIN_INDEX COLUMNS COLUMN_EXPRESSION
SIT209 EU_PK UNIQUE VALID NORMAL N NO null NO EU_IDENTIFIER null
SIT209 EU_UK UNIQUE VALID NORMAL N NO null NO TOKEN null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 EU_PK SIT209 EXTERNAL_USERS EU_IDENTIFIER 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SIT209 EU_UK SIT209 EXTERNAL_USERS TOKEN 1 50 50 ASC