first.sql

一个基于VC6.0MFC的超市管理系统,SQL SERVER 2000数据库.实现基本功能,

create database Market

create table Person
( person_no char(10) primary key,
  person_name char(20),
  person_code char(10),
  person_limit int
)

create table Goods
( goods_no char(10) primary key,
  goods_name char(20),
  goods_quantity int,
  goods_price int
)

create table Record
( Record_Date char(30),
  Record_No char(10),
  Record_Quantity int,
  Record_SaleSum int,
  constraint Recordpri primary key(Record_Date,Record_No)
)

insert into Person values('0','houbingjian','001',0)