數(shù)據(jù)庫設(shè)計(jì)數(shù)據(jù)字典

1、數(shù)據(jù)庫名：BDOA表名：ERPAnPai 日程安排表名：ERPBaoJia 客戶報(bào)價(jià)第 1 頁 共 73 頁序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2CustomNamevarchar1000是客戶名稱3BaoJiaTitlevarchar5000是報(bào)價(jià)主題4BaoJiaTypevarchar5000是報(bào)價(jià)類型5BaoJiaJinEvarchar5000是報(bào)價(jià)序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2UserNamevarchar500是用戶名3TitleStrvarchar5000是日程安排主題4ContentStrtext160是安排

2、內(nèi)容5TimeStartdatetime83是開始時(shí)間6TimeEnddatetime83是結(jié)束時(shí)間7TimeTiXingdatetime83是提醒日期8TypeStrvarchar500是日程類別9TimeStrdatetime83是(getdate()錄入時(shí)間10GongXiangWhovarchar50000是查看人表名：ERPBaoXiao 項(xiàng)目報(bào)銷第 2 頁 共 73 頁序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2ProjectNamevarchar2000是項(xiàng)目名稱3FeiYongTypevarchar500是費(fèi)用類別4ShenQingRenvarchar

3、500是申請金額6BaoJiaContentvarchar80000是報(bào)價(jià)內(nèi)容7BaoJiaResultvarchar50000是報(bào)價(jià)結(jié)果8BaoJiaTimevarchar5000是報(bào)價(jià)時(shí)間9BackInfovarchar80000是備注說明10UserNamevarchar500是錄入人11TimeStrdatetime83是(getdate()錄入時(shí)間12IFSharevarchar50000是共享人13CusBakAvarchar80000是客戶自定義A14CusBakBvarchar80000是客戶自定義B15CusBakCvarchar80000是客戶自定義C16CusBakDva

4、rchar80000是客戶自定義D17CusBakEvarchar80000是客戶自定義E表名：ERPBBSBanKuai版塊表名：ERPBBSTieZi帖子第 3 頁 共 73 頁序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2BanKuaiIDint40是版塊ID3TitleStrvarchar5000是標(biāo)題序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2BanKuaiNamevarchar5000是版塊名稱3BanZhuListvarchar5000是版主列表4BanKuaiMiaoShuvarchar80000是版塊描述5BanKuaiImg

5、varchar2000是版塊圖片6JiaoSeXianZhiListvarchar80000是限制7BuMenXianZhivarchar80000是部門限制8UserXianZhivarchar80000是用戶限制人5ShenPiRenvarchar500是審批人6ShenQingContentvarchar50000是申請內(nèi)容7JinEvarchar500是金額8StateNowvarchar500是當(dāng)前狀態(tài)9Usernamevarchar500是錄入人10ShenQingTimedatetime83是(getdate()申請時(shí)間表名：ERPBook管理第 4 頁 共 73頁序號列名數(shù)據(jù)類

6、型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2BookNamevarchar500是名稱3BookSerilsvarchar500是編碼4SuoShuBuMenvarchar500是所屬部門5BookTypevarchar500是分類6Auothervarchar500是作者7ISBNvarchar500是ISBN 號8CoperStrvarchar500是9ChuBanDatevarchar500是日期10CunFangDianvarchar500是存放位置11ShuLiangvarchar500是數(shù)量12JiaGevarchar500是價(jià)格13NeiRongvarchar5000

7、0是內(nèi)容簡介14NowStatevarchar500是當(dāng)前狀態(tài)15BackInfovarchar50000是備注說4UserNamevarchar500是用戶名5TimeStrdatetime83是(getdate()時(shí)間6ContentStrtext160是內(nèi)容7ZuiHouUservarchar500是最后回復(fù)人8ZuiHouTimedatetime83是(getdate()最后回復(fù)時(shí)間9PaiXuint40是(0)排序10HuiFuContenttext160是帖子回復(fù)表名：ERPBookJieHuan借還表名：ERPBuMen 部門管理表名：ERPBuyChanPin 采購第 5 頁

8、共 73 頁序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2BuMenNamevarchar500是部門名稱3ChargeManvarchar500是4TelStrvarchar500是5ChuanZhenvarchar500是傳真6BackInfovarchar80000是備注說明7DirIDint40是部門 ID序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2BookNamevarchar500是名稱3JieShuDatevarchar500是借書日期4GuiHuanDatevarchar500是歸還

9、日期5JieHuanStatevarchar500是借還狀態(tài)6BackInfovarchar50000是備注說明7UserNamevarchar500是錄入人8TimeStrdatetime83是錄入時(shí)間明16UserNamevarchar500是錄入人17TimeStrdatetime83是錄入時(shí)間表名：ERPBuyOrder 采購訂單第 6 頁 共 73 頁序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2OrderNamevarchar500是訂單名稱3GongYingShangNamevarchar500是供應(yīng)商名稱4Serilsvarchar500是訂單編碼5Di

10、ngDanLeiXingvarchar500是訂單1IDint40是是否2OrderNamevarchar500是訂單名稱3ProductNamevarchar500是名稱4ProductSerilsvarchar500是編碼5GongYingShangvarchar500是供應(yīng)商6ProductTypevarchar500是類型7XingHaovarchar500是型號8DanWeivarchar500是9DanJianumeric92是單價(jià)10ShuLiangnumeric92是數(shù)量11ZongJianumeric92是總價(jià)12YiFuKuannumeric92是已付款13QianKuan

11、Shunumeric92是欠款數(shù)14IFJiaoFuvarchar500是是否交付15ChanPinMiaoShuvarchar50000是描述16UserNamevarchar500是錄入人17TimeStrdatetime83是錄入時(shí)間18BackInfovarchar50000是備注說明表名：ERPCarBaoXian 車輛保險(xiǎn)第 7 頁 共 73 頁序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2CarNamevarchar500是車輛名稱3FeiYongNamevarchar500是費(fèi)用名稱4ProjectNamevarchar500是項(xiàng)目名稱5BaoXianP

12、ricevarchar500是保險(xiǎn)金額6BaoXianDatevarchar500是保險(xiǎn)日期類型6DingDanMiaoShuvarchar50000是訂單描述7CreateDatedatetime83是創(chuàng)建時(shí)間8LaiHuoDatedatetime83是來貨時(shí)間9TiXingDatedatetime83是提醒時(shí)間10ChuangJianRenvarchar500是創(chuàng)建人11FuZeRenvarchar500是負(fù)責(zé)人12FuJianListvarchar5000是附件文件13NowStatevarchar500是訂單狀態(tài)14ShenPiTongGuoRenvarchar500是審批通過人15B

13、ackInfotext160是備注16UserNamevarchar500是錄入人17TimeStrdatetime83是(getdate()錄入時(shí)間表名：ERPCarBaoYang 車輛保養(yǎng)表名：ERPCarInfo 車輛信息第 8 頁 共 73 頁序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2CarNamevarchar500是車輛名稱3BYDatevarchar500是保養(yǎng)日期4JingBanUservarchar500是經(jīng)辦人5ZhuGuanUservarchar500是主管6BYQianLCBNumvarchar500是保養(yǎng)前里程表數(shù)7QiYouJinEvar

14、char500是金額8BYJinEvarchar500是保養(yǎng)金額9WeiXiuJinEvarchar500是維修金額10OtherJinEvarchar500是其他費(fèi)用11UserNamevarchar500是錄入人12TimeStrdatetime83是(getdate()錄入時(shí)間13BackInfovarchar50000是備注說明7TiXingDatevarchar500是提醒日期8UserNamevarchar500是錄入人9TimeStrdatetime83是(getdate()錄入時(shí)間10BackInfovarchar50000是備注說明表名：ERPCarJiaYou 車輛加油第

15、9 頁 共 73 頁序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2CarNamevarchar500是車輛名稱3JYDatevarchar500是加油日期4JingBanUservarchar500是經(jīng)辦人5DriverUservarchar500是司機(jī)6JiaYouAddressvarchar500是加油地點(diǎn)7StartNumvarchar500是開始油量8JiaYouNumvarchar500是加油量9YouFeiJinEvarchar500是加油費(fèi)用序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2CarNamevarchar500是車輛名稱3

16、CarPaiHaovarchar500是車輛牌號4CarXingHaovarchar500是型號5LeiXingvarchar500是類型6SuoShuDepvarchar80000是所屬部門7DriverUservarchar500是司機(jī)8NowStatevarchar500是狀態(tài)9UserNamevarchar500是錄入人10TimeStrdatetime83是(getdate()錄入時(shí)間11BackInfovarchar50000是備注表名：ERPCarLog 車輛日志第 10 頁 共 73 頁序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2CarNamevarc

17、har500是車輛名稱3LogDatevarchar500是日志日期4JingBanUservarchar500是經(jīng)辦人5DriverUservarchar500是司機(jī)6ChuCheDatevarchar500是出車日期7StartNumvarchar500是出發(fā)前里程表數(shù)8EndNumvarchar500是到達(dá)里程表數(shù)9XingShiTimevarchar500是行駛時(shí)間10ShiYouvarchar50000是事由11XingShiLiChengvarchar500是行駛里程12YouHaoShuvarchar500是油耗數(shù)13DaoDaAddressvarchar500是到達(dá)地點(diǎn)14Us

18、erNamevarchar500是錄入人15TimeStrdatetime83是(getdate()錄入時(shí)間10UserNamevarchar500是錄入人11TimeStrdatetime83是(getdate()錄入時(shí)間12BackInfovarchar50000是備注說明表名：ERPCarShiYong 車輛使用表名：ERPCarWeiHu 車輛維護(hù)日志第 11 頁 共 73 頁序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2CarNamevarchar500是車輛名稱3DriverUservarchar500是司機(jī)4Y

19、ongCheUservarchar500是用車人5YongCheBuMenvarchar500是用車部門6QiShiTimevarchar500是起始時(shí)間7JieShuTimevarchar500是結(jié)束時(shí)間8MuDiDivarchar500是目的地9LiChengvarchar500是里程10ShengQingUservarchar500是申請人11DiaoDuUservarchar500是調(diào)度人12ShengQingShiYouvarchar50000是申請事由13NowStatevarchar500是當(dāng)前狀態(tài)14UserNamevarchar500是用戶名15TimeStrdatetime

20、83是(getdate()錄入時(shí)間16BackInfovarchar50000是備注說明16BackInfovarchar50000是備注說明表名：ERPCarWeiZhang 車輛違章日志第 12 頁 共 73 頁序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2CarNamevarchar500是車輛名稱3WZDatevarchar500是違章日期5DriverUservarchar500是司機(jī)6WZAddressvarchar500是違章地點(diǎn)8KouFenNumvarchar500是扣分?jǐn)?shù)9FKJinEvarchar500是罰款金額10UserNamevarchar5

21、00是錄入人11TimeStrdatetime83是(getdate()錄入1IDint40是是否2CarNamevarchar500是車輛名稱3WeiHuRiQivarchar500是維護(hù)日期4WeiHuLeiXingvarchar500是維護(hù)類型5WeiHuYuanYinvarchar50000是維護(hù)6JingBanUservarchar500是經(jīng)辦人7WeiHuFeiYongvarchar500是維護(hù)費(fèi)用8NowStatevarchar500是當(dāng)前狀態(tài)9UserNamevarchar500是錄入人10TimeStrdatetime83是(getdate()錄入時(shí)間11BackInfova

22、rchar50000是備注說明表名：ERPContract 合同管理第 13 頁 共 73 頁序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2HeTongNamevarchar2000是合同名稱3HeTongSerilsvarchar500是合同編碼4HeTongLeiXingvarchar500是合同類別5QianYueKeHuvarchar2000是簽約客戶6HeTongMiaoShuvarchar80000是合同描述7HeTongTiaoKuanvarchar80000是合同條款8HeTongContenttext160是合同內(nèi)容9ShengXiaoDatedate

23、time83是生效日期10ZhongZhiDatedatetime83是終止日期11TiXingDatedatetime83是提醒日期12QianYueRenBuyvarchar500是買方簽約人13QianYueRenSellvarchar500是賣方簽約人14CreateTimedatetime83是(getdate()創(chuàng)建時(shí)間15CreateUservarchar500是創(chuàng)建人16FuJianListvarchar5000是附件文件時(shí)間12BackInfovarchar50000是備注說明表名：ERPContractChanPin 合同表名：ERPCrmSetting 客戶參數(shù)設(shè)置表名：

24、ERPCustomFuWu 客戶服務(wù)第 14 頁 共 73 頁序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2CustomNamevarchar1000是客戶名稱3FuWuTitlevarchar5000是服務(wù)序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2TableNamevarchar1000是表名3LieNamevarchar1000是列名4CanShuNamevarchar1000是參數(shù)值序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2HeTongNamevarchar500是合同名稱3ChanPinNamevarcha

25、r500是名稱4DanJianumeric92是單價(jià)5ShuLiangnumeric92是數(shù)量6ZongJianumeric92是總價(jià)7YiFuKuannumeric92是已付款8QianKuanShunumeric92是欠款數(shù)9IFJiaoFuvarchar500是是否交付10UserNamevarchar500是錄入人11TimeStrdatetime83是錄入時(shí)間12BackInfovarchar50000是備注17BackInfovarchar80000是備注18NowStatevarchar500是合同狀態(tài)表名：ERPCustomHuiFang 客戶回訪第 15 頁 共 73 頁序號

26、列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵空默認(rèn)值說明1IDint40是是否2CustomNamevarchar1000是客戶名稱3HuiFangTitlevarchar5000是回訪主題4HuiFangTypevarchar5000是回訪類型5HuiFangResultvarchar50000是回訪主題4FuWuTypevarchar5000是服務(wù)類型5FuWuResultvarchar50000是服務(wù)結(jié)論6FuWuTimevarchar5000是服務(wù)時(shí)間7UserNamevarchar500是錄入人8TimeStrdatetime83是(getdate()錄入時(shí)間9IFSharevarchar5000

27、0是共享人10CusBakAvarchar80000是客戶自定義A11CusBakBvarchar80000是客戶自定義B12CusBakCvarchar80000是客戶自定義C13CusBakDvarchar80000是客戶自定義D14CusBakEvarchar80000是客戶自定義E表名：ERPCustomInfo第 16 頁 共 73 頁序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵允許空默認(rèn)值說明1IDint40是是否2CustomNamevarchar2000是客戶名稱3CustomSerilsvarchar1000是客戶編碼4ChargeManvarchar1000是負(fù)責(zé)人結(jié)果6HuiFan

28、gTimevarchar5000是回訪時(shí)間7UserNamevarchar500是錄入人8TimeStrdatetime83是(getdate()錄入時(shí)間9IFSharevarchar50000是共享人10CusBakAvarchar80000是客戶自定義A11CusBakBvarchar80000是客戶自定義B12CusBakCvarchar80000是客戶自定義C13CusBakDvarchar80000是客戶自定義D14CusBakEvarchar80000是客戶自定義E第 17 頁 共 73 頁5Addressvarchar5000是地址6UrlLinkvarchar2000是網(wǎng)址7YouBianvarchar500是郵編8TelStrvarchar1000