📄 data.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 : DATA</B></FONT></TD></TR></TABLE><BR>It represents a generic data (i.e. a generic file, even a file inside a zip-compressed archive).<P><P><B>See Also</B>:<blockquote><A HREF="CONTAINS.html">CONTAINS</A><BR><A HREF="REALIZED.html">REALIZED</A><BR><A HREF="PUBLISHED.html">PUBLISHED</A><BR><A HREF="MARKS.html">MARKS</A><BR><A HREF="INCLUDES.html">INCLUDES</A><BR><A HREF="FATHER_OF.html">FATHER_OF</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="#DataID">DataID</A></B></TD><TD>LongSerial</TD><TD>The data ID.</TD></TR><TR><TD><I><A HREF="#FileTypeID">FileTypeID</A></I></TD><TD><A HREF="FILE_TYPE.html">FILE_TYPE(FileTypeID)</A></TD><TD>The ID of the file type of the data.<BR>NULL means "file type not assigned".</TD></TR><TR><TD><A HREF="#DataName">DataName</A></TD><TD>MicroDescription</TD><TD>The name.</TD></TR><TR><TD><A HREF="#FileName">FileName</A></TD><TD>text</TD><TD>The file name.</TD></TR><TR><TD><A HREF="#Date">Date</A></TD><TD>DateTime</TD><TD>The date of last modify.</TD></TR><TR><TD><A HREF="#Dimension">Dimension</A></TD><TD>bigint</TD><TD>The dimesion in bytes.</TD></TR><TR><TD><A HREF="#Description">Description</A></TD><TD>text</TD><TD>Some description.</TD></TR><TR><TD><A HREF="#Duration">Duration</A></TD><TD>int</TD><TD>Duration of playing. It makes sense only when the data is audio or video.</TD></TR><TR><TD><A HREF="#SamplingBits">SamplingBits</A></TD><TD>int</TD><TD>The sampling bits of the audio. It makes sense only if the data is audio or video.</TD></TR><TR><TD><A HREF="#Frequency">Frequency</A></TD><TD>int</TD><TD>The sampling frequency. It makes sense only if the data is audio or video.</TD></TR><TR><TD><A HREF="#Stereo">Stereo</A></TD><TD>smallint</TD><TD>The stereo switch:<BR>0: mono; non zero: stereo.<BR>It makes sense only if data is audio or video.</TD></TR><TR><TD><A HREF="#Bitrate">Bitrate</A></TD><TD>int</TD><TD>The bitrate of playing. It makes sense only if data is audio or video.</TD></TR><TR><TD><A HREF="#DimX">DimX</A></TD><TD>int</TD><TD>Horizontal dimension. It makes sense only if data is video or image.</TD></TR><TR><TD><A HREF="#DimY">DimY</A></TD><TD>int</TD><TD>Vertical dimension. It makes sense only if data is video or image.</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="#DataID">DataID</A></B><TD>bigint</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="#FileTypeID">FileTypeID</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="#DataName">DataName</A><TD>varchar(100)</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="#FileName">FileName</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/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="#Date">Date</A><TD>datetime</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="#Dimension">Dimension</A><TD>bigint</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><TR><TD><A HREF="#Duration">Duration</A><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></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD></TR><TR><TD><A HREF="#SamplingBits">SamplingBits</A><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></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD></TR><TR><TD><A HREF="#Frequency">Frequency</A><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></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD></TR><TR><TD><A HREF="#Stereo">Stereo</A><TD>smallint</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><TR><TD><A HREF="#Bitrate">Bitrate</A><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></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD></TR><TR><TD><A HREF="#DimX">DimX</A><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></TD><TD ALIGN="CENTER"><IMG SRC="../images/unset.gif"></TD></TR><TR><TD><A HREF="#DimY">DimY</A><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></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="DataID">DataID</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : bigint</TD></TR><TR><TD WIDTH="20" ALIGN="center"><IMG SRC="../images/yellowball.gif"></TD><TD><FONT size="+1"><B><A NAME="FileTypeID">FileTypeID</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="DataName">DataName</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : varchar(100)</TD></TR><TR><TD WIDTH="20" ALIGN="center"><IMG SRC="../images/blueball.gif"></TD><TD><FONT size="+1"><B><A NAME="FileName">FileName</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : text</TD></TR><TR><TD WIDTH="20" ALIGN="center"><IMG SRC="../images/blueball.gif"></TD><TD><FONT size="+1"><B><A NAME="Date">Date</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : datetime</TD></TR><TR><TD WIDTH="20" ALIGN="center"><IMG SRC="../images/blueball.gif"></TD><TD><FONT size="+1"><B><A NAME="Dimension">Dimension</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : bigint</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><TR><TD WIDTH="20" ALIGN="center"><IMG SRC="../images/blueball.gif"></TD><TD><FONT size="+1"><B><A NAME="Duration">Duration</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : int</TD></TR><TR><TD WIDTH="20" ALIGN="center"><IMG SRC="../images/blueball.gif"></TD><TD><FONT size="+1"><B><A NAME="SamplingBits">SamplingBits</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : int</TD></TR><TR><TD WIDTH="20" ALIGN="center"><IMG SRC="../images/blueball.gif"></TD><TD><FONT size="+1"><B><A NAME="Frequency">Frequency</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : int</TD></TR><TR><TD WIDTH="20" ALIGN="center"><IMG SRC="../images/blueball.gif"></TD><TD><FONT size="+1"><B><A NAME="Stereo">Stereo</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : smallint</TD></TR><TR><TD WIDTH="20" ALIGN="center"><IMG SRC="../images/blueball.gif"></TD><TD><FONT size="+1"><B><A NAME="Bitrate">Bitrate</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : int</TD></TR><TR><TD WIDTH="20" ALIGN="center"><IMG SRC="../images/blueball.gif"></TD><TD><FONT size="+1"><B><A NAME="DimX">DimX</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : int</TD></TR><TR><TD WIDTH="20" ALIGN="center"><IMG SRC="../images/blueball.gif"></TD><TD><FONT size="+1"><B><A NAME="DimY">DimY</A></B></FONT></TD></TR><TR><TD></TD><TD>Type : int</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 + -