SQL總結(jié)
SQL總結(jié)
數(shù)據(jù)庫
1查詢數(shù)據(jù)
SelectFromwhere2增加數(shù)據(jù)
Insertinto(列名)values(值)3更新數(shù)據(jù)
Updatesetwhere=4刪除數(shù)據(jù)
Deletefrom表名[where]5創(chuàng)建數(shù)據(jù)庫
CreateDatabase(數(shù)據(jù)庫名)Onprimary(
Name=’stuDB_data’
FilenameD:\\stuDB_data.mdf;Size=5MB,Maxsize=100mbFilegrowth=15%)Logon(
Name=’stuDB_log’
Filename=”d:\\stuDB_log.ldf”,Size=2MB,
Filegrowth=1mb)Go
6創(chuàng)建表
CreateTable(表名)
(idintidentity(1,1)primarykey,Namechar(20)nonullSexbit)
7刪除表
Deletefrom表where條件scoreisnulldelete表名表的約束1主鍵約束2唯一約束3默認(rèn)約束4檢查約束5外鍵約束
兩種方式添加約束1建表的時(shí)候添加2先建表后添加多表聯(lián)接查詢分類內(nèi)聯(lián)接左外聯(lián)接右外聯(lián)接完整外連接交叉聯(lián)接全聯(lián)接
TSQL編程使用變量
局部變量先聲明后賦值以@為前綴
全局變量以@_@為前綴聲明局部變量
@變量名數(shù)據(jù)類型Ifelse語句、If(條件)Begin語句1語句2EndElseBegin語句1語句2End
While(條件)Begin語句1語句2BreakEnd事務(wù)
1開始事務(wù)begintransaction2提交事務(wù)committransaction
3回滾(撤銷)事務(wù)rollbacktransaction一旦事務(wù)提交或回滾則事務(wù)結(jié)束
索引類型
唯一索引:不允許有兩個(gè)相同的索引值主鍵索引:為表定義一個(gè)主鍵將自動(dòng)創(chuàng)建主鍵索引主鍵索引時(shí)唯一索引的特殊類型主鍵索引要求主鍵中的每個(gè)值是唯一的并且不能為空
聚集索引表中個(gè)性的物理順序與鍵值的邏輯順序相同每個(gè)表只能有一個(gè)
非聚集索引:指定表的邏輯順序數(shù)據(jù)存儲(chǔ)在一個(gè)位置索引存儲(chǔ)在另一個(gè)位置索引中包含志向數(shù)據(jù)存儲(chǔ)位置的指針可以的多個(gè)小于240個(gè)創(chuàng)建視圖
Createview視圖名AS
Select查詢語句
創(chuàng)建存儲(chǔ)過程
Createproc存儲(chǔ)過程名
@參數(shù)數(shù)據(jù)類型=默認(rèn)值OUTPUT@參數(shù)數(shù)據(jù)類型=默認(rèn)值OUTPUTAS
SQL語句GO
擴(kuò)展閱讀:SQL總結(jié)
3.6SQLAlias(別名)3.7SQLJOIN
用于根據(jù)兩個(gè)或多個(gè)表中的列之間的關(guān)系,從這些表中查詢數(shù)據(jù)。
語法
INNERJOIN:如果表中有至少一個(gè)匹配,則返回行
JOIN:如果表中有至少一個(gè)匹配,則返回行(與INNERJOIN相同)LEFTJOIN:即使右表中沒有匹配,也從左表返回所有的行RIGHTJOIN:即使左表中沒有匹配,也從右表返回所有的行FULLJOIN:只要其中一個(gè)表中存在匹配,就返回行
實(shí)例
"Persons"表:Id_P123"Orders"表:Id_O12345OrderNo7789544678224562456234764Id_P331165LastNameAdamsBushCarterFirstNameJohnGeorgeThomasAddressOxfordStreetFifthAvenue","p":{"h":14.39,"w":79.578,"x":519.405,"y":643.318,"z":658},"ps":{"_cover":true},"t":"word","r":[26]},{"c":{"ix":0,"iy":3647,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":410.505,"x0":410.505,"x1":410.505,"x2":412.665,"x3":412.665,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":658},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_658.png"},"t":"pic"},{"c":{"ix":0,"iy":3654,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":412.665,"x0":412.665,"x1":412.665,"x2":414.825,"x3":414.825,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":659},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_659.png"},"t":"pic"},{"c":{"ix":0,"iy":3661,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":414.825,"x0":414.825,"x1":414.825,"x2":416.985,"x3":416.985,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":660},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_660.png"},"t":"pic"},{"c":{"ix":0,"iy":3668,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":416.984,"x0":416.984,"x1":416.984,"x2":419.144,"x3":419.144,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":661},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_661.png"},"t":"pic"},{"c":{"ix":0,"iy":3675,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":419.144,"x0":419.144,"x1":419.144,"x2":421.304,"x3":421.304,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":662},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_662.png"},"t":"pic"},{"c":{"ix":0,"iy":3682,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":421.305,"x0":421.305,"x1":421.305,"x2":423.465,"x3":423.465,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":663},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_663.png"},"t":"pic"},{"c":{"ix":0,"iy":3689,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":423.465,"x0":423.465,"x1":423.465,"x2":425.625,"x3":425.625,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":664},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_664.png"},"t":"pic"},{"c":{"ix":0,"iy":3696,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":425.625,"x0":425.625,"x1":425.625,"x2":427.785,"x3":427.785,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":665},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_665.png"},"t":"pic"},{"c":{"ix":0,"iy":3703,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":427.784,"x0":427.784,"x1":427.784,"x2":429.945,"x3":429.945,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":666},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_666.png"},"t":"pic"},{"c":{"ix":0,"iy":3710,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":429.945,"x0":429.945,"x1":429.945,"x2":432.105,"x3":432.105,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":667},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_667.png"},"t":"pic"},{"c":{"ix":0,"iy":3717,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":432.105,"x0":432.105,"x1":432.105,"x2":434.265,"x3":434.265,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":668},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_668.png"},"t":"pic"},{"c":{"ix":0,"iy":3724,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":434.265,"x0":434.265,"x1":434.265,"x2":436.425,"x3":436.425,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":669},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_669.png"},"t":"pic"},{"c":{"ix":0,"iy":3731,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":436.424,"x0":436.424,"x1":436.424,"x2":438.585,"x3":438.585,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":670},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_670.png"},"t":"pic"},{"c":{"ix":0,"iy":3738,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":438.585,"x0":438.585,"x1":438.585,"x2":440.745,"x3":440.745,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":671},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_671.png"},"t":"pic"},{"c":{"ix":0,"iy":3745,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":440.745,"x0":440.745,"x1":440.745,"x2":442.905,"x3":442.905,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":672},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_672.png"},"t":"pic"},{"c":{"ix":0,"iy":3752,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":442.905,"x0":442.905,"x1":442.905,"x2":445.065,"x3":445.065,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":673},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_673.png"},"t":"pic"},{"c":{"ix":0,"iy":3759,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":445.064,"x0":445.064,"x1":445.064,"x2":447.224,"x3":447.224,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":674},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_674.png"},"t":"pic"},{"c":{"ix":0,"iy":3766,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":447.225,"x0":447.225,"x1":447.225,"x2":449.385,"x3":449.385,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":675},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_675.png"},"t":"pic"},{"c":{"ix":0,"iy":3773,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":449.385,"x0":449.385,"x1":449.385,"x2":451.545,"x3":451.545,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":676},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_676.png"},"t":"pic"},{"c":{"ix":0,"iy":3780,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":451.544,"x0":451.544,"x1":451.544,"x2":453.705,"x3":453.705,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":677},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_677.png"},"t":"pic"},{"c":{"ix":0,"iy":3787,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":453.704,"x0":453.704,"x1":453.704,"x2":455.864,"x3":455.864,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":678},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_678.png"},"t":"pic"},{"c":{"ix":0,"iy":3794,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":455.864,"x0":455.864,"x1":455.864,"x2":458.025,"x3":458.025,"y":1114.703,"y0":1115.783,"y1":1114.703,"y2":1114.703,"y3":1115.783,"z":679},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_7_679.png"},"t":"pic"},{"c":{"ix":0,"iy":3801,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":458.025,"x0":458.025,"x1":458.025,"x2":460.185,"x3":460.185,"y":1114.703,"y0":1115.783,"y3.15SQLFOREIGNKEY約束
一個(gè)表中的FOREIGNKEY指向另一個(gè)表中的PRIMARYKEY。FOREIGNKEY約束用于預(yù)防破壞表之間連接的動(dòng)作。
FOREIGNKEY約束也能防止非法數(shù)據(jù)插入外鍵列,因?yàn)樗仨毷撬赶虻哪莻(gè)表中的值之一。
語法
在"Orders"表創(chuàng)建時(shí)為"Id_P"列創(chuàng)建FOREIGNKEY:
MySQL:","p":{"h":17.566,"w":53.973,"x":135.036,"y":399.568,"z":31},"ps":{"_enter":1},"s":{"letter-spacing":"-0.064"},"t":"word","r":[11]},{"c":{"ix":0,"iy":0,"iw":663,"ih":36},"p":{"h":36,"w":663,"x":115,"y":431,"z":32},"ps":{"_drop":1},"s":null,"t":"pic"},{"c":{"ix":0,"iy":41,"iw":893,"ih":833},"p":{"h":833,"opacity":1,"w":892.979,"x":0,"y":429,"z":33},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_33.png"},"t":"pic"},{"c":{"ix":0,"iy":879,"iw":2,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":1.079,"x":119.916,"x0":119.916,"x1":119.916,"x2":120.996,"x3":120.996,"y":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":34},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_34.png"},"t":"pic"},{"c":{"ix":0,"iy":886,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":120.996,"x0":120.996,"x1":120.996,"x2":123.156,"x3":123.156,"y":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":35},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_35.png"},"t":"pic"},{"c":{"ix":0,"iy":893,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":123.156,"x0":123.156,"x1":123.156,"x2":125.316,"x3":125.316,"y":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":36},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_36.png"},"t":"pic"},{"c":{"ix":0,"iy":900,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":125.316,"x0":125.316,"x1":125.316,"x2":127.476,"x3":127.476,"y":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":37},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_37.png"},"t":"pic"},{"c":{"ix":0,"iy":907,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":127.476,"x0":127.476,"x1":127.476,"x2":129.636,"x3":129.636,"y":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":38},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_38.png"},"t":"pic"},{"c":{"ix":0,"iy":914,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":129.636,"x0":129.636,"x1":129.636,"x2":131.796,"x3":131.796,"y":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":39},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_39.png"},"t":"pic"},{"c":{"ix":0,"iy":921,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":131.796,"x0":131.796,"x1":131.796,"x2":133.956,"x3":133.956,"y":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":40},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_40.png"},"t":"pic"},{"c":{"ix":0,"iy":928,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":133.956,"x0":133.956,"x1":133.956,"x2":136.116,"x3":136.116,"y":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":41},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_41.png"},"t":"pic"},{"c":{"ix":0,"iy":935,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":136.116,"x0":136.116,"x1":136.116,"x2":138.276,"x3":138.276,"y":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":42},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_42.png"},"t":"pic"},{"c":{"ix":0,"iy":942,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":138.276,"x0":138.276,"x1":138.276,"x2":140.436,"x3":140.436,"y":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":43},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_43.png"},"t":"pic"},{"c":{"ix":0,"iy":949,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":140.435,"x0":140.435,"x1":140.435,"x2":142.595,"x3":142.595,"y":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":44},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_44.png"},"t":"pic"},{"c":{"ix":0,"iy":956,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":142.596,"x0":142.596,"x1":142.596,"x2":144.756,"x3":144.756,"y":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":45},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_45.png"},"t":"pic"},{"c":{"ix":0,"iy":963,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":144.756,"x0":144.756,"x1":144.756,"x2":146.916,"x3":146.916,"y":430.814,"y0":431.894,"y1":430.814,"y2":430.814,"y3":431.894,"z":46},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_16_46.png"},"t":"pic"},{"c":{"ix":0,"iy":970,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":146.916,"x0":146.916,"x1":146.916,"x2":149.076,"x3":149.076,"y":430.814,"y0":431.894,"y1":43":[{"c":{"ix":0,"iy":0,"iw":663,"ih":37},"p":{"h":37,"w":663,"x":115,"y":108,"z":1},"ps":{"_drop":1},"s":null,"t":"pic"},{"c":{"ix":0,"iy":42,"iw":893,"ih":3},"p":{"h":3,"opacity":1,"w":892.979,"x":0,"y":107,"z":2},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_17_2.png"},"t":"pic"},{"c":{"ix":0,"iy":50,"iw":2,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":1.079,"x":119.916,"x0":119.916,"x1":119.916,"x2":120.996,"x3":120.996,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":3},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_17_3.png"},"t":"pic"},{"c":{"ix":0,"iy":57,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":120.996,"x0":120.996,"x1":120.996,"x2":123.156,"x3":123.156,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":4},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_17_4.png"},"t":"pic"},{"c":{"ix":0,"iy":64,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":123.156,"x0":123.156,"x1":123.156,"x2":125.316,"x3":125.316,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y3":109.259,"z":5},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_17_5.png"},"t":"pic"},{"c":{"ix":0,"iy":71,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":125.316,"x0":125.316,"x1":125.316,"x2":127.476,"x3":127.476,"y":108.179,"y0":109.259,"y1":108.179,"y2":108.179,"y如需撤銷CHECK約束,請(qǐng)使用下面的SQL:
SQLServer/Oracle/MSAccess:","p":{"h":17.566,"w":216.378,"x":135.036,"y":146.623,"z":9},"ps":{"_enter":1},"s":{"letter-spacing":"-0.041"},"t":"word","r":[8]},{"c":{"ix":0,"iy":0,"iw":663,"ih":36},"p":{"h":36,"w":663,"x":115,"y":178,"z":10},"ps":{"_drop":1},"s":null,"t":"pic"},{"c":{"ix":0,"iy":41,"iw":893,"ih":1086},"p":{"h":1086,"opacity":1,"w":892.979,"x":0,"y":176,"z":11},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_11.png"},"t":"pic"},{"c":{"ix":0,"iy":1132,"iw":2,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":1.079,"x":119.916,"x0":119.916,"x1":119.916,"x2":120.996,"x3":120.996,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":12},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_12.png"},"t":"pic"},{"c":{"ix":0,"iy":1139,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":120.996,"x0":120.996,"x1":120.996,"x2":123.156,"x3":123.156,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":13},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_13.png"},"t":"pic"},{"c":{"ix":0,"iy":1146,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":123.156,"x0":123.156,"x1":123.156,"x2":125.316,"x3":125.316,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":14},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_14.png"},"t":"pic"},{"c":{"ix":0,"iy":1153,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":125.316,"x0":125.316,"x1":125.316,"x2":127.476,"x3":127.476,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":15},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_15.png"},"t":"pic"},{"c":{"ix":0,"iy":1160,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":127.476,"x0":127.476,"x1":127.476,"x2":129.636,"x3":129.636,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":16},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_16.png"},"t":"pic"},{"c":{"ix":0,"iy":1167,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":129.636,"x0":129.636,"x1":129.636,"x2":131.796,"x3":131.796,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":17},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_17.png"},"t":"pic"},{"c":{"ix":0,"iy":1174,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":131.796,"x0":131.796,"x1":131.796,"x2":133.956,"x3":133.956,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":18},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_18.png"},"t":"pic"},{"c":{"ix":0,"iy":1181,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":133.956,"x0":133.956,"x1":133.956,"x2":136.116,"x3":136.116,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":19},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_19.png"},"t":"pic"},{"c":{"ix":0,"iy":1188,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":136.116,"x0":136.116,"x1":136.116,"x2":138.276,"x3":138.276,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":20},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_20.png"},"t":"pic"},{"c":{"ix":0,"iy":1195,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":138.276,"x0":138.276,"x1":138.276,"x2":140.436,"x3":140.436,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":21},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_21.png"},"t":"pic"},{"c":{"ix":0,"iy":1202,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":140.435,"x0":140.435,"x1":140.435,"x2":142.595,"x3":142.595,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":22},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_22.png"},"t":"pic"},{"c":{"ix":0,"iy":1209,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":142.596,"x0":142.596,"x1":142.596,"x2":144.756,"x3":144.756,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":23},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_23.png"},"t":"pic"},{"c":{"ix":0,"iy":1216,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":144.756,"x0":144.756,"x1":144.756,"x2":146.916,"x3":146.916,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":24},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_24.png"},"t":"pic"},{"c":{"ix":0,"iy":1223,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":146.916,"x0":146.916,"x1":146.916,"x2":149.076,"x3":149.076,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":25},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_25.png"},"t":"pic"},{"c":{"ix":0,"iy":1230,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":149.076,"x0":149.076,"x1":149.076,"x2":151.236,"x3":151.236,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":26},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_26.png"},"t":"pic"},{"c":{"ix":0,"iy":1237,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":151.23,"x0":151.23,"x1":151.23,"x2":153.39,"x3":153.39,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":27},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_27.png"},"t":"pic"},{"c":{"ix":0,"iy":1244,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":153.39,"x0":153.39,"x1":153.39,"x2":155.55,"x3":155.55,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":28},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_28.png"},"t":"pic"},{"c":{"ix":0,"iy":1251,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":155.55,"x0":155.55,"x1":155.55,"x2":157.71,"x3":157.71,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":29},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_29.png"},"t":"pic"},{"c":{"ix":0,"iy":1258,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":157.71,"x0":157.71,"x1":157.71,"x2":159.87,"x3":159.87,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":30},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_30.png"},"t":"pic"},{"c":{"ix":0,"iy":1265,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":159.87,"x0":159.87,"x1":159.87,"x2":162.03,"x3":162.03,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":31},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_31.png"},"t":"pic"},{"c":{"ix":0,"iy":1272,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":162.03,"x0":162.03,"x1":162.03,"x2":164.19,"x3":164.19,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":32},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_32.png"},"t":"pic"},{"c":{"ix":0,"iy":1279,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":164.19,"x0":164.19,"x1":164.19,"x2":166.35,"x3":166.35,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":33},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_33.png"},"t":"pic"},{"c":{"ix":0,"iy":1286,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":166.35,"x0":166.35,"x1":166.35,"x2":168.51,"x3":168.51,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":34},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_34.png"},"t":"pic"},{"c":{"ix":0,"iy":1293,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":168.51,"x0":168.51,"x1":168.51,"x2":170.67,"x3":170.67,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":35},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_35.png"},"t":"pic"},{"c":{"ix":0,"iy":1300,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":170.67,"x0":170.67,"x1":170.67,"x2":172.83,"x3":172.83,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":36},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_36.png"},"t":"pic"},{"c":{"ix":0,"iy":1307,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":172.829,"x0":172.829,"x1":172.829,"x2":174.989,"x3":174.989,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":37},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_37.png"},"t":"pic"},{"c":{"ix":0,"iy":1314,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":174.99,"x0":174.99,"x1":174.99,"x2":177.15,"x3":177.15,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":38},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_38.png"},"t":"pic"},{"c":{"ix":0,"iy":1321,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":177.149,"x0":177.149,"x1":177.149,"x2":179.309,"x3":179.309,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":39},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_39.png"},"t":"pic"},{"c":{"ix":0,"iy":1328,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":179.31,"x0":179.31,"x1":179.31,"x2":181.47,"x3":181.47,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":40},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_40.png"},"t":"pic"},{"c":{"ix":0,"iy":1335,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":181.47,"x0":181.47,"x1":181.47,"x2":183.63,"x3":183.63,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":41},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_41.png"},"t":"pic"},{"c":{"ix":0,"iy":1342,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":183.63,"x0":183.63,"x1":183.63,"x2":185.79,"x3":185.79,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":42},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_42.png"},"t":"pic"},{"c":{"ix":0,"iy":1349,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":185.79,"x0":185.79,"x1":185.79,"x2":187.95,"x3":187.95,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":43},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_43.png"},"t":"pic"},{"c":{"ix":0,"iy":1356,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":187.95,"x0":187.95,"x1":187.95,"x2":190.109,"x3":190.109,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":44},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_44.png"},"t":"pic"},{"c":{"ix":0,"iy":1363,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":190.11,"x0":190.11,"x1":190.11,"x2":192.27,"x3":192.27,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":45},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_45.png"},"t":"pic"},{"c":{"ix":0,"iy":1370,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":192.27,"x0":192.27,"x1":192.27,"x2":194.43,"x3":194.43,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":46},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_46.png"},"t":"pic"},{"c":{"ix":0,"iy":1377,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":194.43,"x0":194.43,"x1":194.43,"x2":196.59,"x3":196.59,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":47},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_47.png"},"t":"pic"},{"c":{"ix":0,"iy":1384,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":196.59,"x0":196.59,"x1":196.59,"x2":198.75,"x3":198.75,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":48},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_48.png"},"t":"pic"},{"c":{"ix":0,"iy":1391,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":198.75,"x0":198.75,"x1":198.75,"x2":200.91,"x3":200.91,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":49},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_49.png"},"t":"pic"},{"c":{"ix":0,"iy":1398,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":200.91,"x0":200.91,"x1":200.91,"x2":203.07,"x3":203.07,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":50},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_50.png"},"t":"pic"},{"c":{"ix":0,"iy":1405,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":203.07,"x0":203.07,"x1":203.07,"x2":205.23,"x3":205.23,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":51},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_51.png"},"t":"pic"},{"c":{"ix":0,"iy":1412,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":205.23,"x0":205.23,"x1":205.23,"x2":207.39,"x3":207.39,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":52},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_52.png"},"t":"pic"},{"c":{"ix":0,"iy":1419,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":207.39,"x0":207.39,"x1":207.39,"x2":209.549,"x3":209.549,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":53},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_53.png"},"t":"pic"},{"c":{"ix":0,"iy":1426,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":209.549,"x0":209.549,"x1":209.549,"x2":211.709,"x3":211.709,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":54},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_54.png"},"t":"pic"},{"c":{"ix":0,"iy":1433,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":211.709,"x0":211.709,"x1":211.709,"x2":213.869,"x3":213.869,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":55},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_55.png"},"t":"pic"},{"c":{"ix":0,"iy":1440,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":213.87,"x0":213.87,"x1":213.87,"x2":216.03,"x3":216.03,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":56},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_56.png"},"t":"pic"},{"c":{"ix":0,"iy":1447,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":216.03,"x0":216.03,"x1":216.03,"x2":218.19,"x3":218.19,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":57},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_57.png"},"t":"pic"},{"c":{"ix":0,"iy":1454,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":218.19,"x0":218.19,"x1":218.19,"x2":220.35,"x3":220.35,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":58},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_58.png"},"t":"pic"},{"c":{"ix":0,"iy":1461,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":220.35,"x0":220.35,"x1":220.35,"x2":222.51,"x3":222.51,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":59},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_59.png"},"t":"pic"},{"c":{"ix":0,"iy":1468,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":222.51,"x0":222.51,"x1":222.51,"x2":224.67,"x3":224.67,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":60},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_60.png"},"t":"pic"},{"c":{"ix":0,"iy":1475,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":224.67,"x0":224.67,"x1":224.67,"x2":226.83,"x3":226.83,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":61},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_61.png"},"t":"pic"},{"c":{"ix":0,"iy":1482,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":226.829,"x0":226.829,"x1":226.829,"x2":228.989,"x3":228.989,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":62},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_62.png"},"t":"pic"},{"c":{"ix":0,"iy":1489,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":228.99,"x0":228.99,"x1":228.99,"x2":231.15,"x3":231.15,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":63},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_63.png"},"t":"pic"},{"c":{"ix":0,"iy":1496,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":231.149,"x0":231.149,"x1":231.149,"x2":233.309,"x3":233.309,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":64},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_64.png"},"t":"pic"},{"c":{"ix":0,"iy":1503,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":233.31,"x0":233.31,"x1":233.31,"x2":235.47,"x3":235.47,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":65},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_65.png"},"t":"pic"},{"c":{"ix":0,"iy":1510,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":235.47,"x0":235.47,"x1":235.47,"x2":237.63,"x3":237.63,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":66},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_66.png"},"t":"pic"},{"c":{"ix":0,"iy":1517,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":237.63,"x0":237.63,"x1":237.63,"x2":239.79,"x3":239.79,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":67},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_67.png"},"t":"pic"},{"c":{"ix":0,"iy":1524,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.195,"x":239.79,"x0":239.79,"x1":239.79,"x2":241.986,"x3":241.986,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":68},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_68.png"},"t":"pic"},{"c":{"ix":0,"iy":1531,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":241.995,"x0":241.995,"x1":241.995,"x2":244.155,"x3":244.155,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":69},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_69.png"},"t":"pic"},{"c":{"ix":0,"iy":1538,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":244.154,"x0":244.154,"x1":244.154,"x2":246.314,"x3":246.314,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":70},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_70.png"},"t":"pic"},{"c":{"ix":0,"iy":1545,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":246.314,"x0":246.314,"x1":246.314,"x2":248.474,"x3":248.474,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":71},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_71.png"},"t":"pic"},{"c":{"ix":0,"iy":1552,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":248.475,"x0":248.475,"x1":248.475,"x2":250.635,"x3":250.635,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":72},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_72.png"},"t":"pic"},{"c":{"ix":0,"iy":1559,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":250.635,"x0":250.635,"x1":250.635,"x2":252.795,"x3":252.795,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":73},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_73.png"},"t":"pic"},{"c":{"ix":0,"iy":1566,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":252.795,"x0":252.795,"x1":252.795,"x2":254.955,"x3":254.955,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":74},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_74.png"},"t":"pic"},{"c":{"ix":0,"iy":1573,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":254.954,"x0":254.954,"x1":254.954,"x2":257.115,"x3":257.115,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":75},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_75.png"},"t":"pic"},{"c":{"ix":0,"iy":1580,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":257.115,"x0":257.115,"x1":257.115,"x2":259.275,"x3":259.275,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":76},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_76.png"},"t":"pic"},{"c":{"ix":0,"iy":1587,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":259.275,"x0":259.275,"x1":259.275,"x2":261.435,"x3":261.435,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":77},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_77.png"},"t":"pic"},{"c":{"ix":0,"iy":1594,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":261.435,"x0":261.435,"x1":261.435,"x2":263.595,"x3":263.595,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":78},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_78.png"},"t":"pic"},{"c":{"ix":0,"iy":1601,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":263.594,"x0":263.594,"x1":263.594,"x2":265.755,"x3":265.755,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":79},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_79.png"},"t":"pic"},{"c":{"ix":0,"iy":1608,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":265.755,"x0":265.755,"x1":265.755,"x2":267.915,"x3":267.915,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":80},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_80.png"},"t":"pic"},{"c":{"ix":0,"iy":1615,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":267.914,"x0":267.914,"x1":267.914,"x2":270.075,"x3":270.075,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":81},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_81.png"},"t":"pic"},{"c":{"ix":0,"iy":1622,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":270.075,"x0":270.075,"x1":270.075,"x2":272.235,"x3":272.235,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":82},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_82.png"},"t":"pic"},{"c":{"ix":0,"iy":1629,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":272.235,"x0":272.235,"x1":272.235,"x2":274.395,"x3":274.395,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":83},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_83.png"},"t":"pic"},{"c":{"ix":0,"iy":1636,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":274.395,"x0":274.395,"x1":274.395,"x2":276.555,"x3":276.555,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":84},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_84.png"},"t":"pic"},{"c":{"ix":0,"iy":1643,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":276.555,"x0":276.555,"x1":276.555,"x2":278.715,"x3":278.715,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":85},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_85.png"},"t":"pic"},{"c":{"ix":0,"iy":1650,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":278.715,"x0":278.715,"x1":278.715,"x2":280.875,"x3":280.875,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":86},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_86.png"},"t":"pic"},{"c":{"ix":0,"iy":1657,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":280.875,"x0":280.875,"x1":280.875,"x2":283.035,"x3":283.035,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":87},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_87.png"},"t":"pic"},{"c":{"ix":0,"iy":1664,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":283.034,"x0":283.034,"x1":283.034,"x2":285.195,"x3":285.195,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":88},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_88.png"},"t":"pic"},{"c":{"ix":0,"iy":1671,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":285.195,"x0":285.195,"x1":285.195,"x2":287.355,"x3":287.355,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":89},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_89.png"},"t":"pic"},{"c":{"ix":0,"iy":1678,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":287.355,"x0":287.355,"x1":287.355,"x2":289.515,"x3":289.515,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":90},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_90.png"},"t":"pic"},{"c":{"ix":0,"iy":1685,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":289.515,"x0":289.515,"x1":289.515,"x2":291.675,"x3":291.675,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":91},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_91.png"},"t":"pic"},{"c":{"ix":0,"iy":1692,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":291.675,"x0":291.675,"x1":291.675,"x2":293.835,"x3":293.835,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":92},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_92.png"},"t":"pic"},{"c":{"ix":0,"iy":1699,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":293.835,"x0":293.835,"x1":293.835,"x2":295.995,"x3":295.995,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":93},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_93.png"},"t":"pic"},{"c":{"ix":0,"iy":1706,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":295.995,"x0":295.995,"x1":295.995,"x2":298.155,"x3":298.155,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":94},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_94.png"},"t":"pic"},{"c":{"ix":0,"iy":1713,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":298.155,"x0":298.155,"x1":298.155,"x2":300.315,"x3":300.315,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":95},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_95.png"},"t":"pic"},{"c":{"ix":0,"iy":1720,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":300.314,"x0":300.314,"x1":300.314,"x2":302.474,"x3":302.474,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":96},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_96.png"},"t":"pic"},{"c":{"ix":0,"iy":1727,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":302.475,"x0":302.475,"x1":302.475,"x2":304.635,"x3":304.635,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":97},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_97.png"},"t":"pic"},{"c":{"ix":0,"iy":1734,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":304.635,"x0":304.635,"x1":304.635,"x2":306.795,"x3":306.795,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":98},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_98.png"},"t":"pic"},{"c":{"ix":0,"iy":1741,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":306.795,"x0":306.795,"x1":306.795,"x2":308.955,"x3":308.955,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":99},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_99.png"},"t":"pic"},{"c":{"ix":0,"iy":1748,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":308.955,"x0":308.955,"x1":308.955,"x2":311.115,"x3":311.115,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":100},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_100.png"},"t":"pic"},{"c":{"ix":0,"iy":1755,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":311.115,"x0":311.115,"x1":311.115,"x2":313.275,"x3":313.275,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":101},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_101.png"},"t":"pic"},{"c":{"ix":0,"iy":1762,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":313.275,"x0":313.275,"x1":313.275,"x2":315.435,"x3":315.435,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":102},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_102.png"},"t":"pic"},{"c":{"ix":0,"iy":1769,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":315.435,"x0":315.435,"x1":315.435,"x2":317.595,"x3":317.595,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":103},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_103.png"},"t":"pic"},{"c":{"ix":0,"iy":1776,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":317.594,"x0":317.594,"x1":317.594,"x2":319.755,"x3":319.755,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":104},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_104.png"},"t":"pic"},{"c":{"ix":0,"iy":1783,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":319.755,"x0":319.755,"x1":319.755,"x2":321.915,"x3":321.915,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":105},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_105.png"},"t":"pic"},{"c":{"ix":0,"iy":1790,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":321.914,"x0":321.914,"x1":321.914,"x2":324.075,"x3":324.075,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":106},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_106.png"},"t":"pic"},{"c":{"ix":0,"iy":1797,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":324.075,"x0":324.075,"x1":324.075,"x2":326.235,"x3":326.235,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":107},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_107.png"},"t":"pic"},{"c":{"ix":0,"iy":1804,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":326.235,"x0":326.235,"x1":326.235,"x2":328.395,"x3":328.395,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":108},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_108.png"},"t":"pic"},{"c":{"ix":0,"iy":1811,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":328.395,"x0":328.395,"x1":328.395,"x2":330.555,"x3":330.555,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":109},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_109.png"},"t":"pic"},{"c":{"ix":0,"iy":1818,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":330.555,"x0":330.555,"x1":330.555,"x2":332.715,"x3":332.715,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":110},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_110.png"},"t":"pic"},{"c":{"ix":0,"iy":1825,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":332.715,"x0":332.715,"x1":332.715,"x2":334.875,"x3":334.875,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":111},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_111.png"},"t":"pic"},{"c":{"ix":0,"iy":1832,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":334.875,"x0":334.875,"x1":334.875,"x2":337.035,"x3":337.035,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":112},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_112.png"},"t":"pic"},{"c":{"ix":0,"iy":1839,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":337.034,"x0":337.034,"x1":337.034,"x2":339.195,"x3":339.195,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":113},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_113.png"},"t":"pic"},{"c":{"ix":0,"iy":1846,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":339.195,"x0":339.195,"x1":339.195,"x2":341.355,"x3":341.355,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":114},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_114.png"},"t":"pic"},{"c":{"ix":0,"iy":1853,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":341.355,"x0":341.355,"x1":341.355,"x2":343.515,"x3":343.515,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":115},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_115.png"},"t":"pic"},{"c":{"ix":0,"iy":1860,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":343.515,"x0":343.515,"x1":343.515,"x2":345.675,"x3":345.675,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":116},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_116.png"},"t":"pic"},{"c":{"ix":0,"iy":1867,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":345.675,"x0":345.675,"x1":345.675,"x2":347.835,"x3":347.835,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":117},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_117.png"},"t":"pic"},{"c":{"ix":0,"iy":1874,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":347.835,"x0":347.835,"x1":347.835,"x2":349.995,"x3":349.995,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":118},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_118.png"},"t":"pic"},{"c":{"ix":0,"iy":1881,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":349.995,"x0":349.995,"x1":349.995,"x2":352.155,"x3":352.155,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":119},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_119.png"},"t":"pic"},{"c":{"ix":0,"iy":1888,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":352.155,"x0":352.155,"x1":352.155,"x2":354.315,"x3":354.315,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":120},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_120.png"},"t":"pic"},{"c":{"ix":0,"iy":1895,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":354.314,"x0":354.314,"x1":354.314,"x2":356.474,"x3":356.474,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":121},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_121.png"},"t":"pic"},{"c":{"ix":0,"iy":1902,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":356.475,"x0":356.475,"x1":356.475,"x2":358.635,"x3":358.635,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":122},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_122.png"},"t":"pic"},{"c":{"ix":0,"iy":1909,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":358.635,"x0":358.635,"x1":358.635,"x2":360.795,"x3":360.795,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":123},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_123.png"},"t":"pic"},{"c":{"ix":0,"iy":1916,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":360.795,"x0":360.795,"x1":360.795,"x2":362.955,"x3":362.955,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":124},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_124.png"},"t":"pic"},{"c":{"ix":0,"iy":1923,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":362.955,"x0":362.955,"x1":362.955,"x2":365.115,"x3":365.115,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":125},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_125.png"},"t":"pic"},{"c":{"ix":0,"iy":1930,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":365.115,"x0":365.115,"x1":365.115,"x2":367.275,"x3":367.275,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":126},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_126.png"},"t":"pic"},{"c":{"ix":0,"iy":1937,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":367.275,"x0":367.275,"x1":367.275,"x2":369.435,"x3":369.435,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":127},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_127.png"},"t":"pic"},{"c":{"ix":0,"iy":1944,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":369.435,"x0":369.435,"x1":369.435,"x2":371.595,"x3":371.595,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":128},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_128.png"},"t":"pic"},{"c":{"ix":0,"iy":1951,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":371.594,"x0":371.594,"x1":371.594,"x2":373.755,"x3":373.755,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":129},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_129.png"},"t":"pic"},{"c":{"ix":0,"iy":1958,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":373.755,"x0":373.755,"x1":373.755,"x2":375.915,"x3":375.915,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":130},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_130.png"},"t":"pic"},{"c":{"ix":0,"iy":1965,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":375.914,"x0":375.914,"x1":375.914,"x2":378.075,"x3":378.075,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":131},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_131.png"},"t":"pic"},{"c":{"ix":0,"iy":1972,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":378.075,"x0":378.075,"x1":378.075,"x2":380.235,"x3":380.235,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":132},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_132.png"},"t":"pic"},{"c":{"ix":0,"iy":1979,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":380.235,"x0":380.235,"x1":380.235,"x2":382.395,"x3":382.395,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":133},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_133.png"},"t":"pic"},{"c":{"ix":0,"iy":1986,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":382.395,"x0":382.395,"x1":382.395,"x2":384.555,"x3":384.555,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":134},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_134.png"},"t":"pic"},{"c":{"ix":0,"iy":1993,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":384.555,"x0":384.555,"x1":384.555,"x2":386.715,"x3":386.715,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":135},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_135.png"},"t":"pic"},{"c":{"ix":0,"iy":201*,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":386.715,"x0":386.715,"x1":386.715,"x2":388.875,"x3":388.875,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":136},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_136.png"},"t":"pic"},{"c":{"ix":0,"iy":201*,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":388.875,"x0":388.875,"x1":388.875,"x2":391.035,"x3":391.035,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":137},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_137.png"},"t":"pic"},{"c":{"ix":0,"iy":201*,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":391.034,"x0":391.034,"x1":391.034,"x2":393.195,"x3":393.195,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":138},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_138.png"},"t":"pic"},{"c":{"ix":0,"iy":2021,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":393.195,"x0":393.195,"x1":393.195,"x2":395.355,"x3":395.355,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":139},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_139.png"},"t":"pic"},{"c":{"ix":0,"iy":2028,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":395.355,"x0":395.355,"x1":395.355,"x2":397.515,"x3":397.515,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":140},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_140.png"},"t":"pic"},{"c":{"ix":0,"iy":2035,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":397.515,"x0":397.515,"x1":397.515,"x2":399.675,"x3":399.675,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":141},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_141.png"},"t":"pic"},{"c":{"ix":0,"iy":2042,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.196,"x":399.674,"x0":399.674,"x1":399.674,"x2":401.871,"x3":401.871,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":142},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_142.png"},"t":"pic"},{"c":{"ix":0,"iy":2049,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":401.864,"x0":401.864,"x1":401.864,"x2":404.025,"x3":404.025,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":143},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_143.png"},"t":"pic"},{"c":{"ix":0,"iy":2056,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":404.025,"x0":404.025,"x1":404.025,"x2":406.185,"x3":406.185,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":144},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_144.png"},"t":"pic"},{"c":{"ix":0,"iy":2063,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":406.184,"x0":406.184,"x1":406.184,"x2":408.344,"x3":408.344,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":145},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_145.png"},"t":"pic"},{"c":{"ix":0,"iy":2070,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":408.344,"x0":408.344,"x1":408.344,"x2":410.504,"x3":410.504,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":146},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_146.png"},"t":"pic"},{"c":{"ix":0,"iy":2077,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":410.505,"x0":410.505,"x1":410.505,"x2":412.665,"x3":412.665,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":147},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_147.png"},"t":"pic"},{"c":{"ix":0,"iy":2084,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":412.665,"x0":412.665,"x1":412.665,"x2":414.825,"x3":414.825,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":148},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_148.png"},"t":"pic"},{"c":{"ix":0,"iy":2091,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":414.825,"x0":414.825,"x1":414.825,"x2":416.985,"x3":416.985,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":149},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_149.png"},"t":"pic"},{"c":{"ix":0,"iy":2098,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":416.984,"x0":416.984,"x1":416.984,"x2":419.144,"x3":419.144,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":150},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_150.png"},"t":"pic"},{"c":{"ix":0,"iy":2105,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":419.144,"x0":419.144,"x1":419.144,"x2":421.304,"x3":421.304,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":151},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_151.png"},"t":"pic"},{"c":{"ix":0,"iy":2112,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":421.305,"x0":421.305,"x1":421.305,"x2":423.465,"x3":423.465,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":152},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_152.png"},"t":"pic"},{"c":{"ix":0,"iy":2119,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":423.465,"x0":423.465,"x1":423.465,"x2":425.625,"x3":425.625,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":153},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_153.png"},"t":"pic"},{"c":{"ix":0,"iy":2126,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":425.625,"x0":425.625,"x1":425.625,"x2":427.785,"x3":427.785,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":154},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_154.png"},"t":"pic"},{"c":{"ix":0,"iy":2133,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":427.784,"x0":427.784,"x1":427.784,"x2":429.945,"x3":429.945,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":155},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_155.png"},"t":"pic"},{"c":{"ix":0,"iy":2140,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":429.945,"x0":429.945,"x1":429.945,"x2":432.105,"x3":432.105,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":156},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_156.png"},"t":"pic"},{"c":{"ix":0,"iy":2147,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":432.105,"x0":432.105,"x1":432.105,"x2":434.265,"x3":434.265,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":157},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_157.png"},"t":"pic"},{"c":{"ix":0,"iy":2154,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":434.265,"x0":434.265,"x1":434.265,"x2":436.425,"x3":436.425,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":158},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_158.png"},"t":"pic"},{"c":{"ix":0,"iy":2161,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":436.424,"x0":436.424,"x1":436.424,"x2":438.585,"x3":438.585,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":159},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_159.png"},"t":"pic"},{"c":{"ix":0,"iy":2168,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":438.585,"x0":438.585,"x1":438.585,"x2":440.745,"x3":440.745,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":160},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_160.png"},"t":"pic"},{"c":{"ix":0,"iy":2175,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":440.745,"x0":440.745,"x1":440.745,"x2":442.905,"x3":442.905,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":161},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_161.png"},"t":"pic"},{"c":{"ix":0,"iy":2182,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":442.905,"x0":442.905,"x1":442.905,"x2":445.065,"x3":445.065,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":162},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_162.png"},"t":"pic"},{"c":{"ix":0,"iy":2189,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":445.064,"x0":445.064,"x1":445.064,"x2":447.224,"x3":447.224,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":163},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_163.png"},"t":"pic"},{"c":{"ix":0,"iy":2196,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":447.225,"x0":447.225,"x1":447.225,"x2":449.385,"x3":449.385,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":164},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_164.png"},"t":"pic"},{"c":{"ix":0,"iy":2203,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":449.385,"x0":449.385,"x1":449.385,"x2":451.545,"x3":451.545,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":165},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_165.png"},"t":"pic"},{"c":{"ix":0,"iy":2210,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":451.544,"x0":451.544,"x1":451.544,"x2":453.705,"x3":453.705,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":166},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_166.png"},"t":"pic"},{"c":{"ix":0,"iy":2217,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":453.704,"x0":453.704,"x1":453.704,"x2":455.864,"x3":455.864,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":167},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_167.png"},"t":"pic"},{"c":{"ix":0,"iy":2224,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":455.864,"x0":455.864,"x1":455.864,"x2":458.025,"x3":458.025,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":168},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_168.png"},"t":"pic"},{"c":{"ix":0,"iy":2231,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":458.025,"x0":458.025,"x1":458.025,"x2":460.185,"x3":460.185,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":169},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_169.png"},"t":"pic"},{"c":{"ix":0,"iy":2238,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":460.184,"x0":460.184,"x1":460.184,"x2":462.344,"x3":462.344,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":170},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_170.png"},"t":"pic"},{"c":{"ix":0,"iy":2245,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":462.344,"x0":462.344,"x1":462.344,"x2":464.504,"x3":464.504,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":171},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_171.png"},"t":"pic"},{"c":{"ix":0,"iy":2252,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":464.505,"x0":464.505,"x1":464.505,"x2":466.665,"x3":466.665,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":172},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_172.png"},"t":"pic"},{"c":{"ix":0,"iy":2259,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":466.665,"x0":466.665,"x1":466.665,"x2":468.825,"x3":468.825,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":173},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_173.png"},"t":"pic"},{"c":{"ix":0,"iy":2266,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":468.825,"x0":468.825,"x1":468.825,"x2":470.985,"x3":470.985,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":174},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_174.png"},"t":"pic"},{"c":{"ix":0,"iy":2273,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":470.984,"x0":470.984,"x1":470.984,"x2":473.144,"x3":473.144,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":175},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_175.png"},"t":"pic"},{"c":{"ix":0,"iy":2280,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":473.144,"x0":473.144,"x1":473.144,"x2":475.304,"x3":475.304,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":176},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_176.png"},"t":"pic"},{"c":{"ix":0,"iy":2287,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":475.305,"x0":475.305,"x1":475.305,"x2":477.465,"x3":477.465,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":177},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_177.png"},"t":"pic"},{"c":{"ix":0,"iy":2294,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":477.465,"x0":477.465,"x1":477.465,"x2":479.625,"x3":479.625,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":178},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_178.png"},"t":"pic"},{"c":{"ix":0,"iy":2301,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":479.625,"x0":479.625,"x1":479.625,"x2":481.785,"x3":481.785,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":179},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_179.png"},"t":"pic"},{"c":{"ix":0,"iy":2308,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":481.784,"x0":481.784,"x1":481.784,"x2":483.945,"x3":483.945,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":180},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_180.png"},"t":"pic"},{"c":{"ix":0,"iy":2315,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":483.945,"x0":483.945,"x1":483.945,"x2":486.105,"x3":486.105,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":181},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_181.png"},"t":"pic"},{"c":{"ix":0,"iy":2322,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":486.105,"x0":486.105,"x1":486.105,"x2":488.265,"x3":488.265,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":182},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_182.png"},"t":"pic"},{"c":{"ix":0,"iy":2329,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":488.265,"x0":488.265,"x1":488.265,"x2":490.425,"x3":490.425,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":183},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_183.png"},"t":"pic"},{"c":{"ix":0,"iy":2336,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":490.424,"x0":490.424,"x1":490.424,"x2":492.585,"x3":492.585,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":184},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_184.png"},"t":"pic"},{"c":{"ix":0,"iy":2343,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":492.585,"x0":492.585,"x1":492.585,"x2":494.745,"x3":494.745,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":185},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_185.png"},"t":"pic"},{"c":{"ix":0,"iy":2350,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":494.745,"x0":494.745,"x1":494.745,"x2":496.905,"x3":496.905,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":186},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_186.png"},"t":"pic"},{"c":{"ix":0,"iy":2357,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":496.905,"x0":496.905,"x1":496.905,"x2":499.065,"x3":499.065,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":187},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_187.png"},"t":"pic"},{"c":{"ix":0,"iy":2364,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":499.064,"x0":499.064,"x1":499.064,"x2":501.224,"x3":501.224,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":188},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_188.png"},"t":"pic"},{"c":{"ix":0,"iy":2371,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":501.225,"x0":501.225,"x1":501.225,"x2":503.385,"x3":503.385,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":189},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_189.png"},"t":"pic"},{"c":{"ix":0,"iy":2378,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":503.385,"x0":503.385,"x1":503.385,"x2":505.545,"x3":505.545,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":190},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_190.png"},"t":"pic"},{"c":{"ix":0,"iy":2385,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":505.544,"x0":505.544,"x1":505.544,"x2":507.705,"x3":507.705,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":191},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_191.png"},"t":"pic"},{"c":{"ix":0,"iy":2392,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":507.704,"x0":507.704,"x1":507.704,"x2":509.864,"x3":509.864,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":192},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_192.png"},"t":"pic"},{"c":{"ix":0,"iy":2399,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.16,"x":509.864,"x0":509.864,"x1":509.864,"x2":512.025,"x3":512.025,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":193},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_193.png"},"t":"pic"},{"c":{"ix":0,"iy":2406,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":512.025,"x0":512.025,"x1":512.025,"x2":514.185,"x3":514.185,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":194},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_194.png"},"t":"pic"},{"c":{"ix":0,"iy":2413,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":514.184,"x0":514.184,"x1":514.184,"x2":516.344,"x3":516.344,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":195},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_195.png"},"t":"pic"},{"c":{"ix":0,"iy":2420,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":516.344,"x0":516.344,"x1":516.344,"x2":518.504,"x3":518.504,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":196},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_196.png"},"t":"pic"},{"c":{"ix":0,"iy":2427,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":518.505,"x0":518.505,"x1":518.505,"x2":520.664,"x3":520.664,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":197},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_197.png"},"t":"pic"},{"c":{"ix":0,"iy":2434,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":520.664,"x0":520.664,"x1":520.664,"x2":522.824,"x3":522.824,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":198},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_198.png"},"t":"pic"},{"c":{"ix":0,"iy":2441,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":522.825,"x0":522.825,"x1":522.825,"x2":524.985,"x3":524.985,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":199},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_199.png"},"t":"pic"},{"c":{"ix":0,"iy":2448,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":524.984,"x0":524.984,"x1":524.984,"x2":527.144,"x3":527.144,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":200},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_200.png"},"t":"pic"},{"c":{"ix":0,"iy":2455,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":527.145,"x0":527.145,"x1":527.145,"x2":529.305,"x3":529.305,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":201},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_201.png"},"t":"pic"},{"c":{"ix":0,"iy":2462,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":529.305,"x0":529.305,"x1":529.305,"x2":531.465,"x3":531.465,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":202},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_202.png"},"t":"pic"},{"c":{"ix":0,"iy":2469,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":531.465,"x0":531.465,"x1":531.465,"x2":533.625,"x3":533.625,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":203},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_203.png"},"t":"pic"},{"c":{"ix":0,"iy":2476,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":533.625,"x0":533.625,"x1":533.625,"x2":535.785,"x3":535.785,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":204},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_204.png"},"t":"pic"},{"c":{"ix":0,"iy":2483,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":535.785,"x0":535.785,"x1":535.785,"x2":537.944,"x3":537.944,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":205},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_205.png"},"t":"pic"},{"c":{"ix":0,"iy":2490,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":537.944,"x0":537.944,"x1":537.944,"x2":540.104,"x3":540.104,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":206},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_206.png"},"t":"pic"},{"c":{"ix":0,"iy":2497,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":540.105,"x0":540.105,"x1":540.105,"x2":542.265,"x3":542.265,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":207},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_207.png"},"t":"pic"},{"c":{"ix":0,"iy":2504,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":542.265,"x0":542.265,"x1":542.265,"x2":544.425,"x3":544.425,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":208},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_208.png"},"t":"pic"},{"c":{"ix":0,"iy":2511,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":544.425,"x0":544.425,"x1":544.425,"x2":546.584,"x3":546.584,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":209},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_209.png"},"t":"pic"},{"c":{"ix":0,"iy":2518,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":546.585,"x0":546.585,"x1":546.585,"x2":548.745,"x3":548.745,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":210},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_210.png"},"t":"pic"},{"c":{"ix":0,"iy":2525,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":548.745,"x0":548.745,"x1":548.745,"x2":550.905,"x3":550.905,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":211},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_211.png"},"t":"pic"},{"c":{"ix":0,"iy":2532,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":550.905,"x0":550.905,"x1":550.905,"x2":553.064,"x3":553.064,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":212},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//95671653//95671653_20_212.png"},"t":"pic"},{"c":{"ix":0,"iy":2539,"iw":4,"ih":2},"p":{"h":2,"opacity":1,"rotate":0,"w":2.159,"x":553.064,"x0":553.064,"x1":553.064,"x2":555.224,"x3":555.224,"y":177.869,"y0":178.949,"y1":177.869,"y2":177.869,"y3":178.949,"z":213},"ps":null,"s":{"pic_fileYes/No邏輯字段,可以顯示為Yes/No、True/False或On/Off。在代碼中,使用常量True和False(等價(jià)于1和0)注釋:Yes/No字段中不允許Null值1比特OleObjectHyperlinkLookupWizard可以存儲(chǔ)圖片、音頻、視頻或其他BLOBs(BinaryLargeOBjects)包含指向其他文件的鏈接,包括網(wǎng)頁。允許你創(chuàng)建一個(gè)可從下列列表中進(jìn)行選擇的選項(xiàng)列表。最多1GB4字節(jié)MySQL數(shù)據(jù)類型
在MySQL中,有三種主要的類型:文本、數(shù)字和日期/時(shí)間類型。Text類型:數(shù)據(jù)類型CHAR(size)描述保存固定長(zhǎng)度的字符串(可包含字母、數(shù)字以及特殊字符)。在括號(hào)中指定字符串的長(zhǎng)度。最多255個(gè)字符。VARCHAR(size)保存可變長(zhǎng)度的字符串(可包含字母、數(shù)字以及特殊字符)。在括號(hào)中指定字符串的最大長(zhǎng)度。最多255個(gè)字符。注釋:如果值的長(zhǎng)度大于255,則被轉(zhuǎn)換為TEXT類型。TINYTEXTTEXTBLOBMEDIUMTEXTMEDIUMBLOBLONGTEXTLONGBLOBENUM(x,y,z,etc.)存放最大長(zhǎng)度為255個(gè)字符的字符串。存放最大長(zhǎng)度為65,535個(gè)字符的字符串。用于BLOBs(BinaryLargeOBjects)。存放最多65,535字節(jié)的數(shù)據(jù)。存放最大長(zhǎng)度為16,777,215個(gè)字符的字符串。用于BLOBs(BinaryLargeOBjects)。存放最多16,777,215字節(jié)的數(shù)據(jù)。存放最大長(zhǎng)度為4,294,967,295個(gè)字符的字符串。用于BLOBs(BinaryLargeOBjects)。存放最多4,294,967,295字節(jié)的數(shù)據(jù)。允許你輸入可能值的列表?梢栽贓NUM列表中列出最大65535個(gè)值。如果列表中不存在插入的值,則插入空值。注釋:這些值是按照你輸入的順序存儲(chǔ)的?梢园凑沾烁袷捷斎肟赡艿闹担篍NUM("X","Y","Z")SET與ENUM類似,SET最多只能包含64個(gè)列表項(xiàng),不過SET可存儲(chǔ)一個(gè)以上的值。Number類型:數(shù)據(jù)類型TINYINT(size)SMALLINT(size)MEDIUMINT(size)INT(size)描述-128到127常規(guī)。0到255無符號(hào)*。在括號(hào)中規(guī)定最大位數(shù)。-32768到32767常規(guī)。0到65535無符號(hào)*。在括號(hào)中規(guī)定最大位數(shù)。-8388608到8388607普通。0to16777215無符號(hào)*。在括號(hào)中規(guī)定最大位數(shù)。-2147483648到2147483647常規(guī)。0到4294967295無符號(hào)*。在括號(hào)中規(guī)定最大位數(shù)。BIGINT(size)-9223372036854775808到9223372036854775807常規(guī)。0到18446744073709551615無符號(hào)*。在括號(hào)中規(guī)定最大位數(shù)。FLOAT(size,d)帶有浮動(dòng)小數(shù)點(diǎn)的小數(shù)字。在括號(hào)中規(guī)定最大位數(shù)。在d參數(shù)中規(guī)定小數(shù)點(diǎn)右側(cè)的最大位數(shù)。DOUBLE(size,d)帶有浮動(dòng)小數(shù)點(diǎn)的大數(shù)字。在括號(hào)中規(guī)定最大位數(shù)。在d參數(shù)中規(guī)定小數(shù)點(diǎn)右側(cè)的最大位數(shù)。DECIMAL(size,d)作為字符串存儲(chǔ)的DOUBLE類型,允許固定的小數(shù)點(diǎn)。*這些整數(shù)類型擁有額外的選項(xiàng)UNSIGNED。通常,整數(shù)可以是負(fù)數(shù)或正數(shù)。如果添加UNSIGNED屬性,那么范圍將從0開始,而不是某個(gè)負(fù)數(shù)。Date類型:數(shù)據(jù)類型DATE()描述日期。格式:YYYY-MM-DD注釋:支持的范圍是從"1000-01-01"到"9999-12-31"DATETIME()*日期和時(shí)間的組合。格式:YYYY-MM-DDHH:MM:SS注釋:支持的范圍是從"1000-01-0100:00:00"到"9999-12-3123:59:59"TIMESTAMP()*時(shí)間戳。TIMESTAMP值使用Unix紀(jì)元("1970-01-0100:00:00"UTC)至今的描述來存儲(chǔ)。格式:YYYY-MM-DDHH:MM:SS注釋:支持的范圍是從"1970-01-0100:00:01"UTC到"2038-01-0903:14:07"UTCTIME()YEAR()時(shí)間。格式:HH:MM:SS注釋:支持的范圍是從"-838:59:59"到"838:59:59"2位或4位格式的年。注釋:4位格式所允許的值:1901到2155。2位格式所允許的值:70到69,表示從1970到2069。*即便DATETIME和TIMESTAMP返回相同的格式,它們的工作方式很不同。在INSERT或UPDATE查詢中,TIMESTAMP自動(dòng)把自身設(shè)置為當(dāng)前的日期和時(shí)間。TIMESTAMP也接受不同的格式,比如YYYYMMDDHHMMSS、YYMMDDHHMMSS、YYYYMMDD或YYMMDD。
SQLServer數(shù)據(jù)類型
Character字符串:數(shù)據(jù)類型char(n)varchar(n)varchar(max)textUnicode字符串:數(shù)據(jù)類型nchar(n)nvarchar(n)nvarchar(max)ntextBinary類型:數(shù)據(jù)類型bit描述允許0、1或NULL存儲(chǔ)描述固定長(zhǎng)度的Unicode數(shù)據(jù)。最多4,000個(gè)字符?勺冮L(zhǎng)度的Unicode數(shù)據(jù)。最多4,000個(gè)字符?勺冮L(zhǎng)度的Unicode數(shù)據(jù)。最多536,870,912個(gè)字符?勺冮L(zhǎng)度的Unicode數(shù)據(jù)。最多2GB字符數(shù)據(jù)。存儲(chǔ)描述固定長(zhǎng)度的字符串。最多8,000個(gè)字符。可變長(zhǎng)度的字符串。最多8,000個(gè)字符?勺冮L(zhǎng)度的字符串。最多1,073,741,824個(gè)字符?勺冮L(zhǎng)度的字符串。最多2GB字符數(shù)據(jù)。存儲(chǔ)nbinary(n)varbinary(n)varbinary(max)imageNumber類型:數(shù)據(jù)類型
tinyintsmallintintbigint
描述
固定長(zhǎng)度的二進(jìn)制數(shù)據(jù)。最多8,000字節(jié)?勺冮L(zhǎng)度的二進(jìn)制數(shù)據(jù)。最多8,000字節(jié)?勺冮L(zhǎng)度的二進(jìn)制數(shù)據(jù)。最多2GB字節(jié)?勺冮L(zhǎng)度的二進(jìn)制數(shù)據(jù)。最多2GB。存儲(chǔ)
允許從0到255的所有數(shù)字。允許從-32,768到32,767的所有數(shù)字。
1字節(jié)2字節(jié)4字節(jié)8字節(jié)
允許從-2,147,483,648到2,147,483,647的所有數(shù)字。
允許介于-9,223,372,036,854,775,808和9,223,372,036,854,775,807之間的所有數(shù)字。
decimal(p,s)
固定精度和比例的數(shù)字。允許從-10^38+1到10^38-1之間的數(shù)
字。
p參數(shù)指示可以存儲(chǔ)的最大位數(shù)(小數(shù)點(diǎn)左側(cè)和右側(cè))。p必須是1
到38之間的值。默認(rèn)是18。
s參數(shù)指示小數(shù)點(diǎn)右側(cè)存儲(chǔ)的最大位數(shù)。s必須是0到p之間的
值。默認(rèn)是0。
5-17字節(jié)
numeric(p,s)
固定精度和比例的數(shù)字。允許從-10^38+1到10^38-1之間的數(shù)
字。
p參數(shù)指示可以存儲(chǔ)的最大位數(shù)(小數(shù)點(diǎn)左側(cè)和右側(cè))。p必須是1
到38之間的值。默認(rèn)是18。
s參數(shù)指示小數(shù)點(diǎn)右側(cè)存儲(chǔ)的最大位數(shù)。s必須是0到p之間的
值。默認(rèn)是0。
5-17字節(jié)
smallmoneymoney
介于-214,748.3648和214,748.3647之間的貨幣數(shù)據(jù)。介于-922,337,203,685,477.5808和922,337,203,685,477.5807
之間的貨幣數(shù)據(jù)。
4字節(jié)8字節(jié)float(n)從-1.79E+308到1.79E+308的浮動(dòng)精度數(shù)字?jǐn)?shù)據(jù)。參數(shù)n指示該字段保存4字節(jié)還是8字節(jié)。float(24)保存4字節(jié),而float(53)保存8字節(jié)。n的默認(rèn)值是53。4或8字節(jié)realDate類型:數(shù)據(jù)類型
datetime
描述
從-3.40E+38到3.40E+38的浮動(dòng)精度數(shù)字?jǐn)?shù)據(jù)。4字節(jié)存儲(chǔ)8bytes
從1753年1月1日到9999年12月31日,精度為3.33毫
秒。
datetime2從1753年1月1日到9999年12月31日,精度為100納
秒。
6-8bytes
smalldatetime
datetimedatetimeoffsettimestamp
從1900年1月1日到2079年6月6日,精度為1分鐘。僅存儲(chǔ)日期。從0001年1月1日到9999年12月31日。
僅存儲(chǔ)時(shí)間。精度為100納秒。與datetime2相同,外加時(shí)區(qū)偏移。
存儲(chǔ)唯一的數(shù)字,每當(dāng)創(chuàng)建或修改某行時(shí),該數(shù)字會(huì)更新。timestamp基于內(nèi)部時(shí)鐘,不對(duì)應(yīng)真實(shí)時(shí)間。每個(gè)表只能有一個(gè)timestamp變
量。
4bytes3bytes3-5bytes8-10bytes
其他數(shù)據(jù)類型:數(shù)據(jù)類型sql_variantuniqueidentifierxmlcursortable描述存儲(chǔ)最多8,000字節(jié)不同數(shù)據(jù)類型的數(shù)據(jù),除了text、ntext以及timestamp。存儲(chǔ)全局標(biāo)識(shí)符(GUID)。存儲(chǔ)XML格式化數(shù)據(jù)。最多2GB。存儲(chǔ)對(duì)用于數(shù)據(jù)庫操作的指針的引用。存儲(chǔ)結(jié)果集,供稍后處理。
FIRST(column)LAST(column)MAX(column)MIN(column)返回在指定的域中第一個(gè)記錄的值返回在指定的域中最后一個(gè)記錄的值返回某列的最高值返回某列的最低值返回某列的總和STDEV(column)STDEVP(column)SUM(column)VAR(column)VARP(column)在SQLServer中的合計(jì)函數(shù)函數(shù)AVG(column)描述返回某列的行數(shù)返回某列的行數(shù)(不包括NULL值)返回被選行數(shù)返回相異結(jié)果的數(shù)目返回在指定的域中第一個(gè)記錄的值(SQLServer201*不支持)返回在指定的域中最后一個(gè)記錄的值(SQLServer201*不支持)返回某列的最高值返回某列的最低值BINARY_CHECKSUMCHECKSUMCHECKSUM_AGGCOUNT(column)COUNT(*)COUNT(DISTINCTcolumn)FIRST(column)LAST(column)MAX(column)MIN(column)STDEV(column)STDEVP(column)SUM(column)返回某列的總和VAR(column)VARP(column)Scalar函數(shù)
Scalar函數(shù)的操作面向某個(gè)單一的值,并返回基于輸入值的一個(gè)單一的值。MSAccess中的Scalar函數(shù)函數(shù)UCASE(c)LCASE(c)MID(c,start[,end])LEN(c)INSTR(c,char)LEFT(c,number_of_char)RIGHT(c,number_of_char)ROUND(c,decimals)MOD(x,y)NOW()FORMAT(c,format)DATEDIFF(d,date1,date2)描述將某個(gè)域轉(zhuǎn)換為大寫將某個(gè)域轉(zhuǎn)換為小寫從某個(gè)文本域\uCURDATE()CURTIME()DATE()返回當(dāng)前的日期返回當(dāng)前的時(shí)間提取日期或日期/時(shí)間表達(dá)式的日期部分返回日期/時(shí)間按的單獨(dú)部分給日期添加指定的時(shí)間間隔從日期減去指定的時(shí)間間隔返回兩個(gè)日期之間的天數(shù)用不同的格式顯示日期/時(shí)間EXTRACT()DATE_ADD()DATE_SUB()DATEDIFF()DATE_FORMAT()SQLServerDate函數(shù)
下面的表格列出了SQLServer中最重要的內(nèi)建日期函數(shù):
函數(shù)GETDATE()描述返回當(dāng)前日期和時(shí)間返回日期/時(shí)間的單獨(dú)部分在日期中添加或減去指定的時(shí)間間隔","p":{"h":14.39,"w":216,"x":435.344,"y":743.788,"z":563},"ps":{"_cover":true},"t":"word","r":[6DATETIME-格式:YYYY-MM-DDHH:MM:SSSMALLDATETIME-格式:YYYY-MM-DDHH:MM:SSTIMESTAMP-格式:唯一的數(shù)字
友情提示:本文中關(guān)于《SQL總結(jié)》給出的范例僅供您參考拓展思維使用,SQL總結(jié):該篇文章建議您自主創(chuàng)作。
來源:網(wǎng)絡(luò)整理 免責(zé)聲明:本文僅限學(xué)習(xí)分享,如產(chǎn)生版權(quán)問題,請(qǐng)聯(lián)系我們及時(shí)刪除。