show tables from jose; describe Collection; describe Game; describe MoreGame; describe Player; describe Event; describe Site; describe Opening; describe IO_Collection; describe IO_Game; describe IO_Player; describe IO_Event; describe IO_Site; describe IO_Opening; describe Map_Collection; describe Map_Game; describe Map_Player; describe Map_Event; describe Map_Site; describe Map_Opening; describe MetaInfo; < Collection keeps together a set of Games. Can be nested recursively, like file folders. > 0, Field , Type , Null , Key , Default, Extra 1, 'Id' , 'int(11)' , '' , 'PRI', '0' , Primate Key 2, 'PId' , 'int(11)' , '' , 'MUL', '0' , Foreign key to Parent Collection (think: folder) 3, 'OPId' , 'int(11)' , 'YES', '' , null , For deleted entries: place to restore the original state 4, 'Name' , 'varchar(255)' , '' , 'MUL', '' , Display name 5, 'Path' , 'varchar(255)' , 'YES', 'MUL', null , Folder Path (just like a file path) 6, 'Attributes' , 'tinyint(4)' , '' , '' , '0' , Flags for system folders, ... 7, 'SourceURL' , 'varchar(255)' , 'YES', 'MUL', null , Where this came from (not yet used) 8, 'LastModified', 'timestamp(14)', 'YES', 'MUL', null , Last Modified Flag 9, 'GameCount' , 'int(11)' , '' , '' , '0' , Number of contained Games (redundant but quicker than select count(*)) < Game holds fixed-size Game Meta-Data > 0 , Field , Type , Null , Key , Default, Extra 1 , 'Id' , 'int(11)' , '' , 'PRI', '0' , Primary Key for a Game 2 , 'CId' , 'int(11)' , '' , 'MUL', '0' , Foreign key to owning Collection 3 , 'Idx' , 'int(11)' , '' , 'MUL', '0' , Sort Index within a Collection 4 , 'Attributes' , 'tinyint(4)' , '' , 'MUL', '0' , Flags: has variations, has comments, ... 5 , 'OCId' , 'int(11)' , 'YES', '' , null , For deleted Games: foreign key to original Collection 6 , 'OIdx' , 'int(11)' , 'YES', '' , null , For deleted Games: foreign key to original Index 7 , 'PlyCount' , 'int(11)' , '' , '' , '0' , Number of Plies 8 , 'Result' , 'tinyint(4)' , '' , 'MUL', '0' , Result (0,1,1/2,*) 9 , 'WhiteId' , 'int(11)' , '' , 'MUL', '0' , Foreign key to White Player 10, 'BlackId' , 'int(11)' , '' , 'MUL', '0' , Foreign key to Black Player 11, 'WhiteELO' , 'int(11)' , 'YES', 'MUL', null , White ELO 12, 'BlackELO' , 'int(11)' , 'YES', 'MUL', null , Black ELO 13, 'EventId' , 'int(11)' , '' , 'MUL', '0' , Foreign key to Event 14, 'SiteId' , 'int(11)' , '' , 'MUL', '0' , Foreign key to Site 15, 'GameDate' , 'date' , 'YES', 'MUL', null , Game Date 16, 'EventDate' , 'date' , 'YES', 'MUL', null , Event Date 17, 'DateFlags' , 'smallint(6)', '' , '' , '0' , Flags: has month, day, ... 18, 'OpeningId' , 'int(11)' , '' , 'MUL', '0' , Foreign key to Opening 19, 'ECO' , 'char(3)' , 'YES', 'MUL', null , ECO code (three chars) 20, 'AnnotatorId', 'int(11)' , '' , 'MUL', '0' , Foreign key to Annotator < MoreGame holds variable-sized Game data > 0, Field , Type , Null , Key , Default, Extra 1, 'GId' , 'int(11)' , '' , 'PRI', '0' , Foreign key to Game 2, 'WhiteTitle', 'varchar(32)' , 'YES', 'MUL', null , White Title 3, 'BlackTitle', 'varchar(32)' , 'YES', 'MUL', null , Black Title 4, 'Round' , 'varchar(32)' , 'YES', 'MUL', null , Round 5, 'Board' , 'varchar(32)' , 'YES', 'MUL', null , Board 6, 'FEN' , 'varchar(128)', 'YES', '' , null , Start FEN (optional) 7, 'Info' , 'varchar(255)', 'YES', 'MUL', null , More PGN tags as csv, key=value 8, 'WhiteSignature', bigint(20), NO , Material Signature for White Pieces 9, 'BlackSignature', bigint(20), NO , Material Signature for Black Pieces 10, 'Bin' , 'mediumblob', 'YES' , Game Moves (binary sequence) 11, 'Comments' , 'mediumtext', 'YES', 'MUL' , Comments (0-terminated strings) 12, 'PosMain', mediumtext, YES,MUL , Position Index (deprecated, not used at all) 13, 'PosVar', mediumtext, YES,MUL , Position Index (deprecated, not used at all) 14, Eval, mediumblob, YES , Evaluation History (populates the Eval Graph) < Player (speaks for itself) > 0, Field , Type , Null, Key , Default, Extra 1, 'Id' , 'int(11)' , '' , 'PRI', '0' , Primary Key 2, 'Name' , 'varchar(255)', '' , 'MUL', '' , Name 3, 'UpperName', 'varchar(255)', '' , 'MUL', '' , Name in Upper Case (meant to speed up queries, it's probably useless) 4, 'Soundex' , 'varchar(6)' , '' , 'MUL', '-' , Soundex (useful for soundex queries) < Event (you guessed it) > 0, Field , Type , Null, Key , Default, Extra 1, 'Id' , 'int(11)' , '' , 'PRI', '0' , '' 2, 'Name' , 'varchar(255)', '' , 'MUL', '' , '' 3, 'UpperName', 'varchar(255)', '' , 'MUL', '' , '' 4, 'Soundex' , 'varchar(6)' , '' , 'MUL', '-' , '' < Site > 0, Field , Type , Null, Key , Default, Extra 1, 'Id' , 'int(11)' , '' , 'PRI', '0' , '' 2, 'Name' , 'varchar(255)', '' , 'MUL', '' , '' 3, 'UpperName', 'varchar(255)', '' , 'MUL', '' , '' 4, 'Soundex' , 'varchar(6)' , '' , 'MUL', '-' , '' < Opening (name and ECO) > 0, Field , Type , Null , Key , Default, Extra 1, 'Id' , 'int(11)' , '' , 'PRI', '0' , Primary Key 2, 'HashKey' , 'bigint(20)' , '' , 'MUL', '0' , Zobrist key for querying an opening book (of the ECO index?) 3, 'Ply' , 'int(11)' , 'YES', '' , null , Ply where the eco code was found 4, 'ECO' , 'char(3)' , '' , 'MUL', '-' , three-letter eco code 5, 'Name' , 'varchar(255)', '' , 'MUL', '' , Name (in any language) 6, 'UpperName', 'varchar(255)', '' , 'MUL', '' , '' 7, 'Soundex' , 'varchar(6)' , '' , 'MUL', '-' , '' < IO_Collection IO schema is stored inside *.jose files. Used to transfer a set of games to another database. Very similar to the Main schema above, except for the Game table. > 0, Field , Type , Null , Key , Default, Extra 1, 'Id' , 'int(11)' , '' , 'PRI', '0' , '' 2, 'PId' , 'int(11)' , '' , '' , '0' , '' 3, 'Name' , 'varchar(255)', '' , '' , '' , '' 4, 'Path' , 'varchar(255)', 'YES', '' , null , '' 5, 'Attributes', 'tinyint(4)' , '' , '' , '0' , '' 6, 'SourceURL' , 'varchar(255)', 'YES', '' , null , '' 7, 'GameCount' , 'int(11)' , '' , '' , '0' , '' < IO_Game stores info from Game and MoreGame in one table > 0 , Field , Type , Null , Key , Default, Extra 1 , 'Id' , 'int(11)' , '' , 'PRI', '0' , '' 2 , 'CId' , 'int(11)' , '' , '' , '0' , '' 3 , 'Idx' , 'int(11)' , '' , '' , '0' , '' 4 , 'Attributes' , 'tinyint(4)' , '' , '' , '0' , '' 5 , 'PlyCount' , 'int(11)' , '' , '' , '0' , '' 6 , 'Result' , 'tinyint(4)' , '' , '' , '0' , '' 7 , 'WhiteId' , 'int(11)' , '' , '' , '0' , '' 8 , 'BlackId' , 'int(11)' , '' , '' , '0' , '' 9 , 'WhiteELO' , 'int(11)' , 'YES', '' , null , '' 10, 'BlackELO' , 'int(11)' , 'YES', '' , null , '' 11, 'EventId' , 'int(11)' , '' , '' , '0' , '' 12, 'SiteId' , 'int(11)' , '' , '' , '0' , '' 13, 'GameDate' , 'date' , 'YES', '' , null , '' 14, 'EventDate' , 'date' , 'YES', '' , null , '' 15, 'DateFlags' , 'smallint(6)' , '' , '' , '0' , '' 16, 'OpeningId' , 'int(11)' , '' , '' , '0' , '' 17, 'ECO' , 'char(3)' , 'YES', '' , null , '' 18, 'AnnotatorId', 'int(11)' , '' , '' , '0' , '' 19, 'WhiteTitle' , 'varchar(32)' , 'YES', '' , null , '' 20, 'BlackTitle' , 'varchar(32)' , 'YES', '' , null , '' 21, 'Round' , 'varchar(32)' , 'YES', 'MUL', null , '' 22, 'Board' , 'varchar(32)' , 'YES', '' , null , '' 23, 'FEN' , 'varchar(128)', 'YES', '' , null , '' 24, 'Info' , 'varchar(255)', 'YES', '' , null , '' 25, 'WhiteSignature', bigint(20), NO , Material Signature for White Pieces 26, 'BlackSignature', bigint(20), NO , Material Signature for Black Pieces 27, 'Bin' , 'mediumblob' , 'YES', '' , null , '' 28, 'Comments' , 'mediumtext' , 'YES', '' , null , '' < IO_Player > 0, Field , Type , Null, Key , Default, Extra 1, 'Id' , 'int(11)' , '' , 'PRI', '0' , '' 2, 'Name', 'varchar(255)', '' , '' , '' , '' < IO_Event > 0, Field , Type , Null, Key , Default, Extra 1, 'Id' , 'int(11)' , '' , 'PRI', '0' , '' 2, 'Name', 'varchar(255)', '' , '' , '' , '' < IO_Site > 0, Field , Type , Null, Key , Default, Extra 1, 'Id' , 'int(11)' , '' , 'PRI', '0' , '' 2, 'Name', 'varchar(255)', '' , '' , '' , '' < IO_Opening > 0, Field , Type , Null , Key , Default, Extra 1, 'Id' , 'int(11)' , '' , 'PRI', '0' , '' 2, 'HashKey', 'bigint(20)' , '' , '' , '0' , '' 3, 'Ply' , 'int(11)' , 'YES', '' , null , '' 4, 'ECO' , 'char(3)' , '' , '' , '' , '' 5, 'Name' , 'varchar(255)', '' , '' , '' , '' < Map_Game used during import and export to re-map keys > 0, Field, Type , Null , Key , Default, Extra 1, 'OId', 'int(11)', 'YES', 'MUL', null , '' 2, 'NId', 'int(11)', 'YES', 'MUL', null , '' < Map_Player > 0, Field, Type , Null , Key , Default, Extra 1, 'OId', 'int(11)', 'YES', 'MUL', null , '' 2, 'NId', 'int(11)', 'YES', 'MUL', null , '' < Map_Event > 0, Field, Type , Null , Key , Default, Extra 1, 'OId', 'int(11)', 'YES', 'MUL', null , '' 2, 'NId', 'int(11)', 'YES', 'MUL', null , '' < Map_Site > 0, Field, Type , Null , Key , Default, Extra 1, 'OId', 'int(11)', 'YES', 'MUL', null , '' 2, 'NId', 'int(11)', 'YES', 'MUL', null , '' < Map_Opening > 0, Field, Type , Null , Key , Default, Extra 1, 'OId', 'int(11)', 'YES', 'MUL', null , '' 2, 'NId', 'int(11)', 'YES', 'MUL', null , '' < Map_Collection > 0, Field, Type , Null , Key , Default, Extra 1, 'OId', 'int(11)', 'YES', 'MUL', null , '' 2, 'NId', 'int(11)', 'YES', 'MUL', null , '' < MetaInfo stores info about the current schema version. essential for automatic schema updates (see CrossOver classes). > 0, Field , Type , Null , Key , Default, Extra 1, 'Property' , 'varchar(64)' , '' , 'MUL', '' , '' 2, 'SchemaName', 'varchar(255)', 'YES', 'MUL', null , '' 3, 'TableName' , 'varchar(255)', 'YES', 'MUL', null , '' 4, 'Version' , 'int(11)' , 'YES', '' , null , '' <