ํ๊ณ/์์ฐ๊ด๋ฆฌ
์ญํ : ์ฐธ์กฐ (์นดํ ๊ณ ๋ฆฌ๋ณ ์นดํ๋ก๊ทธ)
๋์ ๋ ์: DBA ยท ์ด์ ๋ด๋น ยท ์ ๋ฌด ๋ถ์
ํ๊ณ ์์ฐ, ๊ฐ๊ฐ์๊ฐ
์ด ์นดํ ๊ณ ๋ฆฌ๋ ๋ฌด์์ ๋ด๋นํ๋
๊ฐ์ โ ํ๊ณ ์์ฐ, ๊ฐ๊ฐ์๊ฐ
๊ตฌ์ฑ โ ์ด์ ํ ์ด๋ธ 13๊ฐ
์ฃผ์ ํ ์ด๋ธ (ํ ์ ๊ธฐ์ค Top 3)
ACCAS016Tโ 1ํ ยท (์ถ์ ) ์ด๋ ฅ/์ผ์ยท์๋ ๊ด๋ จACCAS0111Tโ 0ํ ยท (์ถ์ ) ์ด๋ ฅ/์ผ์ยท๋น๊ณ ๊ด๋ จACCAS011Tโ 0ํ ยท (์ถ์ ) ์ด๋ ฅ/์ผ์ ๊ด๋ จ
์ฃผ์ PK ํจํด โ ASSETCD (9) ยท LARGCD (4) ยท MIDDCD (4) ยท SMALLCD (4) ยท SEQ (4)
์์ฝ
| ํญ๋ชฉ | ๊ฐ |
|---|---|
| ํ ์ด๋ธ ์ | 13 |
| ์ด ์ปฌ๋ผ ์ | 270 |
| PK ์์ | 13 |
| FK ๊ด๊ณ | 0 |
๊ด๊ณ๋
PK ์ปฌ๋ผ๋ช ๋งค์นญ ๊ธฐ๋ฐ ์ถ์ ๊ด๊ณ ยท ์ด 12๊ฐ ยท ์ค/ํฌ/๋ ธ๋ ๋๋๊ทธ/ํด๋ฆญ ํ์ด๋ผ์ดํธ
๊ด๊ณ๋ ๋ก๋ฉ ์ค...
ํ ์ด๋ธ ๋ชฉ๋ก
| # | ์ํ | ํ ์ด๋ธ๋ช | ์ปฌ๋ผ ์ | ํ ์ | PK | ์ค๋ช |
|---|---|---|---|---|---|---|
| 1 | โ ๏ธ | ACCAS0111T | 15 | 0 | โ | (์ถ์ ) ์ด๋ ฅ/์ผ์ยท๋น๊ณ ๊ด๋ จ |
| 2 | โ ๏ธ | ACCAS011T | 18 | 0 | โ | (์ถ์ ) ์ด๋ ฅ/์ผ์ ๊ด๋ จ |
| 3 | โ ๏ธ | ACCAS012T | 14 | 0 | โ | (์ถ์ ) ์ด๋ ฅ/์ผ์ยท๊ธ์ก ๊ด๋ จ |
| 4 | โ ๏ธ | ACCAS013T | 18 | 0 | โ | (์ถ์ ) ์ด๋ ฅ/์ผ์ยท๋น๊ณ ๊ด๋ จ |
| 5 | โ ๏ธ | ACCAS0141T | 7 | 0 | โ | (์ถ์ ) ์ด๋ ฅ/์ผ์ยท๊ธ์ก ๊ด๋ จ |
| 6 | โ ๏ธ | ACCAS014T | 12 | 0 | โ | (์ถ์ ) ์ด๋ ฅ/์ผ์ยท๋น๊ณ ๊ด๋ จ |
| 7 | โ ๏ธ | ACCAS015T | 8 | 0 | โ | (์ถ์ ) ์ด๋ ฅ/์ผ์ ๊ด๋ จ |
| 8 | ACCAS016T | 11 | 1 | โ | (์ถ์ ) ์ด๋ ฅ/์ผ์ยท์๋ ๊ด๋ จ | |
| 9 | โ ๏ธ | ACCAS01T | 66 | 0 | โ | (์ถ์ ) ์ด๋ ฅ/์ผ์ยท๊ธ์กยท์๋ ๊ด๋ จ |
| 10 | โ ๏ธ | ACCAS02T | 29 | 0 | โ | (์ถ์ ) ์ด๋ ฅ/์ผ์ยท๊ธ์ก ๊ด๋ จ |
| 11 | โ ๏ธ | ACCAS03T | 36 | 0 | โ | (์ถ์ ) ์ด๋ ฅ/์ผ์ยท๊ธ์กยท์๋ ๊ด๋ จ |
| 12 | โ ๏ธ | ACCAS04T | 16 | 0 | โ | (์ถ์ ) ์ด๋ ฅ/์ผ์ยท๊ธ์กยท์๋ ๊ด๋ จ |
| 13 | โ ๏ธ | ACCAS05T | 20 | 0 | โ | (์ถ์ ) ์ด๋ ฅ/์ผ์ยท๊ธ์ก ๊ด๋ จ |
์์ธ ๋ช ์ธ
ACCAS0111T
(์ถ์ ) ์ด๋ ฅ/์ผ์ยท๋น๊ณ ๊ด๋ จ
PK: ASSETCD, CLASSID, CLASSNO
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ASSETCD | VARCHAR2(10) | N | |
| 2 | CLASSID | VARCHAR2(1) | N | |
| 3 | CLASSNO | NUMBER(3,0) | N | |
| 4 | CLSNM1 | VARCHAR2(8) | Y | |
| 5 | CLSNM2 | VARCHAR2(8) | Y | |
| 6 | STRUCTURE | VARCHAR2(30) | Y | |
| 7 | USAGE | VARCHAR2(30) | Y | |
| 8 | SQUAREM | NUMBER(9,3) | Y | |
| 9 | TOTALSQR | NUMBER(9,3) | Y | |
| 10 | FLATSQR | NUMBER(9,3) | Y | |
| 11 | REMARK | VARCHAR2(100) | Y | |
| 12 | FIRSTEMP | VARCHAR2(6) | Y | |
| 13 | FIRSTYMD | DATE | Y | |
| 14 | LASTEMP | VARCHAR2(6) | Y | |
| 15 | LASTYMD | DATE | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ACCAS0111T | โ | ASSETCD, CLASSID, CLASSNO |
ACCAS011T
(์ถ์ ) ์ด๋ ฅ/์ผ์ ๊ด๋ จ
PK: ASSETCD
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ASSETCD | VARCHAR2(10) | N | |
| 2 | PLOTTAGE | NUMBER(9,3) | Y | |
| 3 | PYOUNG | NUMBER(9,3) | Y | |
| 4 | CUTENDSQR | NUMBER(6,3) | Y | |
| 5 | FLOORSQR | NUMBER(9,3) | Y | |
| 6 | COVERRATE | NUMBER(6,3) | Y | |
| 7 | FLNUMBER | NUMBER(3,0) | Y | |
| 8 | BASEMENT | NUMBER(3,0) | Y | |
| 9 | PARKINGLIMIT | NUMBER(3,0) | Y | |
| 10 | AREA1 | NUMBER(1,0) | Y | |
| 11 | AREA2 | NUMBER(1,0) | Y | |
| 12 | PERMITYMD | DATE | Y | |
| 13 | BUILDYMD | DATE | Y | |
| 14 | REGISTERYMD | DATE | Y | |
| 15 | FIRSTEMP | VARCHAR2(6) | Y | |
| 16 | FIRSTYMD | DATE | Y | |
| 17 | LASTEMP | VARCHAR2(6) | Y | |
| 18 | LASTYMD | DATE | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ACCAS011T | โ | ASSETCD |
ACCAS012T
(์ถ์ ) ์ด๋ ฅ/์ผ์ยท๊ธ์ก ๊ด๋ จ
PK: ASSETCD
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ASSETCD | VARCHAR2(10) | N | |
| 2 | STRUCTNAME | VARCHAR2(1) | Y | |
| 3 | BUILDYMD | DATE | Y | |
| 4 | BUILDAMT | NUMBER(13,0) | Y | |
| 5 | LANDSQR | NUMBER(8,2) | Y | |
| 6 | HEIGHT | NUMBER(4,0) | Y | |
| 7 | DEPTH | NUMBER(4,0) | Y | |
| 8 | DOOKE | NUMBER(4,0) | Y | |
| 9 | TOTSQR | NUMBER(8,2) | Y | |
| 10 | PERMITYMD | DATE | Y | |
| 11 | FIRSTEMP | VARCHAR2(6) | Y | |
| 12 | FIRSTYMD | DATE | Y | |
| 13 | LASTEMP | VARCHAR2(6) | Y | |
| 14 | LASTYMD | DATE | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ACCAS012T | โ | ASSETCD |
ACCAS013T
(์ถ์ ) ์ด๋ ฅ/์ผ์ยท๋น๊ณ ๊ด๋ จ
PK: ASSETCD
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ASSETCD | VARCHAR2(10) | N | |
| 2 | VEHICLE | VARCHAR2(1) | Y | |
| 3 | LICENSENO | VARCHAR2(12) | Y | |
| 4 | CARTYPE | VARCHAR2(1) | Y | |
| 5 | USAGE | VARCHAR2(1) | Y | |
| 6 | VEHNAME | VARCHAR2(30) | Y | |
| 7 | CARNO | VARCHAR2(20) | Y | |
| 8 | USEAREA | VARCHAR2(60) | Y | |
| 9 | HORSEPOWER | NUMBER(5,0) | Y | |
| 10 | CYLINDER | NUMBER(3,0) | Y | |
| 11 | FUELKIND | VARCHAR2(20) | Y | |
| 12 | INSPECTFROM | DATE | Y | |
| 13 | INSPECTTO | DATE | Y | |
| 14 | REMARK | VARCHAR2(100) | Y | |
| 15 | FIRSTEMP | VARCHAR2(6) | Y | |
| 16 | FIRSTYMD | DATE | Y | |
| 17 | LASTEMP | VARCHAR2(6) | Y | |
| 18 | LASTYMD | DATE | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ACCAS013T | โ | ASSETCD |
ACCAS0141T
(์ถ์ ) ์ด๋ ฅ/์ผ์ยท๊ธ์ก ๊ด๋ จ
PK: ASSETCD, GONGSIYY
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ASSETCD | VARCHAR2(10) | N | |
| 2 | GONGSIYY | VARCHAR2(4) | N | |
| 3 | GONGSIAMT | NUMBER(13,0) | Y | |
| 4 | FIRSTEMP | VARCHAR2(6) | Y | |
| 5 | FIRSTYMD | DATE | Y | |
| 6 | LASTEMP | VARCHAR2(6) | Y | |
| 7 | LASTYMD | DATE | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ACCAS0141T | โ | ASSETCD, GONGSIYY |
ACCAS014T
(์ถ์ ) ์ด๋ ฅ/์ผ์ยท๋น๊ณ ๊ด๋ จ
PK: ASSETCD
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ASSETCD | VARCHAR2(10) | N | |
| 2 | CLASSFICATION | VARCHAR2(20) | Y | |
| 3 | SQUARE | NUMBER(9,2) | Y | |
| 4 | PYOUNG | NUMBER(8,2) | Y | |
| 5 | WHYREGRMD | DATE | Y | |
| 6 | CONTRATYMD | DATE | Y | |
| 7 | GUBUN | VARCHAR2(1) | Y | |
| 8 | REMARK | VARCHAR2(100) | Y | |
| 9 | FIRSTEMP | VARCHAR2(6) | Y | |
| 10 | FIRSTYMD | DATE | Y | |
| 11 | LASTEMP | VARCHAR2(6) | Y | |
| 12 | LASTYMD | DATE | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ACCAS014T | โ | ASSETCD |
ACCAS015T
(์ถ์ ) ์ด๋ ฅ/์ผ์ ๊ด๋ จ
PK: ASSETCD
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ASSETCD | VARCHAR2(10) | N | |
| 2 | SQUAREAREA | NUMBER(9,3) | Y | |
| 3 | CREATEYMD | DATE | Y | |
| 4 | PERMITYMD | DATE | Y | |
| 5 | FIRSTEMP | VARCHAR2(6) | Y | |
| 6 | FIRSTYMD | DATE | Y | |
| 7 | LASTEMP | VARCHAR2(6) | Y | |
| 8 | LASTYMD | DATE | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ACCAS015T | โ | ASSETCD |
ACCAS016T
(์ถ์ ) ์ด๋ ฅ/์ผ์ยท์๋ ๊ด๋ จ
PK: ASSETCD
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ASSETCD | VARCHAR2(10) | N | |
| 2 | STRUCTCD | VARCHAR2(3) | Y | |
| 3 | ASSQTY | NUMBER(2,0) | Y | |
| 4 | ASSUNIT | VARCHAR2(4) | Y | |
| 5 | ASSSTND | VARCHAR2(20) | Y | |
| 6 | ASSFUNC | VARCHAR2(20) | Y | |
| 7 | STRUCTYMD | DATE | Y | |
| 8 | FIRSTEMP | VARCHAR2(6) | Y | |
| 9 | FIRSTYMD | DATE | Y | |
| 10 | LASTEMP | VARCHAR2(6) | Y | |
| 11 | LASTYMD | DATE | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ACCAS016T | โ | ASSETCD |
ACCAS01T
(์ถ์ ) ์ด๋ ฅ/์ผ์ยท๊ธ์กยท์๋ ๊ด๋ จ
PK: LARGCD, MIDDCD, SMALLCD, SEQ
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | LARGCD | VARCHAR2(1) | N | |
| 2 | MIDDCD | VARCHAR2(2) | N | |
| 3 | SMALLCD | VARCHAR2(3) | N | |
| 4 | SEQ | NUMBER(4,0) | N | |
| 5 | ACCSAUP | VARCHAR2(1) | Y | |
| 6 | DEPTCD | VARCHAR2(6) | Y | |
| 7 | SABUN | VARCHAR2(6) | Y | |
| 8 | SABUN1 | VARCHAR2(6) | Y | |
| 9 | COSTCNTR | VARCHAR2(6) | Y | |
| 10 | SEOLBI | VARCHAR2(10) | Y | |
| 11 | ACCCD | VARCHAR2(7) | Y | |
| 12 | EXKIND | VARCHAR2(3) | Y | |
| 13 | EXRATE | NUMBER(7,3) | Y | |
| 14 | FORGAMT | NUMBER(13,0) | Y | |
| 15 | DESC1 | VARCHAR2(20) | Y | |
| 16 | STANDARD | VARCHAR2(20) | Y | |
| 17 | UNIT | VARCHAR2(10) | Y | |
| 18 | QUANTITY | NUMBER(3,0) | Y | |
| 19 | PRODNO | VARCHAR2(15) | Y | |
| 20 | PRODCD | VARCHAR2(30) | Y | |
| 21 | VENDOR | VARCHAR2(10) | Y | |
| 22 | SETLOC | VARCHAR2(80) | Y | |
| 23 | STRUCT | VARCHAR2(80) | Y | |
| 24 | USAGE | VARCHAR2(40) | Y | |
| 25 | ADDR | VARCHAR2(60) | Y | |
| 26 | REVALYMD | DATE | Y | |
| 27 | REVALAMT | NUMBER(13,0) | Y | |
| 28 | REVALYR | NUMBER(2,0) | Y | |
| 29 | REVALGB | VARCHAR2(1) | Y | |
| 30 | REVGBN1 | VARCHAR2(1) | Y | |
| 31 | REVGBN2 | VARCHAR2(1) | Y | |
| 32 | FIXRATE | NUMBER(5,3) | Y | |
| 33 | TFIXRATE | NUMBER(5,3) | Y | |
| 34 | YEAR1 | VARCHAR2(2) | Y | |
| 35 | YEAR2 | VARCHAR2(2) | Y | |
| 36 | REPAYGB | VARCHAR2(1) | Y | |
| 37 | NATACQYMD | DATE | Y | |
| 38 | ACQAMT | NUMBER(13,0) | Y | |
| 39 | NATACQAMT | NUMBER(13,0) | Y | |
| 40 | NATACQUSEYR | NUMBER(2,0) | Y | |
| 41 | DISPGB | VARCHAR2(3) | Y | |
| 42 | DISPLOC | VARCHAR2(13) | Y | |
| 43 | DISPYMD | DATE | Y | |
| 44 | DISPAMT | NUMBER(13,0) | Y | |
| 45 | DISPTERMREM | NUMBER(13,0) | Y | |
| 46 | DISPREPSUM | NUMBER(13,0) | Y | |
| 47 | PREDISPREPSUM | NUMBER(13,0) | Y | |
| 48 | GICHOAMT | NUMBER(13,0) | Y | |
| 49 | INCRAMT | NUMBER(13,0) | Y | |
| 50 | REDUAMT | NUMBER(13,0) | Y | |
| 51 | TERMLASTREMAIN | NUMBER(13,0) | Y | |
| 52 | REPAYFSUM | NUMBER(13,0) | Y | |
| 53 | DANGJEUM | NUMBER(13,0) | Y | |
| 54 | DANGGAM | NUMBER(13,0) | Y | |
| 55 | REPAYLSUM | NUMBER(13,0) | Y | |
| 56 | MONTHREPAYAMT | NUMBER(13,0) | Y | |
| 57 | FIRSUM | NUMBER(13,0) | Y | |
| 58 | REMANT | NUMBER(13,0) | Y | |
| 59 | REPAYYM | VARCHAR2(6) | Y | |
| 60 | SANGYN | VARCHAR2(1) | Y | |
| 61 | FIRSTEMP | VARCHAR2(6) | Y | |
| 62 | FIRSTYMD | DATE | Y | |
| 63 | LASTEMP | VARCHAR2(6) | Y | |
| 64 | LASTYMD | DATE | Y | |
| 65 | CURUSER | VARCHAR2(6) | Y | |
| 66 | USEYN | VARCHAR2(1) | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ACCAS01T | โ | LARGCD, MIDDCD, SMALLCD, SEQ |
ACCAS02T
(์ถ์ ) ์ด๋ ฅ/์ผ์ยท๊ธ์ก ๊ด๋ จ
PK: LARGCD, MIDDCD, SMALLCD, SEQ, CHNGYM, REPAYCD
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | LARGCD | VARCHAR2(1) | N | |
| 2 | MIDDCD | VARCHAR2(2) | N | |
| 3 | SMALLCD | VARCHAR2(3) | N | |
| 4 | SEQ | NUMBER(4,0) | N | |
| 5 | CHNGYM | VARCHAR2(6) | N | |
| 6 | REPAYCD | VARCHAR2(1) | N | |
| 7 | REPSTYMD | VARCHAR2(8) | Y | |
| 8 | REPENDYMD | VARCHAR2(8) | Y | |
| 9 | USEYR | VARCHAR2(2) | Y | |
| 10 | REPRATE | NUMBER(5,3) | Y | |
| 11 | TREPRATE | NUMBER(5,3) | Y | |
| 12 | ACQAMT | NUMBER(13,0) | Y | |
| 13 | GICHOAMT | NUMBER(13,0) | Y | |
| 14 | INCRAMT | NUMBER(13,0) | Y | |
| 15 | REDUAMT | NUMBER(13,0) | Y | |
| 16 | TERMLASTREMAIN | NUMBER(13,0) | Y | |
| 17 | REPAYFSUM | NUMBER(13,0) | Y | |
| 18 | DANGJEUN | NUMBER(13,0) | Y | |
| 19 | DANGGAM | NUMBER(13,0) | Y | |
| 20 | REPAYLSUM | NUMBER(13,0) | Y | |
| 21 | WOLSANGAK | NUMBER(13,0) | Y | |
| 22 | YEARSANGAK | NUMBER(13,0) | Y | |
| 23 | GICHOJAN | NUMBER(13,0) | Y | |
| 24 | JANJONGA | NUMBER(13,0) | Y | |
| 25 | FIRSTEMP | VARCHAR2(6) | Y | |
| 26 | FIRSTYMD | DATE | Y | |
| 27 | LASTEMP | VARCHAR2(6) | Y | |
| 28 | LASTYMD | DATE | Y | |
| 29 | DEPTCD | VARCHAR2(6) | Y |
์ธ๋ฑ์ค (2๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| ACCAS02T_IDX | - | LARGCD, MIDDCD, SMALLCD, SEQ |
| PK_ACCAS02T | โ | LARGCD, MIDDCD, SMALLCD, SEQ, CHNGYM, REPAYCD |
ACCAS03T
(์ถ์ ) ์ด๋ ฅ/์ผ์ยท๊ธ์กยท์๋ ๊ด๋ จ
PK: LARGCD, MIDDCD, SMALLCD, SEQ, CHNGYM, SEQ1
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | LARGCD | VARCHAR2(1) | N | |
| 2 | MIDDCD | VARCHAR2(2) | N | |
| 3 | SMALLCD | VARCHAR2(3) | N | |
| 4 | SEQ | NUMBER(4,0) | N | |
| 5 | CHNGYM | VARCHAR2(6) | N | |
| 6 | SEQ1 | NUMBER(4,0) | N | |
| 7 | CHNGDT | DATE | Y | |
| 8 | ACCSAUP | VARCHAR2(1) | Y | |
| 9 | CHNGCD | VARCHAR2(2) | Y | |
| 10 | CHNGAMT | NUMBER(13,0) | Y | |
| 11 | CHNGQTY | NUMBER(13,0) | Y | |
| 12 | CHNGLOC | VARCHAR2(20) | Y | |
| 13 | GICHOAMT | NUMBER(13,0) | Y | |
| 14 | INCRAMT | NUMBER(13,0) | Y | |
| 15 | REDUAMT | NUMBER(13,0) | Y | |
| 16 | TERMLASTREMAIN | NUMBER(13,0) | Y | |
| 17 | BEFDEPT | VARCHAR2(6) | Y | |
| 18 | BEFCC | VARCHAR2(6) | Y | |
| 19 | BEFLOC | VARCHAR2(80) | Y | |
| 20 | BEFUSEYR | NUMBER(2,0) | Y | |
| 21 | BEFUSER | VARCHAR2(6) | Y | |
| 22 | AFTUSER | VARCHAR2(6) | Y | |
| 23 | AFTDEPT | VARCHAR2(6) | Y | |
| 24 | AFTCC | VARCHAR2(6) | Y | |
| 25 | AFTLOC | VARCHAR2(80) | Y | |
| 26 | AFTUSEYR | NUMBER(2,0) | Y | |
| 27 | CHNGNM | VARCHAR2(60) | Y | |
| 28 | SELLAMT | NUMBER(13,0) | Y | |
| 29 | PROFITLOSS | NUMBER(13,0) | Y | |
| 30 | FIRSTEMP | VARCHAR2(6) | Y | |
| 31 | FIRSTYMD | DATE | Y | |
| 32 | LASTEMP | VARCHAR2(6) | Y | |
| 33 | LASTYMD | DATE | Y | |
| 34 | REPAYFSUM | NUMBER(13,0) | Y | |
| 35 | REPAYLSUM | NUMBER(13,0) | Y | |
| 36 | NATACQAMT | NUMBER(13,0) | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ACCAS03T | โ | LARGCD, MIDDCD, SMALLCD, SEQ, CHNGYM, SEQ1 |
ACCAS04T
(์ถ์ ) ์ด๋ ฅ/์ผ์ยท๊ธ์กยท์๋ ๊ด๋ จ
PK: ASSETCD, ATTSEQ
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ASSETCD | VARCHAR2(10) | N | |
| 2 | ATTSEQ | NUMBER(2,0) | N | |
| 3 | ATTCD | VARCHAR2(3) | N | |
| 4 | ATTYN | VARCHAR2(1) | Y | |
| 5 | ATTNM | VARCHAR2(20) | Y | |
| 6 | QUANTITY | NUMBER(6,0) | Y | |
| 7 | AMT | NUMBER(13,0) | Y | |
| 8 | OBTYMD | DATE | Y | |
| 9 | ATTYMD | DATE | Y | |
| 10 | MOVYMD | DATE | Y | |
| 11 | MOVASSET | VARCHAR2(10) | Y | |
| 12 | REMARK | VARCHAR2(80) | Y | |
| 13 | FIRSTEMP | VARCHAR2(6) | Y | |
| 14 | FIRSTYMD | DATE | Y | |
| 15 | LASTEMP | VARCHAR2(6) | Y | |
| 16 | LASTYMD | DATE | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ACCAS04T | โ | ASSETCD, ATTSEQ |
ACCAS05T
(์ถ์ ) ์ด๋ ฅ/์ผ์ยท๊ธ์ก ๊ด๋ จ
PK: LARGCD, MIDDCD, SMALLCD, SEQ, DEPTYY
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | LARGCD | VARCHAR2(1) | N | |
| 2 | MIDDCD | VARCHAR2(2) | N | |
| 3 | SMALLCD | VARCHAR2(3) | N | |
| 4 | SEQ | VARCHAR2(4) | N | |
| 5 | DEPTYY | VARCHAR2(4) | N | |
| 6 | ACCSAUP | VARCHAR2(1) | N | |
| 7 | JICHULAMT | NUMBER(13,0) | Y | |
| 8 | JSNUGYE | NUMBER(13,0) | Y | |
| 9 | DESANG | NUMBER(13,0) | Y | |
| 10 | DESANGGYE | NUMBER(13,0) | Y | |
| 11 | JBUINGYE | NUMBER(13,0) | Y | |
| 12 | DANGGIBUINAMT | NUMBER(13,0) | Y | |
| 13 | DANGGIBUINGYE | NUMBER(13,0) | Y | |
| 14 | ILBANAMT | NUMBER(13,0) | Y | |
| 15 | DANGGIAMT | NUMBER(13,0) | Y | |
| 16 | SONGEUM | NUMBER(13,0) | Y | |
| 17 | FIRSTEMP | VARCHAR2(6) | Y | |
| 18 | FIRSTYMD | DATE | Y | |
| 19 | LASTEMP | VARCHAR2(6) | Y | |
| 20 | LASTYMD | DATE | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ACCAS05T | โ | LARGCD, MIDDCD, SMALLCD, SEQ, DEPTYY |
๊ด๋ จ ๋ฌธ์
๊ฒ์ ํค์๋: UNION_ERP, Oracle, undefined, ํ๊ณ/์์ฐ๊ด๋ฆฌ, ํ ์ด๋ธ ์นดํ๋ก๊ทธ, schema reference
Last updated on