1+ CREATE TABLE `dim_skc_info `
2+ (
3+ ` skc_code` varchar (150 ) NULL COMMENT " SKC编码" ,
4+ ` skc_desc` varchar (150 ) NULL COMMENT " skc描述" ,
5+ ` item_code` varchar (150 ) NULL COMMENT " 款号" ,
6+ ` color_name` varchar (300 ) NULL COMMENT " 颜色" ,
7+ ` color_code` varchar (60 ) NULL COMMENT " 颜色编码" ,
8+ ` brand_id` varchar (600 ) NULL COMMENT " 品牌id" ,
9+ ` brand_code` varchar (600 ) NULL COMMENT " 品牌编码" ,
10+ ` brand_name` varchar (600 ) NULL COMMENT " 品牌名称" ,
11+ ` product_year` varchar (30 ) NULL COMMENT " 产品年份" ,
12+ ` season` varchar (30 ) NULL COMMENT " 产品季节" ,
13+ ` product_season` varchar (30 ) NULL COMMENT " 产品季" ,
14+ ` category_id` varchar (60 ) NULL COMMENT " 商品大类id" ,
15+ ` category_code` varchar (60 ) NULL COMMENT " 商品大类编码" ,
16+ ` category_name` varchar (60 ) NULL COMMENT " 商品大类" ,
17+ ` m_name` varchar (600 ) NULL COMMENT " 商品中类" ,
18+ ` c_name` varchar (600 ) NULL COMMENT " 商品类型" ,
19+ ` product_line` varchar (600 ) NULL COMMENT " 产品线" ,
20+ ` product_line_name` varchar (600 ) NULL COMMENT " 产品线名称" ,
21+ ` category_m_name` varchar (60 ) NULL COMMENT " 品类名称" ,
22+ ` series` varchar (600 ) NULL COMMENT " 系列" ,
23+ ` series_name` varchar (600 ) NULL COMMENT " 系列名称" ,
24+ ` theme` varchar (600 ) NULL COMMENT " 主题" ,
25+ ` theme_name` varchar (600 ) NULL COMMENT " 主题名称" ,
26+ ` style_code` varchar (600 ) NULL COMMENT " 款式编码" ,
27+ ` style_name` varchar (600 ) NULL COMMENT " 商品名称" ,
28+ ` style_name_set` varchar (600 ) NULL COMMENT " 品名归集" ,
29+ ` sale_category_name` varchar (300 ) NULL COMMENT " 品类名称冗余字段" ,
30+ ` sale_middle_type` varchar (600 ) NULL COMMENT " 销售中类" ,
31+ ` developcode` varchar (150 ) NULL COMMENT " 开发款号" ,
32+ ` jpg` varchar (200 ) NULL COMMENT " 图片网址" ,
33+ ` tag_price` decimal (8 , 2 ) NULL COMMENT " 吊牌价" ,
34+ ` tag_price_usd` decimal (8 , 2 ) NULL COMMENT " 吊牌价(美元)" ,
35+ ` tag_price_hkd` decimal (8 , 2 ) NULL COMMENT " 吊牌价(港币)" ,
36+ ` tag_price_twd` decimal (8 , 2 ) NULL COMMENT " 吊牌价(新台币)" ,
37+ ` price_region` varchar (60 ) NULL COMMENT " 价格区间段" ,
38+ ` dingdanchengbenjia` varchar (45 ) NULL COMMENT " 订单成本价" ,
39+ ` shangshiboduan_nan` varchar (45 ) NULL COMMENT " 上市日期(南)" ,
40+ ` shangshiboduan_bei` varchar (45 ) NULL COMMENT " 上市日期(北)" ,
41+ ` kaifayanse` varchar (100 ) NULL COMMENT " 开发颜色" ,
42+ ` colortypename` varchar (300 ) NULL COMMENT " 颜色类别名称" ,
43+ ` sex` varchar (600 ) NULL COMMENT " 性别" ,
44+ ` ul_garments_name` varchar (600 ) NULL COMMENT " 服装名称" ,
45+ ` style_version_name` varchar (600 ) NULL COMMENT " 款式版本名称" ,
46+ ` needle_weaving_name` varchar (600 ) NULL COMMENT " 织针名称" ,
47+ ` clothing_length` varchar (90 ) NULL COMMENT " 衣长" ,
48+ ` thickness` varchar (90 ) NULL COMMENT " 厚度" ,
49+ ` kuanshimiaoshu` varchar (6000 ) NULL COMMENT " 款式描述" ,
50+ ` material_science` varchar (765 ) NULL COMMENT " 材料" ,
51+ ` caizhi` varchar (765 ) NULL COMMENT " 材质" ,
52+ ` mianliaofengge` varchar (45 ) NULL COMMENT " 面料风格" ,
53+ ` knitwear_weight` varchar (45 ) NULL COMMENT " 服装重量" ,
54+ ` weight` varchar (6000 ) NULL COMMENT " 重量" ,
55+ ` is_pop` varchar (45 ) NULL COMMENT " 是否POP款" ,
56+ ` banshi` varchar (45 ) NULL COMMENT " 版式" ,
57+ ` pro_level` varchar (600 ) NULL COMMENT " 推广级别" ,
58+ ` dinghuokejidiaopaishiyong` varchar (45 ) NULL COMMENT " " ,
59+ ` shejishi` varchar (45 ) NULL COMMENT " 设计师" ,
60+ ` gushibao` varchar (6000 ) NULL COMMENT " 故事包" ,
61+ ` gushibaoxilie` varchar (45 ) NULL COMMENT " 故事包系列" ,
62+ ` gushibaojibie` varchar (45 ) NULL COMMENT " 故事包级别" ,
63+ ` en_name` varchar (6000 ) NULL COMMENT " 英文名" ,
64+ ` classify` varchar (300 ) NULL COMMENT " 年龄分段(成人,儿童)" ,
65+ ` abroadcolor` varchar (6000 ) NULL COMMENT " 外部颜色" ,
66+ ` XSQY` varchar (300 ) NULL COMMENT " 销售区域" ,
67+ ` prod_level` varchar (300 ) NULL COMMENT " 产品层级" ,
68+ ` launch_month_c` varchar (300 ) NULL COMMENT " 上市月份(中)" ,
69+ ` ProjectType` varchar (45 ) NULL COMMENT " 延续类型" ,
70+ ` is_sale` varchar (300 ) NULL COMMENT " 是否非卖品" ,
71+ ` agegroup` varchar (33 ) NULL COMMENT " 年龄段" ,
72+ ` agegroup_desc` varchar (30 ) NULL COMMENT " 年龄段描述" ,
73+ ` status` int (11 ) NULL COMMENT " 状态" ,
74+ ` updatetime` date NULL COMMENT " 修改时间" ,
75+ ` short_and_long_clothes` varchar (600 ) NULL COMMENT " 长短衣" ,
76+ ` cloth_category` varchar (150 ) NULL COMMENT " 布种分类" ,
77+ ` story_pack_warm` varchar (3000 ) NULL COMMENT " 故事包温带" ,
78+ ` story_pack_hot` varchar (6000 ) NULL COMMENT " 故事包热带" ,
79+ ` story_pack_cold` varchar (6000 ) NULL COMMENT " 故事包寒带" ,
80+ ` story_pack_nuan` varchar (6000 ) NULL COMMENT " 故事包暖带" ,
81+ ` story_pack` varchar (6000 ) NULL COMMENT " 故事包" ,
82+ ` style_channel` varchar (300 ) NULL COMMENT " 渠道" ,
83+ ` listing_date_country` varchar (6000 ) NULL COMMENT " 全国上市日期" ,
84+ ` listing_date` date NULL COMMENT " 商品季上市日期" ,
85+ ` zixilie` varchar (6000 ) NULL COMMENT " 子系列" ,
86+ ` is_changqing` varchar (300 ) NULL COMMENT " 是否常青" ,
87+ ` internal_style_code` varchar (150 ) NULL COMMENT " 内部码" ,
88+ ` itemchannel` varchar (100 ) NULL COMMENT " 商品渠道" ,
89+ ` itemclass` varchar (100 ) NULL COMMENT " 商品类型" ,
90+ ` MaterialClass` varchar (6000 ) NULL COMMENT " 面料分类" ,
91+ ` is_nosale` varchar (10 ) NULL COMMENT " 是否非卖品" ,
92+ ` ShoeHeight` varchar (10 ) NULL COMMENT " 帮高" ,
93+ ` local_name` varchar (30 ) NULL COMMENT " 中文名" ,
94+ ` color_cscheme` varchar (100 ) NULL COMMENT " 色系" ,
95+ ` color_colorInclass` varchar (100 ) NULL COMMENT " 颜色中类" ,
96+ ` thick_and_thin_clothes` varchar (100 ) NULL COMMENT " 厚薄装" ,
97+ ` channel` varchar (100 ) NULL COMMENT " 渠道" ,
98+ ` is_brand_drive` varchar (100 ) NULL COMMENT " 品牌驱动" ,
99+ ` is_business_drive` varchar (100 ) NULL COMMENT " 生意驱动" ,
100+ ` product_season_tq` varchar (30 ) NULL COMMENT " 用于统计同期产品季使用" ,
101+ ` ifcn_name` varchar (300 ) NULL COMMENT " 是否中国开发"
102+ ) ENGINE= OLAP
103+ UNIQUE KEY(` skc_code` )
104+ COMMENT " skc主数据"
105+ DISTRIBUTED BY HASH(` skc_code` ) BUCKETS 1
106+ PROPERTIES (
107+ " replication_allocation" = " tag.location.default: 1" ,
108+ " in_memory" = " false" ,
109+ " storage_format" = " V2"
110+ );
0 commit comments