SqTable

SqEntry
│
└─── SqReentry
     │
     └─── SqTable

	typedef struct  User    User;

	SqTable *table;
	SqType  *tableType = NULL;

	// Using functions of SqSchema to create tables (Recommend)
	table = sq_schema_create(schema, "users", User);

	// Using sq_table_new() to create tables
	table = sq_table_new("users", tableType);
	sq_schema_add(schema, table);

	typedef struct  User    User;

	Sq::Table *table;
	Sq::Type  *tableType = NULL;

	// Using methods of Sq::Schema to create tables (Recommend)
	table = schema->create<User>("users");

	// Using constructor of Sq::Table to create tables
	table = new Sq::Table("users", tableType);
	schema->add(table);

struct DemoTable {
	// ...

	// MyStructure is user-defined C struct
	// This will store JSON object in database column.
	MyStructure    myStruct;

	// SqIntArray is integer array that defined in SqArray.h
	// This will store JSON integer array in database column.
	SqIntArray     intArray;
};

	// JSON object will be stored in VARCHAR column if SQL type is not specified.
	column = sq_table_add_custom(table, "myStruct", offsetof(DemoTable, myStruct),
	                             SQ_TYPE_MY_STRUCT, 128);

	// JSON integer array will be stored in VARCHAR column if SQL type is not specified.
	column = sq_table_add_custom(table, "intArray", offsetof(DemoTable, intArray),
	                             SQ_TYPE_INT_ARRAY, 96);

	// JSON object will be stored in VARCHAR column if SQL type is not specified.
	column = table->custom("myStruct", offsetof(DemoTable, myStruct),
	                       SQ_TYPE_MY_STRUCT, 128);

	// JSON integer array will be stored in VARCHAR column if SQL type is not specified.
	column = table->custom("intArray", offsetof(DemoTable, intArray),
	                       SQ_TYPE_INT_ARRAY, 96);

	// use '&DemoTable::myStruct' to replace 'offsetof(DemoTable, myStruct)'
	column = table->custom("myStruct", &DemoTable::myStruct,
	                       SQ_TYPE_MY_STRUCT, 128);

	// use '&DemoTable::intArray' to replace 'offsetof(DemoTable, intArray)'
	column = table->custom("intArray", &DemoTable::intArray,
	                       SQ_TYPE_INT_ARRAY, 96);

	// JSON integer array will be stored in SQL TEXT column.
	column = sq_table_add_mapping(table, "intArray", offsetof(DemoTable, intArray),
	                              SQ_TYPE_INT_ARRAY,
	                              SQ_SQL_TYPE_TEXT);

	// JSON integer array will be stored in SQL TEXT column.
	column = table->mapping("intArray", offsetof(DemoTable, intArray),
	                        SQ_TYPE_INT_ARRAY,
	                        SQ_SQL_TYPE_TEXT);

	// C function
	sq_table_drop_column(table, "columnName");

	// C++ method
	table->dropColumn("columnName");

	// C function
	sq_table_rename_column(table, "old_name", "new_name");

	// C++ method
	table->renameColumn("old_name", "new_name");

	// C function
	column = sq_table_find_column(table, "columnName");

	// C++ method
	column = table->findColumn("columnName");

	// C function
	column = sq_table_get_primary(table, NULL);

	// C++ method
	column = table->getPrimary();

	// C function
	column = sq_table_add_index(table, "indexName", "columnName01", "columnName02", NULL);

	// C++ method
	column = table->index("indexName", "columnName01", "columnName02");

	// C function
	sq_table_drop_index(table, "indexName");

	// C++ method
	table->dropIndex("indexName");

	// C function
	column = sq_table_add_unique(table, "uniqueName", "columnName01", "columnName02", NULL);

	// C++ method
	column = table->unique("uniqueName", "columnName01", "columnName02");

	// C function
	sq_table_drop_unique(table, "uniqueName");

	// C++ method
	table->dropUnique("uniqueName");

	// C function
	column = sq_table_add_primary(table, "primaryName", "columnName01", "columnName02", NULL);

	// C++ method
	column = table->primary("primaryName", "columnName01", "columnName02");

	// C function
	sq_table_drop_primary(table, "primaryName");

	// C++ method
	table->dropPrimary("primaryName");

	// C function
	// The last argument of sq_table_add_foreign() must be NULL.
	column = sq_table_add_foreign(table, "foreignName", "column1", "column2", NULL);
	sq_column_reference(column, "foreignTableName",     "column1", "column2", NULL);

	// C++ method
	column = table->foreign("foreignName", "column1", "column2");
	column->reference("foreignTableName",  "column1", "column2");

	// C function
	sq_table_drop_foreign(table, "foreignName");

	// C++ method
	table->dropForeign("foreignName");