1、card table

card table發(fā)音

英：　　美：

card table中文意思翻譯

常用釋義：打牌桌：一種專(zhuān)門(mén)用于打牌的桌子

牌桌（打牌用的輕便小桌）

card table雙語(yǔ)使用場(chǎng)景

1、I'd been provided with a sagging army cot and a folding card table chair.───我有凹陷的行軍床和折疊椅各一張，角落里還有尿壺一個(gè)。

2、These young men may have gone their separate ways, but around a card table and a heap of rosy memories, they remain united.───博爾頓的伊格爾斯則走了一條不同的道路。不管怎么說(shuō)，他們都對曼聯(lián)留有美好的回憶。

3、Note that the customer credit card table has the privacy icon for the primary account number.───注意，客戶(hù)信用卡表對主賬戶(hù)編號擁有隱私圖標。

4、On a recent trip, I'd brought a card table and chairs and was happy when we all sat down together to play Rummikub.───在最近的一次探訪(fǎng)中，我帶過(guò)去一張桌子和幾張凳子，大家在一起玩魔力牌時(shí)非常的開(kāi)心。

5、An elementary school teacher sat on a folding chair behind a card table.───一個(gè)小學(xué)教師坐在抽彩票桌旁的折疊椅上。

6、When tea was over, Mr. Hurst reminded his sister-in-law of the card-table -- but in vain.───喝過(guò)茶以后，赫斯脫先生提醒她的小姨子把牌桌擺好，可是沒(méi)有用。

7、Some years back I learned to fly a single-engine plane, but flying a small plane is about as thrilling as sitting at a card table.───幾年前，我學(xué)著(zhù)駕駛單引擎飛機，但駕駛小型飛機就好像坐在牌桌前那樣刺激。

8、Joan: Imagine being on an ocean cruise and spending all your time indoors bent over a card table or a roulette wheel.───瓊：想想看吧，將你整個(gè)假期的時(shí)間花費在賭博船內，就為了在一張桌子上玩牌或者玩輪盤(pán)。

9、Of course, that's not what he wanted to focus on as we sat at the card table in the center of the room.───當然，他可不想因為這些瑣事攪了打牌的興致。

card table相似詞語(yǔ)短語(yǔ)

1、recipe card───配方卡

2、concession card───優(yōu)惠卡

3、show card───n.招貼，廣告；招貼；廣告；樣品卡

4、ghost card───鬼牌

5、card catalog───n.（圖書(shū)館專(zhuān)用的）卡片目錄; 卡片式目錄；圖書(shū)館里的卡片目錄（等于cardcatalogue）

6、car card───n.宣傳廣告; 街車(chē)廣告

7、phone card───電話(huà)卡

8、card───n.（Card）（英）卡德（人名）；n.卡片；紙牌；明信片；vt.記于卡片上

9、table───vt.制表；擱置；嵌合；n.桌子；表格；平地層；adj.桌子的；n.(Table)人名；(羅)塔布萊

2、身份證的檢查約束怎么寫(xiě)

/*建庫*/

use master

if exists (select * from sysdatabases where name='bankDB')--如果存在此數據庫就將其刪除

drop database bankDB

go

--exec xp_cmdshell 'mkdir d:\bank',no_output

create database bankDB

on

(

name='bankDB',

fileName='D:\bank\bankDB.mdf',

filegrowth=15%

)

log on

(

name='bankDB_log',

filename='D:\bank\bankDB_log.ldf',

filegrowth=15%

)

go

/*建表*/

use bankDB

if exists (select * from sysobjects where name='userInfo')

drop database userInfo

go

create table userInfo

(

customerID smallint identity(1,1) not null,

customerName varchar(10) not null,

PID varchar(20) not null,

telephone varchar(20) not null,

address text

)

go

if exists (select * from sysobjects where name='cardInfo')

drop database cardInfo

go

create table cardInfo

