【正文】 idvarchar客戶類型編號c_typevarchar客戶類型dis_attrvarchar 折扣屬性discountint折扣比例pricefloat原價格dis_pricevarchar折扣價格remarkvarchar√備注delmarkint0刪除標記other1varchar√保留1other2varchar√保留2入住信息表[livein]字段名類型允許為空默認值說明pkdecimal主鍵In_novarchar入住單號r_novarchar房間號r_type_idvarchar房間類型編號Main_roomvarchar主房間號Main_pkdecimal主PKc_type_idvarchar客戶類型編號m_idvarchar*客戶編號c_namevarchar客戶名稱c_jpvarchar√客戶名稱簡拼sexvarchar性別zj_typevarchar證件類型zj_novarchar證件編號addressvarchar*地址renshuint人數(shù)in_timevarchar入住時間daysint預注天數(shù)accountfloat消費數(shù)量foregiftfloat押金chk_novarchar*結算單號chk_timevarchar*結算時間remarkvarchar√備注useridvarchar操作員cluemarkint0提醒標志statemarkvarchar0狀態(tài)標志delmarkint0刪除標記other1]varchar√保留1other2varchar√保留2預定信息表[engage]字段名類型允許為空默認值說明pkdecimal主鍵c_namevarchar客戶名稱c_jpvarchar客戶名稱簡拼c_telvarchar客戶電話r_type_idvarchar房間類型編號r_novarchar房間號pa_timevarchar預抵時間keep_timeint保留時間eng_timevarchar預定時間remarkvarchar√備注engagemarkint0預定狀態(tài)標志cluemarkint0提醒標志delmarkint0刪除標記other1varchar√保留1other2varchar√保留2結算表[checkout]字段名類型允許為空默認值說明pkdecimal主鍵chk_novarchar結帳單號in_novarchar入住單號daysint實住天數(shù)moneyfloat金額chk_timevarchar結算時間remarkvarchar√備注delmarkint0刪除標記other1varchar√保留1other2varchar√保留2日志表[record]字段名類型允許為空默認值說明pkdecimal主鍵timedatetime操作時間operatorvarchar操作員briefvarchar內(nèi)容摘要contentvarchar內(nèi)容delmarkint0刪除標記other1varchar√保留1操作員信息表[pwd]字段名類型允許為空默認值說明pkdecimal主鍵useridvarchar用戶登錄IDpwdvarchar登錄密碼puisint用戶權限delmarkint0刪除標記other1varchar√保留1other2varchar√保留2會員信息表[member]字段名類型允許為空默認值說明pkdecimal主鍵m_idvarchar會員編號m_namevarchar會員名稱sexvarchar性別zj_novarchar證件編號addressvarchar詳細地址m_telvarchar聯(lián)系電話remarkvarchar備注delmarkint0刪除標記other1vrchar√保留1other2varchar√保留2散客開單中間表[roomnum]字段名類型允許為空默認值說明roomidvarchar√房間編號團體開單中間表[roomnums]字段名類型允許為空默認值說明rr_typevarchar√房間類型roomidvarchar√房間編號pricefloat√單價預訂信息中間表字段名類型允許為空默認值說明pkdecimal√主鍵c_namevarchar√客戶名稱c_jpvarchar√客戶名稱簡拼c_telvarchar√客戶電話r_type_idvarchar√房間類型編號r_novarchar√房間號pa_timevarchar√預抵時間keep_timeint√保留時間eng_timevarchar√預定時間remarkvarchar√備注engagemarkint√0預定狀態(tài)標志cluemarkint√0提醒標志delmarkint√0刪除標記other1varchar√保留1other2varchar√保留2為你提供優(yōu)秀的畢業(yè)論文參考資料，請您刪除以下內(nèi)容，O(∩_∩)O謝謝?。?！A large group of tea merchants on camels and horses from Northwest China39。s Shaanxi province pass through a stop on the ancient Silk Road, Gansu39。s Zhangye city during their journey to Kazakhstan, May 5, 2015. The caravan, consisting of more than 100 camels, three horsedrawn carriages and four support vehicles, started the trip from Jingyang county in Shaanxi on Sept 19, 2014. It will pass through Gansu province and Xinjiang Uygur autonomous region, and finally arrive in Almaty, formerly known as AlmaAta, the largest city in Kazakhstan, and Dungan in Zhambyl province. The trip will cover about 15,000 kilometers and take the caravan more than one year to plete. The caravan is expected to return to Jingyang in March 2016. Then they will e back, carrying specialty products from Kazakhstan A small art troupe founded six decades ago has grown into a household name in the Inner Mongolia autonomous region. In the 1950s, Ulan Muqir Art Troupe was created by nine young musicians, who toured remote villages on horses and performed traditional Mongolian music and dances for nomadic families. The 54yearold was born in Tongliao, in eastern Inner Mongolia and joined the troupe in says there are 74 branch troupes across Inner Mongolia and actors give around 100 shows every year to local nomadic people. I can still recall the days when I toured with the troupe in the early 39。80s. We sat on the back of pickup trucks for hours. The sky was blue, and we couldn39。t help but sing the folk songs, Nasun says. The vastness of Inner Mongolia and the lack of entertainment options for people living there, made their lives lonely. The nomadic people were very excited about our visits, Nasun recalls. We didn39。t have a formal stage. The audience just sat on the grass. Usually, the performances became a big party with local people joining in. For him, the rewarding part about touring isn39。t just about sharing art with nomadic families but also about gaining inspiration for the music and dance. Ulan Muqir literally translates as red burgeon, and today39。s performers of the troupe still tour the region39。s villages and entertain nomadic families, but their fame has spread around the world. On May 16 and 17, nearly 100 singers and dancers from the troupe performed at Beijing39。s Poly Theater. Their show, titled Ulan Muqir on the Grassland, depicted the history and development of the art troupe. Being from the region allowed me to embrace the culture of Inner Mongolia and being a member of the troupe showed me where I belonged, Nasun, the art troupe39。s president, who is also a renowned tenor, tells China Daily. During a tour in 1985, he went to a village and met an elderly local man, who told h