์ถํ/๋ฉํ
์ญํ : ์ฐธ์กฐ (์นดํ ๊ณ ๋ฆฌ๋ณ ์นดํ๋ก๊ทธ)
๋์ ๋ ์: DBA ยท ์ด์ ๋ด๋น ยท ์ ๋ฌด ๋ถ์
์ถํ ์ง์, ๋ฉํ ๊ด๋ฆฌ
์ด ์นดํ ๊ณ ๋ฆฌ๋ ๋ฌด์์ ๋ด๋นํ๋
๊ฐ์ โ ์ถํ ์ง์, ๋ฉํ ๊ด๋ฆฌ
๊ตฌ์ฑ โ ์ด์ ํ ์ด๋ธ 4๊ฐ
์ฃผ์ ํ ์ด๋ธ (ํ ์ ๊ธฐ์ค Top 3)
DELIVERY_ITEMโ 568069ํ ยท ์ถ๊ณ (์์ธ)DELIVERY_ORDERโ 263800ํ ยท ์ถ๊ณ (๊ณตํต)QC_LOTโ 101226ํ ยท ๋ฐํ/๊ตํ LOT
์ฃผ์ PK ํจํด โ ORDER_DATE (2) ยท ORDER_NO (2) ยท ORDER_SEQ (1) ยท DELIV_DATE (1) ยท QC_DATE (1)
์์ฝ
| ํญ๋ชฉ | ๊ฐ |
|---|---|
| ํ ์ด๋ธ ์ | 4 |
| ์ด ์ปฌ๋ผ ์ | 173 |
| PK ์์ | 4 |
| FK ๊ด๊ณ | 0 |
๊ด๊ณ๋
PK ์ปฌ๋ผ๋ช ๋งค์นญ ๊ธฐ๋ฐ ์ถ์ ๊ด๊ณ ยท ์ด 5๊ฐ ยท ์ค/ํฌ/๋ ธ๋ ๋๋๊ทธ/ํด๋ฆญ ํ์ด๋ผ์ดํธ
๊ด๊ณ๋ ๋ก๋ฉ ์ค...
ํ ์ด๋ธ ๋ชฉ๋ก
| # | ์ํ | ํ ์ด๋ธ๋ช | ์ปฌ๋ผ ์ | ํ ์ | PK | ์ค๋ช |
|---|---|---|---|---|---|---|
| 1 | ๐ฅ | DELIVERY_ITEM | 63 | 568,069 | โ | ์ถ๊ณ (์์ธ) |
| 2 | ๐ฅ | DELIVERY_ORDER | 86 | 263,800 | โ | ์ถ๊ณ (๊ณตํต) |
| 3 | ๐ฅ | QC_LOT | 23 | 101,226 | โ | ๋ฐํ/๊ตํ LOT |
| 4 | TABLE1 | 1 | 2,246 | โ | ์ํ๋ฐํ์ฃผ๋ฌธ๋ด์ญ |
์์ธ ๋ช ์ธ
DELIVERY_ITEM
์ถ๊ณ (์์ธ)
PK: ORDER_DATE, ORDER_NO, ORDER_SEQ, DELIV_DATE
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ORDER_DATE | VARCHAR2(8) | N | ์ฃผ๋ฌธ์ผ์ |
| 2 | ORDER_NO | NUMBER(4,0) | N | ์ฃผ๋ฌธ๋ฒํธ |
| 3 | ORDER_SEQ | NUMBER(2,0) | N | ์๋ฒ |
| 4 | SLIP_GUBUN | VARCHAR2(2) | Y | |
| 5 | SLIP_STATUS_CODE | VARCHAR2(1) | Y | |
| 6 | SLIP_DATE | DATE | Y | |
| 7 | TC_TYPE | VARCHAR2(2) | Y | |
| 8 | ITEM_CODE | VARCHAR2(9) | Y | ํ๋ชฉ์ฝ๋ |
| 9 | SALES_QTY | NUMBER(7,0) | Y | |
| 10 | TAX_QTY | NUMBER(7,0) | Y | ๋งค์ถ์๋ |
| 11 | ADD_QTY | NUMBER(7,0) | Y | ํ ์ฆ์๋ |
| 12 | BULK_QTY | NUMBER(7,0) | Y | |
| 13 | RETRN_QTY | NUMBER(7,0) | Y | |
| 14 | BASIC_PRICE | NUMBER(9,0) | Y | |
| 15 | ORDER_AMT | NUMBER(11,0) | Y | |
| 16 | LOWEST_AMT | NUMBER(11,0) | Y | |
| 17 | CONTRACT_AMT | NUMBER(11,0) | Y | ๋จ๊ฐ |
| 18 | CAMT_PRCTYPE | VARCHAR2(1) | Y | |
| 19 | GREWARD_CODE | VARCHAR2(8) | Y | |
| 20 | SUPPLY_AMT | NUMBER(11,0) | Y | ๊ณต๊ธ๊ฐ์ก |
| 21 | SUPPLY_VAT | NUMBER(11,0) | Y | ๋ถ๊ฐ์ธ |
| 22 | TAX_AMT | NUMBER(11,0) | Y | |
| 23 | TAX_VAT | NUMBER(11,0) | Y | |
| 24 | POLICY_UNAMT | NUMBER(11,0) | Y | |
| 25 | AFTER_UNAMT | NUMBER(11,0) | Y | |
| 26 | BEFOR_UNAMT | NUMBER(11,0) | Y | |
| 27 | DEFOR_DFRAMT | NUMBER(11,0) | Y | |
| 28 | RDATA_DATE | VARCHAR2(8) | Y | |
| 29 | RDATA_NO | NUMBER(4,0) | Y | |
| 30 | RDATA_SEQ | NUMBER(2,0) | Y | |
| 31 | RETRN_DATA_TYPE | VARCHAR2(2) | Y | |
| 32 | DELETE_YN | VARCHAR2(1) | Y | |
| 33 | LOT_NO | VARCHAR2(10) | Y | LOT๋ฒํธ |
| 34 | FIRSTEMP | VARCHAR2(6) | Y | |
| 35 | FIRSTYMD | DATE | Y | |
| 36 | LASTEMP | VARCHAR2(6) | Y | |
| 37 | LASTYMD | DATE | Y | ์ถ๊ณ ์ฒ๋ฆฌ์ผ์ |
| 38 | RSALES_CODE | VARCHAR2(6) | Y | ๊ฐ๋ฉ์ฒ์ฝ๋ |
| 39 | QC_STATUS | VARCHAR2(1) | Y | |
| 40 | QC_END_DATE | DATE | Y | |
| 41 | STOCK_QTY | NUMBER(9,0) | Y | |
| 42 | PACKING_QTY | NUMBER(9,0) | Y | |
| 43 | EXPIRCE_QTY | NUMBER(9,0) | Y | |
| 44 | QUALITY_QTY | NUMBER(9,0) | Y | |
| 45 | DESTROY_QTY | NUMBER(9,0) | Y | |
| 46 | LOT_YM | VARCHAR2(6) | Y | |
| 47 | PRINT_YN | VARCHAR2(1) | Y | |
| 48 | PRINT_DATE | VARCHAR2(8) | Y | |
| 49 | CONTRACT_TYPE_1 | NUMBER(11,0) | Y | ํ๋งค์ฅ๋ ค๊ธ(๋งค์ถํ ์ธ ๋ณ๊ฒฝ์ ) |
| 50 | CONTRACT_TYPE_2 | NUMBER(11,0) | Y | ๋งค์ถํ ์ธ(๋งค์ถํ ์ธ -๊ณ์ฐ์) |
| 51 | CONTRACT_TYPE_3 | NUMBER(11,0) | Y | ์ ๊ธ์ ๋ฆฌ(๋งค์ถ์ด์ตE) |
| 52 | CONTRACT_TYPE_4 | NUMBER(11,0) | Y | ์ํ๊ถ(๋งค์ถ์๊ฐS) |
| 53 | CONTRACT_TYPE_5 | NUMBER(11,0) | Y | ์ฝํ๋ณด์ |
| 54 | CONTRACT_TYPE_6 | NUMBER(11,0) | Y | ํ๊ธ |
| 55 | CONTRACT_TYPE_7 | NUMBER(11,0) | Y | ๊ธฐํ |
| 56 | DELIV_DATE | VARCHAR2(8) | N | ์ถ๊ณ ์ผ์ |
| 57 | DEPT_CODE | VARCHAR2(6) | Y | |
| 58 | EMP_NO | VARCHAR2(6) | Y | |
| 59 | VAT_PRINT_DATE | DATE | Y | |
| 60 | VAT_YYYYMM | VARCHAR2(6) | Y | |
| 61 | VAT_LINESEQ | NUMBER(4,0) | Y | |
| 62 | RCALL_PRINT_YN | VARCHAR2(1) | Y | |
| 63 | RCALL_PRINT_DATE | VARCHAR2(8) | Y |
์ธ๋ฑ์ค (4๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| DELIVERY_ITEM_DATA_IDX | - | SYS_NC00064$, ITEM_CODE |
| IX_DELIVERY_ITEM_1 | - | VAT_YYYYMM, VAT_LINESEQ |
| IX_DELIV_DATE | - | DELIV_DATE |
| PK_DELIVERY_ITEM | โ | ORDER_DATE, ORDER_NO, ORDER_SEQ, DELIV_DATE |
DELIVERY_ORDER
์ถ๊ณ (๊ณตํต)
PK: ORDER_DATE, ORDER_NO
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ORDER_DATE | VARCHAR2(8) | N | ์ฃผ๋ฌธ์ผ์ |
| 2 | ORDER_NO | NUMBER(4,0) | N | ์ฃผ๋ฌธ๋ฒํธ |
| 3 | SLIP_GUBUN | VARCHAR2(2) | Y | ์ฃผ๋ฌธ์ ํ์ฝ๋(SYSCODEDET/S045) |
| 4 | BUSINESS_GUBUN | VARCHAR2(1) | Y | |
| 5 | DEPT_CODE | VARCHAR2(6) | Y | ์์ ์์ฝ๋ |
| 6 | SALES_CODE | VARCHAR2(6) | Y | ๊ฑฐ๋์ฒ์ฝ๋ |
| 7 | CUST_NO | VARCHAR2(6) | Y | |
| 8 | CUST_EMP | VARCHAR2(6) | Y | |
| 9 | FLOW_CODE | VARCHAR2(2) | Y | |
| 10 | EMP_NO | VARCHAR2(6) | Y | |
| 11 | INDIRECT_GUBUN | VARCHAR2(1) | Y | |
| 12 | CONTRACT_YN | VARCHAR2(1) | Y | |
| 13 | SUPPLY_AMT | NUMBER(11,0) | Y | |
| 14 | SUPPLY_VAT | NUMBER(11,0) | Y | |
| 15 | TAX_AMT | NUMBER(11,0) | Y | |
| 16 | TAX_VAT | NUMBER(11,0) | Y | |
| 17 | POLICY_UNAMT | NUMBER(11,0) | Y | |
| 18 | AFTER_UNAMT | NUMBER(11,0) | Y | |
| 19 | BEFOR_UNAMT | NUMBER(11,0) | Y | |
| 20 | BEFOR_DFRAMT | NUMBER(11,0) | Y | |
| 21 | AUTHORITY_1 | VARCHAR2(6) | Y | |
| 22 | AUTHORITY_LEVEL | NUMBER(1,0) | Y | |
| 23 | AUTHORITY_ENDYN | VARCHAR2(1) | Y | |
| 24 | OK_YN | VARCHAR2(1) | Y | |
| 25 | AUTHORITY_2 | VARCHAR2(6) | Y | |
| 26 | CONFIRM_DATE | DATE | Y | |
| 27 | AUTHORITY_TYPE | VARCHAR2(1) | Y | |
| 28 | EXCEPTION_YN | VARCHAR2(1) | Y | |
| 29 | APPROVAL_YN | VARCHAR2(1) | Y | |
| 30 | ACCEPT_YN | VARCHAR2(1) | Y | |
| 31 | ITEM_COUNT | NUMBER(2,0) | Y | |
| 32 | ITEM_PROC | NUMBER(2,0) | Y | |
| 33 | ACCEPT_DATE | DATE | Y | |
| 34 | RDATA_DATE | VARCHAR2(8) | Y | |
| 35 | RDATA_SEQ | NUMBER(4,0) | Y | |
| 36 | RETRN_DATA_TYPE | VARCHAR2(2) | Y | |
| 37 | RETRN_REASON | VARCHAR2(2) | Y | |
| 38 | RETRN_SALES_YN | VARCHAR2(1) | Y | |
| 39 | RETRN_SALES_CNT | NUMBER(2,0) | Y | |
| 40 | RETRN_SALES_CFRM | NUMBER(2,0) | Y | |
| 41 | QC_STATUS | VARCHAR2(1) | Y | |
| 42 | QC_END_DATE | DATE | Y | |
| 43 | RECALL_YN | VARCHAR2(1) | Y | |
| 44 | RECALL_BOX | NUMBER(4,0) | Y | |
| 45 | PRINT_YN | VARCHAR2(1) | Y | |
| 46 | PRINT_DATE | DATE | Y | |
| 47 | FDEPT_CODE | VARCHAR2(6) | Y | |
| 48 | FDEPT_EMP | VARCHAR2(6) | Y | |
| 49 | RETURN_RECIVE_DATE | VARCHAR2(8) | Y | |
| 50 | RETURN_RECIVE_TYPE | VARCHAR2(1) | Y | |
| 51 | RETURN_DEPT_CONFIRM | VARCHAR2(1) | Y | |
| 52 | RETURN_DEPT_DATE | DATE | Y | |
| 53 | PREDELIVERY_REASON | VARCHAR2(1) | Y | |
| 54 | PREDELIVERY_CLOSE_YN | VARCHAR2(1) | Y | |
| 55 | PREDELIVERY_CLOSE_DATE | DATE | Y | |
| 56 | PREDELIVERY_CUST_NAME | VARCHAR2(40) | Y | |
| 57 | REMARK | VARCHAR2(200) | Y | ๋น๊ณ |
| 58 | DISAPPROV_OPPINION | VARCHAR2(100) | Y | |
| 59 | DELETE_YN | VARCHAR2(1) | Y | |
| 60 | VAT_GUBUN | VARCHAR2(1) | Y | |
| 61 | SENDING_CODE | VARCHAR2(1) | Y | |
| 62 | STOCK_STORE | VARCHAR2(4) | Y | |
| 63 | ARRIVE_ZIP_CODE | VARCHAR2(6) | Y | |
| 64 | ARRIVE_NAME | VARCHAR2(50) | Y | |
| 65 | FIRSTEMP | VARCHAR2(6) | Y | |
| 66 | FIRSTYMD | DATE | Y | |
| 67 | LASTEMP | VARCHAR2(6) | Y | |
| 68 | LASTYMD | DATE | Y | |
| 69 | INPUT_GUBUN | VARCHAR2(1) | Y | |
| 70 | RECALL_PRINT_YN | VARCHAR2(1) | Y | ์ธ๊ธ๊ณ์ฐ์์ฒ๋ฆฌ์ฌ๋ถ(1 ์ผ๊ด/2 ๊ฑด๋ณ) |
| 71 | RECALL_PRINT_DATE | VARCHAR2(8) | Y | |
| 72 | RSALES_CODE | VARCHAR2(6) | Y | |
| 73 | CONTRACT_TYPE_1 | NUMBER(11,0) | Y | ํ๋งค์ฅ๋ ค๊ธ |
| 74 | CONTRACT_TYPE_2 | NUMBER(11,0) | Y | ๋งค์ถํ ์ธ |
| 75 | CONTRACT_TYPE_3 | NUMBER(11,0) | Y | ์ ๊ธ์ ๋ฆฌ |
| 76 | CONTRACT_TYPE_4 | NUMBER(11,0) | Y | ์ํ๊ถ |
| 77 | CONTRACT_TYPE_5 | NUMBER(11,0) | Y | ์ฝํ๋ณด์ |
| 78 | CONTRACT_TYPE_6 | NUMBER(11,0) | Y | ํ๊ธ |
| 79 | CONTRACT_TYPE_7 | NUMBER(11,0) | Y | ๊ธฐํ |
| 80 | GREWARD_CODE | VARCHAR2(2) | Y | ์ฝํ๋ณด์์ฝ๋(์ฝ๋ S003 ์ค A๋ก ์์ํ๋ ์ฝ๋) |
| 81 | GREWARD_AMT | NUMBER(11,0) | Y | ์ฝํ๋ณด์์์ฐ์ก |
| 82 | VAT_PRINT_DATE | DATE | Y | |
| 83 | VAT_YYYYMM | VARCHAR2(6) | Y | ์ธ๊ธ๊ณ์ฐ์๋ ์ |
| 84 | VAT_LINESEQ | NUMBER(4,0) | Y | ์ธ๊ธ๊ณ์ฐ์๋ฒํธ |
| 85 | RCALL_PRINT_YN | VARCHAR2(1) | Y | |
| 86 | RCALL_PRINT_DATE | VARCHAR2(8) | Y |
์ธ๋ฑ์ค (2๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| IX_SALES_CODE | - | SALES_CODE |
| PK_DELIVERY_ORDER | โ | ORDER_DATE, ORDER_NO |
QC_LOT
๋ฐํ/๊ตํ LOT
PK: QC_DATE, QC_NO, QC_SEQ, QC_LOT
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | QC_DATE | VARCHAR2(8) | N | ์ ํ์ผ์ |
| 2 | QC_NO | NUMBER(4,0) | N | ์ ํ๋ฒํธ |
| 3 | QC_SEQ | NUMBER(2,0) | N | ์๋ฒ |
| 4 | QC_LOT | VARCHAR2(10) | N | LOT๋ฒํธ |
| 5 | RETRN_QTY | NUMBER(7,0) | Y | ๋ฐํ/๊ตํ์๋ |
| 6 | RETRN_BULK | NUMBER(7,0) | Y | ๋ฑ์์๋ |
| 7 | STOCK_QTY | NUMBER(7,0) | Y | ์ ๊ณ /์ฌ์ ๊ณ ์๋ |
| 8 | PACKING_QTY | NUMBER(7,0) | Y | ์ ๊ณ /์ฌํฌ์ฅ์๋ |
| 9 | EXPRICE_QTY | NUMBER(7,0) | Y | ์ ๊ณ /์ ํจ๊ฒฝ๊ณผ์๋ |
| 10 | QUALITY_QTY | NUMBER(7,0) | Y | ์ ๊ณ /๋ณ์ง์๋ |
| 11 | DESTROY_QTY | NUMBER(7,0) | Y | ์ ๊ณ /ํ์์๋ |
| 12 | TEST_QTY | NUMBER(7,0) | Y | ์ ๊ณ /์ํ์๋ขฐ์๋ |
| 13 | DELETE_YN | VARCHAR2(1) | Y | ์ญ์ ์ฌ๋ถ |
| 14 | EMP_TQTY | NUMBER(9,0) | Y | ์ ๊ณ /๋ฑ์์๋ |
| 15 | BASIC_PRICE | NUMBER(9,0) | Y | ๋ฐํ๊ธฐ์ค๊ฐ |
| 16 | RETRN_ITEM | VARCHAR2(9) | Y | ๋ฐํ/๊ตํํ๋ชฉ |
| 17 | MANUFAC_DATE | VARCHAR2(8) | Y | ์ฌ์ฉ๊ธฐํ |
| 18 | SLIP_IP | VARCHAR2(2) | Y | ์ ํ๊ตฌ๋ถ |
| 19 | LOT_SEQ | NUMBER(2,0) | Y | LOT์ ๋ ฅ์๋ฒ |
| 20 | RDATE | VARCHAR2(8) | Y | ๋ฐํ/๊ตํ ํ์ ์ผ์ |
| 21 | RNO | NUMBER(4,0) | Y | ๋ฐํ์ถ๊ณ /์ ํ๋ฒํธ |
| 22 | RSEQ | NUMBER(2,0) | Y | ๋ฐํ์ถ๊ณ /์๋ฒ |
| 23 | RETRN_REASON | VARCHAR2(1) | Y | ๋ฐํ์ฌ์ (S090) |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_QC_LOT | โ | QC_DATE, QC_NO, QC_SEQ, QC_LOT |
TABLE1
์ํ๋ฐํ์ฃผ๋ฌธ๋ด์ญ
PK: COLUMN1
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | COLUMN1 | VARCHAR2(20) | N |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| SYS_C0014018 | โ | COLUMN1 |
๊ด๋ จ ๋ฌธ์
๊ฒ์ ํค์๋: UNION_ERP, Oracle, undefined, ์ถํ/๋ฉํ, ํ ์ด๋ธ ์นดํ๋ก๊ทธ, schema reference
Last updated on