gyshang.sql

一个ERP系统可以用来学习之用

CREATE TABLE [gyshang] (
	[GYId] [int] NULL CONSTRAINT [DF_gyshang_GYId] DEFAULT (1000),
	[Gydaihao] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Gyname] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[GyLinkman] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[GyAddress] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[GyEmail] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gyphone] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[GyFox] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_供应商] PRIMARY KEY  CLUSTERED 
	(
		[Gydaihao]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO