mysql itpub_mysql company

最新推荐文章于 2021-02-07 13:08:04 发布

邹世辉

最新推荐文章于 2021-02-07 13:08:04 发布

阅读量71

点赞数

文章标签： mysql itpub

本文链接：https://blog.csdn.net/weixin_31785177/article/details/113430220

版权

CREATE TABLE company (

comp_code_id int(10) NOT NULL auto_increment ,

org_id char(10) ,

mfg_comp_code char(20) ,

mfg_comp_name char(50) ,

process_plant_code char(20) ,

process_plant_name char(50) ,

max_turnover_sum decimal(18, 2) ,

prod_capacity decimal(18, 2) ,

wh_cubage decimal(18, 2) ,

wh_acreage decimal(18, 2) ,

file_id char(20),

PRIMARY KEY (`comp_code_id`)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE [company] (

[comp_code_id] [int] IDENTITY (1, 1) NOT NULL ,

[org_id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__company__comp_co__68D28DBC] DEFAULT ('),

[mfg_comp_code] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__company__mfg_com__69C6B1F5] DEFAULT ('),

[mfg_comp_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__company__mfg_com__6ABAD62E] DEFAULT ('),

[process_plant_code] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__company__process__6BAEFA67] DEFAULT ('),

[process_plant_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__company__process__6CA31EA0] DEFAULT ('),

[max_turnover_sum] [numeric](18, 6) NOT NULL CONSTRAINT [DF__company__max_tur__6D9742D9] DEFAULT (0),

[prod_capacity] [numeric](18, 6) NOT NULL CONSTRAINT [DF__company__prod_ca__6E8B6712] DEFAULT (0),

[wh_cubage] [numeric](18, 6) NOT NULL CONSTRAINT [DF__company__wh_cuba__6F7F8B4B] DEFAULT (0),

[wh_acreage] [numeric](18, 6) NOT NULL CONSTRAINT [DF__company__wh_acre__7073AF84] DEFAULT (0),

[file_id] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_company_file_id] DEFAULT ('),

CONSTRAINT [PK_company_comp_code_id ] PRIMARY KEY CLUSTERED

(

[comp_code_id]

) ON [PRIMARY]

GO[@more@]

关注