(

cardID varchar(50) not null,

curType varchar(10) not null,

savingType varchar(10) not null,

openDate datetime not null,

openMoney money not null,

balance money not null,

pass int not null,

IsReportLoss char(2) not null,

customerID smallint not null

)

go

if exists (select * from sysobjects where name='transInfo')

drop database transInfo

go

create table transInfo

(

transDate datetime not null,

cardID varchar(50) not null,

transType varchar(10) not null,

transMoney money not null,

remark text

)

go

/*****建約束*****/

/*userInfo表*/

alter table userInfo

add constraint PK_customerID primary key (customerID)

alter table userInfo

add constraint UQ_PID unique (PID)

alter table userInfo

add constraint ck_PID check(len(PID)=15 or len(PID)=18)

alter table userInfo

add constraint ck_PID2 check (PID 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][0-9][0-9][0-9]' or PID 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][0-9][0-9][A-Z]' or PID 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][0-9][0-9][0-9][0-9][0-9][0-9]' or PID 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][0-9][0-9][0-9][0-9][0-9][A-Z]')

alter table userInfo

add constraint ck_telephone check (len(telephone)=13 or len(telephone)=12)

alter table userInfo

add constraint ck_telephone2 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 '[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')

go

/*cardInfo表*/

alter table cardInfo

add constraint PK_cardID primary key (cardID)

alter table cardInfo

add constraint CK_cardID check(cardID like '1010 3576 [0-9][0-9][0-9][0-9] [0-9][0-9][0-9][0-9]')

alter table cardInfo

add constraint DF_curType default ('RMB') for curType

alter table cardInfo

add constraint CK_savingType check(savingType = '活期' or savingType='定活兩便' or savingType='定期')

alter table cardInfo

add constraint DF_openDate default (getdate()) for openDate

alter table cardInfo

add constraint CK_openMoney check(openMoney >=1)

alter table cardInfo

add constraint CK_balance check(balance>=1)

alter table cardInfo

add constraint CK_pass check(len(pass)=6)

alter table cardInfo

add constraint DF_pass default ('888888') for pass

alter table cardInfo

add constraint CK_IsReportLoss check(IsReportLoss='是' or IsReportLoss='否')

alter table cardInfo

add constraint DF_IsReportLoss default ('否') for IsReportLoss

alter table cardInfo

add constraint FK_customerID foreign key (customerID) references userInfo(customerID)

go

/*transInfo表*/

alter table transInfo

add constraint DF_transDate default (getdate()) for transDate

alter table transInfo

add constraint FK_cardID foreign key (cardID) references cardInfo(cardID)

alter table transInfo

add constraint CK_transType check(transType='存入' or transType='支取')

alter table transInfo

add constraint CK_transMoney check(transMoney>0)

go

/*****測試數據*****/

/*測試userInfo表*/

insert userInfo values('張三','123456789123456123','010-67898978','北京海淀')

insert userInfo values('李四','321245678912345678','0478-44443333',default)

/*測試cardInfo表*/

insert cardInfo(cardID,curType,savingType,openDate,openMoney,balance,pass,IsReportLoss,customerID) values ('1010 3576 1234 5678',DEFAULT,'活期',DEFAULT,1000,1000,DEFAULT,DEFAULT,1)

insert cardInfo(cardID,curType,savingType,openDate,openMoney,balance,pass,IsReportLoss,customerID) values ('1010 3576 1212 1134',DEFAULT,'定期',DEFAULT,1,1,DEFAULT,DEFAULT,2)

/*測試transInfo表*/

insert transInfo(transDate,transType,cardID,transMoney) values(default,'支取','1010 3576 1234 5678',900)

update cardInfo set balance=balance-900 where cardID='1010 3576 1234 5678'

insert transInfo(transDate,transType,cardID,transMoney) values(default,'存入','1010 3576 1212 1134',5000)

update cardInfo set balance=balance+5000 where cardID='1010 3576 1212 1134'

select * from transInfo

select * from cardInfo

select * from userInfo整個(gè)完善的