-- created by Oraschemadoc Wed Mar  4 07:57:46 2020
-- visit http://www.yarpen.cz/oraschemadoc/ for more info

  CREATE TABLE "SPACEUSER"."RHNUSERINFO" 
   (	"USER_ID" NUMBER NOT NULL ENABLE, 
	"NO_CLEAR_SETS" NUMBER DEFAULT (0) NOT NULL ENABLE, 
	"PAGE_SIZE" NUMBER DEFAULT (20) NOT NULL ENABLE, 
	"EMAIL_NOTIFY" NUMBER DEFAULT (1) NOT NULL ENABLE, 
	"TASKO_NOTIFY" CHAR(1) DEFAULT ('Y') NOT NULL ENABLE, 
	"BAD_EMAIL" NUMBER DEFAULT (0) NOT NULL ENABLE, 
	"TZ_OFFSET" NUMBER DEFAULT (-5) NOT NULL ENABLE, 
	"TIMEZONE_ID" NUMBER, 
	"SHOW_APPLIED_ERRATA" CHAR(1) DEFAULT ('N') NOT NULL ENABLE, 
	"SHOW_SYSTEM_GROUP_LIST" CHAR(1) DEFAULT ('N') NOT NULL ENABLE, 
	"AGREED_TO_TERMS" CHAR(1) DEFAULT ('N') NOT NULL ENABLE, 
	"USE_PAM_AUTHENTICATION" CHAR(1) DEFAULT ('N') NOT NULL ENABLE, 
	"LAST_LOGGED_IN" TIMESTAMP (6) WITH LOCAL TIME ZONE, 
	"AGREED_TO_WS_TERMS" CHAR(1), 
	"AGREED_TO_ES_TERMS" CHAR(1), 
	"CREATED" TIMESTAMP (6) WITH LOCAL TIME ZONE DEFAULT (current_timestamp) NOT NULL ENABLE, 
	"MODIFIED" TIMESTAMP (6) WITH LOCAL TIME ZONE DEFAULT (current_timestamp) NOT NULL ENABLE, 
	"PREFERRED_LOCALE" VARCHAR2(8), 
	"CSV_SEPARATOR" CHAR(1) DEFAULT (',') NOT NULL ENABLE, 
	 CONSTRAINT "RHN_USER_INFO_TASKO_CK" CHECK (tasko_notify in ('Y', 'N')) ENABLE, 
	 CONSTRAINT "RHN_USER_INFO_TZOFFSET_CK" CHECK (tz_offset >= -11 and tz_offset <= 13) ENABLE, 
	 CONSTRAINT "RHN_USER_INFO_SEA_CK" CHECK (show_applied_errata in ('Y','N')) ENABLE, 
	 CONSTRAINT "RHN_USER_INFO_SSGL_CK" CHECK (show_system_group_list in ('Y','N')) ENABLE, 
	 CONSTRAINT "RHN_USER_INFO_AGREED_CK" CHECK (agreed_to_terms in ('Y','N')) ENABLE, 
	 CONSTRAINT "RHN_USER_INFO_PAM_CK" CHECK (use_pam_authentication in ('Y','N')) ENABLE, 
	 CONSTRAINT "RHN_USER_INFO_WS_CK" CHECK (agreed_to_ws_terms is null or agreed_to_ws_terms in ('Y','N')) ENABLE, 
	 CONSTRAINT "RHN_USER_INFO_ES_CK" CHECK (agreed_to_es_terms is null or agreed_to_es_terms in ('Y','N')) ENABLE, 
	 CONSTRAINT "RHN_USER_INFO_CSV_CK" CHECK (csv_separator in (',',';')) ENABLE, 
	 CONSTRAINT "RHN_USER_INFO_UID_UQ" UNIQUE ("USER_ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE, 
	 CONSTRAINT "RHN_USER_INFO_USER_FK" FOREIGN KEY ("USER_ID")
	  REFERENCES "SPACEUSER"."WEB_CONTACT" ("ID") ON DELETE CASCADE ENABLE, 
	 CONSTRAINT "RHN_USER_INFO_TZID_FK" FOREIGN KEY ("TIMEZONE_ID")
	  REFERENCES "SPACEUSER"."RHNTIMEZONE" ("ID") ON DELETE CASCADE ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE ROW MOVEMENT 
/
