Skip to Content

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

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

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

ํฌ์žฅ ๊ฒฐ๊ณผ โ€” ๋ฐ•์Šค(์™ธ๊ณฝ ๋ฌถ์Œ) ๋‹จ์œ„ GS1 ๋ฐ”์ฝ”๋“œ (์šฉ์–ด์ง‘(Glossary))

  • ์Šคํ‚ค๋งˆ: dbo
  • ํ–‰ ์ˆ˜(์ถ”์ •): 2,028,782
  • ์ปฌ๋Ÿผ ์ˆ˜: 14
  • PK: GS1_BOX_BARCODE_NO
  • FK FK_GD_PACKING_RESULT_PACK_GD_ITEM_STOCK: ITEM_STOCK_ID โ†’ GD_ITEM_STOCK

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

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

์ปฌ๋Ÿผ ์ „์ฒด

#์ปฌ๋Ÿผ๋ช…ํƒ€์ž…NullPK์„ค๋ช…
1BOX_BARCODE_NOnvarchar(50)N์ง€ํ•จ๋ฐ”์ฝ”๋“œ (์‹ค์ธก(Observed))
2ITEM_STOCK_IDintN์ œํ’ˆ์žฌ๊ณ ์ผ๋ จ๋ฒˆํ˜ธ (์‹ค์ธก(Observed))
3โœ” GS1_BOX_BARCODE_NOnvarchar(100)Nโœ…GS1 ๋ฐ•์Šค ๋ฐ”์ฝ”๋“œ ๋ฒˆํ˜ธ (์šฉ์–ด์ง‘(Glossary))
4BOX_TYPEnvarchar(100)Y๋ฐ•์Šคํƒ€์ž… (์‹ค์ธก(Observed))
5โœ” MAPPING_GS1_BARCODEnvarchar(100)Y๋งคํ•‘๋œ GS1 ๋ฐ”์ฝ”๋“œ (์šฉ์–ด์ง‘(Glossary))
6MAPPING_BOX_TYPEnvarchar(100)Ymapping box ์œ ํ˜• (์šฉ์–ด์ง‘(Glossary))
7PROD_QTYdecimal(15,4)Yprod ์ˆ˜๋Ÿ‰ (์šฉ์–ด์ง‘(Glossary))
8STOCK_QTYdecimal(15,4)Y์žฌ๊ณ ์ˆ˜๋Ÿ‰ (์‹ค์ธก(Observed))
9CHECK_YNnvarchar(1)Yํ™•์ธ ์—ฌ๋ถ€ (์šฉ์–ด์ง‘(Glossary))
10INSERT_USER_CDnvarchar(50)Y์ž…๋ ฅ์‚ฌ์› (์‹ค์ธก(Observed))
11INSERT_TIMEdatetimeYinsert ์‹œ๊ฐ (์šฉ์–ด์ง‘(Glossary))
12UPDATE_USER_CDnvarchar(50)Y์ˆ˜์ •์‚ฌ์› (์‹ค์ธก(Observed))
13UPDATE_TIMEdatetimeY์ผ์ž (์šฉ์–ด์ง‘(Glossary))
14AUDITTRAIL_IDintNidentity audittrail_id ํŠน์ • ์กฐํšŒ๊ฐ’ (ํŠน์ • ํ•ญ๋ชฉ๋งŒ ์กฐํšŒ ์‹œ) (์‹ค์ธก(Observed))

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

์ธ๋ฑ์Šค๋ช…์œ ๋‹ˆํฌPK์ปฌ๋Ÿผํฌํ•จ
ix_BOX_TYPE--BOX_TYPE-
IX_MAPPING_GS1_BARCODE--MAPPING_GS1_BARCODE-
PK_GD_PACKING_RESULT_PACK_1โœ…โœ…GS1_BOX_BARCODE_NO-

๊ด€๋ จ ๋ฌธ์„œ

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

Last updated on