mysql company
发布时间：2022-03-26 13:35:52 所属栏目：编程 来源：互联网
导读：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_ca
|
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] ) ON [PRIMARY] GO （编辑：核心网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
