📄 genre.html
字号:
<HTML><HEAD><!-- Generated by Druid on 12-01-2003 --> <TITLE>Documentation for Database : Medi</TITLE><LINK REL ="stylesheet" TYPE="text/css" HREF="../main/stylesheet.css" TITLE="Style"></HEAD><BODY><P><TABLE BORDER="0" CELLPADDING="1" CELLSPACING="0" WIDTH="100%"><TR><TD ALIGN="center" WIDTH="150"><FONT ID="DbNavBarFont1" SIZE="-2"><B><A HREF="../main/index.html">INDEX</A> <A HREF="../main/revisions.html">REVISIONS</A></B></FONT></TD><TD></TD><TD WIDTH="100"><FONT ID="DbNavBarFont1" SIZE="-2"><B><A HREF="#Overview">OVERVIEW</A></B></FONT></TD><TD WIDTH="100"><FONT ID="DbNavBarFont1" SIZE="-2"><B><A HREF="#FieldSummary">FIELD SUMMARY</A></B></FONT></TD></TR><TR><TD ALIGN="center" WIDTH="150"><FONT ID="DbNavBarFont1" SIZE="-2"><B><A HREF="../main/datatypes.html">DATATYPES</A> <A HREF="../main/tablespaces.html">TABLESPACES</A></B></FONT></TD><TD></TD><TD WIDTH="100"><FONT ID="DbNavBarFont1" SIZE="-2"><B><A HREF="#SqlSummary">SQL SUMMARY</A></B></FONT></TD><TD WIDTH="100"><FONT ID="DbNavBarFont1" SIZE="-2"><B><A HREF="#FieldDetails">FIELD DETAILS</A></B></FONT></TD></TR></TABLE><HR><A NAME="Overview"></A><TABLE BORDER="1" CELLPADDING="2" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#CCCCFF"><TD><FONT SIZE="+2"><B>Table : GENRE</B></FONT></TD></TR></TABLE><BR>It represents a genre of data.<P><P><B>See Also</B>:<blockquote><A HREF="MARKS.html">MARKS</A><BR></blockquote><P><A NAME="FieldSummary"></A><TABLE BORDER="1" CELLPADDING="2" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#A0D0F0"><TD COLSPAN=3><FONT SIZE="+2"><B>Field Summary</B></FONT></TD></TR><TR BGCOLOR="#E8FFFF"><TH WIDTH="20%">Name</TH><TH WIDTH="20%">Type</TH><TH WIDTH="60%">Description</TH></TR><TR><TD><B><A HREF="#GenreID">GenreID</A></B></TD><TD>Serial</TD><TD>The genre ID.</TD></TR><TR><TD><I><A HREF="#SuperGenre">SuperGenre</A></I></TD><TD><A HREF="GENRE.html">GENRE(GenreID)</A></TD><TD>The ID of the genre that is a "super-genre" for this genre.<BR>NULL means that the row represents a root genre.</TD></TR><TR><TD><A HREF="#GenreName">GenreName</A></TD><TD>Name</TD><TD>The genre name.</TD></TR><TR><TD><A HREF="#Description">Description</A></TD><TD>text</TD><TD>Some description.</TD></TR></TABLE><BR><P><A NAME="SqlSummary"></A><TABLE BORDER="1" CELLPADDING="2" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#A0D0F0"><TD COLSPAN=8><FONT SIZE="+2"><B>Sql Summary</B></FONT></TD></TR><TR BGCOLOR="#E8FFFF"><TH WIDTH="50%">Name</TH><TH WIDTH="50%">Type</TH><TH WIDTH="40">PrKey</TH><TH WIDTH="40">Unq</TH><TH WIDTH="40">NotN</TH><TH WIDTH="40">MUnq</TH><TH WIDTH="40">Def</TH><TH WIDTH="40">Idx1</TH></TR><TR><TD><B><A HREF="#GenreID">GenreID</A></B><TD>int</TD><TD ALIGN="CENTER"><IMG SRC="../images/set.gif"></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD><TD ALIGN="CENTER"><IMG SRC="../images/set.gif"></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD><TD>0</TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD></TR><TR><TD><I><A HREF="#SuperGenre">SuperGenre</A></I><TD>int</TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD><TD>null</TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD></TR><TR><TD><A HREF="#GenreName">GenreName</A><TD>varchar(24)</TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD><TD ALIGN="CENTER"><IMG SRC="../images/set.gif"></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD><TD></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD></TR><TR><TD><A HREF="#Description">Description</A><TD>text</TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD><TD></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD></TR></TABLE><BR><A NAME="FieldDetails"></A><TABLE BORDER="1" CELLPADDING="2" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#A0D0F0"><TD COLSPAN=2><FONT SIZE="+2"><B>Field Details</B></FONT></TD></TR></TABLE><BR><TABLE BORDER="0" CELLPADDING="4" CELLSPACING="0" WIDTH="100%"><TR><TD WIDTH="20" ALIGN="center"><IMG SRC="../images/purpleball.gif"></TD><TD><FONT size="+1"><B><A NAME="GenreID">GenreID</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : int</TD></TR><TR><TD WIDTH="20" ALIGN="center"><IMG SRC="../images/yellowball.gif"></TD><TD><FONT size="+1"><B><A NAME="SuperGenre">SuperGenre</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : int</TD></TR><TR><TD></TD><TD>On Update : Cascade</TD></TR><TR><TD></TD><TD>On Delete : Cascade</TD></TR><TR><TD WIDTH="20" ALIGN="center"><IMG SRC="../images/blueball.gif"></TD><TD><FONT size="+1"><B><A NAME="GenreName">GenreName</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : varchar(24)</TD></TR><TR><TD WIDTH="20" ALIGN="center"><IMG SRC="../images/blueball.gif"></TD><TD><FONT size="+1"><B><A NAME="Description">Description</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : text</TD></TR></TABLE><BR><HR><TABLE BORDER="0" CELLPADDING="1" CELLSPACING="0" WIDTH="100%"><TR><TD ALIGN="center" WIDTH="150"><FONT ID="DbNavBarFont1" SIZE="-2"><B><A HREF="../main/index.html">INDEX</A> <A HREF="../main/revisions.html">REVISIONS</A></B></FONT></TD><TD></TD><TD WIDTH="100"><FONT ID="DbNavBarFont1" SIZE="-2"><B><A HREF="#Overview">OVERVIEW</A></B></FONT></TD><TD WIDTH="100"><FONT ID="DbNavBarFont1" SIZE="-2"><B><A HREF="#FieldSummary">FIELD SUMMARY</A></B></FONT></TD></TR><TR><TD ALIGN="center" WIDTH="150"><FONT ID="DbNavBarFont1" SIZE="-2"><B><A HREF="../main/datatypes.html">DATATYPES</A> <A HREF="../main/tablespaces.html">TABLESPACES</A></B></FONT></TD><TD></TD><TD WIDTH="100"><FONT ID="DbNavBarFont1" SIZE="-2"><B><A HREF="#SqlSummary">SQL SUMMARY</A></B></FONT></TD><TD WIDTH="100"><FONT ID="DbNavBarFont1" SIZE="-2"><B><A HREF="#FieldDetails">FIELD DETAILS</A></B></FONT></TD></TR></TABLE></BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -