# Schema

class Schema

## Traits

Utils
Detail

## Properties

static | $debug |  |

## Methods

static
setMigrationFilePath(string $filePath)

No description

from Utils
static
getMigrationFilePath()

No description

from Utils
static
isDetailExists(string $hash)

No description

from Utils
static
createMigrationDetail(string $filePath)

No description

from Utils
static
getLastVersion()

No description

from Utils
debug()

No description

from Utils
static
checkTable(string $tableName)

No description

from Utils
static
repairTable(string $tableName)

No description

from Utils
PDOStatement
getTableDetail(string $tableName)

No description

from Detail
PDOStatement
getColumnDetail(string $tableName, string $columnName)

No description

from Detail
array
getTableColumn(string $tableName, bool $fetchAll = false)

No description

from Detail
static bool
hasTable(string $tableName)

CHeck if table is exists or not

from Detail
static bool
hasColumn(string $tableName, string $columnName)

Check if column exists or not

from Detail
Schema
column(string $column)

This method relate with Schema::table('')

from Detail
array
columns(bool $fetchAll = false)

Same as column, but this method will give you more raw information about column in some table

from Detail
static array
tables()

Get all table data from current database

from Detail
bool
isAutoIncrement()

Get boolean result about table and column Auto Increment status

from Detail
bool
isTemporary()

No description

from Detail
bool
isEmpty()

No description

from Detail
bool
isNull()

No description

from Detail
bool
isUnique()

No description

from Detail
bool
isPrimary()

No description

from Detail
bool
isFullText()

No description

from Detail
bool
isExists()

No description

from Detail
static
connection(string $connectionName = 'SLiMS')

No description

static void
getInstance()

Use singleton pattern

void
structureCreate(string $tableName, Closure $callBack)

Create and table schema with Blueprint as designer based on rdbms grammar

Schema|string
structureTable(string $tableName, Closure $callBack = '')

Modify existing table

void
structureDrop(string $tableName)

Drop table just type table name and drop it.

void
structureDropColumn(string $tableName, string $columnName)

Drop column table just type table and column name then drop it.

void
structureTruncate(string $tableName)

Emptying table

string
__call($method, $arguments)

Magic method to call data via scoped property or structure method

static
__callStatic($method, $arguments)

No description

## Details

###
in Utils at line 18
`static setMigrationFilePath(string $filePath)`

No description

#### Parameters

string | $filePath |

###
in Utils at line 23
`static getMigrationFilePath()`

No description

###
in Utils at line 28
`static isDetailExists(string $hash)`

No description

#### Parameters

string | $hash |

###
in Utils at line 36
`static createMigrationDetail(string $filePath)`

No description

#### Parameters

string | $filePath |

###
in Utils at line 49
`static getLastVersion()`

No description

###
in Utils at line 56
`debug()`

No description

###
in Utils at line 61
`static checkTable(string $tableName)`

No description

#### Parameters

string | $tableName |

###
in Utils at line 69
`static repairTable(string $tableName)`

No description

#### Parameters

string | $tableName |

###
in Detail at line 59
`PDOStatement getTableDetail(string $tableName)`

No description

#### Parameters

string | $tableName |

#### Return Value

PDOStatement |

###
in Detail at line 77
`PDOStatement getColumnDetail(string $tableName, string $columnName)`

No description

#### Parameters

string | $tableName |
string | $columnName |

#### Return Value

PDOStatement |

###
in Detail at line 95
`array getTableColumn(string $tableName, bool $fetchAll = false)`

No description

#### Parameters

string | $tableName |
bool | $fetchAll |

#### Return Value

array |

###
in Detail at line 119
`static bool hasTable(string $tableName)`

CHeck if table is exists or not

#### Parameters

string | $tableName |

#### Return Value

bool |

###
in Detail at line 131
`static bool hasColumn(string $tableName, string $columnName)`

Check if column exists or not

#### Parameters

string | $tableName |
string | $columnName |

#### Return Value

bool |

###
in Detail at line 142
`Schema column(string $column)`

This method relate with Schema::table('')

#### Parameters

string | $column |

#### Return Value

Schema |

###
in Detail at line 156
`array columns(bool $fetchAll = false)`

Same as column, but this method will give you more raw information about column in some table

#### Parameters

bool | $fetchAll |

#### Return Value

array |

###
in Detail at line 166
`static array tables()`

Get all table data from current database

#### Return Value

array |

###
in Detail at line 189
`bool isAutoIncrement()`

Get boolean result about table and column Auto Increment status

#### Return Value

bool |

###
in Detail at line 198
`bool isTemporary()`

No description

#### Return Value

bool |

###
in Detail at line 206
`bool isEmpty()`

No description

#### Return Value

bool |

###
in Detail at line 214
`bool isNull()`

No description

#### Return Value

bool |

###
in Detail at line 222
`bool isUnique()`

No description

#### Return Value

bool |

###
in Detail at line 230
`bool isPrimary()`

No description

#### Return Value

bool |

###
in Detail at line 238
`bool isFullText()`

No description

#### Return Value

bool |

###
in Detail at line 246
`bool isExists()`

No description

#### Return Value

bool |

###
at line 45
`static connection(string $connectionName = 'SLiMS')`

No description

#### Parameters

string | $connectionName |

###
at line 57
`static void getInstance()`

Use singleton pattern

#### Return Value

void |

###
at line 73
`void structureCreate(string $tableName, Closure $callBack)`

Create and table schema with Blueprint as designer based on rdbms grammar

#### Parameters

string | $tableName |
Closure | $callBack |

#### Return Value

void |

###
at line 99
`Schema|string structureTable(string $tableName, Closure $callBack = '')`

Modify existing table

#### Parameters

string | $tableName |
Closure | $callBack |

#### Return Value

Schema|string |

###
at line 128
`void structureDrop(string $tableName)`

Drop table just type table name and drop it.

#### Parameters

string | $tableName |

#### Return Value

void |

###
at line 140
`void structureDropColumn(string $tableName, string $columnName)`

Drop column table just type table and column name then drop it.

#### Parameters

string | $tableName |
string | $columnName |

#### Return Value

void |

###
at line 151
`void structureTruncate(string $tableName)`

Emptying table

#### Parameters

string | $tableName |

#### Return Value

void |

###
at line 163
`string __call($method, $arguments)`

Magic method to call data via scoped property or structure method

#### Parameters

| $method |
| $arguments |

#### Return Value

string |

###
at line 185
`static __callStatic($method, $arguments)`

No description

#### Parameters

| $method |
| $arguments |