序号 | 列名 | 数据类型 | 长度 | 小数位 | 标识 | 主键 | 外键 | 允许空 | 默认值 | 说明 |
1 | ID | int | 4 | 0 | 是 | 是 | 否 | |||
2 | WriteID | int | 4 | 0 | 是 | 所属字库ID | ||||
3 | Unicode | nvarchar | 50 | 0 | 是 | 文字的Unicode编码(10进制) | ||||
4 | Svg | text | 16 | 0 | 是 | SVG信息 | ||||
5 | FontSvg | text | 16 | 0 | 是 | 字体SVG格式 | ||||
6 | CDate | datetime | 8 | 3 | 是 | |||||
7 | ZStatus | int | 4 | 0 | 是 |
字体大师手写字体详情
GO
CREATE TABLE [dbo].[ZL_Font_WriteWord](
[ID] [int] IDENTITY(1,1) NOT NULL,
[WriteID] [int] NULL,
[Unicode] [nvarchar](50) NULL,
[Svg] [text] NULL,
[FontSvg] [text] NULL,
[CDate] [datetime] NULL,
[ZStatus] [int] NULL,
[vCanvasData] [text] NULL,
[vCanvasList] [text] NULL,
[vCount] [int] NULL,
CONSTRAINT [PK_ZL_Font_WriteList] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
detele from ZL_Font_WriteWord
drop table ZL_Font_WriteWord
TRUNCATE table ZL_Font_WriteWord