์ ํ/์ฆ๋น
์ญํ : ์ฐธ์กฐ (์นดํ ๊ณ ๋ฆฌ๋ณ ์นดํ๋ก๊ทธ)
๋์ ๋ ์: DBA ยท ์ด์ ๋ด๋น ยท ์ ๋ฌด ๋ถ์
์ ํ ๋ฐํ, ์ฆ๋น ๊ด๋ฆฌ
์ด ์นดํ ๊ณ ๋ฆฌ๋ ๋ฌด์์ ๋ด๋นํ๋
๊ฐ์ โ ์ ํ ๋ฐํ, ์ฆ๋น ๊ด๋ฆฌ
๊ตฌ์ฑ โ ์ด์ ํ ์ด๋ธ 5๊ฐ ยท ๋ฐฑ์ /์ด๋ ฅ 2๊ฐ (๋ง์ด๊ทธ๋ ์ด์ ์ ์ธ ํ๋ณด)
์ฃผ์ ํ ์ด๋ธ (ํ ์ ๊ธฐ์ค Top 3)
VOUCHER_SALESโ 2613667ํ ยท ๊ฑฐ๋์ฅVOUCHER_SALES_0817โ 312204ํ ยท (์ถ์ ) ๊ฑฐ๋์ฅ ๊ณ์ดVOUCHER_SALES_0427โ 288376ํ ยท (์ถ์ ) ๊ฑฐ๋์ฅ ๊ณ์ด
์ฃผ์ PK ํจํด โ SALES_CODE (1) ยท APPROV_DATE (1) ยท SALES_DATE (1) ยท SALES_NO (1) ยท SALES_SEQ (1)
์์ฝ
| ํญ๋ชฉ | ๊ฐ |
|---|---|
| ํ ์ด๋ธ ์ | 7 |
| ์ด ์ปฌ๋ผ ์ | 119 |
| PK ์์ | 2 |
| FK ๊ด๊ณ | 0 |
๊ด๊ณ๋
PK ์ปฌ๋ผ๋ช ๋งค์นญ ๊ธฐ๋ฐ ์ถ์ ๊ด๊ณ ยท ์ด 14๊ฐ ยท ์ค/ํฌ/๋ ธ๋ ๋๋๊ทธ/ํด๋ฆญ ํ์ด๋ผ์ดํธ
ํ ์ด๋ธ ๋ชฉ๋ก
๐ฆ ๋ฐฑ์ /๋ฒ์ ํ ์ด๋ธ 2๊ฐ ํฌํจ ยท ๐ฅ 1๋งํ ์ด์ ยท โ ๏ธ ๋น ํ ์ด๋ธ
| # | ์ํ | ํ ์ด๋ธ๋ช | ์ปฌ๋ผ ์ | ํ ์ | PK | ์ค๋ช |
|---|---|---|---|---|---|---|
| 1 | ๐ฅ | VOUCHER_SALES | 17 | 2,613,667 | โ | ๊ฑฐ๋์ฅ |
| 2 | ๐ฅ | VOUCHER_SALES_0420 | 17 | 288,088 | - | (์ถ์ ) ๊ฑฐ๋์ฅ ๊ณ์ด |
| 3 | ๐ฅ | VOUCHER_SALES_0421 | 17 | 287,039 | - | (์ถ์ ) ๊ฑฐ๋์ฅ ๊ณ์ด |
| 4 | ๐ฅ | VOUCHER_SALES_0427 | 17 | 288,376 | - | (์ถ์ ) ๊ฑฐ๋์ฅ ๊ณ์ด |
| 5 | ๐ฅ | VOUCHER_SALES_0817 | 17 | 312,204 | - | (์ถ์ ) ๊ฑฐ๋์ฅ ๊ณ์ด |
| 6 | ๐ฆ | VOUCHER_SALES_100315 | 17 | 382,032 | - | ๐ฆ ๊ฑฐ๋์ฅ์ ๋ฐฑ์ |
| 7 | ๐ฆ | VOUCHER_SALES_20180410 | 17 | 1,819,594 | โ | ๐ฆ ๊ฑฐ๋์ฅ์ ๋ฐฑ์ |
์์ธ ๋ช ์ธ
VOUCHER_SALES
๊ฑฐ๋์ฅ
PK: SALES_CODE, APPROV_DATE, SALES_DATE, SALES_NO, SALES_SEQ, SALES_GUBUN, SLIP_GUBUN
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | VARCHAR2(6) | N | ๊ฑฐ๋์ฒ |
| 2 | SALES_DATE | VARCHAR2(8) | N | ์ฃผ๋ฌธ์ผ์ |
| 3 | SALES_GUBUN | VARCHAR2(1) | N | ๊ฑฐ๋๊ตฌ๋ถ(0:์ด๊ธฐํ, 1:๋งค์ถ, 2:์๊ธ, 3:๋ฏธ๊ฒฐ, 4:๊ธฐํ) |
| 4 | SALES_NO | NUMBER(4,0) | N | ์ฃผ๋ฌธ๋ฒํธ |
| 5 | SALES_SEQ | NUMBER(2,0) | N | ์ฃผ๋ฌธ์๋ฒ |
| 6 | SLIP_GUBUN | VARCHAR2(2) | N | ์ฃผ๋ฌธ์ ํ |
| 7 | APPROV_DATE | VARCHAR2(8) | N | ์ถ๊ณ ์ผ์/์น์ธ์ผ์ |
| 8 | BANK_PRINT_YN | VARCHAR2(1) | Y | ํต์ฅ๊ธฐ์ฅ๋์์ ๋ฌด |
| 9 | BANK_SEQ | NUMBER(2,0) | Y | ํต์ฅ/์ฑ ๋ฒํธ |
| 10 | BANK_PAGE | NUMBER(2,0) | Y | ํต์ฅ/ํ์ด์ง |
| 11 | BANK_LINE | NUMBER(2,0) | Y | ํต์ฅ/๋ผ์ธ |
| 12 | BANK_YN | VARCHAR2(1) | Y | ํต์ฅ/๊ธฐ์ฅ์ฌ๋ถ |
| 13 | BANK_DATE | VARCHAR2(8) | Y | ํต์ฅ/๊ธฐ์ฅ์ผ์ |
| 14 | BANK_TIME | VARCHAR2(4) | Y | ํต์ฅ/๊ธฐ์ฅ์ฒ๋ฆฌ์๊ฐ |
| 15 | BANK_MSG | VARCHAR2(80) | Y | ๋น๊ณ |
| 16 | LAST_YMD | DATE | Y | ๋ง์ง๋ง์ ๋ ฅ์ผ์ |
| 17 | LAST_EMP | VARCHAR2(6) | Y | ๋ง์ง๋ง์ ๋ ฅ์ |
์ธ๋ฑ์ค (2๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| IX_VOUCHER_SALES_1 | - | SALES_DATE, SALES_CODE |
| PK_VOUCHER_SALES | โ | SALES_CODE, APPROV_DATE, SALES_DATE, SALES_NO, SALES_SEQ, SALES_GUBUN, SLIP_GUBUN |
VOUCHER_SALES_0420
(์ถ์ ) ๊ฑฐ๋์ฅ ๊ณ์ด
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | VARCHAR2(6) | N | |
| 2 | SALES_DATE | VARCHAR2(8) | N | |
| 3 | SALES_GUBUN | VARCHAR2(1) | N | |
| 4 | SALES_NO | NUMBER(4,0) | N | |
| 5 | SALES_SEQ | NUMBER(2,0) | N | |
| 6 | SLIP_GUBUN | VARCHAR2(2) | N | |
| 7 | APPROV_DATE | VARCHAR2(8) | N | |
| 8 | BANK_PRINT_YN | VARCHAR2(1) | Y | |
| 9 | BANK_SEQ | NUMBER(2,0) | Y | |
| 10 | BANK_PAGE | NUMBER(2,0) | Y | |
| 11 | BANK_LINE | NUMBER(2,0) | Y | |
| 12 | BANK_YN | VARCHAR2(1) | Y | |
| 13 | BANK_DATE | VARCHAR2(8) | Y | |
| 14 | BANK_TIME | VARCHAR2(4) | Y | |
| 15 | BANK_MSG | VARCHAR2(80) | Y | |
| 16 | LAST_YMD | DATE | Y | |
| 17 | LAST_EMP | VARCHAR2(6) | Y |
VOUCHER_SALES_0421
(์ถ์ ) ๊ฑฐ๋์ฅ ๊ณ์ด
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | VARCHAR2(6) | N | |
| 2 | SALES_DATE | VARCHAR2(8) | N | |
| 3 | SALES_GUBUN | VARCHAR2(1) | N | |
| 4 | SALES_NO | NUMBER(4,0) | N | |
| 5 | SALES_SEQ | NUMBER(2,0) | N | |
| 6 | SLIP_GUBUN | VARCHAR2(2) | N | |
| 7 | APPROV_DATE | VARCHAR2(8) | N | |
| 8 | BANK_PRINT_YN | VARCHAR2(1) | Y | |
| 9 | BANK_SEQ | NUMBER(2,0) | Y | |
| 10 | BANK_PAGE | NUMBER(2,0) | Y | |
| 11 | BANK_LINE | NUMBER(2,0) | Y | |
| 12 | BANK_YN | VARCHAR2(1) | Y | |
| 13 | BANK_DATE | VARCHAR2(8) | Y | |
| 14 | BANK_TIME | VARCHAR2(4) | Y | |
| 15 | BANK_MSG | VARCHAR2(80) | Y | |
| 16 | LAST_YMD | DATE | Y | |
| 17 | LAST_EMP | VARCHAR2(6) | Y |
VOUCHER_SALES_0427
(์ถ์ ) ๊ฑฐ๋์ฅ ๊ณ์ด
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | VARCHAR2(6) | N | |
| 2 | SALES_DATE | VARCHAR2(8) | N | |
| 3 | SALES_GUBUN | VARCHAR2(1) | N | |
| 4 | SALES_NO | NUMBER(4,0) | N | |
| 5 | SALES_SEQ | NUMBER(2,0) | N | |
| 6 | SLIP_GUBUN | VARCHAR2(2) | N | |
| 7 | APPROV_DATE | VARCHAR2(8) | N | |
| 8 | BANK_PRINT_YN | VARCHAR2(1) | Y | |
| 9 | BANK_SEQ | NUMBER(2,0) | Y | |
| 10 | BANK_PAGE | NUMBER(2,0) | Y | |
| 11 | BANK_LINE | NUMBER(2,0) | Y | |
| 12 | BANK_YN | VARCHAR2(1) | Y | |
| 13 | BANK_DATE | VARCHAR2(8) | Y | |
| 14 | BANK_TIME | VARCHAR2(4) | Y | |
| 15 | BANK_MSG | VARCHAR2(80) | Y | |
| 16 | LAST_YMD | DATE | Y | |
| 17 | LAST_EMP | VARCHAR2(6) | Y |
VOUCHER_SALES_0817
(์ถ์ ) ๊ฑฐ๋์ฅ ๊ณ์ด
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | VARCHAR2(6) | N | |
| 2 | SALES_DATE | VARCHAR2(8) | N | |
| 3 | SALES_GUBUN | VARCHAR2(1) | N | |
| 4 | SALES_NO | NUMBER(4,0) | N | |
| 5 | SALES_SEQ | NUMBER(2,0) | N | |
| 6 | SLIP_GUBUN | VARCHAR2(2) | N | |
| 7 | APPROV_DATE | VARCHAR2(8) | N | |
| 8 | BANK_PRINT_YN | VARCHAR2(1) | Y | |
| 9 | BANK_SEQ | NUMBER(2,0) | Y | |
| 10 | BANK_PAGE | NUMBER(2,0) | Y | |
| 11 | BANK_LINE | NUMBER(2,0) | Y | |
| 12 | BANK_YN | VARCHAR2(1) | Y | |
| 13 | BANK_DATE | VARCHAR2(8) | Y | |
| 14 | BANK_TIME | VARCHAR2(4) | Y | |
| 15 | BANK_MSG | VARCHAR2(80) | Y | |
| 16 | LAST_YMD | DATE | Y | |
| 17 | LAST_EMP | VARCHAR2(6) | Y |
VOUCHER_SALES_100315
๐ฆ ๋ฐฑ์ ํ ์ด๋ธ โ
VOUCHER_SALES์ ์์ ๋ณต์ฌ๋ณธ. ๋ง์ด๊ทธ๋ ์ด์ ๋์์์ ์ ์ธ ๊ฒํ .
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | VARCHAR2(6) | N | |
| 2 | SALES_DATE | VARCHAR2(8) | N | |
| 3 | SALES_GUBUN | VARCHAR2(1) | N | |
| 4 | SALES_NO | NUMBER(4,0) | N | |
| 5 | SALES_SEQ | NUMBER(2,0) | N | |
| 6 | SLIP_GUBUN | VARCHAR2(2) | N | |
| 7 | APPROV_DATE | VARCHAR2(8) | N | |
| 8 | BANK_PRINT_YN | VARCHAR2(1) | Y | |
| 9 | BANK_SEQ | NUMBER(2,0) | Y | |
| 10 | BANK_PAGE | NUMBER(2,0) | Y | |
| 11 | BANK_LINE | NUMBER(2,0) | Y | |
| 12 | BANK_YN | VARCHAR2(1) | Y | |
| 13 | BANK_DATE | VARCHAR2(8) | Y | |
| 14 | BANK_TIME | VARCHAR2(4) | Y | |
| 15 | BANK_MSG | VARCHAR2(80) | Y | |
| 16 | LAST_YMD | DATE | Y | |
| 17 | LAST_EMP | VARCHAR2(6) | Y |
VOUCHER_SALES_20180410
๐ฆ ๋ฐฑ์ ํ ์ด๋ธ โ
VOUCHER_SALES์ ์์ ๋ณต์ฌ๋ณธ. ๋ง์ด๊ทธ๋ ์ด์ ๋์์์ ์ ์ธ ๊ฒํ .
PK: SALES_CODE, APPROV_DATE, SALES_DATE, SALES_NO, SALES_SEQ, SALES_GUBUN, SLIP_GUBUN
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | VARCHAR2(6) | N | |
| 2 | SALES_DATE | VARCHAR2(8) | N | |
| 3 | SALES_GUBUN | VARCHAR2(1) | N | |
| 4 | SALES_NO | NUMBER(4,0) | N | |
| 5 | SALES_SEQ | NUMBER(2,0) | N | |
| 6 | SLIP_GUBUN | VARCHAR2(2) | N | |
| 7 | APPROV_DATE | VARCHAR2(8) | N | |
| 8 | BANK_PRINT_YN | VARCHAR2(1) | Y | |
| 9 | BANK_SEQ | NUMBER(2,0) | Y | |
| 10 | BANK_PAGE | NUMBER(2,0) | Y | |
| 11 | BANK_LINE | NUMBER(2,0) | Y | |
| 12 | BANK_YN | VARCHAR2(1) | Y | |
| 13 | BANK_DATE | VARCHAR2(8) | Y | |
| 14 | BANK_TIME | VARCHAR2(4) | Y | |
| 15 | BANK_MSG | VARCHAR2(80) | Y | |
| 16 | LAST_YMD | DATE | Y | |
| 17 | LAST_EMP | VARCHAR2(6) | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_VOUCHER_SALES_20180410 | โ | SALES_CODE, APPROV_DATE, SALES_DATE, SALES_NO, SALES_SEQ, SALES_GUBUN, SLIP_GUBUN |
๊ด๋ จ ๋ฌธ์
๊ฒ์ ํค์๋: UNION_ERP, Oracle, undefined, ์ ํ/์ฆ๋น, ํ ์ด๋ธ ์นดํ๋ก๊ทธ, schema reference