ALTER TABLE POS_AMENDMENT ADD CONSTRAINT POS_AMENDMENT_X PRIMARY KEY (TRAN_ID)
   
ALTER TABLE EMP_EXITFORM_HDR ADD CONSTRAINT EMP_EXITFORM_HDR_X PRIMARY KEY (EXIT_INTERVIEW_ID)
   
ALTER TABLE SITE_MANPOWER_DEPLOYMENT ADD CONSTRAINT SITE_MANPOWER_DEPLOYMENT_PK PRIMARY KEY (SITE_CODE, TRAN_DATE, ITEM_TYPE)
   
ALTER TABLE UNIT_TRANSFER_HDR ADD CONSTRAINT PK_TRANSACTION PRIMARY KEY (TRAN_ID)
   
ALTER TABLE EMP_EXITFORM_HR ADD CONSTRAINT EMP_EXITFORM_HR_X PRIMARY KEY (EXIT_INTERVIEW_ID, LINE_NO)
   
ALTER TABLE PAYMENT_PLAN_HDR ADD CONSTRAINT PK_PAYMENT_PLAN_HDR PRIMARY KEY (PAY_PLAN_ID)
   
ALTER TABLE BUYER_TRANSFER_HDR ADD CONSTRAINT PK_YOUR_TABLE_NAME PRIMARY KEY (TRAN_ID)
   
ALTER TABLE INTEREST_CAL_DETAILS ADD CONSTRAINT PK_INTEREST_CAL_DETAILS PRIMARY KEY (TRAN_ID, LINE_NO)
   
ALTER TABLE RETAIL_FOOTFALL ADD CONSTRAINT RETAIL_FOOTFALL_PK PRIMARY KEY (SITE_CODE, TRAN_DATE, HOURS)
   
ALTER TABLE ENTERPRISE_CP_ACC ADD CONSTRAINT PK_ENTERPRISE PRIMARY KEY (ENTERPRISE, ENTERPRISE_ACC)
   
ALTER TABLE ALLWDEDN_BKP ADD CONSTRAINT ALLWDEDN_X PRIMARY KEY (AD_CODE)
   
ALTER TABLE ALLWDEDN_BKP ADD CONSTRAINT FK_ALLWDEDN_TAUTH_CODE FOREIGN KEY (TAUTH_CODE)
	  REFERENCES TAX_AUTHORITY (TAUTH_CODE) ENABLE NOVALIDATE 
ALTER TABLE ALLWDEDN_BKP ADD CONSTRAINT FK_ALLWDEDN_ACCT FOREIGN KEY (ACCT_CODE__SAL)
	  REFERENCES ACCOUNTS (ACCT_CODE) ENABLE NOVALIDATE 
ALTER TABLE ALLWDEDN_BKP ADD CONSTRAINT FK_ALLWDEDN_CCTR_CODE__SAL FOREIGN KEY (CCTR_CODE__SAL)
	  REFERENCES COSTCTR (CCTR_CODE) ENABLE 
ALTER TABLE PAYMENT_PLAN_DET ADD CONSTRAINT PK_PAYMENT_PLAN_DET PRIMARY KEY (PAY_PLAN_ID, LINE_NO)
   
ALTER TABLE EMP_EXITFORM_EMP ADD CONSTRAINT EMP_EXITFORM_EMP_X PRIMARY KEY (EXIT_INTERVIEW_ID, LINE_NO)
   
ALTER TABLE WAIVE_OFF_HDR ADD CONSTRAINT WAIVE_OFF_HDR_PK PRIMARY KEY (TRAN_ID)
   
ALTER TABLE APPLICANT_INFO ADD CONSTRAINT PK_APPLICANT_INFO PRIMARY KEY (TRAN_ID)
   
ALTER TABLE WORKING_DAYS ADD CONSTRAINT WORKING_DAYS_PK PRIMARY KEY (SITE_CODE, PRD_CODE)
   
ALTER TABLE RETAIL_SALES_TARGET ADD CONSTRAINT RETAIL_SALES_TARGET_PK PRIMARY KEY (SALES_PER, PRD_CODE, SITE_CODE, ITEM_TYPE)
   
ALTER TABLE USERTYPE_LIC_CHRGS ADD CONSTRAINT USERTYPE_LIC_CHRGS_PK PRIMARY KEY (USER_LIC_TYPE)
   
ALTER TABLE WO_OBSRV_DET ADD CONSTRAINT WO_OBSRV_DET_X PRIMARY KEY (TRAN_ID, LINE_NO)
   
ALTER TABLE MISC_DRCR_INTEREST ADD CONSTRAINT PK_YOUR_TABLE PRIMARY KEY (TRAN_ID, LINE_NO)
   
ALTER TABLE ASSET_DEPR_YEARLY ADD CONSTRAINT PK_ASSET_DEPR_YEAR PRIMARY KEY (ASSET_CODE, ACCT_PRD, ITEM_SER, GRP_CODE, SITE_CODE)
   
ALTER TABLE ASSET_DEPR_YEARLY ADD CONSTRAINT FK_ASSET_DEPR_YEAR_ASSET_CODE FOREIGN KEY (ASSET_CODE)
	  REFERENCES ASSET_REGISTER (ASSET_CODE) ENABLE 
ALTER TABLE EMP_EXIT_CLEARANCE ADD CONSTRAINT EMP_CLEARANCE_HDR_X PRIMARY KEY (CLEARANCE_ID)
   
ALTER TABLE RESIGNATION_FORM ADD CONSTRAINT RESIGNATION_FORM_X PRIMARY KEY (RESIGNATION_ID)
   
ALTER TABLE RPT_PRINT_LOG ADD CONSTRAINT RPT_PRINT_LOG_X PRIMARY KEY (TRAN_ID)
   
ALTER TABLE TRANSPORTER_BILL_CHGS ADD CONSTRAINT TRANSPORTER_BILL_CHGS_X PRIMARY KEY (TRAN_ID, LINE_NO)
   

-- No of Rows = 29
