如何在Sage中找到关系50 databse v22在mysql中（已转换为mysql）

Question

我是新来的mysql和会计，但是，我已经通过ODBC将Sage 50 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作为数据库。