-- c:\oragen\tables.con
--
-- Generated for Oracle 8 on Tue Mar 05  08:37:40 2002 by Server Generator 6.0.3.11.0
  
PROMPT Creating Primary Key on 'MAIL_LISTS'
ALTER TABLE MAIL_LISTS
 ADD (CONSTRAINT MAIL_LIST_PK PRIMARY KEY 
  (NAME)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'TEST_CMNTS'
ALTER TABLE TEST_CMNTS
 ADD (CONSTRAINT TEST_CMNT_PK PRIMARY KEY 
  (CMNT_NO)
 USING INDEX 
 PCTFREE 10
)
/

PROMPT Creating Primary Key on 'LOCNS'
ALTER TABLE LOCNS
 ADD (CONSTRAINT LOCN_PK PRIMARY KEY 
  (LOCN_NAME)
 USING INDEX 
 PCTFREE 10
)
/

PROMPT Creating Primary Key on 'TSTABCDCHS'
ALTER TABLE TSTABCDCHS
 ADD (CONSTRAINT TSTABCDCH_PK PRIMARY KEY 
  (CHAN_NUM
  ,TEST_NO)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'ASSM_DESCR'
ALTER TABLE ASSM_DESCR
 ADD (CONSTRAINT ASSM_DESCR_PK PRIMARY KEY 
  (POSN
  ,ASSM_CTYPE
  ,CTYPE)
 USING INDEX 
 PCTFREE 10
)
/

PROMPT Creating Primary Key on 'TSTDETMFRS'
ALTER TABLE TSTDETMFRS
 ADD (CONSTRAINT TSTDETMFR_PK PRIMARY KEY 
  (TEST_NO)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'PERSONS'
ALTER TABLE PERSONS
 ADD (CONSTRAINT PERSON_PK PRIMARY KEY 
  (INITLS)
 USING INDEX 
 PCTFREE 10
)
/

PROMPT Creating Primary Key on 'ASSM_ITEMS'
ALTER TABLE ASSM_ITEMS
 ADD (CONSTRAINT ASSM_ITEM_PK PRIMARY KEY 
  (ASSM_CTYPE
  ,CTYPE
  ,POSN
  ,ASSM_SER_NO)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'SHIP_ITEMS'
ALTER TABLE SHIP_ITEMS
 ADD (CONSTRAINT SHIP_ITEM_PK PRIMARY KEY 
  (SER_NO
  ,SHIP_NO)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'ITEM_DESCR'
ALTER TABLE ITEM_DESCR
 ADD (CONSTRAINT ITEM_DESCR_PK PRIMARY KEY 
  (CTYPE)
 USING INDEX 
 PCTFREE 10
)
/

PROMPT Creating Primary Key on 'EVENT_DESCR'
ALTER TABLE EVENT_DESCR
 ADD (CONSTRAINT EVENT_DESC_PK PRIMARY KEY 
  (EVENT_NAME)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'TSTDETIVS'
ALTER TABLE TSTDETIVS
 ADD (CONSTRAINT TSTDETIV_PK PRIMARY KEY 
  (TEST_NO)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'WEB_LINKS'
ALTER TABLE WEB_LINKS
 ADD (CONSTRAINT WEB_LINK_PK PRIMARY KEY 
  (WEB_LINK_ID)
 USING INDEX 
 PCTFREE 10
)
/

PROMPT Creating Primary Key on 'TEST_IMAGES'
ALTER TABLE TEST_IMAGES
 ADD (CONSTRAINT TEST_IMAGE_PK PRIMARY KEY 
  (NAME
  ,TEST_NO)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'MAILS'
ALTER TABLE MAILS
 ADD (CONSTRAINT MAIL_PK PRIMARY KEY 
  (ADDRESS
  ,MAIL_LIST_NAME)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'TSTMODXY'
ALTER TABLE TSTMODXY
 ADD (CONSTRAINT TSTMODXY_PK PRIMARY KEY 
  (TEST_NO)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'TEST_WAFER_E_PARAM'
ALTER TABLE TEST_WAFER_E_PARAM
 ADD (CONSTRAINT TSTWAFEPAR_PK PRIMARY KEY 
  (STRUCTURE
  ,TEST_NO)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'TSTHYBRC'
ALTER TABLE TSTHYBRC
 ADD (CONSTRAINT TSTHYBRC_PK PRIMARY KEY 
  (TEST_NO)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'ITEM_CMNTS'
ALTER TABLE ITEM_CMNTS
 ADD (CONSTRAINT ITEM_CMNT_PK PRIMARY KEY 
  (CMNT_NO)
 USING INDEX 
 PCTFREE 10
)
/

PROMPT Creating Primary Key on 'TSTDETOPTS'
ALTER TABLE TSTDETOPTS
 ADD (CONSTRAINT TSTDETOPT_PK PRIMARY KEY 
  (TEST_NO)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'TEST_LIST'
ALTER TABLE TEST_LIST
 ADD (CONSTRAINT TEST_LIST_PK PRIMARY KEY 
  (TEST_NAME
  ,CTYPE)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'TEST_LIMITS'
ALTER TABLE TEST_LIMITS
 ADD (CONSTRAINT TEST_LIMIT_PK PRIMARY KEY 
  (PARM_NAME
  ,MFR
  ,TEST_NAME
  ,CTYPE)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'DISASSMLOGS'
ALTER TABLE DISASSMLOGS
 ADD (CONSTRAINT DISASSMLOG_PK PRIMARY KEY 
  (DISASSM_DATE
  ,SER_NO
  ,ASSM_SER_NO)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'TSTABCD'
ALTER TABLE TSTABCD
 ADD (CONSTRAINT TSTABCD_PK PRIMARY KEY 
  (TEST_NO)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'DEFECTS'
ALTER TABLE DEFECTS
 ADD (CONSTRAINT DEFECT_PK PRIMARY KEY 
  (CHAN_1ST
  ,DEFECT_NAME
  ,TEST_NO)
 USING INDEX 
 PCTFREE 10
)
/

PROMPT Creating Primary Key on 'MFRS'
ALTER TABLE MFRS
 ADD (CONSTRAINT MFR_PK PRIMARY KEY 
  (MFR)
 USING INDEX 
 PCTFREE 10
)
/

PROMPT Creating Primary Key on 'ITEM_IMAGES'
ALTER TABLE ITEM_IMAGES
 ADD (CONSTRAINT IT_IMAGE_PK PRIMARY KEY 
  (SER_NO
  ,NAME)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'TESTS'
ALTER TABLE TESTS
 ADD (CONSTRAINT TEST_PK PRIMARY KEY 
  (TEST_NO)
 USING INDEX 
 PCTFREE 10
)
/

PROMPT Creating Primary Key on 'SHIP'
ALTER TABLE SHIP
 ADD (CONSTRAINT SHIP_PK PRIMARY KEY 
  (SHIP_NO)
 USING INDEX 
 PCTFREE 10
)
/

PROMPT Creating Primary Key on 'ITEM_CATEGORIES'
ALTER TABLE ITEM_CATEGORIES
 ADD (CONSTRAINT ITEM_CAT_PK PRIMARY KEY 
  (CATEGORY)
 USING INDEX 
 PCTFREE 10
)
/

PROMPT Creating Primary Key on 'ITEM_EVENTS'
ALTER TABLE ITEM_EVENTS
 ADD (CONSTRAINT ITEM_EVENT_PK PRIMARY KEY 
  (ID)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'ITEMS'
ALTER TABLE ITEMS
 ADD (CONSTRAINT ITEM_PK PRIMARY KEY 
  (SER_NO)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'MFR_ACCESS'
ALTER TABLE MFR_ACCESS
 ADD (CONSTRAINT MFR_ACCESS_PK PRIMARY KEY 
  (ID)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'STOCKS'
ALTER TABLE STOCKS
 ADD (CONSTRAINT STOCK_PK PRIMARY KEY 
  (LOCN_NAME
  ,SER_NO)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'DEFECT_DESCR'
ALTER TABLE DEFECT_DESCR
 ADD (CONSTRAINT DEFCT_DESC_PK PRIMARY KEY 
  (DEFECT_NAME)
 USING INDEX 
 PCTFREE 10
)
/

PROMPT Creating Primary Key on 'TEST_DESCR'
ALTER TABLE TEST_DESCR
 ADD (CONSTRAINT TEST_DESCR_PK PRIMARY KEY 
  (TEST_NAME)
 USING INDEX 
 PCTFREE 10
)
/

PROMPT Creating Primary Key on 'TSTMODZ'
ALTER TABLE TSTMODZ
 ADD (CONSTRAINT TSTMODZ_PK PRIMARY KEY 
  (TEST_NO)
 USING INDEX 
)
/

PROMPT Creating Primary Key on 'TEST_RAWDATA'
ALTER TABLE TEST_RAWDATA
 ADD (CONSTRAINT TST_DATA_PK PRIMARY KEY 
  (TEST_NO)
 USING INDEX 
 PCTFREE 10
)
/

PROMPT Creating Unique Keys on 'LOCNS'
ALTER TABLE LOCNS 
 ADD ( CONSTRAINT LOCN_UNIQUE UNIQUE 
  (LOCN)
 USING INDEX 
)
/
  
PROMPT Creating Check Constraints on 'TEST_CMNTS'
ALTER TABLE TEST_CMNTS
 ADD (CONSTRAINT AVCON_1911_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'LOCNS'
ALTER TABLE LOCNS
 ADD (CONSTRAINT AVCON_1904_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'TSTABCDCHS'
ALTER TABLE TSTABCDCHS
 ADD (CONSTRAINT AVCON_311011_GAIN_000 CHECK (GAIN BETWEEN 0 AND 500))
 ADD (CONSTRAINT AVCON_311011_OFFSE_000 CHECK (OFFSET BETWEEN -600 AND 600))
 ADD (CONSTRAINT AVCON_311011_CHAN__000 CHECK (CHAN_NUM BETWEEN 0 AND 127))
 ADD (CONSTRAINT AVCON_311011_NOISE_000 CHECK (NOISE BETWEEN 0 AND 50))
 ADD (CONSTRAINT AVCON_311011_TRDAC_000 CHECK (TRDACSLOPE BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_311011_TRDAC_001 CHECK (TRDACERR BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_311011_CHSTA_000 CHECK (CHSTATUS BETWEEN 0 AND 4294967295))
 ADD (CONSTRAINT AVCON_311011_CHSTA_001 CHECK (CHSTATUSVALID BETWEEN 0 AND 4294967295))
/
 
PROMPT Creating Check Constraints on 'ASSM_DESCR'
ALTER TABLE ASSM_DESCR
 ADD (CONSTRAINT AVCON_2206_POSN_000 CHECK (POSN BETWEEN 0 AND 999))
 ADD (CONSTRAINT AVCON_2206_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'TSTDETMFRS'
ALTER TABLE TSTDETMFRS
 ADD (CONSTRAINT AVCON_97488_THICK_000 CHECK (THICKNESS BETWEEN 200 AND 400))
 ADD (CONSTRAINT AVCON_97488_V_DEP_000 CHECK (V_DEP BETWEEN 0 AND 400))
 ADD (CONSTRAINT AVCON_97488_R_BIA_000 CHECK (R_BIAS_UPPER BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_97488_R_BIA_001 CHECK (R_BIAS_LOWER BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_97488_TEMPE_000 CHECK (TEMPERATURE BETWEEN -30 AND 100))
 ADD (CONSTRAINT AVCON_97488_I_LEA_000 CHECK (I_LEAK_150 BETWEEN 0 AND 99999999))
 ADD (CONSTRAINT AVCON_97488_I_LEA_001 CHECK (I_LEAK_350 BETWEEN 0 AND 99999999))
/
 
PROMPT Creating Check Constraints on 'PERSONS'
ALTER TABLE PERSONS
 ADD (CONSTRAINT AVCON_1906_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'ASSM_ITEMS'
ALTER TABLE ASSM_ITEMS
 ADD (CONSTRAINT AVCON_2228_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'SHIP_ITEMS'
ALTER TABLE SHIP_ITEMS
 ADD (CONSTRAINT AVCON_19648_RECVD_000 CHECK (RECVD IN ('YES', 'NO')))
 ADD (CONSTRAINT AVCON_19648_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'ITEM_DESCR'
ALTER TABLE ITEM_DESCR
 ADD (CONSTRAINT AVCON_1903_NO_CO_000 CHECK (NO_COMPS BETWEEN 0 AND 999))
 ADD (CONSTRAINT AVCON_1903_IS_UN_000 CHECK (IS_UNIQUE IN ('YES', 'NO')))
 ADD (CONSTRAINT AVCON_1903_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
  
PROMPT Creating Check Constraints on 'TSTDETIVS'
ALTER TABLE TSTDETIVS
 ADD (CONSTRAINT AVCON_97482_TEMPE_000 CHECK (TEMPERATURE BETWEEN -30 AND 100))
 ADD (CONSTRAINT AVCON_97482_ANNEA_000 CHECK (ANNEAL_TIME BETWEEN 0 AND 99999999))
 ADD (CONSTRAINT AVCON_97482_I_LEA_000 CHECK (I_LEAK_150 BETWEEN 0 AND 99999999))
 ADD (CONSTRAINT AVCON_97482_I_LEA_001 CHECK (I_LEAK_350 BETWEEN 0 AND 99999999))
 ADD (CONSTRAINT AVCON_97482_RAD_D_000 CHECK (RAD_DOSE BETWEEN 0 AND 10))
/
 
PROMPT Creating Check Constraints on 'WEB_LINKS'
ALTER TABLE WEB_LINKS
 ADD (CONSTRAINT AVCON_1915_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
   
PROMPT Creating Check Constraints on 'TSTMODXY'
ALTER TABLE TSTMODXY
 ADD (CONSTRAINT AVCON_234670_MHX_000 CHECK (MHX BETWEEN -100 AND 0))
 ADD (CONSTRAINT AVCON_234670_MHY_000 CHECK (MHY BETWEEN -50 AND 5))
 ADD (CONSTRAINT AVCON_234670_MSX_000 CHECK (MSX BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_234670_MSY_000 CHECK (MSY BETWEEN -50 AND 5))
 ADD (CONSTRAINT AVCON_234670_MIDXF_000 CHECK (MIDXF BETWEEN -1 AND 1))
 ADD (CONSTRAINT AVCON_234670_MIDYF_000 CHECK (MIDYF BETWEEN -1 AND 1))
 ADD (CONSTRAINT AVCON_234670_SEPF_000 CHECK (SEPF BETWEEN 50 AND 70))
 ADD (CONSTRAINT AVCON_234670_SEPB_000 CHECK (SEPB BETWEEN 50 AND 70))
 ADD (CONSTRAINT AVCON_234670_STERE_000 CHECK (STEREO BETWEEN -25 AND -15))
 ADD (CONSTRAINT AVCON_234670_A1_000 CHECK (A1 BETWEEN -1 AND 1))
 ADD (CONSTRAINT AVCON_234670_A2_000 CHECK (A2 BETWEEN -1 AND 1))
 ADD (CONSTRAINT AVCON_234670_A3_000 CHECK (A3 BETWEEN -1 AND 1))
 ADD (CONSTRAINT AVCON_234670_A4_000 CHECK (A4 BETWEEN -1 AND 1))
 ADD (CONSTRAINT AVCON_234670_TEMPE_000 CHECK (TEMPERATURE BETWEEN -20 AND 70))
/
 
PROMPT Creating Check Constraints on 'TEST_WAFER_E_PARAM'
ALTER TABLE TEST_WAFER_E_PARAM
 ADD (CONSTRAINT AVCON_325908_STRUC_000 CHECK (STRUCTURE BETWEEN 1 AND 5))
 ADD (CONSTRAINT AVCON_325908_VTN08_000 CHECK (VTN08 BETWEEN 0.0 AND 5.0))
 ADD (CONSTRAINT AVCON_325908_IDN08_000 CHECK (IDN08 BETWEEN 0 AND 20))
 ADD (CONSTRAINT AVCON_325908_BVN08_000 CHECK (BVN08 BETWEEN 0 AND 25))
 ADD (CONSTRAINT AVCON_325908_VTP08_000 CHECK (VTP08 BETWEEN 0 AND 5))
 ADD (CONSTRAINT AVCON_325908_IDP08_000 CHECK (IDP08 BETWEEN 0 AND 20))
 ADD (CONSTRAINT AVCON_325908_BVP08_000 CHECK (BVP08 BETWEEN 0 AND 20))
 ADD (CONSTRAINT AVCON_325908_RSBL_000 CHECK (RSBL BETWEEN 0 AND 1000))
 ADD (CONSTRAINT AVCON_325908_RSN_P_000 CHECK (RSN_PLUS BETWEEN 0 AND 200))
 ADD (CONSTRAINT AVCON_325908_RSP_P_000 CHECK (RSP_PLUS BETWEEN 0 AND 200))
 ADD (CONSTRAINT AVCON_325908_RSP1_000 CHECK (RSP1 BETWEEN 0 AND 5))
 ADD (CONSTRAINT AVCON_325908_BETA__000 CHECK (BETA_AT_10 BETWEEN 0 AND 1000))
 ADD (CONSTRAINT AVCON_325908_BETA__001 CHECK (BETA_AT_100 BETWEEN 0 AND 1000))
 ADD (CONSTRAINT AVCON_325908_VAT_000 CHECK (VAT BETWEEN 0 AND 500))
 ADD (CONSTRAINT AVCON_325908_BVCEO_000 CHECK (BVCEOT BETWEEN 0 AND 20))
 ADD (CONSTRAINT AVCON_325908_BVCES_000 CHECK (BVCEST BETWEEN 0 AND 30))
 ADD (CONSTRAINT AVCON_325908_VPJ12_000 CHECK (VPJ12 BETWEEN 0 AND 5))
 ADD (CONSTRAINT AVCON_325908_IDPJ1_000 CHECK (IDPJ12 BETWEEN 0 AND 50))
 ADD (CONSTRAINT AVCON_325908_RCM1N_000 CHECK (RCM1N_PLUS BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_325908_RCM1P_000 CHECK (RCM1P_PLUS BETWEEN 0 AND 200))
 ADD (CONSTRAINT AVCON_325908_RCM1P_001 CHECK (RCM1P1 BETWEEN 0 AND 2))
 ADD (CONSTRAINT AVCON_325908_RCM2M_000 CHECK (RCM2M1 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_325908_RSRHV_000 CHECK (RSRHV BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_325908_REXTR_000 CHECK (REXTRINS BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_325908_TOXP1_000 CHECK (TOXP1N_PLUS BETWEEN 0 AND 1000))
 ADD (CONSTRAINT AVCON_325908_B12X1_000 CHECK (B12X10_AT_10 BETWEEN 0 AND 1000))
 ADD (CONSTRAINT AVCON_325908_B12X1_001 CHECK (B12X10_AT_100 BETWEEN 0 AND 1000))
 ADD (CONSTRAINT AVCON_325908_VEARL_000 CHECK (VEARLY BETWEEN 0 AND 250))
 ADD (CONSTRAINT AVCON_325908_CP1TO_000 CHECK (CP1TOX BETWEEN 500 AND 3000))
 ADD (CONSTRAINT AVCON_325908_CP1HO_000 CHECK (CP1HOX BETWEEN 500 AND 1500))
/
 
PROMPT Creating Check Constraints on 'TSTHYBRC'
ALTER TABLE TSTHYBRC
 ADD (CONSTRAINT AVCON_271747_SCAN__000 CHECK (SCAN_NO BETWEEN 0 AND 65535))
 ADD (CONSTRAINT AVCON_271747_TIME__000 CHECK (TIME_POWERED BETWEEN 0 AND 9999999999))
 ADD (CONSTRAINT AVCON_271747_T0_000 CHECK (T0 BETWEEN -100 AND 200))
 ADD (CONSTRAINT AVCON_271747_T1_000 CHECK (T1 BETWEEN -100 AND 200))
 ADD (CONSTRAINT AVCON_271747_RAD_D_000 CHECK (RAD_DOSE BETWEEN 0 AND 9999999999))
 ADD (CONSTRAINT AVCON_271747_ANNEA_000 CHECK (ANNEAL_TIME BETWEEN 0 AND 9999999999))
 ADD (CONSTRAINT AVCON_271747_N_SCA_000 CHECK (N_SCANS BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_0_000 CHECK (Q_0 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_1_000 CHECK (Q_1 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_2_000 CHECK (Q_2 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_3_000 CHECK (Q_3 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_4_000 CHECK (Q_4 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_5_000 CHECK (Q_5 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_6_000 CHECK (Q_6 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_7_000 CHECK (Q_7 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_8_000 CHECK (Q_8 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_9_000 CHECK (Q_9 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_10_000 CHECK (Q_10 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_11_000 CHECK (Q_11 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_12_000 CHECK (Q_12 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_13_000 CHECK (Q_13 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_14_000 CHECK (Q_14 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_Q_15_000 CHECK (Q_15 BETWEEN 0 AND 16))
 ADD (CONSTRAINT AVCON_271747_RC_FI_000 CHECK (RC_FIT BETWEEN 0 AND 255))
 ADD (CONSTRAINT AVCON_271747_M0_RC_000 CHECK (M0_RC_MN_VT50 BETWEEN 0 AND 640))
 ADD (CONSTRAINT AVCON_271747_M0_RC_001 CHECK (M0_RC_MN_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_M0_RC_002 CHECK (M0_RC_MN_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_M0_RC_003 CHECK (M0_RC_RMS_VT50 BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_M0_RC_004 CHECK (M0_RC_RMS_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_M0_RC_005 CHECK (M0_RC_RMS_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S1_RC_000 CHECK (S1_RC_MN_VT50 BETWEEN 0 AND 640))
 ADD (CONSTRAINT AVCON_271747_S1_RC_001 CHECK (S1_RC_MN_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S1_RC_002 CHECK (S1_RC_MN_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S1_RC_003 CHECK (S1_RC_RMS_VT50 BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S1_RC_004 CHECK (S1_RC_RMS_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S1_RC_005 CHECK (S1_RC_RMS_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S2_RC_000 CHECK (S2_RC_MN_VT50 BETWEEN 0 AND 640))
 ADD (CONSTRAINT AVCON_271747_S2_RC_001 CHECK (S2_RC_MN_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S2_RC_002 CHECK (S2_RC_MN_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S2_RC_003 CHECK (S2_RC_RMS_VT50 BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S2_RC_004 CHECK (S2_RC_RMS_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S2_RC_005 CHECK (S2_RC_RMS_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S3_RC_000 CHECK (S3_RC_MN_VT50 BETWEEN 0 AND 640))
 ADD (CONSTRAINT AVCON_271747_S3_RC_001 CHECK (S3_RC_MN_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S3_RC_002 CHECK (S3_RC_MN_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S3_RC_003 CHECK (S3_RC_RMS_VT50 BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S3_RC_004 CHECK (S3_RC_RMS_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S3_RC_005 CHECK (S3_RC_RMS_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S4_RC_000 CHECK (S4_RC_MN_VT50 BETWEEN 0 AND 640))
 ADD (CONSTRAINT AVCON_271747_S4_RC_001 CHECK (S4_RC_MN_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S4_RC_002 CHECK (S4_RC_MN_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S4_RC_003 CHECK (S4_RC_RMS_VT50 BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S4_RC_004 CHECK (S4_RC_RMS_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S4_RC_005 CHECK (S4_RC_RMS_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_E5_RC_000 CHECK (E5_RC_MN_VT50 BETWEEN 0 AND 640))
 ADD (CONSTRAINT AVCON_271747_E5_RC_001 CHECK (E5_RC_MN_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_E5_RC_002 CHECK (E5_RC_MN_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_E5_RC_003 CHECK (E5_RC_RMS_VT50 BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_E5_RC_004 CHECK (E5_RC_RMS_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_E5_RC_005 CHECK (E5_RC_RMS_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_M8_RC_000 CHECK (M8_RC_MN_VT50 BETWEEN 0 AND 640))
 ADD (CONSTRAINT AVCON_271747_M8_RC_001 CHECK (M8_RC_MN_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_M8_RC_002 CHECK (M8_RC_MN_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_M8_RC_003 CHECK (M8_RC_RMS_VT50 BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_M8_RC_004 CHECK (M8_RC_RMS_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_M8_RC_005 CHECK (M8_RC_RMS_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S9_RC_000 CHECK (S9_RC_MN_VT50 BETWEEN 0 AND 640))
 ADD (CONSTRAINT AVCON_271747_S9_RC_001 CHECK (S9_RC_MN_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S9_RC_002 CHECK (S9_RC_MN_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S9_RC_003 CHECK (S9_RC_RMS_VT50 BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S9_RC_004 CHECK (S9_RC_RMS_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S9_RC_005 CHECK (S9_RC_RMS_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S10_R_000 CHECK (S10_RC_MN_VT50 BETWEEN 0 AND 640))
 ADD (CONSTRAINT AVCON_271747_S10_R_001 CHECK (S10_RC_MN_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S10_R_002 CHECK (S10_RC_MN_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S10_R_003 CHECK (S10_RC_RMS_VT50 BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S10_R_004 CHECK (S10_RC_RMS_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S10_R_005 CHECK (S10_RC_RMS_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S11_R_000 CHECK (S11_RC_MN_VT50 BETWEEN 0 AND 640))
 ADD (CONSTRAINT AVCON_271747_S11_R_001 CHECK (S11_RC_MN_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S11_R_002 CHECK (S11_RC_MN_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S11_R_003 CHECK (S11_RC_RMS_VT50 BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S11_R_004 CHECK (S11_RC_RMS_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S11_R_005 CHECK (S11_RC_RMS_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S12_R_000 CHECK (S12_RC_MN_VT50 BETWEEN 0 AND 640))
 ADD (CONSTRAINT AVCON_271747_S12_R_001 CHECK (S12_RC_MN_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S12_R_002 CHECK (S12_RC_MN_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S12_R_003 CHECK (S12_RC_RMS_VT50 BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S12_R_004 CHECK (S12_RC_RMS_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_S12_R_005 CHECK (S12_RC_RMS_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_E13_R_000 CHECK (E13_RC_MN_VT50 BETWEEN 0 AND 640))
 ADD (CONSTRAINT AVCON_271747_E13_R_001 CHECK (E13_RC_MN_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_E13_R_002 CHECK (E13_RC_MN_NSE BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_E13_R_003 CHECK (E13_RC_RMS_VT50 BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_E13_R_004 CHECK (E13_RC_RMS_GAIN BETWEEN 0 AND 120))
 ADD (CONSTRAINT AVCON_271747_E13_R_005 CHECK (E13_RC_RMS_NSE BETWEEN 0 AND 120))
/
 
PROMPT Creating Check Constraints on 'ITEM_CMNTS'
ALTER TABLE ITEM_CMNTS
 ADD (CONSTRAINT AVCON_1902_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'TSTDETOPTS'
ALTER TABLE TSTDETOPTS
 ADD (CONSTRAINT AVCON_97485_TEMPE_000 CHECK (TEMPERATURE BETWEEN -30 AND 100))
 ADD (CONSTRAINT AVCON_97485_RAD_D_000 CHECK (RAD_DOSE BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_97485_ANNEA_000 CHECK (ANNEAL_TIME BETWEEN 0 AND 99999999))
 ADD (CONSTRAINT AVCON_97485_V_DEP_000 CHECK (V_DEP BETWEEN 0 AND 500))
 ADD (CONSTRAINT AVCON_97485_I_LEA_000 CHECK (I_LEAK_DEV BETWEEN -99999999 AND 99999999))
 ADD (CONSTRAINT AVCON_97485_C_INT_000 CHECK (C_INTERSTRIP BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_97485_C_INT_001 CHECK (C_INTERSTRIP_SD BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_97485_R_BIA_000 CHECK (R_BIAS BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_97485_R_BIA_001 CHECK (R_BIAS_SD BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_97485_R_ALU_000 CHECK (R_ALU_STRIP BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_97485_R_ALU_001 CHECK (R_ALU_STRIP_SD BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_97485_C_COU_000 CHECK (C_COUPLING BETWEEN 0 AND 500))
 ADD (CONSTRAINT AVCON_97485_C_COU_001 CHECK (C_COUPLING_SD BETWEEN 0 AND 500))
 ADD (CONSTRAINT AVCON_97485_R_IMP_000 CHECK (R_IMPLANT BETWEEN 0 AND 99999999))
 ADD (CONSTRAINT AVCON_97485_V_FLA_000 CHECK (V_FLAT BETWEEN 0 AND 700))
/
 
PROMPT Creating Check Constraints on 'TEST_LIST'
ALTER TABLE TEST_LIST
 ADD (CONSTRAINT AVCON_1914_REQUI_000 CHECK (REQUIRED IN ('YES', 'NO')))
 ADD (CONSTRAINT AVCON_1914_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'TEST_LIMITS'
ALTER TABLE TEST_LIMITS
 ADD (CONSTRAINT AVCON_245785_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'DISASSMLOGS'
ALTER TABLE DISASSMLOGS
 ADD (CONSTRAINT AVCON_128285_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'TSTABCD'
ALTER TABLE TSTABCD
 ADD (CONSTRAINT AVCON_311008_PREAM_000 CHECK (PREAMPBIAS BETWEEN 0 AND 500))
 ADD (CONSTRAINT AVCON_311008_SHAPE_000 CHECK (SHAPERBIAS BETWEEN 0 AND 500))
 ADD (CONSTRAINT AVCON_311008_PRFFL_000 CHECK (PRFFLG IN ('YES', 'NO')))
 ADD (CONSTRAINT AVCON_311008_DIGFL_000 CHECK (DIGFLG IN ('YES', 'NO')))
 ADD (CONSTRAINT AVCON_311008_DPP_000 CHECK (DPP IN ('YES', 'NO')))
 ADD (CONSTRAINT AVCON_311008_VDD0_000 CHECK (VDD0 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDD0S_000 CHECK (VDD0STRICT BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDDTE_000 CHECK (VDDTEST1F0 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDDTE_001 CHECK (VDDTEST2F0 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDDTE_002 CHECK (VDDTEST3F0 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDDTE_003 CHECK (VDDTEST4F0 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDDTE_004 CHECK (VDDTEST5F0 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDDTE_005 CHECK (VDDTEST6F0 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDDTE_006 CHECK (VDDTEST7F0 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDD1_000 CHECK (VDD1 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDD1S_000 CHECK (VDD1STRICT BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDDTE_007 CHECK (VDDTEST1F1 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDDTE_008 CHECK (VDDTEST2F1 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDDTE_009 CHECK (VDDTEST3F1 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDDTE_010 CHECK (VDDTEST4F1 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDDTE_011 CHECK (VDDTEST5F1 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDDTE_012 CHECK (VDDTEST6F1 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_VDDTE_013 CHECK (VDDTEST7F1 BETWEEN 3.3 AND 4.5))
 ADD (CONSTRAINT AVCON_311008_FMAXT_000 CHECK (FMAXTEST1 BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_311008_FMAXT_001 CHECK (FMAXTEST2 BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_311008_FMAXT_002 CHECK (FMAXTEST3 BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_311008_FMAXT_003 CHECK (FMAXTEST4 BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_311008_FMAXT_004 CHECK (FMAXTEST5 BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_311008_FMAXT_005 CHECK (FMAXTEST6 BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_311008_FMAXT_006 CHECK (FMAXTEST7 BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_311008_THRSD_000 CHECK (THRSDACSLOPE BETWEEN 0 AND 3.125))
 ADD (CONSTRAINT AVCON_311008_THRSD_001 CHECK (THRSDACERR BETWEEN 0 AND 800))
 ADD (CONSTRAINT AVCON_311008_PREAM_001 CHECK (PREAMPDACSLOPE BETWEEN 0 AND 2))
 ADD (CONSTRAINT AVCON_311008_PREAM_002 CHECK (PREAMDACERR BETWEEN 0 AND 300))
 ADD (CONSTRAINT AVCON_311008_SHAPE_001 CHECK (SHAPERDACSLOPE BETWEEN 0 AND 2))
 ADD (CONSTRAINT AVCON_311008_SHAPE_002 CHECK (SHAPERDACERR BETWEEN 0 AND 300))
 ADD (CONSTRAINT AVCON_311008_MDIGC_000 CHECK (MDIGC BETWEEN 0 AND 0.2))
 ADD (CONSTRAINT AVCON_311008_SDIGC_000 CHECK (SDIGC BETWEEN 0 AND 0.2))
 ADD (CONSTRAINT AVCON_311008_MANAC_000 CHECK (MANAC BETWEEN 0 AND 0.2))
 ADD (CONSTRAINT AVCON_311008_SANAC_000 CHECK (SANAC BETWEEN 0 AND 0.2))
 ADD (CONSTRAINT AVCON_311008_NDNOR_000 CHECK (NDNORESP BETWEEN 0 AND 128))
 ADD (CONSTRAINT AVCON_311008_NDPIP_000 CHECK (NDPIPELINE BETWEEN 0 AND 128))
 ADD (CONSTRAINT AVCON_311008_NDNOI_000 CHECK (NDNOISE BETWEEN 0 AND 128))
 ADD (CONSTRAINT AVCON_311008_NDGAI_000 CHECK (NDGAIN BETWEEN 0 AND 128))
 ADD (CONSTRAINT AVCON_311008_NDTRI_000 CHECK (NDTRIM BETWEEN 0 AND 128))
 ADD (CONSTRAINT AVCON_311008_NDHOF_000 CHECK (NDHOFFSET0 BETWEEN 0 AND 128))
 ADD (CONSTRAINT AVCON_311008_NDHOF_001 CHECK (NDHOFFSET1 BETWEEN 0 AND 128))
 ADD (CONSTRAINT AVCON_311008_NDHOF_002 CHECK (NDHOFFSET2 BETWEEN 0 AND 128))
 ADD (CONSTRAINT AVCON_311008_NDHOF_003 CHECK (NDHOFFSET3 BETWEEN 0 AND 128))
 ADD (CONSTRAINT AVCON_311008_NDEAD_000 CHECK (NDEAD BETWEEN 0 AND 128))
 ADD (CONSTRAINT AVCON_311008_STATU_000 CHECK (STATUS IN (0)))
 ADD (CONSTRAINT AVCON_311008_STATU_001 CHECK (STATUSVALID IN (0)))
 ADD (CONSTRAINT AVCON_311008_AUXFL_000 CHECK (AUXFLAGS IN (0)))
 ADD (CONSTRAINT AVCON_311008_AVGAI_000 CHECK (AVGAIN BETWEEN 0 AND 500))
 ADD (CONSTRAINT AVCON_311008_SGAIN_000 CHECK (SGAIN BETWEEN 0 AND 50))
 ADD (CONSTRAINT AVCON_311008_MAXGA_000 CHECK (MAXGAIN BETWEEN 0 AND 500))
 ADD (CONSTRAINT AVCON_311008_MINGA_000 CHECK (MINGAIN BETWEEN 0 AND 500))
 ADD (CONSTRAINT AVCON_311008_AVOFF_000 CHECK (AVOFFSET BETWEEN -600 AND 600))
 ADD (CONSTRAINT AVCON_311008_SOFFS_000 CHECK (SOFFSET BETWEEN 0 AND 400))
 ADD (CONSTRAINT AVCON_311008_MAXOF_000 CHECK (MAXOFFSET BETWEEN -600 AND 600))
 ADD (CONSTRAINT AVCON_311008_MINOF_000 CHECK (MINOFFSET BETWEEN -600 AND 600))
 ADD (CONSTRAINT AVCON_311008_MAXTR_000 CHECK (MAXTRDACERR BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_311008_MAXTR_001 CHECK (MAXTRSLOPE BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_311008_MINTR_000 CHECK (MINTRSLOPE BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_311008_TRDAC_000 CHECK (TRDACRANGE0 BETWEEN 0 AND 500))
 ADD (CONSTRAINT AVCON_311008_TRDAC_001 CHECK (TRDACRANGE1 BETWEEN 0 AND 500))
 ADD (CONSTRAINT AVCON_311008_TRDAC_002 CHECK (TRDACRANGE2 BETWEEN 0 AND 500))
 ADD (CONSTRAINT AVCON_311008_TRDAC_003 CHECK (TRDACRANGE3 BETWEEN 0 AND 500))
 ADD (CONSTRAINT AVCON_311008_AVNOI_000 CHECK (AVNOISE BETWEEN 0 AND 50))
 ADD (CONSTRAINT AVCON_311008_SNOIS_000 CHECK (SNOISE BETWEEN 0 AND 50))
 ADD (CONSTRAINT AVCON_311008_MAXNO_000 CHECK (MAXNOISE BETWEEN 0 AND 50))
 ADD (CONSTRAINT AVCON_311008_MINNO_000 CHECK (MINNOISE BETWEEN 0 AND 50))
 ADD (CONSTRAINT AVCON_311008_QFACT_000 CHECK (QFACTOR BETWEEN 0 AND 20))
 ADD (CONSTRAINT AVCON_311008_BIN_000 CHECK (BIN BETWEEN 0 AND 28))
 ADD (CONSTRAINT AVCON_311008_NFPST_000 CHECK (NFPSTATBAD BETWEEN 0 AND 128))
 ADD (CONSTRAINT AVCON_311008_NFPDY_000 CHECK (NFPDYNBAD BETWEEN 0 AND 128))
 ADD (CONSTRAINT AVCON_311008_ANALO_000 CHECK (ANALOGERRCODE BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_311008_MINVS_000 CHECK (MINVSWCLK0 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_MINVS_001 CHECK (MINVSWCLK1 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_MINVS_002 CHECK (MINVSWCOM0 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_MINVS_003 CHECK (MINVSWCOM1 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_MINVS_004 CHECK (MINVSWDIN0 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_MINVS_005 CHECK (MINVSWDIN1 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_MINVS_006 CHECK (MINVSWTIN0 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_MINVS_007 CHECK (MINVSWTIN1 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_VSWLE_000 CHECK (VSWLED BETWEEN 0 AND 2))
 ADD (CONSTRAINT AVCON_311008_VSWER_000 CHECK (VSWERRLED BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_VSWDO_000 CHECK (VSWDOUT0 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_VSWER_001 CHECK (VSWERRDOUT0 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_VSWDO_001 CHECK (VSWDOUT1 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_VSWER_002 CHECK (VSWERRDOUT1 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_VSWTO_000 CHECK (VSWTOUT0 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_VSWER_003 CHECK (VSWERRTOUT0 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_VSWTO_001 CHECK (VSWTOUT1 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_VSWER_004 CHECK (VSWERRTOUT1 BETWEEN 0 AND 1))
 ADD (CONSTRAINT AVCON_311008_PHASE_000 CHECK (PHASECOM0 BETWEEN 0 AND 40))
 ADD (CONSTRAINT AVCON_311008_PHASE_001 CHECK (PHASEERRCOM0 BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_311008_PHASE_002 CHECK (PHASECOM1 BETWEEN 0 AND 40))
 ADD (CONSTRAINT AVCON_311008_PHASE_003 CHECK (PHASEERRCOM1 BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_311008_PHASE_004 CHECK (PHASEDIN0 BETWEEN 0 AND 40))
 ADD (CONSTRAINT AVCON_311008_PHASE_005 CHECK (PHASEERRDIN0 BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_311008_PHASE_006 CHECK (PHASEDIN1 BETWEEN 0 AND 40))
 ADD (CONSTRAINT AVCON_311008_PHASE_007 CHECK (PHASEERRDIN1 BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_311008_PHASE_008 CHECK (PHASETIN0 BETWEEN 0 AND 40))
 ADD (CONSTRAINT AVCON_311008_PHASE_009 CHECK (PHASEERRTIN0 BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_311008_PHASE_010 CHECK (PHASETIN1 BETWEEN 0 AND 40))
 ADD (CONSTRAINT AVCON_311008_PHASE_011 CHECK (PHASEERRTIN1 BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_311008_PHASE_012 CHECK (PHASELED BETWEEN 0 AND 40))
 ADD (CONSTRAINT AVCON_311008_PHASE_013 CHECK (PHASEERRLED BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_311008_PHASE_014 CHECK (PHASEDOUT0 BETWEEN 0 AND 40))
 ADD (CONSTRAINT AVCON_311008_PHASE_015 CHECK (PHASEERRDOUT0 BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_311008_PHASE_016 CHECK (PHASEDOUT1 BETWEEN 0 AND 40))
 ADD (CONSTRAINT AVCON_311008_PHASE_017 CHECK (PHASEERRDOUT1 BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_311008_PHASE_018 CHECK (PHASETOUT0 BETWEEN 0 AND 40))
 ADD (CONSTRAINT AVCON_311008_PHASE_019 CHECK (PHASEERRTOUT0 BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_311008_PHASE_020 CHECK (PHASETOUT1 BETWEEN 0 AND 40))
 ADD (CONSTRAINT AVCON_311008_PHASE_021 CHECK (PHASEERRTOUT1 BETWEEN 0 AND 10))
 ADD (CONSTRAINT AVCON_311008_CLK0D_000 CHECK (CLK0DCMIN BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_311008_CLK0D_001 CHECK (CLK0DCMAX BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_311008_CLK1D_000 CHECK (CLK1DCMIN BETWEEN 0 AND 100))
 ADD (CONSTRAINT AVCON_311008_CLK1D_001 CHECK (CLK1DCMAX BETWEEN 0 AND 100))
/
 
PROMPT Creating Check Constraints on 'DEFECTS'
ALTER TABLE DEFECTS
 ADD (CONSTRAINT AVCON_1899_CHAN__000 CHECK (CHAN_1ST BETWEEN 0 AND 1536))
 ADD (CONSTRAINT AVCON_1899_CHAN__001 CHECK (CHAN_LAST BETWEEN 0 AND 1536))
 ADD (CONSTRAINT AVCON_1899_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'MFRS'
ALTER TABLE MFRS
 ADD (CONSTRAINT AVCON_1905_MFR_N_000 CHECK (MFR_NO BETWEEN 10 AND 99))
 ADD (CONSTRAINT AVCON_1905_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
  
PROMPT Creating Check Constraints on 'TESTS'
ALTER TABLE TESTS
 ADD (CONSTRAINT AVCON_1909_PROBL_000 CHECK (PROBLEM IN ('YES', 'NO')))
 ADD (CONSTRAINT AVCON_1909_PASS_000 CHECK (PASS IN ('YES', 'NO')))
 ADD (CONSTRAINT AVCON_1909_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'SHIP'
ALTER TABLE SHIP
 ADD (CONSTRAINT AVCON_1907_GROSS_000 CHECK (GROSS_WT BETWEEN 0 AND 9999999999))
 ADD (CONSTRAINT AVCON_1907_NO_PA_000 CHECK (NO_PACKS BETWEEN 0 AND 999))
 ADD (CONSTRAINT AVCON_1907_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'ITEM_CATEGORIES'
ALTER TABLE ITEM_CATEGORIES
 ADD (CONSTRAINT AVCON_2470_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'ITEM_EVENTS'
ALTER TABLE ITEM_EVENTS
 ADD (CONSTRAINT AVCON_301755_HI_TE_000 CHECK (HI_TEMP BETWEEN -40 AND 200))
 ADD (CONSTRAINT AVCON_301755_LOW_T_000 CHECK (LOW_TEMP BETWEEN -40 AND 200))
 ADD (CONSTRAINT AVCON_301755_TEMP_000 CHECK (TEMP BETWEEN -40 AND 200))
/
 
PROMPT Creating Check Constraints on 'ITEMS'
ALTER TABLE ITEMS
 ADD (CONSTRAINT AVCON_1901_TRASH_000 CHECK (TRASHED IN ('YES', 'NO')))
 ADD (CONSTRAINT AVCON_1901_SUBSY_000 CHECK (SUBSYST IN ('S')))
 ADD (CONSTRAINT AVCON_1901_ASSEM_000 CHECK (ASSEMBLED IN ('YES', 'NO')))
 ADD (CONSTRAINT AVCON_1901_PASSE_000 CHECK (PASSED IN ('YES', 'NO')))
/
  
PROMPT Creating Check Constraints on 'STOCKS'
ALTER TABLE STOCKS
 ADD (CONSTRAINT AVCON_2317_QTY_000 CHECK (QTY BETWEEN 0 AND 9999999999))
 ADD (CONSTRAINT AVCON_2317_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'DEFECT_DESCR'
ALTER TABLE DEFECT_DESCR
 ADD (CONSTRAINT AVCON_1900_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'TEST_DESCR'
ALTER TABLE TEST_DESCR
 ADD (CONSTRAINT AVCON_1912_NO_CH_000 CHECK (NO_CHANS BETWEEN 0 AND 1536))
 ADD (CONSTRAINT AVCON_1912_SUBSY_000 CHECK (SUBSYST IN ('S')))
/
 
PROMPT Creating Check Constraints on 'TSTMODZ'
ALTER TABLE TSTMODZ
 ADD (CONSTRAINT AVCON_234667_ZAVEF_000 CHECK (ZAVEF BETWEEN -5 AND 5))
 ADD (CONSTRAINT AVCON_234667_ZAVEB_000 CHECK (ZAVEB BETWEEN -5 AND 5))
 ADD (CONSTRAINT AVCON_234667_ZMAXF_000 CHECK (ZMAXF BETWEEN -5 AND 5))
 ADD (CONSTRAINT AVCON_234667_ZMINF_000 CHECK (ZMINF BETWEEN -5 AND 5))
 ADD (CONSTRAINT AVCON_234667_ZMAXB_000 CHECK (ZMAXB BETWEEN -5 AND 5))
 ADD (CONSTRAINT AVCON_234667_ZMINB_000 CHECK (ZMINB BETWEEN -5 AND 5))
 ADD (CONSTRAINT AVCON_234667_ZRMSF_000 CHECK (ZRMSF BETWEEN 0 AND 5))
 ADD (CONSTRAINT AVCON_234667_ZRMSB_000 CHECK (ZRMSB BETWEEN 0 AND 5))
 ADD (CONSTRAINT AVCON_234667_TEMPE_000 CHECK (TEMPERATURE BETWEEN -20 AND 70))
/
 
PROMPT Creating Check Constraints on 'TEST_RAWDATA'
ALTER TABLE TEST_RAWDATA
 ADD (CONSTRAINT AVCON_2300_SUBSY_000 CHECK (SUBSYST IN ('S')))
/

PROMPT Creating Foreign Keys on 'TEST_CMNTS'
ALTER TABLE TEST_CMNTS ADD CONSTRAINT
 TEST_CMNT_TEST_FK FOREIGN KEY 
  (TEST_NO) REFERENCES TESTS
  (TEST_NO)
/

PROMPT Creating Foreign Keys on 'TSTABCDCHS'
ALTER TABLE TSTABCDCHS ADD CONSTRAINT
 TSTABCDCH_TSTABCD_FK FOREIGN KEY 
  (TEST_NO) REFERENCES TSTABCD
  (TEST_NO)
/

PROMPT Creating Foreign Keys on 'ASSM_DESCR'
ALTER TABLE ASSM_DESCR ADD CONSTRAINT
 ASSM_DESCR_ITEM_DESCR_FK FOREIGN KEY 
  (ASSM_CTYPE) REFERENCES ITEM_DESCR
  (CTYPE) ADD CONSTRAINT
 ASSM_DESCR_ITEM_DESCR_HAS_FK FOREIGN KEY 
  (CTYPE) REFERENCES ITEM_DESCR
  (CTYPE)
/

PROMPT Creating Foreign Keys on 'TSTDETMFRS'
ALTER TABLE TSTDETMFRS ADD CONSTRAINT
 TSTDETMFR_TEST_FK FOREIGN KEY 
  (TEST_NO) REFERENCES TESTS
  (TEST_NO)
/

PROMPT Creating Foreign Keys on 'PERSONS'
ALTER TABLE PERSONS ADD CONSTRAINT
 PERSON_LOCN_FK FOREIGN KEY 
  (LOCN_NAME) REFERENCES LOCNS
  (LOCN_NAME)
/

PROMPT Creating Foreign Keys on 'ASSM_ITEMS'
ALTER TABLE ASSM_ITEMS ADD CONSTRAINT
 ASSM_ITEM_ASSM_DESCR_FK FOREIGN KEY 
  (ASSM_CTYPE
  ,CTYPE
  ,POSN) REFERENCES ASSM_DESCR
  (ASSM_CTYPE
  ,CTYPE
  ,POSN) ADD CONSTRAINT
 ASSM_ITEM_ITEM_ASSEMBLY_FK FOREIGN KEY 
  (ASSM_SER_NO) REFERENCES ITEMS
  (SER_NO) ADD CONSTRAINT
 ASSM_ITEM_ITEM_FK FOREIGN KEY 
  (SER_NO) REFERENCES ITEMS
  (SER_NO)
/

PROMPT Creating Foreign Keys on 'SHIP_ITEMS'
ALTER TABLE SHIP_ITEMS ADD CONSTRAINT
 SHIP_ITEM_SHIP_FK FOREIGN KEY 
  (SHIP_NO) REFERENCES SHIP
  (SHIP_NO) ADD CONSTRAINT
 SHIP_ITEM_ITEM_FK FOREIGN KEY 
  (SER_NO) REFERENCES ITEMS
  (SER_NO)
/

PROMPT Creating Foreign Keys on 'ITEM_DESCR'
ALTER TABLE ITEM_DESCR ADD CONSTRAINT
 ITEM_DESCR_ITEM_CAT_FK FOREIGN KEY 
  (CATEGORY) REFERENCES ITEM_CATEGORIES
  (CATEGORY)
/

PROMPT Creating Foreign Keys on 'TSTDETIVS'
ALTER TABLE TSTDETIVS ADD CONSTRAINT
 TSTDETIV_TEST_FK FOREIGN KEY 
  (TEST_NO) REFERENCES TESTS
  (TEST_NO)
/

PROMPT Creating Foreign Keys on 'WEB_LINKS'
ALTER TABLE WEB_LINKS ADD CONSTRAINT
 WEB_LINK_TEST_FK FOREIGN KEY 
  (TEST_NO) REFERENCES TESTS
  (TEST_NO)
/

PROMPT Creating Foreign Keys on 'TEST_IMAGES'
ALTER TABLE TEST_IMAGES ADD CONSTRAINT
 TEST_IMAGE_TEST_FK FOREIGN KEY 
  (TEST_NO) REFERENCES TESTS
  (TEST_NO)
/

PROMPT Creating Foreign Keys on 'MAILS'
ALTER TABLE MAILS ADD CONSTRAINT
 MAIL_MAIL_LIST_FK FOREIGN KEY 
  (MAIL_LIST_NAME) REFERENCES MAIL_LISTS
  (NAME)
/

PROMPT Creating Foreign Keys on 'TSTMODXY'
ALTER TABLE TSTMODXY ADD CONSTRAINT
 TSTMODXY_TEST_FK FOREIGN KEY 
  (TEST_NO) REFERENCES TESTS
  (TEST_NO)
/

PROMPT Creating Foreign Keys on 'TEST_WAFER_E_PARAM'
ALTER TABLE TEST_WAFER_E_PARAM ADD CONSTRAINT
 TSTWAFEPAR_TEST_FK FOREIGN KEY 
  (TEST_NO) REFERENCES TESTS
  (TEST_NO)
/

PROMPT Creating Foreign Keys on 'TSTHYBRC'
ALTER TABLE TSTHYBRC ADD CONSTRAINT
 TSTHYBRC_TEST_FK FOREIGN KEY 
  (TEST_NO) REFERENCES TESTS
  (TEST_NO)
/

PROMPT Creating Foreign Keys on 'ITEM_CMNTS'
ALTER TABLE ITEM_CMNTS ADD CONSTRAINT
 ITEM_CMNT_ITEM_FK FOREIGN KEY 
  (SER_NO) REFERENCES ITEMS
  (SER_NO) ADD CONSTRAINT
 ITEM_CMNT_PERSON_FK FOREIGN KEY 
  (INITLS) REFERENCES PERSONS
  (INITLS)
/

PROMPT Creating Foreign Keys on 'TSTDETOPTS'
ALTER TABLE TSTDETOPTS ADD CONSTRAINT
 TSTDETOPT_TEST_FK FOREIGN KEY 
  (TEST_NO) REFERENCES TESTS
  (TEST_NO)
/

PROMPT Creating Foreign Keys on 'TEST_LIST'
ALTER TABLE TEST_LIST ADD CONSTRAINT
 TEST_LIST_ITEM_DESCR_FK FOREIGN KEY 
  (CTYPE) REFERENCES ITEM_DESCR
  (CTYPE) ADD CONSTRAINT
 TEST_LIST_TEST_DESCR_FK FOREIGN KEY 
  (TEST_NAME) REFERENCES TEST_DESCR
  (TEST_NAME)
/

PROMPT Creating Foreign Keys on 'TEST_LIMITS'
ALTER TABLE TEST_LIMITS ADD CONSTRAINT
 TEST_LIMIT_MFR_FK FOREIGN KEY 
  (MFR) REFERENCES MFRS
  (MFR) ADD CONSTRAINT
 TEST_LIMIT_TEST_LIST_FK FOREIGN KEY 
  (TEST_NAME
  ,CTYPE) REFERENCES TEST_LIST
  (TEST_NAME
  ,CTYPE)
/

PROMPT Creating Foreign Keys on 'DISASSMLOGS'
ALTER TABLE DISASSMLOGS ADD CONSTRAINT
 DISASSMLOG_ITEM_ASSEMBLY_FK FOREIGN KEY 
  (ASSM_SER_NO) REFERENCES ITEMS
  (SER_NO) ADD CONSTRAINT
 DISASSMLOG_ITEM_FK FOREIGN KEY 
  (SER_NO) REFERENCES ITEMS
  (SER_NO)
/

PROMPT Creating Foreign Keys on 'TSTABCD'
ALTER TABLE TSTABCD ADD CONSTRAINT
 TSTABCD_TEST_FK FOREIGN KEY 
  (TEST_NO) REFERENCES TESTS
  (TEST_NO)
/

PROMPT Creating Foreign Keys on 'DEFECTS'
ALTER TABLE DEFECTS ADD CONSTRAINT
 DEFECT_DEFCT_DESC_FK FOREIGN KEY 
  (DEFECT_NAME) REFERENCES DEFECT_DESCR
  (DEFECT_NAME) ADD CONSTRAINT
 DEFECT_TEST_FK FOREIGN KEY 
  (TEST_NO) REFERENCES TESTS
  (TEST_NO)
/

PROMPT Creating Foreign Keys on 'ITEM_IMAGES'
ALTER TABLE ITEM_IMAGES ADD CONSTRAINT
 IT_IMAGE_ITEM_FK FOREIGN KEY 
  (SER_NO) REFERENCES ITEMS
  (SER_NO)
/

PROMPT Creating Foreign Keys on 'TESTS'
ALTER TABLE TESTS ADD CONSTRAINT
 TEST_PERSON_FK FOREIGN KEY 
  (INITLS) REFERENCES PERSONS
  (INITLS) ADD CONSTRAINT
 TEST_TEST_DESCR_FK FOREIGN KEY 
  (TEST_NAME) REFERENCES TEST_DESCR
  (TEST_NAME) ADD CONSTRAINT
 TEST_ITEM_FK FOREIGN KEY 
  (SER_NO) REFERENCES ITEMS
  (SER_NO) ADD CONSTRAINT
 TEST_LOCN_FK FOREIGN KEY 
  (LOCN_NAME) REFERENCES LOCNS
  (LOCN_NAME)
/

PROMPT Creating Foreign Keys on 'SHIP'
ALTER TABLE SHIP ADD CONSTRAINT
 SHIP_LOCN_FK FOREIGN KEY 
  (LOCN_NAME) REFERENCES LOCNS
  (LOCN_NAME) ADD CONSTRAINT
 SHIP_LOCN_RECEIVED_AT_FK FOREIGN KEY 
  (DEST_LOCN_NAME) REFERENCES LOCNS
  (LOCN_NAME) ADD CONSTRAINT
 SHIP_PERSON_FK FOREIGN KEY 
  (INITLS) REFERENCES PERSONS
  (INITLS) ADD CONSTRAINT
 SHIP_PERSON_SENT_TO_FK FOREIGN KEY 
  (DEST_INITLS) REFERENCES PERSONS
  (INITLS)
/

PROMPT Creating Foreign Keys on 'ITEM_EVENTS'
ALTER TABLE ITEM_EVENTS ADD CONSTRAINT
 ITEM_EVENT_EVENT_DESC_FK FOREIGN KEY 
  (EVENT_DESC_EVENT_NAME) REFERENCES EVENT_DESCR
  (EVENT_NAME) ADD CONSTRAINT
 ITEM_EVENT_ITEM_FK FOREIGN KEY 
  (ITEM_SER_NO) REFERENCES ITEMS
  (SER_NO) ADD CONSTRAINT
 ITEM_EVENT_LOCN_FK FOREIGN KEY 
  (LOCN_LOCN_NAME) REFERENCES LOCNS
  (LOCN_NAME)
/

PROMPT Creating Foreign Keys on 'ITEMS'
ALTER TABLE ITEMS ADD CONSTRAINT
 ITEM_ITEM_DESCR_FK FOREIGN KEY 
  (CTYPE) REFERENCES ITEM_DESCR
  (CTYPE) ADD CONSTRAINT
 ITEM_PERSON_FK FOREIGN KEY 
  (INITLS) REFERENCES PERSONS
  (INITLS) ADD CONSTRAINT
 ITEM_MFR_FK FOREIGN KEY 
  (MFR) REFERENCES MFRS
  (MFR) ADD CONSTRAINT
 ITEM_LOCN_FK FOREIGN KEY 
  (LOCN_NAME) REFERENCES LOCNS
  (LOCN_NAME)
/

PROMPT Creating Foreign Keys on 'STOCKS'
ALTER TABLE STOCKS ADD CONSTRAINT
 STOCK_ITEM_FK FOREIGN KEY 
  (SER_NO) REFERENCES ITEMS
  (SER_NO) ADD CONSTRAINT
 STOCK_LOCN_FK FOREIGN KEY 
  (LOCN_NAME) REFERENCES LOCNS
  (LOCN_NAME)
/

PROMPT Creating Foreign Keys on 'TSTMODZ'
ALTER TABLE TSTMODZ ADD CONSTRAINT
 TSTMODZ_TEST_FK FOREIGN KEY 
  (TEST_NO) REFERENCES TESTS
  (TEST_NO)
/

PROMPT Creating Foreign Keys on 'TEST_RAWDATA'
ALTER TABLE TEST_RAWDATA ADD CONSTRAINT
 TST_DATA_TEST_FK FOREIGN KEY 
  (TEST_NO) REFERENCES TESTS
  (TEST_NO)
/


