Dashboard > Electronic Research Administration > Database Schema > FIS_ER.SH_STATE_T
Electronic Research Administration Log In   View a printable version of the current page.
FIS_ER.SH_STATE_T
Added by Michael Clay, last edited by Michael Clay on Jul 12, 2005
Labels: 
(None)

Shared State Table

This is a table in tablespace FIS_ER.

Purpose:

Schema

name human readable name primary type size scale null default indexed comment
POSTAL_STATE_CD Postal State Code   VARCHAR2 2   No   Yes  
POSTAL_STATE_NM Postal State Name   VARCHAR2 30   Yes   No  

Potential Foreign Key Relationships

No relationships detected

Indexes

name colunm name column position direction
SH_STATE_TP1 POSTAL_STATE_CD 1 ASC

Source Code References

file name line number quote
erasrc/ERA/src/edu/iu/uis/fps/er/data/global/GB_StateDomainS
uper.java
63 this.setTableName("FIS_ER.SH_STATE_T");

DDL SQL

CREATE TABLE "FIS_ER"."SH_STATE_T" ("POSTAL_STATE_CD" VARCHAR2(2 
    byte) NOT NULL, "POSTAL_STATE_NM" VARCHAR2(30 byte))  
    TABLESPACE "FIS_ER" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 160K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0)

Site powered by a free Open Source Project / Non-profit License (more) of Confluence - the Enterprise wiki.
Learn more or evaluate Confluence for your organisation.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.2.7 Build:#524 Jul 28, 2006) - Bug/feature request - Contact Administrators