oracle实训_实-表

《oracle实训_实-表》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、1.TitleTableColumnNameidtitledescritionratingcategoryRelease_datepriceKeytypepkNulls/uniqueNnnnnnFKtableFKcolumnCKDefaultDatatypenumVarchar2Varchar2numchardatenumlength1020100101020102.MemberTableColumnNameidnameJoin_dateAddressCityPhoneKeytypepkNulls/uniqueN

2、n,uknnnnFKtableFKcolumnCKDefaultDatatypenumVarchar2dateVarchar2Varchar2numlength1020202020203.RentalTableColumnNameBook_dateAct_ret_dateExp_ret_dateTitle_idtitleCopy_idMember_idKeytypeFk,pkFk,pkFk,pkNulls/uniqueukukFKtabletitletitlecopymemberFKcolumnCKDefault

3、DatatypedatedatedatenumnumnumLength2020201010104.ReservationTableColumnNameTitle_idMember_idRes_dateKeytypeFk,pkFk,,pkNulls/uniqueNn,ukNn,ukFKtabletitlememberFKcolumnididCKDefaultDatetypenumnumdateLength1010205.TitleCopyTableColumnNameidstatusTitle_idKeytypep

4、kFk,pkNulls/uniquennNn,ukFKtableTitleFKcolumnidCKY/NDefaultNDatatypenumVarchar2numLength102010