SQLite3x.create_table

def create_table(
        self,
        name: AnyStr,
        columns: ColumnsType,
        IF_NOT_EXIST: bool = None,
        without_rowid: bool = None,
):
    """
    Method to create new table

    Parameters
    ----------
    name : AnyStr
        Name of creating table
    columns : ColumnsType
        Columns of table (ColumnsType-like)
    IF_NOT_EXIST :
        Turn on/off "IF NOT EXISTS" prefix
    without_rowid :
        Turn on/off "WITHOUT ROWID" postfix

    """

import sqllex as sx

db = sx.SQLite3x(path='database.db')
# db = sx.PostgreSQL(...)

db.create_table(
    'table',  # here is name of table
    {
        'column_1': sx.INTEGER,
        'column_2': sx.TEXT
    } 
)

db.create_table(
    'table2',  # here is name of table
    {
        'column_21': sx.INTEGER,
        'column_22': sx.TEXT
    },
    IF_NOT_EXIST=True
)

# database.db
#
# - table
# - - column_1
# - - column_2


db.create_table(
    name='books',
    columns={
        'id': [sx.INTEGER],
        'name': [sx.TEXT, sx.NOT_NULL]
    } 
)

# database.db
#
# - table
# - - column_1
# - - column_2
#
# - books
# - - id
# - - name


db.create_table(
    name='descriptions',
    columns={
        'book_id': [sx.INTEGER],
        'about': [sx.TEXT, sx.NOT_NULL],
        sx.FOREIGN_KEY: {
            'book_id': ['books', 'id']
        }
    },
    IF_NOT_EXIST=True
)


# database.db
#
# - table
# - - column_1
# - - column_2
#
# - books
# - - id  <─────────┐
# - - name          │
#                   │ FOREIGN_KEY
# - descriptions    │
# - - book_id >─────┘
# - - about