⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 contact0310.sql

📁 本人为公司开发的Flex办公系统web源码,包括数据库脚本文件。
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Debug] (
	[seq] [int] IDENTITY (1, 1) NOT NULL ,
	[debugsql] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Depart] (
	[Depart_code] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Depart_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Discuss] (
	[rec] [int] NOT NULL ,
	[State] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Docu_Code] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[dis_title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[user_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[dis_content] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[dis_time] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Docus] (
	[Docu_id] [int] NOT NULL ,
	[Docu_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Form_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Docus_s1] (
	[Docu_id] [int] NOT NULL ,
	[Operate_id] [int] NOT NULL ,
	[Button_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Button_desc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Is_status] [bit] NOT NULL ,
	[status_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Complete_Operate_id] [int] NULL ,
	[IsRequired] [bit] NOT NULL ,
	[PreOP_Button_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Docus_s2] (
	[Docu_id] [int] NOT NULL ,
	[button_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[uid_seq] [int] NOT NULL ,
	[uid] [int] NOT NULL ,
	[operates] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ECN_Main] (
	[ECN_Code] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ERP_Code] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[Chg_Dep] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Add_user_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Chk_user_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Item_Code] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[High_type] [int] NULL ,
	[Op_user_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ECN_Reason] [varchar] (400) COLLATE Chinese_PRC_CI_AS NULL ,
	[CP_deal] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[BCP_deal] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mat_deal] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Bom_chg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Pic_chg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChkRule_chg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[SOP_chg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sample_chg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Else_chg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Chg_mark] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Chg_num] [int] NULL ,
	[Chg_date] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Advise_QC] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Advise_MC] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Advise_Pur] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Advise_Else] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Author_Tech] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Author_Manager] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Else_desc] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[Else_change] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ECN_Sub] (
	[ECN_Code] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[seq] [int] NOT NULL ,
	[ERP_Code] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ERP_Name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ERP_Rule] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Chg_Code] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Chg_Name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Chg_Rule] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Change_desc] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[EW_Main] (
	[EW_ID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EW_DEP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MEMO] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Make_by] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Make_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Audit_by] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Audit_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Author_by] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Author_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[EW_Sub] (
	[EW_ID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SEQ] [int] NOT NULL ,
	[EW_EMP] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EW_DATE_FROM] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EW_TIME_FROM] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EW_DATE_TO] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EW_TIME_TO] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EW_WORK] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MEMO] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Emp_Contract] (
	[contractNo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[orginazeComCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[orginazeNo1] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[orginazeNo2] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[orginazeNo3] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[user_ename] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[user_cname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[is_current] [int] NOT NULL ,
	[contractState] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IDCard] [varchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sex] [int] NOT NULL ,
	[birthday] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[degree] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[specialty] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[graduate_date] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[native_place] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[registered_place] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[current_place] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[apply_way] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[introducer] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[contract_begin] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[contract_end] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[contract_times_af2008] [int] NOT NULL ,
	[arrive_date] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[leave_date] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[leave_type] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[emp_phone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[emp_mobile] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[memo] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Photo] [image] NULL ,
	[ver] [int] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Fllow_List] (
	[Docu_id] [int] NOT NULL ,
	[Operate_id] [int] NOT NULL ,
	[Button_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Button_desc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Is_status] [bit] NOT NULL ,
	[Compstatus_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IsRequired] [bit] NOT NULL ,
	[CanOP_ByDocu_Code] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CanOP_ByOperator] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CanOP_ByElse] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CanOP_ByElse_Para] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CanUseButtons] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[GAPOperate_Log] (
	[AutoRec] [int] IDENTITY (1, 1) NOT NULL ,
	[Docu_id] [int] NOT NULL ,
	[Docu_Code] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Operate_uid] [int] NOT NULL ,
	[Button_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Operate_time] [smalldatetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[GAP_Main] (
	[GAP_Code] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[GAP_Dep] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[GAP_Reason] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[GAP_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ERP_Code] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ERP_Name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Mat_Class] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Base_Unit] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Pic_Code] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Use_State] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Tech_User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Tech_User_Time] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Store_Ware] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ware_Unit] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Store_Unit] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Vendor_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Pur_Period] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Pur_Unit] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Low_Lot] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Purchaser] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Pur_User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Pur_User_Time] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Plan_Strategy] [int] NOT NULL ,
	[Pur_Strategy] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Safe_Qty] [numeric](18, 3) NOT NULL ,
	[MRPMergeRequire] [int] NOT NULL ,
	[Key_Goods] [int] NOT NULL ,
	[Plan_User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Plan_User_Time] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[QC_Type] [int] NOT NULL ,
	[QC_ManageMethod] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[QC_GNT] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Guarant_Days] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[QC_User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[QC_User_Time] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ERP_User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ERP_User_Time] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MEMO] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Curr_State] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Row_ID] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[GAP_Rights] (
	[State_Seq] [int] NOT NULL ,
	[State_ID] [int] NOT NULL ,
	[State_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Enabled_Btns] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Enabled_Conts] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Enabled_User_Dep] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[LEAVE_Main] (
	[LR_ID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LR_DEP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LR_EMP] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[POSIT] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LEAVE_TYPE] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DATE_FROM] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TIME_FROM] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DATE_TO] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TIME_TO] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LR_REASON] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[WORK_HAND] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MEMO] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Make_by] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Make_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Audit_by] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Audit_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Author_by] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Author_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MailLog] (
	[Docu_code] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[button_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[msg] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[opdate] [smalldatetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MoudleSYS] (
	[Rec] [int] NOT NULL ,
	[MoudleName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MenuName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BelongtoSubSysID] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MyFiles] (
	[FTitle] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FData] [image] NOT NULL ,
	[FType] [varchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[create_user] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[create_dm] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FID] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OABuild] (
	[BuildID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BuildType] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Memo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ver] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OABuildSub] (
	[BuildID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[RoomID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp01Name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp02Name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp03Name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp04Name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp05Name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp06Name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp07Name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp08Name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp01InDate] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp02InDate] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp03InDate] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp04InDate] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp05InDate] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp06InDate] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp07InDate] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Emp08InDate] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OAFiles] (
	[FTitle] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FData] [image] NOT NULL ,
	[FType] [varchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[create_user] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[create_dm] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -