java 流水账号生成_流水帐号生成自定义策略

USE[fa1]GO/****** 对象:  Table [dbo].[SYS_SERIAL_NUMBER]    脚本日期: 07/09/2010 12:45:23 ******/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOSETANSI_PADDINGONGOCREATETABLE[dbo].[SYS_SERIAL_NUMBER]([ID][varchar](32)NOTNULL,[CREATE_TIME][datetime]NULL,[CREATE_USER][varchar](20)NULL,[ROW_STATUS][varchar](1)NULL,[UPDATE_TIME][datetime]NULL,[UPDATE_USER][varchar](20)NULL,[CATEGORY][varchar](40)NULL,[INITIAL_NUMBER][numeric](10,0)NULL,[LAST_NUMBER][numeric](10,0)NULL,[MAX_NUMBER][numeric](10,0)NULL,[PREFIX_CHAR][varchar](255)NULL,[REMARK][varchar](40)NULL,[REMARKS][varchar](250)NULL,[PERSTRING][varchar](10)NULL)ON[PRIMARY]GOSETANSI_PADDINGOFFGOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'SYS_SERIAL_NUMBER',@level2type=N'COLUMN',@level2name=N'ID'GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'CREATE_TIME',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'SYS_SERIAL_NUMBER',@level2type=N'COLUMN',@level2name=N'CREATE_TIME'GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'CREATE_USER',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'SYS_SERIAL_NUMBER',@level2type=N'COLUMN',@level2name=N'CREATE_USER'GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'ROW_STATUS',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'SYS_SERIAL_NUMBER',@level2type=N'COLUMN',@level2name=N'ROW_STATUS'GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'UPDATE_TIME',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'SYS_SERIAL_NUMBER',@level2type=N'COLUMN',@level2name=N'UPDATE_TIME'GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'UPDATE_USER',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'SYS_SERIAL_NUMBER',@level2type=N'COLUMN',@level2name=N'UPDATE_USER'GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'前缀',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'SYS_SERIAL_NUMBER',@level2type=N'COLUMN',@level2name=N'CATEGORY'GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'起初号码',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'SYS_SERIAL_NUMBER',@level2type=N'COLUMN',@level2name=N'INITIAL_NUMBER'GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'最后号码',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'SYS_SERIAL_NUMBER',@level2type=N'COLUMN',@level2name=N'LAST_NUMBER'GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'最大的流水号',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'SYS_SERIAL_NUMBER',@level2type=N'COLUMN',@level2name=N'MAX_NUMBER'GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'PREFIX_CHAR',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'SYS_SERIAL_NUMBER',@level2type=N'COLUMN',@level2name=N'PREFIX_CHAR'GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'REMARK',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'SYS_SERIAL_NUMBER',@level2type=N'COLUMN',@level2name=N'REMARK'GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'REMARKS',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'SYS_SERIAL_NUMBER',@level2type=N'COLUMN',@level2name=N'REMARKS'GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'PERSTRING',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'SYS_SERIAL_NUMBER',@level2type=N'COLUMN',@level2name=N'PERSTRING'GOEXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'流水号',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'SYS_SERIAL_NUMBER'