mil.nga.geopackage.db.master.SQLiteMasterColumn Maven / Gradle / Ivy

Go to download
package mil.nga.geopackage.db.master;

/**
 * SQLite Master table (sqlite_master) column keywords
 * 
 * @author osbornb
 * @since 3.3.0
 */
public enum SQLiteMasterColumn {

	/**
	 * The sqlite_master.type column will be one of the following text strings:
	 * 'table', 'index', 'view', or 'trigger' according to the type of object
	 * defined. The 'table' string is used for both ordinary and virtual tables.
	 */
	TYPE,

	/**
	 * The sqlite_master.name column will hold the name of the object.
	 */
	NAME,

	/**
	 * The sqlite_master.tbl_name column holds the name of a table or view that
	 * the object is associated with. For a table or view, the tbl_name column
	 * is a copy of the name column. For an index, the tbl_name is the name of
	 * the table that is indexed. For a trigger, the tbl_name column stores the
	 * name of the table or view that causes the trigger to fire.
	 */
	TBL_NAME,

	/**
	 * The sqlite_master.rootpage column stores the page number of the root
	 * b-tree page for tables and indexes. For rows that define views, triggers,
	 * and virtual tables, the rootpage column is 0 or NULL.
	 */
	ROOTPAGE,

	/**
	 * The sqlite_master.sql column stores SQL text that describes the object.
	 * This SQL text is a CREATE TABLE, CREATE VIRTUAL TABLE, CREATE INDEX,
	 * CREATE VIEW, or CREATE TRIGGER statement that if evaluated against the
	 * database file when it is the main database of a database connection would
	 * recreate the object.
	 */
	SQL;

}