| 1 |
- window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t4070","name":"tb_option","subtype":"TABLE","is_user_defined":false,"description":"<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n <html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n <head>\r\n <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" /><title>\r\n </title>\r\n <style type=\"text/css\">\r\n .cs2654AE3A{text-align:left;text-indent:0pt;margin:0pt 0pt 0pt 0pt}\r\n .cs82292024{color:#000000;background-color:transparent;font-family:Segoe UI;font-size:10pt;font-weight:normal;font-style:normal;}\r\n </style>\r\n </head>\r\n <body>\r\n <p class=\"cs2654AE3A\"><span class=\"cs82292024\">옵션. 옵션 등록에 의한 발생</span></p></body>\r\n </html>","summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"tb_option"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-39464","object_id":"column-39464","name":"GOODS_CD","name_without_path":"GOODS_CD","description":"상품코드","is_pk":true,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39465","object_id":"column-39465","name":"OPT_CD","name_without_path":"OPT_CD","description":"옵션코드","is_pk":true,"is_identity":false,"data_type":"varchar","data_length":"200","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39466","object_id":"column-39466","name":"OPT_CD1","name_without_path":"OPT_CD1","description":"옵션코드1(자사:COLOR_CD, 입점:옵션명1)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39467","object_id":"column-39467","name":"OPT_CD2","name_without_path":"OPT_CD2","description":"옵션코드2(자사:SIZE, 입점:옵션명2)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39472","object_id":"column-39472","name":"SKU_MODEL_NO","name_without_path":"SKU_MODEL_NO","description":"SKUModelNo(WMS)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"50","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39469","object_id":"column-39469","name":"PRODUCT_NO","name_without_path":"PRODUCT_NO","description":"ProductNo(WMS)","is_pk":false,"is_identity":false,"data_type":"unsigned int","data_length":"10, 0","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39468","object_id":"column-39468","name":"PRODUCT_CODE","name_without_path":"PRODUCT_CODE","description":"ProductCode(WMS)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"50","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39460","object_id":"column-39460","name":"BASE_STOCK_QTY","name_without_path":"BASE_STOCK_QTY","description":"기준재고(안전재고)수량","is_pk":false,"is_identity":false,"data_type":"smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39461","object_id":"column-39461","name":"CURR_STOCK_QTY","name_without_path":"CURR_STOCK_QTY","description":"현재고수량","is_pk":false,"is_identity":false,"data_type":"smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39475","object_id":"column-39475","name":"STORE_STOCK_QTY","name_without_path":"STORE_STOCK_QTY","description":"매장재고수량","is_pk":false,"is_identity":false,"data_type":"smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39474","object_id":"column-39474","name":"STORE_MAX_QTY","name_without_path":"STORE_MAX_QTY","description":"매장별최대재고수량(자사상품만사용)","is_pk":false,"is_identity":false,"data_type":"smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39459","object_id":"column-39459","name":"ADD_PRICE","name_without_path":"ADD_PRICE","description":"추가가격","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39473","object_id":"column-39473","name":"SOLDOUT_YN","name_without_path":"SOLDOUT_YN","description":"결품여부","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39462","object_id":"column-39462","name":"DISP_ORD","name_without_path":"DISP_ORD","description":"표시순서","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"1","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39463","object_id":"column-39463","name":"DISP_YN","name_without_path":"DISP_YN","description":"표시여부","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"Y","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39471","object_id":"column-39471","name":"REG_NO","name_without_path":"REG_NO","description":"등록자번호","is_pk":false,"is_identity":false,"data_type":"unsigned int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39470","object_id":"column-39470","name":"REG_DT","name_without_path":"REG_DT","description":"등록일시","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":false,"computed_formula":"","default_value":"CURRENT_TIMESTAMP","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39477","object_id":"column-39477","name":"UPD_NO","name_without_path":"UPD_NO","description":"수정자번호","is_pk":false,"is_identity":false,"data_type":"unsigned int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39476","object_id":"column-39476","name":"UPD_DT","name_without_path":"UPD_DT","description":"수정일시","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":false,"computed_formula":"","default_value":"CURRENT_TIMESTAMP","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]}],"relations":[],"unique_keys":[{"name":"PRIMARY","description":"상품코드","is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"GOODS_CD","name":"GOODS_CD"},{"path":null,"name_without_path":"OPT_CD","name":"OPT_CD"}],"custom_fields":{}}],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};
|
