apart.sql

这是用PB6开发的一个POS管理系统

/* ============================================================ */
/*   Database name:  SYPOS                                      */
/*   DBMS name:      Microsoft SQL Server 7.x                   */
/*   Created on:     2000-10-20  21:19                          */
/* ============================================================ */

if exists (select 1
            from  sysobjects
           where  id = object_id('Apart')
            and   type = 'U')
   drop table Apart
go

if exists (select 1
            from  sysobjects
           where  id = object_id('ApartDetail')
            and   type = 'U')
   drop table ApartDetail
go

if exists (select 1
            from  sysobjects
           where  id = object_id('ApartGoods')
            and   type = 'U')
   drop table ApartGoods
go

/* ============================================================ */
/*   Table: ApartGoods                                          */
/* ============================================================ */
create table ApartGoods
(
    mastergoodsno  TGoods                not null,
    slavegoodsno   TGoods                not null,
    masterqty      TQty                  null    ,
    slaveqty	   TQty                  null    ,
    apartflag      char(1)               not null,
    constraint PK_APARTGOODS primary key (mastergoodsno, slavegoodsno)
)
go

/* ============================================================ */
/*   Table: ApartDetail                                         */
/* ============================================================ */
create table ApartDetail
(
    apartno        TReceipt              not null,
    goodsno        TGoods                not null,
    qty            tQty                  null    ,
    costprice      TPrice                null    ,
    retailprice    TPrice                null    ,
    constraint PK_APARTDETAIL primary key (apartno, goodsno)
)
go

/* ============================================================ */
/*   Table: Apart                                               */
/* ============================================================ */
create table Apart
(
    apartno        TReceipt              not null,
    goodsno        TGoods                null    ,
    Qty            TQty                  null    ,
    Amt            TAmt                  null    ,
    NTaxAmt        TAmt                  null    ,
    RetailAmt      TAmt                  null    ,
    operator       TStaff                null    ,
    inputdate      TDate                 null    
        default getdate(),
    auditdate      TDate                 null    
        default getdate(),
    auditflag      char(1)               null    
        default '0',
    auditoperator  TStaff                null    ,
    ReceiptFlag    char(1)               null    
        default '0',
    ApartFlag      char(1)               null    ,
    Inputdept      TDept                 not null,
    Remark         TMemo                 null    ,
    constraint PK_APART primary key (apartno)
)
go