first.sql

来自「一个基于VC6.0MFC的超市管理系统,SQL SERVER 2000数据库.实」· SQL 代码 · 共 25 行

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)