<?php
require_once "Schema.php";

abstract class STINK_student_records_Test_Student extends PHPUnit_Extensions_Database_TestCase_CreateTable
{
	public function getTableName()
	{
		return 'STUDENT';
	}
	
	
	public function getColumnList()
	{
		return array(
			// No need to test legal values because of the FK. If the FK is missing it's broken anyway!
			'STUDENT_ID'		=>	array(	'generic_type'	=>	'NUMBER',
											'sql_type'		=>	array( 'NUMBER', 'INTEGER' ),
											'min_length'	=>	7,
											'max_length'	=>	7,
											'decimals'		=>	0,
											'nullable'		=>	false,
											'test_value'	=>	"1234571",	), // Has to be an unused Person_ID in the fixture because of the FK.
			'HOME_PHONE'		=>	array(	'generic_type'	=>	'TEXT',
											'sql_type'		=>	array( 'VARCHAR2', 'VARCHAR' ),
											'min_length'	=>	15,
											'nullable'		=>	true,
											'test_value'	=>	"612245678764",	),
			'HOME_ADDRESS'		=>	array(	'generic_type'	=>	'TEXT',
											'sql_type'		=>	array( 'VARCHAR2', 'VARCHAR' ),
											'min_length'	=>	200,
											'max_length'	=>	200,
											'nullable'		=>	false,
											'test_value'	=>	"30 Pinewood Ave, Kalumba, NSW",	),
			'INTERNATIONAL'		=>	array(	'generic_type'	=>	'TEXT',
											'sql_type'		=>	array( 'CHAR', 'VARCHAR2', 'VARCHAR' ),
											'min_length'	=>	1,
											'nullable'		=>	false,
											'default'       =>  FALSE_VALUE,
											'legal_values'	=>	array( TRUE_VALUE, FALSE_VALUE ),
// 												'f', 'F', 'false', 'False', 'FALSE', 'n', 'N', 'no', 'No', 'NO', '0',
// 												't', 'T', 'true', 'True', 'TRUE', 'y', 'Y', 'yes', 'Yes', 'YES', '1',	),
											'illegal_values'=>	array( ' ', 'X', '9', '@' ),
											'test_value'	=>	TRUE_VALUE,	),
			// No need to test legal values because of the FK. If the FK is missing it's broken anyway!
			'SUPERVISOR_ID'		=>	array(	'generic_type'	=>	'NUMBER',
											'sql_type'		=>	array( 'NUMBER', 'INTEGER' ),
											'aliases'		=>	array( 'STAFF_ID', 'PERSON_ID' ),
											'min_length'	=>	7,
											'max_length'	=>	7,
											'nullable'		=>	true,
											'test_value'	=>	"1234567",	),	);
	}
	
	
	public function getPKColumnList()
	{
		return array( 'STUDENT_ID' );
	}
	
	
	public function getFKColumnList()
	{
		return array(
			'PERSON' => array( 'STUDENT_ID' ),
			'STAFF' => array( 'SUPERVISOR_ID' ),
		);
	}
	
	
	public function getUniqueColumnList()
	{
		return array();
	}
}
?>