You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
41 lines
1.4 KiB
Plaintext
41 lines
1.4 KiB
Plaintext
alter TABLE [t_sys_awoke]
|
|
add [提醒时间] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
|
|
[提醒抬头] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
|
|
[月份] [int] NULL ,
|
|
[内容类别] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
|
|
[业务类型] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
|
|
[显示方式] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
|
|
[提醒对象] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
|
|
[提醒结尾] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
|
|
[内容字段] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
|
|
[更新业务状态] [bit] NULL ,
|
|
[运抵报告状态] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
|
|
[报关信息状态] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
|
|
[是否发送提醒] [bit] NULL ,
|
|
[码头信息] [bit] NULL ,
|
|
[海关运抵报告] [bit] NULL ,
|
|
[海关报关信息] [bit] NULL ,
|
|
[出口舱单] [bit] NULL ,
|
|
[QQCTU码头信息] [bit] NULL ,
|
|
[QQCTU运抵报告] [bit] NULL ,
|
|
[QQCTU报关信息] [bit] NULL ,
|
|
[QQCTU出口舱单] [bit] NULL ,
|
|
[是否提醒到客户] [bit] NULL
|
|
---
|
|
CREATE TABLE [t_op_state_igz] (
|
|
[OS] [int] IDENTITY (1, 1) NOT NULL ,
|
|
[业务状态] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
|
|
[状态时间] [smalldatetime] NULL ,
|
|
[主提单号] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
|
|
[分提单号] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
|
|
[箱号] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
|
|
CONSTRAINT [PK_t_op_state_igz] PRIMARY KEY CLUSTERED
|
|
(
|
|
[OS]
|
|
) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
|
|
|
|
|
|
|