You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
57 lines
2.1 KiB
57 lines
2.1 KiB
/*==============================================================*/
|
|
/* DBMS name: Microsoft SQL Server 2012 */
|
|
/* Created on: 2021/5/17 15:14:06 */
|
|
/*==============================================================*/
|
|
|
|
|
|
if exists (select 1
|
|
from sysobjects
|
|
where id = object_id('Reagt_Approve')
|
|
and type = 'U')
|
|
drop table Reagt_Approve
|
|
go
|
|
|
|
if exists (select 1
|
|
from sysobjects
|
|
where id = object_id('Reagt_Approve_Status')
|
|
and type = 'U')
|
|
drop table Reagt_Approve_Status
|
|
go
|
|
|
|
drop schema dbo
|
|
go
|
|
|
|
/*==============================================================*/
|
|
/* User: dbo */
|
|
/*==============================================================*/
|
|
create schema dbo
|
|
go
|
|
|
|
/*==============================================================*/
|
|
/* Table: Reagt_Approve */
|
|
/*==============================================================*/
|
|
create table Reagt_Approve (
|
|
ApproveId int identity,
|
|
ApproveName varchar(200) null,
|
|
Specification varchar(200) null,
|
|
Number int null,
|
|
Maker varchar(100) null,
|
|
ApprovePeople varchar(20) null,
|
|
Verifier varchar(20) null,
|
|
ApproveStatus int null,
|
|
ApproveTime datetime null,
|
|
constraint PK_REAGT_APPROVE primary key (ApproveId)
|
|
)
|
|
go
|
|
|
|
/*==============================================================*/
|
|
/* Table: Reagt_Approve_Status */
|
|
/*==============================================================*/
|
|
create table Reagt_Approve_Status (
|
|
StatusId int identity,
|
|
StatusCode varchar(20) null,
|
|
StatusName varchar(30) null,
|
|
constraint PK_REAGT_APPROVE_STATUS primary key (StatusId)
|
|
)
|
|
go
|
|
|
|
|