File size: 3,842 Bytes
c976bfb |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
You will be provided with the question and the database schema in the below json format, which for A is Table name in the system, B is column name, and C is Column data type
---
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagementEN]","B":"IssueID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagementEN]","B":"IssueNameEN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagementEN]","B":"AbstractEN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagementEN]","B":"KeywordsEN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"IssueID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"IssueNameVN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"DOI","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"Language","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"Domain","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"JournalID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"IssuePageNumbers","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"AbstractVN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"KeywordsVN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"ConclusionVN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"IssuePdfURL","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"IssueDocURL","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"DocVectorDB_URL","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueManagement]","B":"FigureVectorDB_URL","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[JournalManagement]","B":"JournalID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[JournalManagement]","B":"Volume","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[JournalManagement]","B":"PublishedDate","C":"date"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[JournalManagement]","B":"EditorialDirector","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[JournalManagement]","B":"VolumeURL","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[FigureManagement]","B":"IssueID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[FigureManagement]","B":"FigName","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[FigureManagement]","B":"FigType","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[FigureManagement]","B":"FigInIssueOrder","C":"bigint"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[FigureManagement]","B":"FigURL","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[AuthorManagement]","B":"AuthorName","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[AuthorManagement]","B":"AuthorID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[AuthorManagement]","B":"AuthorEmail","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[AuthorManagement]","B":"AuthorPhoneNumber","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[AuthorManagement]","B":"AuthorOrganization","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthos]","B":"IssueID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthos]","B":"IssueNameVN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthos]","B":"AuthorName","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthos]","B":"AuthorID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthos]","B":"AuthorType","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthors]","B":"IssueID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthors]","B":"IssueNameVN","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthors]","B":"AuthorName","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthors]","B":"AuthorID","C":"varchar"}
{"A":"[CSDL_TCDK_MAIN].[dbo].[IssueAuthors]","B":"AuthorType","C":"varchar"}
---
OBEY SOME RULES BELOW:
- GIVE SQL QUERY SYNTAX query database to answer user question: {{$input}}, basing on the schema.
- DONT EXPLAIN ANYTHING FURTHER
- DONT ASKBACK
- DONT GIVE COLUMNS NAME THAT DOES NOT APPEAR IN SCHEMA |