CREATE (n:User { name: '胡汉三', desc: '组长' }) return n;

CREATE (n:User { name: '杨金水', desc: '老板' }) return n;

CREATE (n:User { name: '刘武宗', desc: '组员' }) return n;

CREATE (n:User { name: '龙追风', desc: '组员' }) return n;

CREATE (n:User { name: '林梓阳', desc: '组员' }) return n;
CREATE (n:User { name: '王鼎文', desc: '组员' }) return n;


CREATE (n:perTask { title: '讨论会记录',type:'周任务' }) return n;
CREATE (n:perTask { title: '语雀上撰写使用说明书',type:'周任务' }) return n;
CREATE (n:perTask { title: '日报反馈',type:'日任务' }) return n;
CREATE (n:perTask { title: 'bug记录',type:'日任务' }) return n;
CREATE (n:perTask { title: '每日参与讨论会',type:'日任务' }) return n;
CREATE (n:perTask { title: '京东店铺好评',type:'月任务' }) return n;







match(n:User{name:"杨金水"}),(m:perTask{title:"京东店铺好评"}) create (n)-[r:负责]->(m) return r;
match(n:User{name:"杨金水"}),(m:perTask{title:"讨论会记录"}) create (m)-[r:抄送]->(n) return r;
match(n:User{name:"杨金水"}),(m:perTask{title:"语雀上撰写使用说明书"}) create (m)-[r:抄送]->(n) return r;
match(n:User{name:"杨金水"}),(m:perTask{title:"日报反馈"}) create (m)-[r:抄送]->(n) return r;
match(n:User{name:"杨金水"}),(m:perTask{title:"bug记录"}) create (m)-[r:抄送]->(n) return r;
match(n:User{name:"杨金水"}),(m:perTask{title:"每日参与讨论会"}) create (m)-[r:抄送]->(n) return r;


match(n:User{name:"龙追风"}),(m:perTask{title:"讨论会记录"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"龙追风"}),(m:perTask{title:"语雀上撰写使用说明书"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"龙追风"}),(m:perTask{title:"日报反馈"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"龙追风"}),(m:perTask{title:"bug记录"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"龙追风"}),(m:perTask{title:"每日参与讨论会"}) create (n)-[r:执行]->(m) return r;

match(n:User{name:"刘武宗"}),(m:perTask{title:"讨论会记录"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"刘武宗"}),(m:perTask{title:"语雀上撰写使用说明书"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"刘武宗"}),(m:perTask{title:"日报反馈"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"刘武宗"}),(m:perTask{title:"bug记录"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"刘武宗"}),(m:perTask{title:"每日参与讨论会"}) create (n)-[r:执行]->(m) return r;

match(n:User{name:"林梓阳"}),(m:perTask{title:"讨论会记录"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"林梓阳"}),(m:perTask{title:"语雀上撰写使用说明书"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"林梓阳"}),(m:perTask{title:"日报反馈"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"林梓阳"}),(m:perTask{title:"bug记录"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"林梓阳"}),(m:perTask{title:"每日参与讨论会"}) create (n)-[r:执行]->(m) return r;

match(n:User{name:"王鼎文"}),(m:perTask{title:"讨论会记录"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"王鼎文"}),(m:perTask{title:"语雀上撰写使用说明书"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"王鼎文"}),(m:perTask{title:"日报反馈"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"王鼎文"}),(m:perTask{title:"bug记录"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"王鼎文"}),(m:perTask{title:"每日参与讨论会"}) create (n)-[r:执行]->(m) return r;

match(n:User{name:"胡汉三"}),(m:perTask{title:"讨论会记录"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"胡汉三"}),(m:perTask{title:"语雀上撰写使用说明书"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"胡汉三"}),(m:perTask{title:"日报反馈"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"胡汉三"}),(m:perTask{title:"bug记录"}) create (n)-[r:执行]->(m) return r;
match(n:User{name:"胡汉三"}),(m:perTask{title:"每日参与讨论会"}) create (n)-[r:执行]->(m) return r;

match(n:User{name:"胡汉三"}),(m:perTask{title:"讨论会记录"}) create (n)-[r:负责]->(m) return r;
match(n:User{name:"胡汉三"}),(m:perTask{title:"语雀上撰写使用说明书"}) create (n)-[r:负责]->(m) return r;
match(n:User{name:"胡汉三"}),(m:perTask{title:"日报反馈"}) create (n)-[r:负责]->(m) return r;
match(n:User{name:"胡汉三"}),(m:perTask{title:"bug记录"}) create (n)-[r:负责]->(m) return r;


match(n:User{name:"杨金水"}),(m:User{name:"刘武宗"}) create (n)-[r:老板]->(m) return r;
match(n:User{name:"杨金水"}),(m:User{name:"龙追风"}) create (n)-[r:老板]->(m) return r;
match(n:User{name:"杨金水"}),(m:User{name:"林梓阳"}) create (n)-[r:老板]->(m) return r;
match(n:User{name:"杨金水"}),(m:User{name:"胡汉三"}) create (n)-[r:老板]->(m) return r;
match(n:User{name:"杨金水"}),(m:User{name:"王鼎文"}) create (n)-[r:老板]->(m) return r;


//删除关系
MATCH (n:User{name:"杨金水"})-[r:老板]-(m:User{name:"胡汉三"})  DELETE r

//删除所以数据
match (n) detach delete n


//查找所有数据
match(n) return n


//查询某人负责的任务
match (n:User{name:"胡汉三"})-[:负责]->(perTask) return n,perTask

//查询某人执行的任务
match (n:User{name:"胡汉三"})-[:执行]->(perTask) return n,perTask

//查询抄送某人的任务
match (n:User{name:"胡汉三"})-[:抄送]->(perTask) return n,perTask

//查询所有与某人相关的任务
match (n:User{name:"杨金水"})-[:负责|执行|抄送]->(perTask) return n,perTask
match(n:User {name:"胡汉三"})-[*]->(m:perTask) return n,m


//查询一个任务谁在参与执行
match(n:User)-[:执行]->(m:perTask {title:"京东店铺好评"}) return n,m

//查询某人负责的任务谁在执行
MATCH (a:User {name : '胡汉三'})-[:负责]->(m)<-[:执行]-(b:User) return m,b


//查询某人负责的任务谁在执行
MATCH (a:User {name : '胡汉三'})-[:负责]->(m)<-[:执行]-(b:User) return m,b