Location: PHPKode > projects > Netautor Professional > netautor/napro4/admin/docu/en/adm_schema.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
	<title>Documentation | Netautor Professional | Data Schema</title>
	<link rel="stylesheet" type="text/css" href="../../../include/docu.css">
</head>
<body>
<a name="page_top"> </a>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
	<td class="menu">
		<font class="menu"><b>application:</b></font>
		<font class="function"><b>Data Schema</b></font>
	</td>
	<td align="right" nowrap>
		<span class="link">
		&raquo;&nbsp;<a href="#screen" class="link">Screenshot</a><br>
		</span>
	</td>
</tr>
</table>

<br>

<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
	<td class="text">
		<font class="menu"><b>Description:</b></a>
		<br>
		The schema manager can be used to define data structures, which are used
		in Netautor applications.
		<br>
		Knowledge in SQL administration and design is not necessary, but 
		it is advisable to consider the required fields and dependecies before.

		The following field types are available:
		<ul>
			<li>Char (text, max. length of 255 chars)</li>
			<li>Text (text, max. length 16MByte or 2 GB, depending on the database used)</li>
			<li>Date</li>
			<li>Time</li>
			<li>Number (integer)</li>
			<li>Multi Media data (Images, Movies, ... )</li>
			<li>Area     (An area containing more fields)</li>
		</ul>

		Each schema represents a more or less complex XML structure.
		Netautor saves this structure into one or more tables in the database.
	</td>
</tr>
<tr>
	<td class="text" align="right">
		<a href="#page_top" class="menu"><img src="../../../grafik/button_top.gif" border="0"></a><br>
		<img src="../../../grafik/pixel.gif" width="1" height="4"><br>
	</td>
</tr>
<tr>
	<td class="line"><img src="../../../grafik/pixel.gif" width="1" height="1"></td>
</tr>
</table>

<br>

<a name="screen"> </a>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
	<td class="text">
		<font class="menu"><b>Screenshot:</b></font>
		<br>
		<img src="../../../grafik/pixel.gif" width="1" height="4"><br>
		<img src="../../../grafik/en/docu/adm_schema.jpg" width="723" height="278"><br>
		<br>
		
		<table width="732" class="text">
		<tr>
			<td width="350" valign="top">
				<ol type="1">
					<li value="1" class="screenshot">
						<b>New field</b>
						<br>
						clears the input fields and prepares the form for creating an new field.<br>
						<br>
					</li>
					<li value="2" class="screenshot">
						<b>save field</b>
						<br>
						saves a data field<br>
						<br>
					</li>
					<li value="3" class="screenshot">
						<b>delete field</b>
						<br>
						deletes the current data field<br>
						<br>
					</li>
					<li value="4" class="screenshot">
						<b>table selection (schema selection)</b>
						<br>
						specifies, in which schema a data field should be created, updated or deleted.<br>
						<br>
					</li>
					<li value="5" class="screenshot">
						<b>area selection</b>
						<br>
						specifies, in which area of the current schema a data field should be created, updated or deleted.<br>
						<br>
					</li>
					<li value="6" class="screenshot">
						<b>name</b>
						<br>
						name of the data field.<br>
						<br>
					</li>
					<li value="7" class="screenshot">
						<b>remark</b>
						<br>
						comments about the data field.<br>
						<br>
					</li>
					<li value="8" class="screenshot">
						<b>content type</b>
						<br>
						specifies the data type of a field.<br>
						<br>
					</li>
					<li value="9" class="screenshot">
						<b>pre-settings</b>
						<br>
						opens a new window cotaining the pre-settings of the field, depending on its data type.<br>
						<br>
					</li>
				</ol>
			</td>
			<td width="27" valign="top">
				<img src="../../../grafik/pixel.gif" width="27" height="1"><br>
			</td>
			<td width="355" valign="top">
				<ol type="1">
					<li value="10" class="screenshot">
						<b>multiple entries</b>
						<br>
						allows multiple values for a data field.<br>
						<img src="../../../grafik/pixel.gif" width="1" height="6"><br>
						<b>mandatory</b>
						<br>
						specifies, if a value for this field is mandatory.<br>
						<img src="../../../grafik/pixel.gif" width="1" height="6"><br>
						<b>Unique</b>
						<br>
						prevents that the same value is used several times.<br>
						<img src="../../../grafik/pixel.gif" width="1" height="6"><br>
						<b>Index</b>
						<br>
						Indexes the value. Permits faster data-access.<br>
						<br>
					</li>
					<li value="11" class="screenshot">
						<b>create table</b>
						<br>
						opens a new window where a new schema can be created.<br>
						<img src="../../../grafik/pixel.gif" width="1" height="6"><br>
						<b>table process</b>
						<br>
						opens a new window where the schema selected in the table selection box (4)
						can be renamed or deleted. Also version control setigns can be changed.<br>
						<br>
					</li>
					<li value="12" class="screenshot">
						<b>table selection</b>
						<br>
						to select a schema which should be altered or displayed in the detail view.<br>
						<br>
					</li>
					<li value="13" class="screenshot">
						<b>detail view</b>
						<br>
						shows details about the schema selected in the table selection box (12).<br>
						<br>
					</li>
					<li value="14" class="screenshot">
						<b>Fulltext index</b>
						<br>
						Using this tool, a full text index of the database can be created.
						Currently, this function can only be used with Oracle and MySQL.
						MS SQL users have to create this index using the MS SQL Enterprise Manager.
						<br>
						After successfull index creation, the Netautor function <i>"npf_results"</i> can be used for full text search in the database.<br>
						<br>
					</li>
				</ol>
			</td>
		</tr>
		</table>

<br>
<!--
<table border="0" cellpadding="0" cellspacing="5" width="100%">
<tr>
	<td class="text">
		<font class="menu"><b>Related:</b></font>
	</td>
	<td class="text" align="right">
		<a href="#page_top" class="menu"><img src="../../../grafik/button_top.gif" border="0"></a><br>
		<img src="../../../grafik/pixel.gif" width="1" height="4"><br>
	</td>
</tr>
<tr>
	<td class="line" colspan="2"><img src="../../../grafik/pixel.gif" width="1" height="1"></td>
</tr>
</table>
-->
<a name="ende"> </a>

</body>
</html>
Return current item: Netautor Professional