Skip to Content

์—ญํ• : ์‹ค๋ฌด (ํ…Œ์ด๋ธ” ์ƒ์„ธ)
๋Œ€์ƒ ๋…์ž: SP ์ด์‹ ๋‹ด๋‹น ยท ์ปฌ๋Ÿผ ์กฐํšŒ
์„ ํ–‰ ์กฐ๊ฑด: ์„์ง€ ํŒŒ์ดํ”„๋ผ์ธ ๊ถŒ์žฅ

๐Ÿ—บ ๊ด€๊ณ„๋„์—์„œ ์ด ํ…Œ์ด๋ธ” ์ฐพ๊ธฐ

GD_ITEM_ISSUE_HISTORY ์„์ง€ ์ฐธ์กฐ

ํ’ˆ๋ชฉ ์ถœ๊ณ  ์ด๋ ฅ โ€” ์ถœ๊ณ  ๊ฑด๋ณ„ ๋ฐ”์ฝ”๋“œ ์ƒ์„ธ (์šฉ์–ด์ง‘(Glossary))

  • ์Šคํ‚ค๋งˆ: dbo
  • ํ–‰ ์ˆ˜(์ถ”์ •): 26,721,657
  • ์ปฌ๋Ÿผ ์ˆ˜: 18
  • PK: ITEM_ISSUE_HISTORY_ID
  • FK FK_GD_ITEM_ISSUE_HISTORY_GD_ITEM_ISSUE: ITEM_ISSUE_ID โ†’ GD_ITEM_ISSUE

์„์ง€ ๋ณด๊ณ  SP ์—์„œ ์ฐธ์กฐํ•˜๋Š” ์ปฌ๋Ÿผ

  • โœ” ํ‘œ์‹œ๋œ ์ปฌ๋Ÿผ์€ dbo.SP_SUPPLY_REPORT ์—์„œ ์‹ค์ œ ์กฐํšŒยท๊ฐฑ์‹  ๋Œ€์ƒ (์ถœ์ฒ˜: sys.dm_sql_referenced_entities)
  • ์„ค๋ช… ๊ผฌ๋ฆฌํ‘œ: (์‹ค์ธก) ์ €์žฅ ํ”„๋กœ์‹œ์ € ์ฃผ์„, (์šฉ์–ด์ง‘) ์ˆ˜๋™ ์‚ฌ์ „, (์ถ”์ •) ์ด๋ฆ„ ํŒจํ„ด ์ž๋™

์ปฌ๋Ÿผ ์ „์ฒด

#์ปฌ๋Ÿผ๋ช…ํƒ€์ž…NullPK์„ค๋ช…
1ITEM_ISSUE_HISTORY_IDintNโœ…identity ํ’ˆ๋ชฉ ์ถœ๊ณ  ์ด๋ ฅ ID (์šฉ์–ด์ง‘(Glossary))
2โœ” ITEM_ISSUE_IDintY์ œํ’ˆ์ž…๊ณ ์ผ๋ จ๋ฒˆํ˜ธ (์‹ค์ธก(Observed))
3DETAIL_STOCK_IDintY๋ผ๋ฒจ๋ฐœํ–‰๋ฒˆํ˜ธ (์‹ค์ธก(Observed))
4PACKING_ORDER_NOnvarchar(50)Yํฌ์žฅ์ œํ’ˆ์ฝ”๋“œ (์‹ค์ธก(Observed))
5โœ” BARCODEnvarchar(100)Y๊ฐœ๋ณ„ ๋ฐ”์ฝ”๋“œ (์‹ค์ธก(Observed))
6ISSUE_DATEnvarchar(10)Y์ถœ๊ณ ์ผ์ž (์‹ค์ธก(Observed))
7ISSUE_QTYdecimal(15,4)Y์ถœ๊ณ ์ˆ˜๋Ÿ‰ (์‹ค์ธก(Observed))
8ISSUE_STATUSnvarchar(20)Y์ถœ๊ณ ์ง€์‹œ์ƒํƒœ (์‹ค์ธก(Observed))
9LOT_NOnvarchar(30)Y์ œ์กฐ๋ฒˆํ˜ธ (์‹ค์ธก(Observed))
10END_DATEnvarchar(10)Y์œ ํ†ต๊ธฐํ•œ โ€”์‚ฌ์šฉ (์‹ค์ธก(Observed))
11MEDIUM_BARCODEnvarchar(100)Y์ค‘๋ฐ•์Šค ๋ฐ”์ฝ”๋“œ (์‹ค์ธก(Observed))
12LARGE_BARCODEnvarchar(100)Y๋ฐ๋ฐ•์Šค ๋ฐ”์ฝ”๋“œ (์‹ค์ธก(Observed))
13INSERT_USER_CDnvarchar(50)Y์ž…๋ ฅ์‚ฌ์› (์‹ค์ธก(Observed))
14INSERT_TIMEdatetimeYinsert ์‹œ๊ฐ (์šฉ์–ด์ง‘(Glossary))
15UPDATE_USER_CDnvarchar(50)Y์ˆ˜์ •์‚ฌ์› (์‹ค์ธก(Observed))
16UPDATE_TIMEdatetimeY์ผ์ž (์šฉ์–ด์ง‘(Glossary))
17OUTER_INTERFACEnvarchar(50)Y์™ธ๋ถ€ ์‹œ์Šคํ…œ ์ธํ„ฐํŽ˜์ด์Šค ์—ฌ๋ถ€ (์šฉ์–ด์ง‘(Glossary))
18AUDITTRAIL_IDintNcomputed audittrail_id ํŠน์ • ์กฐํšŒ๊ฐ’ (ํŠน์ • ํ•ญ๋ชฉ๋งŒ ์กฐํšŒ ์‹œ) (์‹ค์ธก(Observed))

์ธ๋ฑ์Šค (4๊ฐœ)

์ธ๋ฑ์Šค๋ช…์œ ๋‹ˆํฌPK์ปฌ๋Ÿผํฌํ•จ
ix_DETAIL_STOCK_ID--DETAIL_STOCK_ID-
ix_ITEM_ISSUE_ID--ITEM_ISSUE_ID-
ix_PACKING_ORDER_NO--PACKING_ORDER_NO-
PK_GD_ITEM_ISSUE_HISTORYโœ…โœ…ITEM_ISSUE_HISTORY_ID DESC-

๊ด€๋ จ ๋ฌธ์„œ

๊ฒ€์ƒ‰ ํ‚ค์›Œ๋“œ: ์„์ง€ ์ฐธ์กฐ, eulji reference, ํ…Œ์ด๋ธ” ์ƒ์„ธ, table detail, ์ปฌ๋Ÿผ ๋ช…์„ธ

Last updated on