summaryrefslogtreecommitdiff
path: root/framework/db/schema/CDbTableSchema.php
diff options
context:
space:
mode:
Diffstat (limited to 'framework/db/schema/CDbTableSchema.php')
-rw-r--r--framework/db/schema/CDbTableSchema.php78
1 files changed, 78 insertions, 0 deletions
diff --git a/framework/db/schema/CDbTableSchema.php b/framework/db/schema/CDbTableSchema.php
new file mode 100644
index 0000000..b70a2c8
--- /dev/null
+++ b/framework/db/schema/CDbTableSchema.php
@@ -0,0 +1,78 @@
+<?php
+/**
+ * CDbTableSchema class file.
+ *
+ * @author Qiang Xue <qiang.xue@gmail.com>
+ * @link http://www.yiiframework.com/
+ * @copyright Copyright &copy; 2008-2011 Yii Software LLC
+ * @license http://www.yiiframework.com/license/
+ */
+
+/**
+ * CDbTableSchema is the base class for representing the metadata of a database table.
+ *
+ * It may be extended by different DBMS driver to provide DBMS-specific table metadata.
+ *
+ * CDbTableSchema provides the following information about a table:
+ * <ul>
+ * <li>{@link name}</li>
+ * <li>{@link rawName}</li>
+ * <li>{@link columns}</li>
+ * <li>{@link primaryKey}</li>
+ * <li>{@link foreignKeys}</li>
+ * <li>{@link sequenceName}</li>
+ * </ul>
+ *
+ * @property array $columnNames List of column names.
+ *
+ * @author Qiang Xue <qiang.xue@gmail.com>
+ * @version $Id: CDbTableSchema.php 3426 2011-10-25 00:01:09Z alexander.makarow $
+ * @package system.db.schema
+ * @since 1.0
+ */
+class CDbTableSchema extends CComponent
+{
+ /**
+ * @var string name of this table.
+ */
+ public $name;
+ /**
+ * @var string raw name of this table. This is the quoted version of table name with optional schema name. It can be directly used in SQLs.
+ */
+ public $rawName;
+ /**
+ * @var string|array primary key name of this table. If composite key, an array of key names is returned.
+ */
+ public $primaryKey;
+ /**
+ * @var string sequence name for the primary key. Null if no sequence.
+ */
+ public $sequenceName;
+ /**
+ * @var array foreign keys of this table. The array is indexed by column name. Each value is an array of foreign table name and foreign column name.
+ */
+ public $foreignKeys=array();
+ /**
+ * @var array column metadata of this table. Each array element is a CDbColumnSchema object, indexed by column names.
+ */
+ public $columns=array();
+
+ /**
+ * Gets the named column metadata.
+ * This is a convenient method for retrieving a named column even if it does not exist.
+ * @param string $name column name
+ * @return CDbColumnSchema metadata of the named column. Null if the named column does not exist.
+ */
+ public function getColumn($name)
+ {
+ return isset($this->columns[$name]) ? $this->columns[$name] : null;
+ }
+
+ /**
+ * @return array list of column names
+ */
+ public function getColumnNames()
+ {
+ return array_keys($this->columns);
+ }
+}