SELECT INDEX_NAME, INDEX_TYPE, TABLE_NAME FROM USER_INDEXES ORDER BY INDEX_NAME;
CUSTOMER_PHONE_INDEX NORMAL CUSTOMER
PK_ACCOUNT NORMAL ACCOUNT
SALES_RECEIPT_ID_INDEX NORMAL SALES
PRODUCT_BARCODE_INDEX NORMAL PRODUCT
constraint 목록
SELECT C.TABLE_NAME, C.SEARCH_CONDITION, C.CONSTRAINT_NAME FROM ALL_CONSTRAINTS C, USER_TABLES T WHERE C.TABLE_NAME = T.TABLE_NAME;
SALES "PROD_ID" IS NOT NULL SYS_C0010863
SALES "CUST_ID" IS NOT NULL SYS_C0010864
SALES "TIME_ID" IS NOT NULL SYS_C0010865
SALES "CHANNEL_ID" IS NOT NULL SYS_C0010866
SALES "PROMO_ID" IS NOT NULL SYS_C0010867
SALES "QUANTITY_SOLD" IS NOT NULL SYS_C0010868
SALES "AMOUNT_SOLD" IS NOT NULL SYS_C0010869
A_ORDER "ORDER_ID" IS NOT NULL SYS_C0013551
A_ORDER "BRANCH_ID" IS NOT NULL SYS_C0013552
A_ORDER "ORD_DATE" IS NOT NULL SYS_C0013553
A_ORDER "AMOUNT" IS NOT NULL SYS_C0013554
BRANCH "BRANCH_ID" IS NOT NULL SYS_C0013556
BRANCH "ADDRESS" IS NOT NULL SYS_C0013557
BRANCH "PHONE" IS NOT NULL SYS_C0013558
BRANCH "MEF" IS NOT NULL SYS_C0013559
CANCEL "CANCEL_ID" IS NOT NULL SYS_C0013561
CANCEL "SALES_ID" IS NOT NULL SYS_C0013562
CANCEL "CAN_DATE" IS NOT NULL SYS_C0013563
COMMUTE "EMP_ID" IS NOT NULL SYS_C0013571
COMMUTE "COMMUTE_ID" IS NOT NULL SYS_C0013573
COMPANY "COMPANY_ID" IS NOT NULL SYS_C0013575
COMPANY "COM_NAME" IS NOT NULL SYS_C0013576
COMPANY "PHONE" IS NOT NULL SYS_C0013577
CUSTOMER "CUSTOMER_ID" IS NOT NULL SYS_C0013579
CUSTOMER "CUS_NAME" IS NOT NULL SYS_C0013580
CUSTOMER "SEX" IS NOT NULL SYS_C0013581
CUSTOMER "BIRTH" IS NOT NULL SYS_C0013582
DISPOSAL "DISPOSAL_ID" IS NOT NULL SYS_C0013584
DISPOSAL "DIS_DATE" IS NOT NULL SYS_C0013585
DISPOSAL_PRODUCT "PRODUCT_ID" IS NOT NULL SYS_C0013587
DISPOSAL_PRODUCT "DISPOSAL_ID" IS NOT NULL SYS_C0013588
DISPOSAL_PRODUCT "QUANTITY" IS NOT NULL SYS_C0013589
EMPLOSS "EMP_ID" IS NOT NULL SYS_C0013591
EMPLOSS "AMOUNT" IS NOT NULL SYS_C0013592
EMPLOSS "LOSS_TIME" IS NOT NULL SYS_C0013593
EMPLOYEE "EMP_ID" IS NOT NULL SYS_C0013595
EMPLOYEE "BRANCH_ID" IS NOT NULL SYS_C0013596
EMPLOYEE "EMP_NAME" IS NOT NULL SYS_C0013597
EMPLOYEE "RANK" IS NOT NULL SYS_C0013598
EMPLOYEE "PHONE" IS NOT NULL SYS_C0013599
EMPLOYEE "SALARY" IS NOT NULL SYS_C0013600
EMPLOYEE "ACCOUNT" IS NOT NULL SYS_C0013601
EMPLOYEE "ADDRESS" IS NOT NULL SYS_C0013602
EMPLOYEE "BANK" IS NOT NULL SYS_C0013603
EVENT "EVENT_ID" IS NOT NULL SYS_C0013605
EVENT "EVENT_NAME" IS NOT NULL SYS_C0013606
EVENT "START_DATE" IS NOT NULL SYS_C0013607
EVENT "FINISH_DATE" IS NOT NULL SYS_C0013608
IE_CODE "IE_CODE" IS NOT NULL SYS_C0013610
IE_CODE "IE_NAME" IS NOT NULL SYS_C0013611
INCOME_EXPENDITURE "AMOUNT" IS NOT NULL SYS_C0013613
INCOME_EXPENDITURE "IE_DATE" IS NOT NULL SYS_C0013614
INCOME_EXPENDITURE "BRANCH_ID" IS NOT NULL SYS_C0013615
INCOME_EXPENDITURE "IE_CODE" IS NOT NULL SYS_C0013616
LOSS "QUANTITY" IS NOT NULL SYS_C0013618
LOSS "PRODUCT_ID" IS NOT NULL SYS_C0013619
LOSS "BRANCH_ID" IS NOT NULL SYS_C0013620
LOSS "LOSS_CODE" IS NOT NULL SYS_C0013621
LOSS_CODE "LOSS_CODE" IS NOT NULL SYS_C0013623
LOSS_CODE "LOSSCODE_NAME" IS NOT NULL SYS_C0013624
ORDER_PRODUCT "PRODUCT_ID" IS NOT NULL SYS_C0013626
ORDER_PRODUCT "ORDER_ID" IS NOT NULL SYS_C0013627
ORDER_PRODUCT "QUANTITY" IS NOT NULL SYS_C0013628
PAYMENT "AMOUNT" IS NOT NULL SYS_C0013630
PAYMENT "SALES_ID" IS NOT NULL SYS_C0013631
PAYMENT "PAYMENT_CODE" IS NOT NULL SYS_C0013632
PAYMENT_CODE "PAYMENT_CODE" IS NOT NULL SYS_C0013634
PAYMENT_CODE "PAYMENT_NAME" IS NOT NULL SYS_C0013635
PRODUCT "PRODUCT_ID" IS NOT NULL SYS_C0013637
PRODUCT "PRICE" IS NOT NULL SYS_C0013638
PRODUCT "NAME" IS NOT NULL SYS_C0013639
PRODUCT "CSPS" IS NOT NULL SYS_C0013640
PRODUCT "FRS" IS NOT NULL SYS_C0013641
PRODUCT "COMPANY_ID" IS NOT NULL SYS_C0013642
PRODUCT "ORD_PRI" IS NOT NULL SYS_C0013643
RECEIVE "RCV_DATE" IS NOT NULL SYS_C0013645
RECEIVE "COMPANY_ID" IS NOT NULL SYS_C0013646
RECEIVE "ORDER_ID" IS NOT NULL SYS_C0013647
RECEIVE_PRODUCT "COMPANY_ID" IS NOT NULL SYS_C0013649
RECEIVE_PRODUCT "ORDER_ID" IS NOT NULL SYS_C0013650
RECEIVE_PRODUCT "PRODUCT_ID" IS NOT NULL SYS_C0013651
RECEIVE_PRODUCT "QUANTITY" IS NOT NULL SYS_C0013652
SALARY "SALARY_ID" IS NOT NULL SYS_C0013654
SALARY "EMP_ID" IS NOT NULL SYS_C0013655
SALARY "SAL_DATE" IS NOT NULL SYS_C0013656
SALARY "AMOUNT" IS NOT NULL SYS_C0013657
SALES "BRANCH_ID" IS NOT NULL SYS_C0013661
SALES "CANCEL_CHECK" IS NOT NULL SYS_C0013662
SALES "AMOUNT" IS NOT NULL SYS_C0013663
SALES_PRODUCT "PRODUCT_ID" IS NOT NULL SYS_C0013665
SALES_PRODUCT "SALES_ID" IS NOT NULL SYS_C0013666
SALES_PRODUCT "QUANTITY" IS NOT NULL SYS_C0013667
SEND "COMPANY_ID" IS NOT NULL SYS_C0013669
SEND "ORDER_ID" IS NOT NULL SYS_C0013670
SEND "SEND_DATE" IS NOT NULL SYS_C0013671
SEND_ERROR "COMPANY_ID" IS NOT NULL SYS_C0013673
SEND_ERROR "ORDER_ID" IS NOT NULL SYS_C0013674
SEND_ERROR "SENDERR_DATE" IS NOT NULL SYS_C0013675
SEND "RCV_CHECK" IS NOT NULL SEND_RCV_CHECK_NN
SENDERROR_PRODUCT "COMPANY_ID" IS NOT NULL SYS_C0013681
SENDERROR_PRODUCT "ORDER_ID" IS NOT NULL SYS_C0013682
SENDERROR_PRODUCT "QUANTITY" IS NOT NULL SYS_C0013683
SENDERROR_PRODUCT "PRODUCT_ID" IS NOT NULL SYS_C0013684
STOCK "PRODUCT_ID" IS NOT NULL SYS_C0013687
STOCK "BRANCH_ID" IS NOT NULL SYS_C0013688
STOCK "QUANTITY" IS NOT NULL SYS_C0013689
SALES cancel_check in (0,1) SALES_CK_CANCEL_CHECK
ACCOUNT "USERNAME" IS NOT NULL SYS_C0013764
ACCOUNT "PASSWORD" IS NOT NULL SYS_C0013765
ACCOUNT "BRANCH_ID" IS NOT NULL SYS_C0013766
AUTHORITY "USERNAME" IS NOT NULL SYS_C0013768
AUTHORITY "AUTHORITY" IS NOT NULL SYS_C0013769
CUSTOMER "PHONE" IS NOT NULL JUSO1_PHONE_NN
index 목록 (기본키 제외)
constraint 목록