/*==============================================================*/
/* 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