Hi
I've created an ERD on LucidChart and exported it for MySQL and tried to use this input to re-create in LucidChart the same document with the ERD import from SQL but get an error.
"Error:We couldn't parse the output you provided."
What is wrong with my input?
I'm trying to figure out how should I setup my SQL schema for import from SQL
How can generated data from export not being good for input?
Thank you
Hi Simon
Thanks for posting in the Community!
I am not sure I fully understand. Do you mean that you manually created an ERD in Lucidchart which you then exported for MySQL and then directly re-imported the exported file back into Lucidchart?
Could you provide some more details regarding what you are trying to achieve so I can try and guide you better?
Thanks!
Hi Coumba
Yes I'm trying to do exactly what you mentioned.
We can import our DB in format of (MySQL PostgreSQL Oracle SQL Server) I tried with MySQL
Reference: https://lucidchart.zendesk.com/hc/en-us/articles/207299756-Entity-Relationship-Diagrams#import-database
However it didn't work
I tried with the example given from the SQL "7. Click Copy to Clipboard to copy the query." didn't work either
So at last resort I create manually the ERD "https://lucidchart.zendesk.com/hc/en-us/articles/207299756-Entity-Relationship-Diagrams#manually-create-erd"
and export it as MySQL => https://lucidchart.zendesk.com/hc/en-us/articles/207299756-Entity-Relationship-Diagrams#export-erd
Then I tried to import this file into the import of ERD it doesn't work
How can something generated from export cannot be good format for import?
Could you share a working MySQL file good for import in the ERD?
Thank you
Best regards
Simon
Hi Simon
Thanks for the explanation.
Note that you will need to first run the query reference at step 7 of the Import your database section of our ERD help article in your DBMS before either pasting the output in plain text or importing the results generated by your DBMS back into Lucidchart.
Basically step 7 is only about copying the query from Lucidchart and the following steps explain what to do with the query:
I hope this helps however if you feel that I am misunderstanding I would recommend filing a support ticket and include the URL to your document so that our team can take a closer look and test if necessary!
Hi Coumba
Thank you for highlight the request to DB first missed this part.
I tried it it works thanks
However only the Primary key Foreign Key(constraint key) are into the schema which is not all the data(other columns).
At the end I created it manually from my DB as I couldn't find a solution.
Thank you
Simon
Hi Simon
Glad to read that you've been able to import your file after having ran the query in your DBMS!
If I understand correctly the issue that you are now experiencing not all entities (with the exception of your primary and foreign keys) are rendered onto your ERD.
When you import your file into Lucidchart the software immediately converts the imported query into a list of databases tables and schemas and organizes the list in your shape menu. If some of the entities you expect to see rendered are not available from your shape menu it is likely that they were not clearly referenced in your data file or the file is mis-formatted.
To be able to help with that we would need to take a look at the .csv file or plain text output received from your DBMS after running the query provided by Lucidchart. I will turn this community post into a support request and reach out to you that way to ask for this information as well as a few other ones in order for me to take a look. You'll receive an email from me very shortly!
I would recommend filing a support ticket and include the URL
I am having the same issue, but with what seems to be a valid Import File. I attempted to convert the CSV to TSV and Text but still get this error when trying to import. I will post the first few rows of the data. I’m not sure what the issue is as the error doesn’t give specific reason for failure.
#NAMES
dbms TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION DATA_TYPE CHARACTER_MAXIMUM_LENGTH CONSTRAINT_TYPE TABLE_SCHEMA TABLE_NAME COLUMN_NAME
#TYPES
str str str str str I str I str str str str
#ROWS 774
sqlserver Ignition Report UserReport id 1 int PRIMARY KEY
sqlserver Ignition Report UserReport UserID 2 int FOREIGN KEY dbo scada_users id
sqlserver Ignition Report UserReport ReportID 3 int
sqlserver Ignition Report UserReport FrequencyID 4 int
sqlserver Ignition Report UserReport DeliveryTimeID 5 int
sqlserver Ignition LSEM Attachment AttachmentId 1 int PRIMARY KEY
sqlserver Ignition LSEM Attachment ObjectId 2 int
sqlserver Ignition LSEM Attachment ObjectType 3 nvarchar 50
sqlserver Ignition LSEM Attachment GlobalId 4 nvarchar 50
sqlserver Ignition LSEM Attachment FileName 5 nvarchar 256
sqlserver Ignition LSEM Attachment FileType 6 nvarchar 10
sqlserver Ignition LSEM Attachment FileSize 7 int
sqlserver Ignition LSEM Attachment S3FileName 8 nvarchar 255
sqlserver Ignition LSEM Attachment S3ThumbnailName 9 nvarchar 255
sqlserver Ignition LSEM Attachment CreatedBy 10 int
sqlserver Ignition LSEM Attachment CreatedOn 11 datetime2
Hi
I see “sqlserver” in your output. If this is correct, I recommend comparing it to the example output file I’ve attached to this comment. Using this as a template will allow you to identify any differences in structure that Lucidchart isn’t able to interpret.
Hi
Thanks again!!
will this work with Redshift databases ? i changed the code so that i runs in my db but then when i tried either uploading the output as csv or directly pasting in plain text i get the parse error
my redshift code
SELECT
'redshift' AS dbms,
t.table_catalog,
t.table_schema,
t.table_name,
c.column_name,
c.ordinal_position,
c.data_type,
c.character_maximum_length,
n.constraint_type,
k2.table_schema as table_schema,
k2.table_name,
k2.column_name
FROM
information_schema.tables t
NATURAL LEFT JOIN information_schema.columns c
LEFT JOIN (
information_schema.key_column_usage k
NATURAL JOIN information_schema.table_constraints n
NATURAL LEFT JOIN information_schema.referential_constraints r
) ON
c.table_catalog = k.table_catalog
AND c.table_schema = k.table_schema
AND c.table_name = k.table_name
AND c.column_name = k.column_name
LEFT JOIN information_schema.key_column_usage k2 ON
k.ordinal_position = k2.ordinal_position
AND r.unique_constraint_catalog = k2.constraint_catalog
AND r.unique_constraint_schema = k2.constraint_schema
AND r.unique_constraint_name = k2.constraint_name
WHERE
t.table_type = 'BASE TABLE'
AND t.table_schema NOT IN ('information_schema', 'pg_catalog')
and still get the “We couldn t parse the output you provided”
Hi
If you'd like to see support for more databases in the future, we’d love to hear more in our Product Feedback space. I hope this helps!
Hi
I am (Newbie) also haiving issues when i try to upload attached csv file...through sql server.
Could you please check if you are able to load and let me know what i am missing. fyi I am building thei data base and try to load as sql server..
dbms,TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,ORDINAL_POSITION,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,CONSTRAINT_TYPE,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PROJ_ELEMENT_ID,1,int,,PRIMARY KEY,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PROJECT_ID,6,int,,FOREIGN KEY,dbo,pjf_projects_all_b,PROJECT_ID
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,RQMT_ID,4,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,SPRINT_ID,5,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,IS_INTEGRATED,2,varchar,1,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,OBJECT_TYPE,7,varchar,30,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LAST_SYNC_DATE,3,datetime,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ELEMENT_NUMBER,8,varchar,100,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_TOP_ELEMENT_ID,9,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_WBS_LEVEL,10,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_PARENT_ELEMENT_ID,11,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,SERVICE_TYPE_CODE,12,varchar,30,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CHARGEABLE_FLAG,13,varchar,1,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,BILLABLE_FLAG,14,varchar,1,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LIMIT_TO_TXN_CONTROLS_FLAG,15,varchar,1,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,START_DATE,16,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,COMPLETION_DATE,17,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LABOR_COST_MULTIPLIER_NAME,18,varchar,20,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,COST_IND_RATE_SCH_ID,19,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,COST_IND_SCH_FIXED_DATE,20,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,OVR_COST_IND_RATE_SCH_ID,21,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ALLOW_CROSS_CHARGE_FLAG,22,varchar,1,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CC_PROCESS_LABOR_FLAG,23,varchar,1,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LABOR_TP_SCHEDULE_ID,24,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LABOR_TP_FIXED_DATE,25,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CC_PROCESS_NL_FLAG,26,varchar,1,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NL_TP_SCHEDULE_ID,27,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NL_TP_FIXED_DATE,28,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,RECEIVE_PROJECT_INVOICE_FLAG,29,varchar,1,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,WORK_TYPE_ID,30,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,RETIREMENT_COST_FLAG,31,varchar,1,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CINT_ELIGIBLE_FLAG,32,varchar,1,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CINT_STOP_DATE,33,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,GEN_ETC_SOURCE_CODE,34,varchar,30,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CLIN_ELEMENT_ID,35,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CREATION_DATE,36,datetime,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CREATED_BY,37,varchar,64,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LAST_UPDATE_DATE,38,datetime,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LAST_UPDATED_BY,39,varchar,64,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PM_SOURCE_CODE,40,varchar,30,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PM_SOURCE_REFERENCE,41,varchar,100,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,MANAGER_PERSON_ID,42,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CARRYING_OUT_ORGANIZATION_ID,43,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LAST_UPDATE_LOGIN,44,varchar,32,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE_CATEGORY,45,varchar,30,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE1,46,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE2,47,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE3,48,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE4,49,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE5,50,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE6,51,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE7,52,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE8,53,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE9,54,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE10,55,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE11,56,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE12,57,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE13,58,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE14,59,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE15,60,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE16,61,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE17,62,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE18,63,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE19,64,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE20,65,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE21,66,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE22,67,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE23,68,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE24,69,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE25,70,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE26,71,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE27,72,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE28,73,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE29,74,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE30,75,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE31,76,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE32,77,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE33,78,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE34,79,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE35,80,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE36,81,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE37,82,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE38,83,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE39,84,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE40,85,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE41,86,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE42,87,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE43,88,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE44,89,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE45,90,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE46,91,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE47,92,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE48,93,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE49,94,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE50,95,varchar,150,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE1_NUMBER,96,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE2_NUMBER,97,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE3_NUMBER,98,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE4_NUMBER,99,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE5_NUMBER,100,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE6_NUMBER,101,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE7_NUMBER,102,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE8_NUMBER,103,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE9_NUMBER,104,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE10_NUMBER,105,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE11_NUMBER,106,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE12_NUMBER,107,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE13_NUMBER,108,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE14_NUMBER,109,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE15_NUMBER,110,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE1_DATE,111,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE2_DATE,112,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE3_DATE,113,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE4_DATE,114,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE5_DATE,115,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE6_DATE,116,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE7_DATE,117,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE8_DATE,118,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE9_DATE,119,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE10_DATE,120,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE11_DATE,121,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE12_DATE,122,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE13_DATE,123,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE14_DATE,124,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE15_DATE,125,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PARENT_STRUCTURE_ID,126,int,,FOREIGN KEY,dbo,pjf_proj_elements_b,PARENT_STRUCTURE_ID
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,OBJECT_VERSION_NUMBER,127,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,STRUCTURE_TYPE,128,varchar,30,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LEAF_NODE_FLAG,129,varchar,1,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CREATED_FROM_SOURCE_ID,130,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PLANNING_START_DATE,131,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PLANNING_END_DATE,132,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,BASELINE_START_DATE,133,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,BASELINE_FINISH_DATE,134,date,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,SITE_USE_ID,135,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PERCENT_COMP_CALC_METHOD,136,varchar,30,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ETC_CALC_METHOD,137,varchar,30,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PLANNING_DATES_ROLLUP_FLAG,138,varchar,1,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CAPITALIZABLE_FLAG,139,varchar,1,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_ELEM_VER_ID,140,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_PARENT_STRUCT_VER_ID,141,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_PARENT_ELEM_VER_ID,142,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_PARENT_OBJECT_TYPE,143,varchar,30,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_WBS_NUMBER,144,varchar,240,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_DISPLAY_SEQUENCE,145,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,IC_CLIN_ELEMENT_ID,146,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CRITICAL_FLAG,147,varchar,1,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,MILESTONE_FLAG,148,varchar,1,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PRIMARY_RESOURCE_ID,149,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_TYPE_CODE,150,varchar,30,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE01_ID,151,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE02_ID,152,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE03_ID,153,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE04_ID,154,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE05_ID,155,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE06_ID,156,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE07_ID,157,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE08_ID,158,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE09_ID,159,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE10_ID,160,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE11_ID,161,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE12_ID,162,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE13_ID,163,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE14_ID,164,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE15_ID,165,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE16_ID,166,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE17_ID,167,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE18_ID,168,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE19_ID,169,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE20_ID,170,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE21_ID,171,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE22_ID,172,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE23_ID,173,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE24_ID,174,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE25_ID,175,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE26_ID,176,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE27_ID,177,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE28_ID,178,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE29_ID,179,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE30_ID,180,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE31_ID,181,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE32_ID,182,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE33_ID,183,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE34_ID,184,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE35_ID,185,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE36_ID,186,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE37_ID,187,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE38_ID,188,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE39_ID,189,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE40_ID,190,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR01,191,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR02,192,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR03,193,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR04,194,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR05,195,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR06,196,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR07,197,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR08,198,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR09,199,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR10,200,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR01,201,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR02,202,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR03,203,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR04,204,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR05,205,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR06,206,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR07,207,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR08,208,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR09,209,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR10,210,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR11,211,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR12,212,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR13,213,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR14,214,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR15,215,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR16,216,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR17,217,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR18,218,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR19,219,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR20,220,varchar,200,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ISSUE_ID,221,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_STATUS_CODE,222,varchar,30,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,OBJECT_ASSOCIATION_BITMAP,223,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,EXTERNAL_ID,224,varchar,240,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LAST_VIEWED_DATE,225,datetime,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_EXECUTION_DISP_SEQ,226,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ELEMENT_TYPE,227,varchar,30,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,USER_DEFINED_TASK_TYPE,228,varchar,30,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PROJ_ELEMENT_ID_META,229,int,,,,,
ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,GATE_FLAG,230,varchar,1,,,,
Thanks
I have built up an excel table (in sql format with foreign and primary keys and all other fields) from pdf documentation of an Oracel database. (I had to go with documentation ad Oracel extract seems to be not providing all the tables i need and drops the foreign keys)
I have many tables but for now I just tried to create 2 tables with relationships in Lucid to start with but failed on the upload.
Below is the error i get . I wonder if anyone has done something similar.
File format i load
I also believe you may be mixing information across Oracle and SQL sever, which Lucidchart isn’t able to interpret. For example, in your CSV you pasted above, your DBMS column shows “ORC,” but the SQL server option would expect to see “sqlserver” here. I recommend you model your tables after only one of the options, then use the corresponding import method.
thanks
I have only loaded 3 tables with relationships...Could you please guide/check what am i missing on my file..Or show me a simple 3 table example so i can built my template accordingly...
dbms | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CONSTRAINT_TYPE | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME |
sqlserver | Snap | dbo | PJF_PROJ_ELEMENTS_B | PROJ_ELEMENT_ID | 1 | int | PRIMARY KEY | ||||
sqlserver | Snap | dbo | PJF_PROJ_ELEMENTS_B | PARENT_STRUCTURE_ID | 126 | int | FOREIGN KEY | dbo | pjf_proj_elements_b | PARENT_STRUCTURE_ID | |
sqlserver | Snap | dbo | PJF_PROJ_ELEMENTS_B | PROJECT_ID | 6 | int | FOREIGN KEY | dbo | pjf_projects_all_b | PROJECT_ID | |
sqlserver | Snap | dbo | PJF_PROJECTS_ALL_B | PROJECT_ID | 1 | int | PRIMARY KEY | ||||
sqlserver | Snap | dbo | PJF_PROJECTS_ALL_B | PROJECT_TYPE_ID | 5 | int | FOREIGN KEY | dbo | pjf_project_types_b | PROJECT_TYPE_ID | |
sqlserver | Snap | dbo | PJF_PROJECTS_ALL_B | PROJECT_STATUS_CODE | 8 | varchar | 30 | FOREIGN KEY | dbo | pjf_project_statuses_b | PROJECT_STATUS_CODE |
sqlserver | Snap | dbo | PJF_PROJECTS_ALL_B | COST_IND_RATE_SCH_ID | 40 | int | FOREIGN KEY | dbo | pjf_ind_rate_sch_b | COST_IND_RATE_SCH_ID | |
sqlserver | Snap | dbo | PJF_PROJECTS_ALL_B | OVR_COST_IND_RATE_SCH_ID | 42 | int | FOREIGN KEY | dbo | pjf_ind_rate_sch_b | OVR_COST_IND_RATE_SCH_ID | |
sqlserver | Snap | dbo | PJF_PROJECTS_ALL_B | LABOR_TP_SCHEDULE_ID | 64 | int | FOREIGN KEY | dbo | pjf_tp_schedules | LABOR_TP_SCHEDULE_ID | |
sqlserver | Snap | dbo | PJF_PROJECTS_ALL_B | NL_TP_SCHEDULE_ID | 67 | int | FOREIGN KEY | dbo | pjf_tp_schedules | NL_TP_SCHEDULE_ID | |
sqlserver | Snap | dbo | PJF_PROJECTS_ALL_B | WORK_TYPE_ID | 69 | int | FOREIGN KEY | dbo | pjf_work_types_b | WORK_TYPE_ID | |
sqlserver | Snap | dbo | PJF_PROJECTS_ALL_B | CINT_RATE_SCH_ID | 87 | int | FOREIGN KEY | dbo | pjc_cint_rate_sch_b | CINT_RATE_SCH_ID | |
sqlserver | Snap | dbo | PJO_PROJECT_PROGRESS | PROJECT_PROGRESS_ID | 1 | int | PRIMARY KEY | ||||
sqlserver | Snap | dbo | PJO_PROJECT_PROGRESS | PROJECT_ID | 2 | int | FOREIGN KEY | dbo | pjf_projects_all_b | PROJECT_ID | |
sqlserver | Snap | dbo | PJO_PROJECT_PROGRESS | PROJ_ELEMENT_ID | 5 | int | FOREIGN KEY | dbo | pjf_proj_elements_b | PROJ_ELEMENT_ID | |
sqlserver | Snap | dbo | PJO_PROJECT_PROGRESS | ELEMENT_VERSION_ID | 6 | int | FOREIGN KEY | dbo | pjf_proj_element_version | ELEMENT_VERSION_ID | |
sqlserver | Snap | dbo | PJO_PROJECT_PROGRESS | PLAN_VERSION_ID | 10 | int | FOREIGN KEY | dbo | pjo_plan_versions_b | PLAN_VERSION_ID |
hI
Below is the CSV i have tried.
dbms,TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,ORDINAL_POSITION,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,CONSTRAINT_TYPE,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJ_ELEMENTS_B,PROJ_ELEMENT_ID,1,int,NULL,PRIMARY KEY,,,
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJ_ELEMENTS_B,PROJECT_ID,6,int,NULL,FOREIGN KEY,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID,1,int,NULL,PRIMARY KEY,,,
Can you try pasting your CSV as plain text in the upload option, add the tables to the canvas, and if no relationship lines are drawn, respond with a screenshot of what you’re seeing?
hi
dbms,TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,ORDINAL_POSITION,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,CONSTRAINT_TYPE,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME
sqlserver,AdventureWorks2008R3,Sales,PJB_BILLING_EVENTS,EVENT_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJB_BILLING_EVENTS,PROJECT_ID,11,int,NULL,FOREIGN KEY,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_BILLING_EVENTS,TASK_ID,12,int,NULL,FOREIGN KEY,Sales,PJF_PROJ_ELEMENTS_B,TASK_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INV_LINE_DISTS,INVOICE_DIST_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJB_INV_LINE_DISTS,INVOICE_ID,4,int,NULL,FOREIGN KEY,Sales,PJB_INVOICE_HEADERS,INVOICE_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INV_LINE_DISTS,INVOICE_LINE_ID,5,int,NULL,FOREIGN KEY,Sales,PJB_INVOICE_LINES,INVOICE_LINE_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INV_LINE_DISTS,BILL_TRX_ID,7,int,NULL,FOREIGN KEY,Sales,PJB_BILL_TRXS,BILL_TRX_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INV_LINE_DISTS,CREDITED_INVOICE_ID,76,int,NULL,FOREIGN KEY,Sales,PJB_INVOICE_HEADERS,CREDITED_INVOICE_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INV_LINE_DISTS,CREDITED_INVOICE_LINE_ID,77,int,NULL,FOREIGN KEY,Sales,PJB_INVOICE_LINES,CREDITED_INVOICE_LINE_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INV_LINE_DISTS,RBS_ELEMENT_ID,82,int,NULL,FOREIGN KEY,Sales,PJF_RBS_ELEMENTS,RBS_ELEMENT_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_FORMATS,INVOICE_FORMAT_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_FORMATS,INVOICE_GROUP_ID,3,int,NULL,FOREIGN KEY,Sales,PJB_INV_GROUP_HEADERS,INVOICE_GROUP_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_HEADERS,INVOICE_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_HEADERS,ACCTD_RATE_TYPE,36,varchar,NULL,FOREIGN KEY,Sales,GL_DAILY_CONVERSION_TYPES,ACCTD_RATE_TYPE
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_LINES,INVOICE_LINE_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_LINES,INVOICE_ID,5,int,NULL,FOREIGN KEY,Sales,PJB_INVOICE_HEADERS,INVOICE_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_LINES,CREDITED_INVOICE_ID,11,int,NULL,FOREIGN KEY,Sales,PJB_INVOICE_HEADERS,CREDITED_INVOICE_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_LINES,INVOICE_FORMAT_ID,14,int,NULL,FOREIGN KEY,Sales,PJB_INVOICE_FORMATS,INVOICE_FORMAT_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJ_ELEMENTS_B,PROJ_ELEMENT_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJ_ELEMENTS_B,PARENT_STRUCTURE_ID,2,int,NULL,NULL,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJ_ELEMENTS_B,PROJECT_ID,6,int,NULL,FOREIGN KEY,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,PROJECT_TYPE_ID,2,int,NULL,FOREIGN KEY,Sales,PJF_PROJECT_TYPES_B,PROJECT_TYPE_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,CARRYING_OUT_ORGANIZATION_ID,3,int,NULL,NULL,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,PUBLIC_SECTOR_FLAG,4,varchar,NULL,NULL,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,PROJECT_STATUS_CODE,5,varchar,NULL,FOREIGN KEY,Sales,PJF_PROJECT_STATUSES_B,PROJECT_STATUS_CODE
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,COST_IND_RATE_SCH_ID,6,int,NULL,FOREIGN KEY,Sales,PJF_IND_RATE_SCH_B,COST_IND_RATE_SCH_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,COST_IND_SCH_FIXED_DATE,7,date,NULL,NULL,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,OVR_COST_IND_RATE_SCH_ID,8,int,NULL,FOREIGN KEY,Sales,PJF_IND_RATE_SCH_B,OVR_COST_IND_RATE_SCH_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,LABOR_TP_SCHEDULE_ID,9,int,NULL,FOREIGN KEY,Sales,PJF_TP_SCHEDULES,LABOR_TP_SCHEDULE_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,LABOR_TP_FIXED_DATE,10,date,NULL,NULL,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,CC_PROCESS_NL_FLAG,11,varchar,NULL,NULL,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,NL_TP_SCHEDULE_ID,12,int,NULL,FOREIGN KEY,Sales,PJF_TP_SCHEDULES,NL_TP_SCHEDULE_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,NL_TP_FIXED_DATE,13,date,NULL,NULL,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,WORK_TYPE_ID,14,int,NULL,FOREIGN KEY,Sales,PJF_WORK_TYPES_B,WORK_TYPE_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,CINT_RATE_SCH_ID,15,int,NULL,FOREIGN KEY,Sales,PJC_CINT_RATE_SCH_B,CINT_RATE_SCH_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_LINE_DETAILS,PLAN_LINE_DETAIL_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_LINE_DETAILS,PLANNING_ELEMENT_ID,8,int,NULL,FOREIGN KEY,Sales,PJO_PLANNING_ELEMENTS,PLANNING_ELEMENT_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_LINE_DETAILS,PLAN_VERSION_ID,13,int,NULL,FOREIGN KEY,Sales,PJO_PLAN_VERSIONS_B,PLAN_VERSION_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_LINES,PLAN_LINE_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_LINES,PLANNING_ELEMENT_ID,39,int,NULL,FOREIGN KEY,Sales,PJO_PLANNING_ELEMENTS,PLANNING_ELEMENT_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_LINES,PLAN_VERSION_ID,41,int,NULL,FOREIGN KEY,Sales,PJO_PLAN_VERSIONS_B,PLAN_VERSION_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_TYPES_B,PLAN_TYPE_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_VERSIONS_B,PLAN_VERSION_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_VERSIONS_B,PROJECT_ID,16,int,NULL,FOREIGN KEY,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_VERSIONS_B,PLAN_TYPE_ID,18,int,NULL,FOREIGN KEY,Sales,PJO_PLAN_TYPES_B,PLAN_TYPE_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_CURRENCIES,PLANNING_CURRENCY_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_CURRENCIES,PLANNING_OPTION_ID,2,int,NULL,FOREIGN KEY,Sales,PJO_PLANNING_OPTIONS,PLANNING_OPTION_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_ELEMENTS,PLANNING_ELEMENT_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_ELEMENTS,PLAN_VERSION_ID,6,int,NULL,FOREIGN KEY,Sales,PJO_PLAN_VERSIONS_B,PLAN_VERSION_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_ELEMENTS,PROJECT_ID,7,int,NULL,FOREIGN KEY,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_ELEMENTS,TASK_ID,8,int,NULL,FOREIGN KEY,Sales,PJF_PROJ_ELEMENTS_B,TASK_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_ELEMENTS,RBS_ELEMENT_ID,9,int,NULL,FOREIGN KEY,Sales,PJF_RBS_ELEMENTS,RBS_ELEMENT_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_OPTIONS,PLANNING_OPTION_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_OPTIONS,PLAN_TYPE_ID,31,int,NULL,FOREIGN KEY,Sales,PJO_PLAN_TYPES_B,PLAN_TYPE_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_OPTIONS,AMOUNT_SET_ID,42,int,NULL,FOREIGN KEY,Sales,PJO_FIN_PLAN_AMT_SETS,AMOUNT_SET_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PROJECT_PROGRESS,PROJECT_PROGRESS_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PROJECT_PROGRESS,PROJECT_ID,2,int,NULL,FOREIGN KEY,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PROJECT_PROGRESS,PROJ_ELEMENT_ID,5,int,NULL,FOREIGN KEY,Sales,PJF_PROJ_ELEMENTS_B,PROJ_ELEMENT_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PROJECT_PROGRESS,ELEMENT_VERSION_ID,6,int,NULL,FOREIGN KEY,Sales,PJF_PROJ_ELEMENT_VERSION,ELEMENT_VERSION_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PROJECT_PROGRESS,PLAN_VERSION_ID,10,int,NULL,FOREIGN KEY,Sales,PJO_PLAN_VERSIONS_B,PLAN_VERSION_ID
Hi
Are there any relationships in particular that you are expecting to see and are not?
Reply
Create an account in the community
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to create an account.
Log in to the community
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to log in.
Login with SSO
Log in with LucidEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.