診療后服務(wù)數(shù)據(jù)庫(kù)表結(jié)構(gòu)詳細(xì)設(shè)計(jì)文檔

1、診療后服務(wù)數(shù)據(jù)庫(kù)表結(jié)構(gòu)詳細(xì)設(shè)計(jì)文檔create table AFFIXTABLE醫(yī)學(xué)咨詢附件表(IDVARCHAR2(32) not null, -ASKID VARCHAR2(32), - OLDFILENAME VARCHAR2(200), - NEWFILENAME VARCHAR2(200), FILEPATH VARCHAR2(500), -SERVERTYPE VARCHAR2(2), - ANSWERID VARCHAR2(32) -)自增 ID 咨詢 ID-附件原名字-附件新名字附件路徑 附件類型 答案表 IDcreate table AFFIX_CHECK(ID VARCHA

2、R2(32) not null, -FILENAME VARCHAR2(400), - ANNEXNO VARCHAR2(100), -URL VARCHAR2(200), -ARTID VARCHAR2(32) -)復(fù)查提醒附件表自增 ID 附件名稱 附件新名稱 附件路徑 信息 IDcreate table AFFIX_MEMACTIVE(IDVARCHAR2(32) not null,-FILENAME VARCHAR2(400), ANNEXNO VARCHAR2(100), URL VARCHAR2(200), ARTID VARCHAR2(32)會(huì)員提醒附件表同上create tab

3、le AFFIX_NOTICE(ID VARCHAR2(32) not null, -FILENAME VARCHAR2(400), ANNEXNO VARCHAR2(100), URL VARCHAR2(200),ARTID VARCHAR2(32)通知公告附件表同上)create table AFFIX_PUB康復(fù)刊物附件表(IDVARCHAR2(32) not null, -同上FILENAME VARCHAR2(400),ANNEXNO VARCHAR2(100),URL VARCHAR2(200),ARTID VARCHAR2(32)create table AFFIX_RECORD

4、電子健康檔案附件表(IDVARCHAR2(32) not null, -同上FILENAME VARCHAR2(400),ANNEXNO VARCHAR2(100),URL VARCHAR2(200),ARTID VARCHAR2(32)create table ANNEX康復(fù)方案附件表(IDVARCHAR2(32) not null,-同上FILENAME VARCHAR2(400),ANNEXNO VARCHAR2(100),URL VARCHAR2(200),ARTID VARCHAR2(32)create table ARTPACKAGE檔案包(IDVARCHAR2(32) not n

5、ull,-自增 IDPACKAGENAME VARCHAR2(50), -檔案包名稱CREATEPERSON VARCHAR2(50), -創(chuàng)建人CREATETIME DATE, - 創(chuàng)建時(shí)間FREECODE VARCHAR2(50), - 空閑字段FREECODE2 VARCHAR2(50) - 空閑字段)create table ASK_RESPONSE(ID VARCHAR2(32) not null, -ASKID VARCHAR2(32), -RESID VARCHAR2(32) -)咨詢，回復(fù)中間表自增 ID咨詢 ID回復(fù) ID預(yù)約掛號(hào)標(biāo)準(zhǔn)表自增 ID 俱樂(lè)部 ID 專家 ID 專

6、家名稱 出診時(shí)間 出診星期幾上午OF下午掛號(hào)數(shù)可掛號(hào)時(shí)間 信息有效時(shí)間create table BASICREGISTER(ID VARCHAR2(32) not null, CLUBID VARCHAR2(32), - EXPERTID VARCHAR2(32), -EXPERTNAME VARCHAR2(30), WORKDATE VARCHAR2(30), - WEEKDAY VARCHAR2(20), -DAYTIME VARCHAR2(30), -COUNT INTEGER, -REGISTERTIME INTEGER, -AVAILTIME INTEGER -create tabl

7、e CHECKDETAIL 電子健康檔案模版詳細(xì) (ITEMID VARCHAR2(32), -模版 IDRESULT VARCHAR2(50), -結(jié)果UNITNAME VARCHAR2(50), -單位ARRANGE VARCHAR2(50), -范圍RECORDID VARCHAR2(32) -檔案 IDcreate table CHECKITEM電子健康檔案模版(IDVARCHAR2(32) not null, -自增 IDITEMNAME VARCHAR2(100), -模版名稱DORDER INTEGER - 排序號(hào))create table CITY城市表，現(xiàn)在沒(méi)用(CITYID

8、 VARCHAR2(32) not null,CITYNAME VARCHAR2(200), PROVINCEID VARCHAR2(32)create table CLUB俱樂(lè)部(ID VARCHAR2(32) not null, -自增 IDCLUBNAME VARCHAR2(50), -俱樂(lè)部名稱HOSPITALID VARCHAR2(32), -醫(yī)院 IDOFFICEID VARCHAR2(32), -科室 IDREMARK VARCHAR2(2000), - 簡(jiǎn)介 ISSTART VARCHAR2(2), -是否啟用DORDER VARCHAR2(32), -排序號(hào)CLUBCODE

9、VARCHAR2(20), -俱樂(lè)部編號(hào)MODULEID VARCHAR2(32), -模板 IDIMGSRC VARCHAR2(300) -圖片路徑)create table CLUB_CUSTOMER(ID VARCHAR2(32) not null,-CLUBID VARCHAR2(32),-MEMBERNO VARCHAR2(32)-會(huì)員，俱樂(lè)部關(guān)聯(lián)表主鍵俱樂(lè)部 id會(huì)員 idcreate table CLUB_NOTICE(ID VARCHAR2(32) not null, - CLUBID VARCHAR2(32), - NOTICEID VARCHAR2(32) -通知公告，俱樂(lè)

10、部關(guān)聯(lián)表自增 ID 俱樂(lè)部 ID 通知公告 IDcreate table CLUB_REGISTER 預(yù)約掛號(hào)表 (CLUBID VARCHAR2(32), -俱樂(lè)部 IDEXPERTID VARCHAR2(32), -專家 IDEXPERTNAME VARCHAR2(50), -專家名稱WORKDATE VARCHAR2(50), -出診時(shí)間WEEKDAY VARCHAR2(50), -星期幾DAYTIME VARCHAR2(30), -上午 | 下午可掛號(hào)時(shí)間 預(yù)約標(biāo)準(zhǔn)表 IDCOUNTINTEGER, -掛號(hào)數(shù)REGISTERTIME VARCHAR2(30), -BASICID VAR

11、CHAR2(32) -)create table CLUB_SERVER(ID VARCHAR2(32) not null,-CLUBID VARCHAR2(32), -MEMBERID VARCHAR2(32) -)俱樂(lè)部客服關(guān)聯(lián)表自增 ID 俱樂(lè)部 ID 客服 IDcreate table COUNTY省表，現(xiàn)在沒(méi)用(COUNTRYID VARCHAR2(32) not null,COUNTRYNAME VARCHAR2(200),CITYID VARCHAR2(32)create table CUSTOMER -會(huì)員表(IDVARCHAR2(32) not null,-主鍵MEMBERN

12、O VARCHAR2(11),-會(huì)員號(hào)NAMEVARCHAR2(20),-名稱SEXVARCHAR2(2),-性別BIRTHDAY DATE,-出生日期PHONEVARCHAR2(20),-電話FIXATIONPHONE VARCHAR2(200),-手機(jī)ADDRESSINFO VARCHAR2(100),-地址POSTCODE VARCHAR2(50),-郵編EMAILVARCHAR2(50),-emailILLNESSID VARCHAR2(100),-疾病 idREMARK VARCHAR2(500),描述SERVICENO VARCHAR2(50),-服務(wù)號(hào)INSIDENO VARCH

13、AR2(50),-內(nèi)部號(hào)AVAILABLEDATE INTEGER,-有效期限ISSTART VARCHAR2(2),-是否啟用CREATETIME DATE,-創(chuàng)建時(shí)間STARTDATE DATE,-開(kāi)始時(shí)間ENDDATE DATE,-結(jié)束時(shí)間MOMMUNITY VARCHAR2(50),-家屬社區(qū)醫(yī)院LANDCOUNT INTEGER,-登陸次數(shù)LASTLANDDATE DATE,-登陸時(shí)間LASTLANDIP VARCHAR2(50),-登陸 ipTYPEID VARCHAR2(2), 會(huì)員類型密碼加密密碼 昵稱 五位自增 三位自增 套餐類型 套餐家庭成員數(shù)量PASSWORD VARCH

14、AR2(12),- SECRPASSWORD VARCHAR2(32),- ALIASVARCHAR2(20),-FIVEINCREASE VARCHAR2(5),- THREEINCREASE VARCHAR2(3),- DINNERTYPE VARCHAR2(2),- DINNERCOUNT VARCHAR2(2)- )create table CUSTOMER_ILL -會(huì)員疾病表(IDVARCHAR2(32) not null,-主鍵CUSTOMERID VARCHAR2(32),-會(huì)員 idCLUBID VARCHAR2(32), 俱樂(lè)部 id OTHERID VARCHAR2(32

15、),-疾病 idREMARKS VARCHAR2(2000)-描述)會(huì)員模塊表主鍵 會(huì)員 id 模塊 idcreate table CUSTOMER_MODULE-(ID VARCHAR2(32) not null,-MEMBERNO VARCHAR2(32) not null,- MODULEID VARCHAR2(32) not null-)康復(fù)方案會(huì)員關(guān)聯(lián)表自增 ID 會(huì)員 ID 方案 IDcreate table CUSTOM_SERVER(ID VARCHAR2(32) not null, - CUSTOMID VARCHAR2(32), - INFOID VARCHAR2(32),

16、 -SENDTIME DATE, - 放松時(shí)間SENDPERSON VARCHAR2(50), -發(fā)送人INFOTYPE VARCHAR2(32), -信息類型STATUS INTEGER - 信息狀態(tài)會(huì)員復(fù)查提醒關(guān)聯(lián)表自增 ID 會(huì)員 ID 信息 ID發(fā)送人信息類型（暫時(shí)沒(méi)用）會(huì)員，會(huì)員活動(dòng)關(guān)聯(lián)表create table CUS_DBCHECK -(ID VARCHAR2(32) not null, - CUSTOMID VARCHAR2(32), - INFOID VARCHAR2(32), - SENDTIME DATE, - 發(fā)送時(shí)間SENDPERSON VARCHAR2(50), -

17、INFOTYPE VARCHAR2(32), -STATUS INTEGER - 狀態(tài) )create table CUS_MEMACTIVE -(CUSTOMID VARCHAR2(32), INFOID VARCHAR2(32), SENDTIME DATE, SENDPERSON VARCHAR2(50), INFOTYPE VARCHAR2(32), STATUS INTEGER)create table CUS_PUB (ID VARCHAR2(32) not null, - CUSTOMID VARCHAR2(32), INFOID VARCHAR2(32), SENDTIME D

18、ATE, SENDPERSON VARCHAR2(50), INFOTYPE VARCHAR2(32), STATUS INTEGER )create table DB_CHECKREMIND (IDCLUBID會(huì)員，康復(fù)刊物關(guān)聯(lián)表同上CHECKTIME PUBDATE SIGNNAME PUBPERSON ACCEPTOBJVARCHAR2(32) not null, -VARCHAR2(32) not null, -DATE, -復(fù)查時(shí)間DATE, -創(chuàng)建時(shí)間VARCHAR2(20), -VARCHAR2(32), -VARCHAR2(4000), -復(fù)查提醒自增 ID俱樂(lè)部 IDCHEC

19、KCONTENT CLOB, -ATTENTIONITEM CLOB, -TITLE VARCHAR2(50) - ) create table EXPERTILL (ID VARCHAR2(32) not null, -ILLID VARCHAR2(32), - EXPERTID VARCHAR2(32) - )create table FAMILYRELATION- (IDVARCHAR2(32) not null,-MEMBERID VARCHAR2(32),- OTHERID VARCHAR2(32)- )create table FORMDETAIL(ID VARCHAR2(32)

20、not null, -RESULT VARCHAR2(50), -UNITNAME VARCHAR2(50), -ARRANGE VARCHAR2(50), -ITEMNAME VARCHAR2(50), -簽名發(fā)布人 接收人 復(fù)查內(nèi)容沒(méi)用標(biāo)題專家，疾病關(guān)聯(lián)表自增 ID 疾病 ID 專家 ID家庭成員和會(huì)員關(guān)系表主鍵會(huì)員 id家庭成員 id電子健康檔案類型詳細(xì)自增 ID結(jié)果單位范圍項(xiàng)目名稱STYLEID VARCHAR2(32) - 類型 ID)create table FORMSTYLE電子健康檔案類型(IDVARCHAR2(32) not null, -自增 IDSTYLENAME VAR

21、CHAR2(50), -類型名STYLECODE VARCHAR2(20), -類型編號(hào)REMARK VARCHAR2(4000) -類型簡(jiǎn)介)create table HEALTHMETHOD康復(fù)方案(HEALTHID VARCHAR2(32) not null, -自增 IDCLUBID VARCHAR2(32) not null, -俱樂(lè)部名稱TITLEVARCHAR2(50), -標(biāo)題CONTENT CLOB, - 內(nèi)容ACCEPTOBJ VARCHAR2(4000), -接收人CREATEDATE DATE, - 創(chuàng)建時(shí)間SIGNVARCHAR2(50), -簽名CREATEPERS

22、ON VARCHAR2(32), -創(chuàng)建人PERSONID VARCHAR2(32), -創(chuàng)建人 IDVALIDATETIME INTEGER, -有效期（沒(méi)用）TYPEID VARCHAR2(32) - )類型 IDcreate table HEALTHRECORD (電子健康檔案(IDVARCHAR2(32) not null, -自增 IDTITLE VARCHAR2(50), -標(biāo)題CONTENTCLOB, -內(nèi)容MEMBERNO VARCHAR2(32), -會(huì)員 IDPUBDATE DATE, - 創(chuàng)建時(shí)間PUBPERSON VARCHAR2(32), -創(chuàng)建人PACKAGEID

23、VARCHAR2(32), -檔案包 IDMODULETYPE VARCHAR2(50), -模版 IDFLAG VARCHAR2(2), -標(biāo)志SEX VARCHAR2(2), -性別SAMPLE VARCHAR2(50), -標(biāo)本W(wǎng)HICHOFFICE VARCHAR2(50), -科別EXAMINE VARCHAR2(100), -診斷CASENUMBER VARCHAR2(50), -病歷號(hào)BEDNUMBER VARCHAR2(50), -床號(hào)SAMPLETYPE VARCHAR2(50), -標(biāo)本類型CHECKDEPART VARCHAR2(50), -檢驗(yàn)部門SEEDOCTOR V

24、ARCHAR2(50), -送檢醫(yī)師CLINICEXAMINE VARCHAR2(50), -臨床診斷DOCTORREMIND VARCHAR2(4000),- 醫(yī)生建議TYPEVARCHAR2(2), -信息類型SENDTIME DATE, - 發(fā)送送檢STYLEID VARCHAR2(32),模版類型 IDCLUBIDVARCHAR2(32) - 俱樂(lè)部 ID)康復(fù)方案自增 ID俱樂(lè)部 ID方案編號(hào)標(biāo)題創(chuàng)建人簽名接收人 上級(jí)欄目 ID 標(biāo)題create table HEALTH_PUBLICATION(ID VARCHAR2(32) not null, - CLUBID VARCHAR2(

25、32), - PERIODICALNO VARCHAR2(20), - PUB_TITLE VARCHAR2(100), - PUB_CONTENT CLOB, -內(nèi)容PUBDATE DATE, - 創(chuàng)建時(shí)間 PUBPERSON VARCHAR2(32), -SIGNNAME VARCHAR2(20), -ACCEPTOBJ VARCHAR2(4000), -TOPICID VARCHAR2(32), -TITLE VARCHAR2(32) -)create table HOSPITAL醫(yī)院(HOSPITALID VARCHAR2(32) not null, -自增 IDHOSPITALNAM

26、E VARCHAR2(200), - 醫(yī)院名稱REMARK VARCHAR2(500), -簡(jiǎn)介ISSTART VARCHAR2(32), -是否啟用DORDER VARCHAR2(32), -排序號(hào)PROVINCEID VARCHAR2(32), -省CITYID VARCHAR2(32), -市COUNTRYID VARCHAR2(32), -縣HOSPITALCODE VARCHAR2(20) - )醫(yī)院編號(hào)create table HOSPITAL_SERVER- (IDVARCHAR2(32) not null,-醫(yī)院客服表主鍵HOSPITALID VARCHAR2(32),-醫(yī)院

27、idMEMBERID VARCHAR2(32)-客服 id)create table ILLNESS疾病表(ID VARCHAR2(32) not null, -自增 IDILLNAME VARCHAR2(50), -疾病名稱REMARK VARCHAR2(2000), - 簡(jiǎn)介CLUBID VARCHAR2(32) - 俱樂(lè)部 IDID VARCHAR2(32) not null, -自增 IDILLNAME VARCHAR2(50), -疾病名稱REMARK VARCHAR2(100) -簡(jiǎn)介)create table MEDICALQUESTION -醫(yī)學(xué)咨詢表(ASKID VARCHA

28、R2(32) not null, - 自增 IDCLUBID VARCHAR2(32), -俱樂(lè)部 IDASKTIME DATE, - 咨詢時(shí)間ASKQUESTION VARCHAR2(1000),-咨詢主題SIGNNAME VARCHAR2(20), -簽名CUSTOMERID VARCHAR2(32), -會(huì)員 IDTITLE VARCHAR2(150), -標(biāo)題INFOTYPE INTEGER, - 每用ISSTART VARCHAR2(2), -已讀未讀FLAG INTEGER -查看標(biāo)志)醫(yī)學(xué)咨詢回復(fù)表自增 ID俱樂(lè)部 ID恢復(fù)人回復(fù)內(nèi)容簽名恢復(fù)主題回復(fù)人create table M

29、EDICALRESPONSE - (RESID VARCHAR2(32) not null, - CLUBID VARCHAR2(32), - RESTIME DATE, -回復(fù)時(shí)間RESPERSON VARCHAR2(20), -RESCONTENT VARCHAR2(1000), -SIGNNAME VARCHAR2(20), - RESTITLE VARCHAR2(150), -PUBPERSON VARCHAR2(32) -)create table MEMBERACTIVE 會(huì)員活動(dòng)表(IDVARCHAR2(32) not null, -自增 IDCLUBID VARCHAR2(32

30、), -俱樂(lè)部 IDACTIVETITLE VARCHAR2(100), - 標(biāo)題 ACTIVECONTENT VARCHAR2(3000), -內(nèi)容PUBDATE DATE, -創(chuàng)建時(shí)間PUBPERSON VARCHAR2(32), -創(chuàng)建人SIGNNAME VARCHAR2(20), -簽名STARTDATE DATE, -開(kāi)始時(shí)間ENDDATE DATE, -結(jié)束時(shí)間ACCEPTOBJ VARCHAR2(4000) - 接收人會(huì)員預(yù)約信息自增 ID 會(huì)員 ID 俱樂(lè)部 ID 專家 ID預(yù)約時(shí)間預(yù)約時(shí)間上午下午星期會(huì)員類型基礎(chǔ)數(shù)據(jù)表主鍵類型名稱康復(fù)方案審核信息表自增 ID標(biāo)題關(guān)鍵字查找類型

31、create table MEMBERREGISTER(ID VARCHAR2(32) not null, - MEMBERID VARCHAR2(32), - CLUBID VARCHAR2(32), - EXPERTID VARCHAR2(32), -REGISTERTIME VARCHAR2(30), -BOOKDATE VARCHAR2(30), -DAYTIME VARCHAR2(30), -WEEKDAY VARCHAR2(20) - )create table MEMBERTYPE(TYPEID VARCHAR2(32) not null,-TYPENAME VARCHAR2(5

32、0),-ISSTART INTEGER,-是否啟用REMARK VARCHAR2(500)-描述)create table METHODSTAND(ID VARCHAR2(32) not null, TITLE VARCHAR2(50), -CONTENT CLOB, - 內(nèi)容 KEYCODE VARCHAR2(50),- SEARCHTYPE VARCHAR2(2) -)create table METHODTYPE康復(fù)方案類型表(IDVARCHAR2(32) not null, -自增 IDTYPENAME VARCHAR2(50), -類型名稱ISSTART INTEGER -是否啟用模

33、塊菜單表MODULEID VARCHAR2(32) not null,ID1INTEGER,ID2INTEGER,ID3INTEGER,ID4INTEGER,ID5INTEGER,ID6INTEGER,ID7INTEGER,ID8INTEGER,create table MODULEMENU(主鍵)MODULENAME VARCHAR2(20),-模塊名稱GRADE INTEGER,-級(jí)別 -PIDVARCHAR2(20),-父 IDDORDER INTEGER,-排序HREF1 VARCHAR2(100), 客服人員功能HREF2 VARCHAR2(100), 會(huì)員功能連接ISLEAF IN

34、TEGER, -是否葉子節(jié)點(diǎn)ISSTART INTEGER-是否啟用)create table MODULESELECT-俱樂(lè)部樣式表(MODULEID VARCHAR2(32) not null,-主鍵MODULENAME VARCHAR2(50),-俱樂(lè)部名稱CSSFILE VARCHAR2(100)-樣式路徑)create table NOTICE -通知公告表(ID VARCHAR2(32) not null, -自增 IDTITLE VARCHAR2(50), - 標(biāo)題CONTENT CLOB, -內(nèi)容PUBDATE DATE, -創(chuàng)建時(shí)間PUBPERSON VARCHAR2(32)

35、, -創(chuàng)建人ACCEPTOBJ VARCHAR2(4000), - 接收人HOSPITALID VARCHAR2(32) -醫(yī)院 ID)create table OFFICETABLE -科室表(OFFICEID VARCHAR2(32) not null, -自增 IDHOSPITALID VARCHAR2(32), -醫(yī)院 IDTYPEID VARCHAR2(32), -類型 IDOFFICENAME VARCHAR2(20), -科室 IDREMARK VARCHAR2(500), -簡(jiǎn)介ISSTART INTEGER, -是否啟用DORDER INTEGER, -排序號(hào)OFFICENO

36、 VARCHAR2(16) -科室編號(hào)create table OFFICETYPE -科室類型(TYPEID VARCHAR2(32) not null, -自增 IDTYPENAME VARCHAR2(50), -類型名稱REMARK VARCHAR2(500), -簡(jiǎn)介ISSTART INTEGER, - 是否啟用DORDER INTEGER - 排序號(hào)create table OPERATE_ITEM-操作欄目表(IDVARCHAR2(32) not null,-主鍵OPERATEITEM VARCHAR2(20),-操作欄目ISSTART VARCHAR2(2)-是否啟用)操作欄目基

37、礎(chǔ)表主鍵操作 id模塊 idcreate table OPERATE_MODULE- (IDVARCHAR2(32) not null,-OPERATE_ID VARCHAR2(32),- MODULE_ID VARCHAR2(32)-)create table OPERATIONLOG操作日志表(ID VARCHAR2(32) not null, 主鍵 OPERATETIME DATE,-操作欄目OPERATEPERSON VARCHAR2(32),-操作人OPERATEITEM VARCHAR2(32), 操作時(shí)間OPERATECONTENT VARCHAR2(1000),-操作內(nèi)容OPE

38、RATETYPE INTEGER 操作人的身份)create table OTHERMEMBER-家庭成員表(OTHERID VARCHAR2(32) not null,-主鍵OTHERNAME VARCHAR2(20),-姓名SEXVARCHAR2(2),-性別BIRTHDAY DATE,-出生日期PHONEVARCHAR2(20),-電話FIXATIONPHONE VARCHAR2(20),-手機(jī)ADDRESSINFO VARCHAR2(100),-地址POSTCODE VARCHAR2(50),-郵編EMAILVARCHAR2(50),-電子郵件ILLNESS VARCHAR2(100)

39、,-疾病名稱REMARKS VARCHAR2(4000)-描述)create table PHOTOFILE照片(自增 ID專家 ID舊名稱新名稱IDVARCHAR2(32) not null, -EXPERTID VARCHAR2(32), - OLDFILENAME VARCHAR2(200), -NEWFILENAME VARCHAR2(200), -康復(fù)刊物主題表 自增 ID 主題名稱FILEPATH VARCHAR2(500) - 路徑 )create table PUBLICTOPIC -(ID VARCHAR2(32) not null, -TITLE VARCHAR2(50)

40、-)create table REMINDTIME -提醒時(shí)間表(IDVARCHAR2(32) not null, -自增 IDINFOID VARCHAR2(32), -信息 IDREMINDTIME DATE, -提醒時(shí)間FLAGVARCHAR2(2), -標(biāo)志已讀，未讀ENTERTIME DATE, -創(chuàng)建時(shí)間ENTERPERSON VARCHAR2(50) - 創(chuàng)建人)create table ROLE -角色表(ROLEID VARCHAR2(32) not null,-主鍵ROLENAME VARCHAR2(20) ， - 角色名稱REMARK VARCHAR2(500),-描述I

41、SSTART INTEGER,-是否啟用ROLETYPE INTEGER,-角色類型CREATEDATE DATE- 創(chuàng)建時(shí)間)角色模塊表主鍵create table ROLE_MODULEMENU(ID VARCHAR2(32) not null,-ROLEID VARCHAR2(32),-角色 idMODULEID VARCHAR2(20)-模塊 id)角色操作項(xiàng)表主鍵角色 id模塊 id操作項(xiàng) id 是否啟用create table ROLE_OPERATE-(IDVARCHAR2(32) not null,-ROLE_ID VARCHAR2(32),- MODULE_ID VARCHAR2(32),- OPERATE_ID VARCHAR2(32),- ISSTA