select user_id, login, workspace_id from lams_user;

select * from lams_workspace;

select workspace_folder_id wf_id, parent_folder_id, name, user_id, lams_workspace_folder_type_id wf_type_id from lams_workspace_folder;

select learning_design_id, title, user_id, copy_type_id, workspace_folder_id from lams_learning_design;

select lesson_id, learning_design_id, user_id, lesson_state_id from lams_lesson;

select organisation_id, name, code, description, parent_organisation_id, organisation_type_id, workspace_id from lams_organisation l;