物流项目总结
物流动态
CREATE TABLE [dbo].[active] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[content] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[author] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[showdate] [datetime] NOT NULL
) ON [PRIMARY]
车辆信息表
CREATE TABLE [dbo].[car] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[numbers] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[carname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[types] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[loads] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[usetime] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[drivername] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[drivertime] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[number] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[styles] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[transtyle] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[linkman] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[phone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[meg] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[showdate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[username] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
本地公告
CREATE TABLE [dbo].[gonggao] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[content] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[author] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[showdate] [datetime] NOT NULL
) ON [PRIMARY]