如何在已转换为mysql的SAGE50数据库v22中查找关系

Question

我对mysql和会计是新手，但是，我已经通过ODBC将SAGE50 V22数据库表转换为mysql，但是找不到关系。未选择主键。

我的项目是创建类似的应用程序，如赛奇50，但在PHP和MySQL

我的问题是，我是否应该手动创建关系，或者有什么方法可以通过命令找到关系？

提前感谢

我附上一些表格供你参考...........

# Table structure for table 'LETTER_TYPE'
#

DROP TABLE IF EXISTS `LETTER_TYPE` CASCADE; 
CREATE TABLE `LETTER_TYPE` (
  `UNIQUE_ID` INT,
  `LETTER_TYPE` SMALLINT,
  `DESCRIPTION` VARCHAR(30) CHARACTER SET utf8,
  `RECORD_CREATE_DATE` DATETIME,
  `RECORD_MODIFY_DATE` DATETIME,
  `RECORD_DELETED` SMALLINT
) ENGINE=MyISAM;

#
# Dumping data for table 'LETTER_TYPE'
#

LOCK TABLES `LETTER_TYPE` WRITE;
INSERT IGNORE INTO `LETTER_TYPE`(`UNIQUE_ID`, `LETTER_TYPE`, `DE SCRIPTION`, `RECORD_CREATE_DATE`, `RECORD_MODIFY_DATE`, `RECORD_DELETED`) VALUES(1, 1, 'Reminder', '2013-08-10 21:31:50', '2013-08-10 21:31:50', 0), (2, 2, 'Warning', '2013-08-10 21:31:50', '2013-08-10 21:31:50', 0), (3, 3, 'Legal threat', '2013-08-10 21:31:50', '2013-08-10 21:31:50', 0), (4, 4, 'Statements', '2013-08-10 21:31:50', '2013-08-10 21:31:50', 0), (5, 5, 'Orders/Quotes', '2013-08-10 21:31:50', '2013-08-10 21:31:50', 0), (6, 6, 'Invoice/Credits', '2013-08-10 21:31:50', '2013-08-10 21:31:50', 0), (7, 7, 'GDN/GRN', '2013-08-10 21:31:50', '2013-08-10 21:31:50', 0), (8, 8, 'Remittances', '2013-08-10 21:31:50', '2013-08-10 21:31:50', 0), (9, 9, 'DefaultLetter', '2013-08-10 21:31:50', '2013-08-10 21:31:50', 0);
UNLOCK TABLES;
ALTER TABLE `AUDIT_HEADER` MODIFY `DATE` DATE;
ALTER TABLE `AUDIT_HEADER` MODIFY `DATE_ENTERED` DATE;
ALTER TABLE `AUDIT_HEADER` MODIFY `RECORD_CREATE_DATE` DATE;
ALTER TABLE `AUDIT_JOURNAL` MODIFY `DATE` DATE;
ALTER TABLE `AUDIT_JOURNAL` MODIFY `DATE_ENTERED` DATE;
ALTER TABLE `AUDIT_SPLIT` MODIFY `DATE` DATE;
ALTER TABLE `AUDIT_SPLIT` MODIFY `DATE_ENTERED` DATE;
ALTER TABLE `AUDIT_USAGE` MODIFY `DATE` DATE;
ALTER TABLE `AUDIT_VAT` MODIFY `DATE` DATE;
ALTER TABLE `AUDIT_VAT` MODIFY `DATE_ENTERED` DATE;
ALTER TABLE `BANK_STATEMENT` MODIFY `STATEMENT_DATE` DATE;
ALTER TABLE `BANK_STATEMENT` MODIFY `RECONCILIATION_DATE` DATE;
ALTER TABLE `CONTACT_HISTORY` MODIFY `CONTACT_DATE` DATE;
ALTER TABLE `CONTACT_HISTORY` MODIFY `START` DATE;
ALTER TABLE `CONTACT_HISTORY` MODIFY `END` DATE;
ALTER TABLE `CONTACT_HISTORY` MODIFY `DURATION` DATE;
ALTER TABLE `CONTACT_HISTORY` MODIFY `FOLLOW_UP_TIME` DATE;
ALTER TABLE `GRN_ITEM` MODIFY `DATE` DATE;   
ALTER TABLE `INVOICE` MODIFY `INVOICE_DATE` DATE;

#     
...........................

# Table structure for table 'PERIOD'
#

DROP TABLE IF EXISTS `PERIOD` CASCADE;
CREATE TABLE `PERIOD` (
  `PERIOD` SMALLINT,
  `DESCRIPTION` VARCHAR(29) CHARACTER SET utf8
) ENGINE=MyISAM;

#
# Dumping data for table 'PERIOD'
#

LOCK TABLES `PERIOD` WRITE;
INSERT IGNORE INTO `PERIOD`(`PERIOD`, `DESCRIPTION`) VALUES(0, 'Brought forward'), (1, 'Month 1, June 2015'), (2, 'Month 2, July 2015'), (3, 'Month 3, August 2015'), (4, 'Month 4, September 2015'), (5, 'Month 5, October 2015'), (6, 'Month 6, November 2015'), (7, 'Month 7, December 2015'), (8, 'Month 8, January 2016'), (9, 'Month 9, February 2016'), (10, 'Month 10, March 2016'), (11, 'Month 11, April 2016'), (12, 'Month 12, May 2016'), (13, 'Complete (all transactions)');
UNLOCK TABLES;
ALTER TABLE `AUDIT_HEADER` MODIFY `DATE` DATE;
ALTER TABLE `AUDIT_HEADER` MODIFY `DATE_ENTERED` DATE;
ALTER TABLE `AUDIT_HEADER` MODIFY `RECORD_CREATE_DATE` DATE;
ALTER TABLE `AUDIT_JOURNAL` MODIFY `DATE` DATE;
ALTER TABLE `AUDIT_JOURNAL` MODIFY `DATE_ENTERED` DATE;
ALTER TABLE `AUDIT_SPLIT` MODIFY `DATE` DATE;
ALTER TABLE `AUDIT_SPLIT` MODIFY `DATE_ENTERED` DATE;
ALTER TABLE `AUDIT_USAGE` MODIFY `DATE` DATE;
ALTER TABLE `AUDIT_VAT` MODIFY `DATE` DATE;
ALTER TABLE `AUDIT_VAT` MODIFY `DATE_ENTERED` DATE;
ALTER TABLE `BANK_STATEMENT` MODIFY `STATEMENT_DATE` DATE;
ALTER TABLE `BANK_STATEMENT` MODIFY `RECONCILIATION_DATE` DATE;
ALTER TABLE `CONTACT_HISTORY` MODIFY `CONTACT_DATE` DATE;
ALTER TABLE `CONTACT_HISTORY` MODIFY `START` DATE;
ALTER TABLE `CONTACT_HISTORY` MODIFY `END` DATE;
ALTER TABLE `CONTACT_HISTORY` MODIFY `DURATION` DATE;
ALTER TABLE `CONTACT_HISTORY` MODIFY `FOLLOW_UP_TIME` DATE;
ALTER TABLE `GRN_ITEM` MODIFY `DATE` DATE;
ALTER TABLE `INVOICE` MODIFY `INVOICE_DATE` DATE;

#

Answer 1

你有两个选择来解决你的问题。首先，您可以使用sage数据字典并手动添加所有关系，或者我选择，您可以使用mysql直接连接到sage 50数据库并获得它的完整转储。

PS:在后台，Sage使用mysql作为数据库。