Map Traveler MCP
by mfukushim
{
"version": "6",
"dialect": "sqlite",
"id": "d736ddc4-63a1-4ea8-af00-41764effaf37",
"prevId": "00000000-0000-0000-0000-000000000000",
"tables": {
"anniversary": {
"name": "anniversary",
"columns": {
"id": {
"name": "id",
"type": "integer",
"primaryKey": true,
"notNull": true,
"autoincrement": true
},
"year": {
"name": "year",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"month": {
"name": "month",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"day": {
"name": "day",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"name": {
"name": "name",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"dayOff": {
"name": "dayOff",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": 0
},
"dayType": {
"name": "dayType",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": 0
},
"historyType": {
"name": "historyType",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": 0
},
"historyId": {
"name": "historyId",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": 0
},
"del": {
"name": "del",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": false
},
"created": {
"name": "created",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
}
},
"indexes": {},
"foreignKeys": {},
"compositePrimaryKeys": {},
"uniqueConstraints": {},
"checkConstraints": {}
},
"avatar_model": {
"name": "avatar_model",
"columns": {
"id": {
"name": "id",
"type": "integer",
"primaryKey": true,
"notNull": true,
"autoincrement": true
},
"comment": {
"name": "comment",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"baseCharPrompt": {
"name": "baseCharPrompt",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"created": {
"name": "created",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"modelName": {
"name": "modelName",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
}
},
"indexes": {},
"foreignKeys": {},
"compositePrimaryKeys": {},
"uniqueConstraints": {},
"checkConstraints": {}
},
"avatar_sns": {
"name": "avatar_sns",
"columns": {
"id": {
"name": "id",
"type": "integer",
"primaryKey": true,
"notNull": true,
"autoincrement": true
},
"assignAvatarId": {
"name": "assignAvatarId",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"snsType": {
"name": "snsType",
"type": "text(4)",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"snsHandleName": {
"name": "snsHandleName",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"snsId": {
"name": "snsId",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"checkedPostId": {
"name": "checkedPostId",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"mentionPostId": {
"name": "mentionPostId",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"created": {
"name": "created",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"enable": {
"name": "enable",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": false
}
},
"indexes": {},
"foreignKeys": {},
"compositePrimaryKeys": {},
"uniqueConstraints": {},
"checkConstraints": {}
},
"env_kv": {
"name": "env_kv",
"columns": {
"key": {
"name": "key",
"type": "text",
"primaryKey": true,
"notNull": true,
"autoincrement": false
},
"value": {
"name": "value",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"created": {
"name": "created",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"updated": {
"name": "updated",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
}
},
"indexes": {},
"foreignKeys": {},
"compositePrimaryKeys": {},
"uniqueConstraints": {},
"checkConstraints": {}
},
"run_abroad_route": {
"name": "run_abroad_route",
"columns": {
"id": {
"name": "id",
"type": "integer",
"primaryKey": true,
"notNull": true,
"autoincrement": true
},
"html_instructions": {
"name": "html_instructions",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"maneuver": {
"name": "maneuver",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"duration": {
"name": "duration",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"terminalStart": {
"name": "terminalStart",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
}
},
"indexes": {},
"foreignKeys": {},
"compositePrimaryKeys": {},
"uniqueConstraints": {},
"checkConstraints": {}
},
"run_avatar": {
"name": "run_avatar",
"columns": {
"id": {
"name": "id",
"type": "integer",
"primaryKey": true,
"notNull": true,
"autoincrement": true
},
"name": {
"name": "name",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"modelId": {
"name": "modelId",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"created": {
"name": "created",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"enable": {
"name": "enable",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": false
},
"nextStayTime": {
"name": "nextStayTime",
"type": "integer",
"primaryKey": false,
"notNull": false,
"autoincrement": false
},
"lang": {
"name": "lang",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"currentRoute": {
"name": "currentRoute",
"type": "text",
"primaryKey": false,
"notNull": false,
"autoincrement": false
}
},
"indexes": {},
"foreignKeys": {},
"compositePrimaryKeys": {},
"uniqueConstraints": {},
"checkConstraints": {}
},
"run_terminal": {
"name": "run_terminal",
"columns": {
"id": {
"name": "id",
"type": "integer",
"primaryKey": true,
"notNull": true,
"autoincrement": true
},
"country": {
"name": "country",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"name": {
"name": "name",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"type": {
"name": "type",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"lat": {
"name": "lat",
"type": "real",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": 0
},
"lng": {
"name": "lng",
"type": "real",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": 0
}
},
"indexes": {},
"foreignKeys": {},
"compositePrimaryKeys": {},
"uniqueConstraints": {},
"checkConstraints": {}
},
"run_history": {
"name": "run_history",
"columns": {
"seq": {
"name": "seq",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"tripId": {
"name": "tripId",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"lng": {
"name": "lng",
"type": "real",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"lat": {
"name": "lat",
"type": "real",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"elapsed": {
"name": "elapsed",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"address": {
"name": "address",
"type": "text",
"primaryKey": false,
"notNull": false,
"autoincrement": false,
"default": "'NULL'"
},
"imagePath": {
"name": "imagePath",
"type": "text",
"primaryKey": false,
"notNull": false,
"autoincrement": false,
"default": "'NULL'"
},
"coursePath": {
"name": "coursePath",
"type": "text",
"primaryKey": false,
"notNull": false,
"autoincrement": false,
"default": "'NULL'"
},
"placePath": {
"name": "placePath",
"type": "text",
"primaryKey": false,
"notNull": false,
"autoincrement": false,
"default": "'NULL'"
},
"plainPath": {
"name": "plainPath",
"type": "text",
"primaryKey": false,
"notNull": false,
"autoincrement": false,
"default": "'NULL'"
},
"createTime": {
"name": "createTime",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"time": {
"name": "time",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"standOffsetX": {
"name": "standOffsetX",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": 0
},
"standOffsetY": {
"name": "standOffsetY",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": 0
},
"model": {
"name": "model",
"type": "text",
"primaryKey": false,
"notNull": false,
"autoincrement": false,
"default": "'NULL'"
},
"fitImage": {
"name": "fitImage",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": 0
},
"appendPrompt": {
"name": "appendPrompt",
"type": "text",
"primaryKey": false,
"notNull": false,
"autoincrement": false,
"default": "'NULL'"
},
"pictAuthor": {
"name": "pictAuthor",
"type": "text",
"primaryKey": false,
"notNull": false,
"autoincrement": false,
"default": "'NULL'"
}
},
"indexes": {
"UQ_seq": {
"name": "UQ_seq",
"columns": [
"seq"
],
"isUnique": true
}
},
"foreignKeys": {},
"compositePrimaryKeys": {},
"uniqueConstraints": {},
"checkConstraints": {}
},
"run_status": {
"name": "run_status",
"columns": {
"id": {
"name": "id",
"type": "integer",
"primaryKey": true,
"notNull": true,
"autoincrement": true
},
"avatarId": {
"name": "avatarId",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": 1
},
"tripId": {
"name": "tripId",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": 0
},
"tilEndEpoch": {
"name": "tilEndEpoch",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": 0
},
"status": {
"name": "status",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"from": {
"name": "from",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"to": {
"name": "to",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"destination": {
"name": "destination",
"type": "text",
"primaryKey": false,
"notNull": false,
"autoincrement": false
},
"startLat": {
"name": "startLat",
"type": "real",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"startLng": {
"name": "startLng",
"type": "real",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"endLat": {
"name": "endLat",
"type": "real",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"endLng": {
"name": "endLng",
"type": "real",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"durationSec": {
"name": "durationSec",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"distanceM": {
"name": "distanceM",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"startTime": {
"name": "startTime",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"startCountry": {
"name": "startCountry",
"type": "text(4)",
"primaryKey": false,
"notNull": false,
"autoincrement": false,
"default": "'NULL'"
},
"endCountry": {
"name": "endCountry",
"type": "text(4)",
"primaryKey": false,
"notNull": false,
"autoincrement": false,
"default": "'NULL'"
},
"startTz": {
"name": "startTz",
"type": "text",
"primaryKey": false,
"notNull": false,
"autoincrement": false,
"default": "'NULL'"
},
"endTz": {
"name": "endTz",
"type": "text",
"primaryKey": false,
"notNull": false,
"autoincrement": false,
"default": "'NULL'"
},
"currentPathNo": {
"name": "currentPathNo",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": 0
},
"currentStepNo": {
"name": "currentStepNo",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": 0
}
},
"indexes": {},
"foreignKeys": {},
"compositePrimaryKeys": {},
"uniqueConstraints": {},
"checkConstraints": {}
},
"sns_posts": {
"name": "sns_posts",
"columns": {
"id": {
"name": "id",
"type": "integer",
"primaryKey": true,
"notNull": true,
"autoincrement": true
},
"snsType": {
"name": "snsType",
"type": "text(2)",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"snsPostId": {
"name": "snsPostId",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"snsReplyId": {
"name": "snsReplyId",
"type": "text",
"primaryKey": false,
"notNull": false,
"autoincrement": false,
"default": "'NULL'"
},
"postType": {
"name": "postType",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"sendUserId": {
"name": "sendUserId",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"info": {
"name": "info",
"type": "text",
"primaryKey": false,
"notNull": false,
"autoincrement": false,
"default": "'NULL'"
},
"del": {
"name": "del",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"createTime": {
"name": "createTime",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
}
},
"indexes": {},
"foreignKeys": {},
"compositePrimaryKeys": {},
"uniqueConstraints": {},
"checkConstraints": {}
},
"test_tab": {
"name": "test_tab",
"columns": {
"id": {
"name": "id",
"type": "integer",
"primaryKey": true,
"notNull": true,
"autoincrement": true
},
"issue_id": {
"name": "issue_id",
"type": "text",
"primaryKey": false,
"notNull": true,
"autoincrement": false
},
"comment": {
"name": "comment",
"type": "text",
"primaryKey": false,
"notNull": false,
"autoincrement": false
},
"del": {
"name": "del",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false,
"default": false
},
"created": {
"name": "created",
"type": "integer",
"primaryKey": false,
"notNull": true,
"autoincrement": false
}
},
"indexes": {},
"foreignKeys": {},
"compositePrimaryKeys": {},
"uniqueConstraints": {},
"checkConstraints": {}
}
},
"views": {},
"enums": {},
"_meta": {
"schemas": {},
"tables": {},
"columns": {}
},
"internal": {
"indexes": {}
}
}