需要完整的，刚学不久sql

需要完整的，刚学不久，，有没有写一下。说哈结实实门当户对姐的

1. 创建数据库

   CREATE DATABASE [ATM]
   on
   ( NAME = N'ATM', FILENAME = N'f:\bank\ATM.mdf' , FILEGROWTH = 15%)
   

2. 创建userInfo表

   USE [ATM]
   CREATE TABLE [dbo].[userInfo](
    [customerID] [int] IDENTITY(1,1) NOT NULL,
    [customerName] [varchar](20) NOT NULL,
    [PID] [varchar](18) NOT NULL UNIQUE check ((len([PID])=(18) OR len([PID])=(15))),
    [telephone] [varchar](13) NOT NULL 
   check (([telephone] like '[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]' 
      OR [telephone] like '[1-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')),
    [address] [varchar](255) NULL,
    PRIMARY KEY ([customerID]))
   GO
   

3. 创建cardInfo表及触发器

   USE [ATM]
   CREATE TABLE [dbo].cardInfo(
    cardID varchar(20) primary key not null check (cardID like '1010 3576 %'),
    curType varchar(10) NOT NULL default 'RMB',
    savingType varchar(5) check (savingType in ('活期','定活两便','定期')),
    openDate date NOT NULL default SYSDATETIME(),
    openMoney decimal not null check (openMoney >=1),
    balance    decimal not null,
    pass varchar(6) default '888888' check (pass like '[0-9][0-9][0-9][0-9][0-9][0-9]'),
    IsReportLoss varchar(2) check (IsReportLoss in ('是','否')) default '否',
    customerID int foreign key references dbo.userInfo (customerID)
    )
   go
   create trigger card_trigger on dbo.cardInfo
   after insert,update
   as
   begin
    delete from dbo.cardInfo where balance <1
   end
   GO
   

4. 创建transInfo表

   USE [ATM]
   CREATE TABLE [dbo].transInfo(
    transDate date not null default sysdatetime(),
    cardID [varchar](20) NOT NULL foreign key references dbo.cardInfo (cardID) index trans_card_index NONCLUSTERED,
    transType varchar(4) NOT NULL check (transType in ('存入','支取')),
    transMoney decimal NOT NULL check (transMoney > 0),
    remark [varchar](255) NULL
    )
   GO
   

用管理器做一遍，生成脚本就知道了

你也可以使用可视化软件做。

建议下载个Navicat，安装教程 : https://www.cnblogs.com/xuexianqi/p/12797170.html