๊ณ์ฝ/๋จ๊ฐ
์ญํ : ์ฐธ์กฐ (์นดํ ๊ณ ๋ฆฌ๋ณ ์นดํ๋ก๊ทธ)
๋์ ๋ ์: DBA ยท ์ด์ ๋ด๋น ยท ์ ๋ฌด ๋ถ์
๊ณ์ฝ ์ด๋ ฅ, ๋จ๊ฐ ๊ด๋ฆฌ
์ด ์นดํ ๊ณ ๋ฆฌ๋ ๋ฌด์์ ๋ด๋นํ๋
๊ฐ์ โ ๊ณ์ฝ ์ด๋ ฅ, ๋จ๊ฐ ๊ด๋ฆฌ
๊ตฌ์ฑ โ ์ด์ ํ ์ด๋ธ 7๊ฐ ยท ๋ฐฑ์ /์ด๋ ฅ 3๊ฐ (๋ง์ด๊ทธ๋ ์ด์ ์ ์ธ ํ๋ณด)
์ฃผ์ ํ ์ด๋ธ (ํ ์ ๊ธฐ์ค Top 3)
CONTRACT_HISTORYโ 130094ํ ยท ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ HISTORYCONTRACT_HISTORY_1012โ 66240ํ ยท (์ถ์ ) ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ HISTORY ๊ณ์ดCONTRACT_VALUEโ 63484ํ ยท ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ
์ฃผ์ PK ํจํด โ ITEM_CODE (6) ยท CUST_CODE (5) ยท SALES_CODE (4) ยท TERM_FROM (4) ยท CHANGE_YMD (2)
์์ฝ
| ํญ๋ชฉ | ๊ฐ |
|---|---|
| ํ ์ด๋ธ ์ | 10 |
| ์ด ์ปฌ๋ผ ์ | 295 |
| PK ์์ | 8 |
| FK ๊ด๊ณ | 0 |
๊ด๊ณ๋
PK ์ปฌ๋ผ๋ช ๋งค์นญ ๊ธฐ๋ฐ ์ถ์ ๊ด๊ณ ยท ์ด 18๊ฐ ยท ์ค/ํฌ/๋ ธ๋ ๋๋๊ทธ/ํด๋ฆญ ํ์ด๋ผ์ดํธ
๊ด๊ณ๋ ๋ก๋ฉ ์ค...
ํ ์ด๋ธ ๋ชฉ๋ก
๐ฆ ๋ฐฑ์ /๋ฒ์ ํ ์ด๋ธ 3๊ฐ ํฌํจ ยท ๐ฅ 1๋งํ ์ด์ ยท โ ๏ธ ๋น ํ ์ด๋ธ
| # | ์ํ | ํ ์ด๋ธ๋ช | ์ปฌ๋ผ ์ | ํ ์ | PK | ์ค๋ช |
|---|---|---|---|---|---|---|
| 1 | ๐ฅ | CONTRACT_HISTORY | 30 | 130,094 | โ | ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ HISTORY |
| 2 | ๐ฅ | CONTRACT_VALUE | 29 | 63,484 | โ | ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ |
| 3 | ๐ฅ | CONTRACT_HISTORY_1012 | 30 | 66,240 | โ | (์ถ์ ) ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ HISTORY ๊ณ์ด |
| 4 | ๐ฆ | CONTRACT_VALUE_20120330 | 29 | 41,897 | โ | ๐ฆ ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ์ ๋ฐฑ์ |
| 5 | ๐ฆ | CONTRACT_VALUE_20110613 | 29 | 25,452 | โ | ๐ฆ ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ์ ๋ฐฑ์ |
| 6 | ๐ฅ | CONTRACT_VALUE_1012 | 29 | 22,157 | โ | (์ถ์ ) ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ ๊ณ์ด |
| 7 | ๐ฅ | CONTRACT_VALUE_0812 | 29 | 13,954 | - | (์ถ์ ) ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ ๊ณ์ด |
| 8 | ๐ฅ | CONTRACT_MOVE_WHOLESALE | 31 | 29,214 | โ | (์ถ์ ) ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ ๊ณ์ด |
| 9 | ๐ฆ | CONTRACT_VALUE_20240701 | 29 | 209,306 | - | ๐ฆ ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ์ ๋ฐฑ์ |
| 10 | CONTRACT_VALUE_TAKING | 30 | 523 | โ | ์ ๊ท๊ฑฐ๋์ฒ๊ณ์ฝ๋จ๊ฐ์ด๊ด๋ด์ญ |
์์ธ ๋ช ์ธ
CONTRACT_HISTORY
์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ HISTORY
PK: SALES_CODE, CUST_CODE, ITEM_CODE, CHANGE_YMD
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | VARCHAR2(6) | N | ๊ฑฐ๋์ฒ์ฝ๋ |
| 2 | CUST_CODE | VARCHAR2(6) | N | ๋ฉํ์ฒ์ฝ๋ |
| 3 | ITEM_CODE | VARCHAR2(9) | N | ํ๋ชฉ์ฝ๋ |
| 4 | CHANGE_YMD | DATE | N | ๋ณ๊ฒฝ์ผ์ |
| 5 | BUSINESS_GUBUN | VARCHAR2(1) | N | ๊ฑฐ๋์ฒ์ฌ์ ๊ตฌ๋ถ (S002) |
| 6 | BASE_AMT | NUMBER(9,0) | Y | ๋น์๊ธฐ์ค์ฝ๊ฐ(๋ณดํ์ฝ๊ฐ) |
| 7 | ORDER_AMT | NUMBER(9,0) | Y | ๋น์์ ์ฑ ๊ฐ(์ฃผ๋ฌธ๊ฐ) |
| 8 | LOWEST_AMT | NUMBER(9,0) | Y | ๋น์์๊ธํํ๊ฐ |
| 9 | CAMT_PRCTYPE | VARCHAR2(1) | Y | ๊ณ์ฝ๋จ๊ฐ์งํ์ ํ (S198;์ฌ์ ํ ์ฆ,์ฌํ) |
| 10 | CONTRACT_AMT | NUMBER(9,0) | Y | ๊ณ์ฝ๋จ๊ฐ |
| 11 | RND_RATE | NUMBER(5,2) | Y | ๊ธฐ์ค๊ฐ๋๋น๊ณ์ฝ๋จ๊ฐ๋น์จ |
| 12 | TERM_FROM | DATE | Y | ๊ณ์ฝ๊ธฐ๊ฐ(FROM) |
| 13 | TERM_TO | DATE | Y | ๊ณ์ฝ๊ธฐ๊ฐ(TO) |
| 14 | CHANGE_DATE | DATE | Y | ๋ณ๊ฒฝ์ผ์ |
| 15 | CONTRACT_GUBUN | VARCHAR2(1) | Y | ๊ธฐ์์์ ํ(1:๋จ๊ฐ์ฌ๊ณ์ฝ,2:์ ๊ทํ๋ชฉ,3:๊ธฐ์ค๊ฐ๋ณ๊ฒฝ) |
| 16 | MON_SOMO | NUMBER(7,0) | Y | ์์์์๋ชจ๋ |
| 17 | DRAFT_DATE | VARCHAR2(8) | Y | ๊ธฐ์์ผ์ |
| 18 | DRAFT_NO | NUMBER(4,0) | Y | ๊ธฐ์๋ฌธ์๋ฒํธ |
| 19 | USE_YN | VARCHAR2(1) | Y | ์ฌ์ฉ์ฌ๋ถ |
| 20 | FIRSTEMP | VARCHAR2(6) | Y | |
| 21 | FIRSTYMD | DATE | Y | |
| 22 | LASTEMP | VARCHAR2(6) | Y | |
| 23 | LASTYMD | DATE | Y | |
| 24 | CONTRACT_TYPE_1 | NUMBER(5,2) | Y | ํ๋งค์ฅ๋ ค๊ธ |
| 25 | CONTRACT_TYPE_2 | NUMBER(5,2) | Y | ๋งค์ถํ ์ธ |
| 26 | CONTRACT_TYPE_3 | NUMBER(5,2) | Y | ์ ๊ธ์ ๋ฆฌ |
| 27 | CONTRACT_TYPE_4 | NUMBER(5,2) | Y | ์ํ๊ถ |
| 28 | CONTRACT_TYPE_5 | NUMBER(5,2) | Y | ์ฝํ๋ณด์ |
| 29 | CONTRACT_TYPE_6 | NUMBER(5,2) | Y | ํ๊ธ์ ๋ฆฌ |
| 30 | CONTRACT_TYPE_7 | NUMBER(5,2) | Y | ๊ธฐํ |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| SYS_C008408 | โ | SALES_CODE, CUST_CODE, ITEM_CODE, CHANGE_YMD |
CONTRACT_VALUE
์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ
PK: SALES_CODE, CUST_CODE, ITEM_CODE, TERM_FROM
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | VARCHAR2(6) | N | ๊ฑฐ๋์ฒ์ฝ๋ |
| 2 | CUST_CODE | VARCHAR2(6) | N | ๋ฉํ์ฒ์ฝ๋ |
| 3 | ITEM_CODE | VARCHAR2(9) | N | ํ๋ชฉ์ฝ๋ |
| 4 | BUSINESS_GUBUN | VARCHAR2(1) | N | ์ฌ์ ๊ตฌ๋ถ (S002) |
| 5 | BASE_AMT | NUMBER(9,0) | Y | ๋น์๊ธฐ์ค์ฝ๊ฐ(๋ณดํ์ฝ๊ฐ) |
| 6 | ORDER_AMT | NUMBER(9,0) | Y | ๊ณ์ฐ์๊ฐ(์ฃผ๋ฌธ๊ฐ) |
| 7 | LOWEST_AMT | NUMBER(9,0) | Y | ๋น์์๊ธํ๊ฐ |
| 8 | CAMT_PRCTYPE | VARCHAR2(1) | Y | ๊ณ์ฝ๋จ๊ฐ์งํ์ ํ(S198;์ฌ์ ํ ์ฆ/์ฌํ) |
| 9 | CONTRACT_AMT | NUMBER(9,0) | Y | ๊ณ์ฝ๋จ๊ฐ |
| 10 | RND_RATE | NUMBER(5,2) | Y | ๊ธฐ์ค๊ฐ๋๋น๊ณ์ฝ๋จ๊ฐ๋น์จ |
| 11 | TERM_FROM | DATE | N | ๊ณ์ฝ๊ธฐ๊ฐ(FROM) |
| 12 | TERM_TO | DATE | Y | ๊ณ์ฝ๊ธฐ๊ฐ(TO) |
| 13 | CHANGE_DATE | DATE | Y | ๋ณ๊ฒฝ์ผ์ |
| 14 | CONTRACT_GUBUN | VARCHAR2(1) | Y | ๊ธฐ์์์ ํ |
| 15 | MON_SOMO | NUMBER(7,0) | Y | ์์์์๋ชจ๋ |
| 16 | DRAFT_DATE | VARCHAR2(8) | Y | ๊ธฐ์์ผ์ |
| 17 | DRAFT_NO | NUMBER(4,0) | Y | ๊ธฐ์๋ฌธ์๋ฒํธ |
| 18 | USE_YN | VARCHAR2(1) | Y | ์ฌ์ฉ์ฌ๋ถ |
| 19 | FIRSTEMP | VARCHAR2(6) | Y | ์ต์ด์ ๋ ฅ์ |
| 20 | FIRSTYMD | DATE | Y | |
| 21 | LASTEMP | VARCHAR2(6) | Y | |
| 22 | LASTYMD | DATE | Y | |
| 23 | CONTRACT_TYPE_1 | NUMBER(5,2) | Y | ํ๋งค์ฅ๋ ค๊ธ์์จ |
| 24 | CONTRACT_TYPE_2 | NUMBER(5,2) | Y | ๋งค์ถํ ์ธ์์จ |
| 25 | CONTRACT_TYPE_3 | NUMBER(5,2) | Y | ์ ๊ธ์ ๋ฆฌ์์จ |
| 26 | CONTRACT_TYPE_4 | NUMBER(5,2) | Y | ์ํ๊ถ์์จ |
| 27 | CONTRACT_TYPE_5 | NUMBER(5,2) | Y | ์ฝํ๋ณด์์์จ |
| 28 | CONTRACT_TYPE_6 | NUMBER(5,2) | Y | ํ๊ธ์ ๋ฆฌ์์จ |
| 29 | CONTRACT_TYPE_7 | NUMBER(5,2) | Y | ๊ธฐํ์์จ |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_CONTRACT_VALUE | โ | SALES_CODE, CUST_CODE, ITEM_CODE, TERM_FROM |
CONTRACT_HISTORY_1012
(์ถ์ ) ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ HISTORY ๊ณ์ด
PK: SALES_CODE, CUST_CODE, ITEM_CODE, CHANGE_YMD
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | VARCHAR2(6) | N | |
| 2 | CUST_CODE | VARCHAR2(6) | N | |
| 3 | ITEM_CODE | VARCHAR2(9) | N | |
| 4 | CHANGE_YMD | DATE | N | |
| 5 | BUSINESS_GUBUN | VARCHAR2(1) | N | |
| 6 | BASE_AMT | NUMBER(9,0) | Y | |
| 7 | ORDER_AMT | NUMBER(9,0) | Y | |
| 8 | LOWEST_AMT | NUMBER(9,0) | Y | |
| 9 | CAMT_PRCTYPE | VARCHAR2(1) | Y | |
| 10 | CONTRACT_AMT | NUMBER(9,0) | Y | |
| 11 | RND_RATE | NUMBER(5,2) | Y | |
| 12 | TERM_FROM | DATE | Y | |
| 13 | TERM_TO | DATE | Y | |
| 14 | CHANGE_DATE | DATE | Y | |
| 15 | CONTRACT_GUBUN | VARCHAR2(1) | Y | |
| 16 | MON_SOMO | NUMBER(7,0) | Y | |
| 17 | DRAFT_DATE | VARCHAR2(8) | Y | |
| 18 | DRAFT_NO | NUMBER(4,0) | Y | |
| 19 | USE_YN | VARCHAR2(1) | Y | |
| 20 | FIRSTEMP | VARCHAR2(6) | Y | |
| 21 | FIRSTYMD | DATE | Y | |
| 22 | LASTEMP | VARCHAR2(6) | Y | |
| 23 | LASTYMD | DATE | Y | |
| 24 | CONTRACT_TYPE_1 | NUMBER(5,2) | Y | |
| 25 | CONTRACT_TYPE_2 | NUMBER(5,2) | Y | |
| 26 | CONTRACT_TYPE_3 | NUMBER(5,2) | Y | |
| 27 | CONTRACT_TYPE_4 | NUMBER(5,2) | Y | |
| 28 | CONTRACT_TYPE_5 | NUMBER(5,2) | Y | |
| 29 | CONTRACT_TYPE_6 | NUMBER(5,2) | Y | |
| 30 | CONTRACT_TYPE_7 | NUMBER(5,2) | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| SYS_C008410 | โ | SALES_CODE, CUST_CODE, ITEM_CODE, CHANGE_YMD |
CONTRACT_VALUE_20120330
๐ฆ ๋ฐฑ์ ํ ์ด๋ธ โ
CONTRACT_VALUE์ ์์ ๋ณต์ฌ๋ณธ. ๋ง์ด๊ทธ๋ ์ด์ ๋์์์ ์ ์ธ ๊ฒํ .
PK: SALES_CODE, CUST_CODE, ITEM_CODE, TERM_FROM
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | VARCHAR2(6) | N | |
| 2 | CUST_CODE | VARCHAR2(6) | N | |
| 3 | ITEM_CODE | VARCHAR2(9) | N | |
| 4 | BUSINESS_GUBUN | VARCHAR2(1) | N | |
| 5 | BASE_AMT | NUMBER(9,0) | Y | |
| 6 | ORDER_AMT | NUMBER(9,0) | Y | |
| 7 | LOWEST_AMT | NUMBER(9,0) | Y | |
| 8 | CAMT_PRCTYPE | VARCHAR2(1) | Y | |
| 9 | CONTRACT_AMT | NUMBER(9,0) | Y | |
| 10 | RND_RATE | NUMBER(5,2) | Y | |
| 11 | TERM_FROM | DATE | N | |
| 12 | TERM_TO | DATE | Y | |
| 13 | CHANGE_DATE | DATE | Y | |
| 14 | CONTRACT_GUBUN | VARCHAR2(1) | Y | |
| 15 | MON_SOMO | NUMBER(7,0) | Y | |
| 16 | DRAFT_DATE | VARCHAR2(8) | Y | |
| 17 | DRAFT_NO | NUMBER(4,0) | Y | |
| 18 | USE_YN | VARCHAR2(1) | Y | |
| 19 | FIRSTEMP | VARCHAR2(6) | Y | |
| 20 | FIRSTYMD | DATE | Y | |
| 21 | LASTEMP | VARCHAR2(6) | Y | |
| 22 | LASTYMD | DATE | Y | |
| 23 | CONTRACT_TYPE_1 | NUMBER(5,2) | Y | |
| 24 | CONTRACT_TYPE_2 | NUMBER(5,2) | Y | |
| 25 | CONTRACT_TYPE_3 | NUMBER(5,2) | Y | |
| 26 | CONTRACT_TYPE_4 | NUMBER(5,2) | Y | |
| 27 | CONTRACT_TYPE_5 | NUMBER(5,2) | Y | |
| 28 | CONTRACT_TYPE_6 | NUMBER(5,2) | Y | |
| 29 | CONTRACT_TYPE_7 | NUMBER(5,2) | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_CONTRACT_VALUE_20120330 | โ | SALES_CODE, CUST_CODE, ITEM_CODE, TERM_FROM |
CONTRACT_VALUE_20110613
๐ฆ ๋ฐฑ์ ํ ์ด๋ธ โ
CONTRACT_VALUE์ ์์ ๋ณต์ฌ๋ณธ. ๋ง์ด๊ทธ๋ ์ด์ ๋์์์ ์ ์ธ ๊ฒํ .
PK: SALES_CODE, CUST_CODE, ITEM_CODE, TERM_FROM
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | VARCHAR2(6) | N | |
| 2 | CUST_CODE | VARCHAR2(6) | N | |
| 3 | ITEM_CODE | VARCHAR2(9) | N | |
| 4 | BUSINESS_GUBUN | VARCHAR2(1) | N | |
| 5 | BASE_AMT | NUMBER(9,0) | Y | |
| 6 | ORDER_AMT | NUMBER(9,0) | Y | |
| 7 | LOWEST_AMT | NUMBER(9,0) | Y | |
| 8 | CAMT_PRCTYPE | VARCHAR2(1) | Y | |
| 9 | CONTRACT_AMT | NUMBER(9,0) | Y | |
| 10 | RND_RATE | NUMBER(5,2) | Y | |
| 11 | TERM_FROM | DATE | N | |
| 12 | TERM_TO | DATE | Y | |
| 13 | CHANGE_DATE | DATE | Y | |
| 14 | CONTRACT_GUBUN | VARCHAR2(1) | Y | |
| 15 | MON_SOMO | NUMBER(7,0) | Y | |
| 16 | DRAFT_DATE | VARCHAR2(8) | Y | |
| 17 | DRAFT_NO | NUMBER(4,0) | Y | |
| 18 | USE_YN | VARCHAR2(1) | Y | |
| 19 | FIRSTEMP | VARCHAR2(6) | Y | |
| 20 | FIRSTYMD | DATE | Y | |
| 21 | LASTEMP | VARCHAR2(6) | Y | |
| 22 | LASTYMD | DATE | Y | |
| 23 | CONTRACT_TYPE_1 | NUMBER(5,2) | Y | |
| 24 | CONTRACT_TYPE_2 | NUMBER(5,2) | Y | |
| 25 | CONTRACT_TYPE_3 | NUMBER(5,2) | Y | |
| 26 | CONTRACT_TYPE_4 | NUMBER(5,2) | Y | |
| 27 | CONTRACT_TYPE_5 | NUMBER(5,2) | Y | |
| 28 | CONTRACT_TYPE_6 | NUMBER(5,2) | Y | |
| 29 | CONTRACT_TYPE_7 | NUMBER(5,2) | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_CONTRACT_VALUE_20110613 | โ | SALES_CODE, CUST_CODE, ITEM_CODE, TERM_FROM |
CONTRACT_VALUE_1012
(์ถ์ ) ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ ๊ณ์ด
PK: SALES_CODE, CUST_CODE, ITEM_CODE, TERM_FROM
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | VARCHAR2(6) | N | |
| 2 | CUST_CODE | VARCHAR2(6) | N | |
| 3 | ITEM_CODE | VARCHAR2(9) | N | |
| 4 | BUSINESS_GUBUN | VARCHAR2(1) | N | |
| 5 | BASE_AMT | NUMBER(9,0) | Y | |
| 6 | ORDER_AMT | NUMBER(9,0) | Y | |
| 7 | LOWEST_AMT | NUMBER(9,0) | Y | |
| 8 | CAMT_PRCTYPE | VARCHAR2(1) | Y | |
| 9 | CONTRACT_AMT | NUMBER(9,0) | Y | |
| 10 | RND_RATE | NUMBER(5,2) | Y | |
| 11 | TERM_FROM | DATE | N | |
| 12 | TERM_TO | DATE | Y | |
| 13 | CHANGE_DATE | DATE | Y | |
| 14 | CONTRACT_GUBUN | VARCHAR2(1) | Y | |
| 15 | MON_SOMO | NUMBER(7,0) | Y | |
| 16 | DRAFT_DATE | VARCHAR2(8) | Y | |
| 17 | DRAFT_NO | NUMBER(4,0) | Y | |
| 18 | USE_YN | VARCHAR2(1) | Y | |
| 19 | FIRSTEMP | VARCHAR2(6) | Y | |
| 20 | FIRSTYMD | DATE | Y | |
| 21 | LASTEMP | VARCHAR2(6) | Y | |
| 22 | LASTYMD | DATE | Y | |
| 23 | CONTRACT_TYPE_1 | NUMBER(5,2) | Y | |
| 24 | CONTRACT_TYPE_2 | NUMBER(5,2) | Y | |
| 25 | CONTRACT_TYPE_3 | NUMBER(5,2) | Y | |
| 26 | CONTRACT_TYPE_4 | NUMBER(5,2) | Y | |
| 27 | CONTRACT_TYPE_5 | NUMBER(5,2) | Y | |
| 28 | CONTRACT_TYPE_6 | NUMBER(5,2) | Y | |
| 29 | CONTRACT_TYPE_7 | NUMBER(5,2) | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_CONTRACT_VALUE_1012 | โ | SALES_CODE, CUST_CODE, ITEM_CODE, TERM_FROM |
CONTRACT_VALUE_0812
(์ถ์ ) ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ ๊ณ์ด
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | VARCHAR2(6) | N | |
| 2 | CUST_CODE | VARCHAR2(6) | N | |
| 3 | ITEM_CODE | VARCHAR2(9) | N | |
| 4 | BUSINESS_GUBUN | VARCHAR2(1) | N | |
| 5 | BASE_AMT | NUMBER(9,0) | Y | |
| 6 | ORDER_AMT | NUMBER(9,0) | Y | |
| 7 | LOWEST_AMT | NUMBER(9,0) | Y | |
| 8 | CAMT_PRCTYPE | VARCHAR2(1) | Y | |
| 9 | CONTRACT_AMT | NUMBER(9,0) | Y | |
| 10 | RND_RATE | NUMBER(5,2) | Y | |
| 11 | TERM_FROM | DATE | Y | |
| 12 | TERM_TO | DATE | Y | |
| 13 | CHANGE_DATE | DATE | Y | |
| 14 | CONTRACT_GUBUN | VARCHAR2(1) | Y | |
| 15 | MON_SOMO | NUMBER(7,0) | Y | |
| 16 | DRAFT_DATE | VARCHAR2(8) | Y | |
| 17 | DRAFT_NO | NUMBER(4,0) | Y | |
| 18 | USE_YN | VARCHAR2(1) | Y | |
| 19 | FIRSTEMP | VARCHAR2(6) | Y | |
| 20 | FIRSTYMD | DATE | Y | |
| 21 | LASTEMP | VARCHAR2(6) | Y | |
| 22 | LASTYMD | DATE | Y | |
| 23 | CONTRACT_TYPE_1 | NUMBER(5,2) | Y | |
| 24 | CONTRACT_TYPE_2 | NUMBER(5,2) | Y | |
| 25 | CONTRACT_TYPE_3 | NUMBER(5,2) | Y | |
| 26 | CONTRACT_TYPE_4 | NUMBER(5,2) | Y | |
| 27 | CONTRACT_TYPE_5 | NUMBER(5,2) | Y | |
| 28 | CONTRACT_TYPE_6 | NUMBER(5,2) | Y | |
| 29 | CONTRACT_TYPE_7 | NUMBER(5,2) | Y |
CONTRACT_MOVE_WHOLESALE
(์ถ์ ) ์์ ๊ด๋ฆฌ/๊ณ์ฝ๋จ๊ฐ ๊ณ์ด
PK: TAKE_SALES_CODE, TAKE_CUST_CODE, GIVE_SALES_CODE, GIVE_CUST_CODE, ITEM_CODE, TERM_FROM
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | TAKE_SALES_CODE | VARCHAR2(6) | N | |
| 2 | TAKE_CUST_CODE | VARCHAR2(6) | N | |
| 3 | GIVE_SALES_CODE | VARCHAR2(6) | N | |
| 4 | GIVE_CUST_CODE | VARCHAR2(6) | N | |
| 5 | ITEM_CODE | VARCHAR2(9) | N | |
| 6 | BUSINESS_GUBUN | VARCHAR2(1) | N | |
| 7 | BASE_AMT | NUMBER(9,0) | Y | |
| 8 | ORDER_AMT | NUMBER(9,0) | Y | |
| 9 | LOWEST_AMT | NUMBER(9,0) | Y | |
| 10 | CAMT_PRCTYPE | VARCHAR2(1) | Y | |
| 11 | CONTRACT_AMT | NUMBER(9,0) | Y | |
| 12 | RND_RATE | NUMBER(5,2) | Y | |
| 13 | TERM_FROM | DATE | N | |
| 14 | TERM_TO | DATE | Y | |
| 15 | CHANGE_DATE | DATE | Y | |
| 16 | CONTRACT_GUBUN | VARCHAR2(1) | Y | |
| 17 | MON_SOMO | NUMBER(7,0) | Y | |
| 18 | DRAFT_DATE | VARCHAR2(8) | Y | |
| 19 | DRAFT_NO | NUMBER(4,0) | Y | |
| 20 | USE_YN | VARCHAR2(1) | Y | |
| 21 | FIRSTEMP | VARCHAR2(6) | Y | |
| 22 | FIRSTYMD | DATE | Y | |
| 23 | LASTEMP | VARCHAR2(6) | Y | |
| 24 | LASTYMD | DATE | Y | |
| 25 | CONTRACT_TYPE_1 | NUMBER(5,2) | Y | |
| 26 | CONTRACT_TYPE_2 | NUMBER(5,2) | Y | |
| 27 | CONTRACT_TYPE_3 | NUMBER(5,2) | Y | |
| 28 | CONTRACT_TYPE_4 | NUMBER(5,2) | Y | |
| 29 | CONTRACT_TYPE_5 | NUMBER(5,2) | Y | |
| 30 | CONTRACT_TYPE_6 | NUMBER(5,2) | Y | |
| 31 | CONTRACT_TYPE_7 | NUMBER(5,2) | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_CONTRACT_MOVE_WHOLESALE | โ | TAKE_SALES_CODE, TAKE_CUST_CODE, GIVE_SALES_CODE, GIVE_CUST_CODE, ITEM_CODE, TERM_FROM |
CONTRACT_VALUE_20240701
๐ฆ ๋ฐฑ์ ํ ์ด๋ธ โ
CONTRACT_VALUE์ ์์ ๋ณต์ฌ๋ณธ. ๋ง์ด๊ทธ๋ ์ด์ ๋์์์ ์ ์ธ ๊ฒํ .
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | VARCHAR2(6) | N | |
| 2 | CUST_CODE | VARCHAR2(6) | N | |
| 3 | ITEM_CODE | VARCHAR2(9) | N | |
| 4 | BUSINESS_GUBUN | VARCHAR2(1) | N | |
| 5 | BASE_AMT | NUMBER(9,0) | Y | |
| 6 | ORDER_AMT | NUMBER(9,0) | Y | |
| 7 | LOWEST_AMT | NUMBER(9,0) | Y | |
| 8 | CAMT_PRCTYPE | VARCHAR2(1) | Y | |
| 9 | CONTRACT_AMT | NUMBER(9,0) | Y | |
| 10 | RND_RATE | NUMBER(5,2) | Y | |
| 11 | TERM_FROM | DATE | Y | |
| 12 | TERM_TO | DATE | Y | |
| 13 | CHANGE_DATE | DATE | Y | |
| 14 | CONTRACT_GUBUN | VARCHAR2(1) | Y | |
| 15 | MON_SOMO | NUMBER(7,0) | Y | |
| 16 | DRAFT_DATE | VARCHAR2(8) | Y | |
| 17 | DRAFT_NO | NUMBER(4,0) | Y | |
| 18 | USE_YN | VARCHAR2(1) | Y | |
| 19 | FIRSTEMP | VARCHAR2(6) | Y | |
| 20 | FIRSTYMD | DATE | Y | |
| 21 | LASTEMP | VARCHAR2(6) | Y | |
| 22 | LASTYMD | DATE | Y | |
| 23 | CONTRACT_TYPE_1 | NUMBER(5,2) | Y | |
| 24 | CONTRACT_TYPE_2 | NUMBER(5,2) | Y | |
| 25 | CONTRACT_TYPE_3 | NUMBER(5,2) | Y | |
| 26 | CONTRACT_TYPE_4 | NUMBER(5,2) | Y | |
| 27 | CONTRACT_TYPE_5 | NUMBER(5,2) | Y | |
| 28 | CONTRACT_TYPE_6 | NUMBER(5,2) | Y | |
| 29 | CONTRACT_TYPE_7 | NUMBER(5,2) | Y |
CONTRACT_VALUE_TAKING
์ ๊ท๊ฑฐ๋์ฒ๊ณ์ฝ๋จ๊ฐ์ด๊ด๋ด์ญ
PK: TAKE_SALES_CODE, GIVE_SALES_CODE, CUST_CODE, ITEM_CODE, TERM_FROM
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | TAKE_SALES_CODE | VARCHAR2(6) | N | ์ธ์(์ ๊ท)๊ฑฐ๋์ฒ |
| 2 | GIVE_SALES_CODE | VARCHAR2(6) | N | ๊ธฐ์กด(์ธ๊ณ)๊ฑฐ๋์ฒ |
| 3 | CUST_CODE | VARCHAR2(6) | N | ๋ฉํ์ฒ |
| 4 | ITEM_CODE | VARCHAR2(9) | N | ํ๋ชฉ์ฝ๋ |
| 5 | BUSINESS_GUBUN | VARCHAR2(1) | N | |
| 6 | BASE_AMT | NUMBER(9,0) | Y | |
| 7 | ORDER_AMT | NUMBER(9,0) | Y | |
| 8 | LOWEST_AMT | NUMBER(9,0) | Y | |
| 9 | CAMT_PRCTYPE | VARCHAR2(1) | Y | |
| 10 | CONTRACT_AMT | NUMBER(9,0) | Y | |
| 11 | RND_RATE | NUMBER(5,2) | Y | |
| 12 | TERM_FROM | DATE | N | |
| 13 | TERM_TO | DATE | Y | |
| 14 | CHANGE_DATE | DATE | Y | |
| 15 | CONTRACT_GUBUN | VARCHAR2(1) | Y | |
| 16 | MON_SOMO | NUMBER(7,0) | Y | |
| 17 | DRAFT_DATE | VARCHAR2(8) | Y | |
| 18 | DRAFT_NO | NUMBER(4,0) | Y | |
| 19 | USE_YN | VARCHAR2(1) | Y | |
| 20 | FIRSTEMP | VARCHAR2(6) | Y | |
| 21 | FIRSTYMD | DATE | Y | |
| 22 | LASTEMP | VARCHAR2(6) | Y | |
| 23 | LASTYMD | DATE | Y | |
| 24 | CONTRACT_TYPE_1 | NUMBER(5,2) | Y | |
| 25 | CONTRACT_TYPE_2 | NUMBER(5,2) | Y | |
| 26 | CONTRACT_TYPE_3 | NUMBER(5,2) | Y | |
| 27 | CONTRACT_TYPE_4 | NUMBER(5,2) | Y | |
| 28 | CONTRACT_TYPE_5 | NUMBER(5,2) | Y | |
| 29 | CONTRACT_TYPE_6 | NUMBER(5,2) | Y | |
| 30 | CONTRACT_TYPE_7 | NUMBER(5,2) | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_CONTRACT_VALUE_TAKING | โ | TAKE_SALES_CODE, GIVE_SALES_CODE, CUST_CODE, ITEM_CODE, TERM_FROM |
๊ด๋ จ ๋ฌธ์
๊ฒ์ ํค์๋: UNION_ERP, Oracle, undefined, ๊ณ์ฝ/๋จ๊ฐ, ํ ์ด๋ธ ์นดํ๋ก๊ทธ, schema reference
Last updated on