2020-09-07-x
Xplorist Lv6
  2020-09-07 13:30:13 2020-09-07 13:30      

2020-09-07

todo-list

  • 新产品开发系统整理在使用的模块和使用状况

record-list

  • 添加两个不用绑定IP的账号，一个MacI普通用户，一个没有任何权限
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

-- 查询权限表中最大id的下一个id
select (max(t.id) + 1) from INDIVIDUAL_AUTH t

-- 查询专案id
select t.id from PROJECT t where t.name = 'FlowTest'

-- 查询人员id
select t.id from ACCOUNT_BROKEN t where t.account_name = 'C3006113'

-- 将工号为C3006113人员添加到FlowTest专案的权限中
insert into INDIVIDUAL_AUTH t
  (t.id, t.entity_uid, t.entitycreated, t.project_id, t.accountbroken_id)
values
  (376556, sys_guid(), sysdate, '45754', '376673')


  • 给C3006113开通MacI普通用户权限，这样C3006113就是FlowTest的普通用户了

  • C3005882为没有任何权限的新用户

  • F1639229为管理员账号

  • 整理每个模块的数据表

专案下模块

模块 数据表 查询语句 最近数据(专案)
客户图档 FILE_MANAGE_CUSTOMFILE select t.* from FILE_MANAGE_CUSTOMFILE t order by t.createdate desc C98(成都) - 2020/9/5 14:11:32
会议记录 FILE_MANAGE_TOTALS(會議記錄, BOM, 客戶重要郵件) select t.* from FILE_MANAGE_TOTALS t where t.typeno = ‘會議記錄’ order by t.createdate desc X1780(成都) - 2020/9/7 10:25:25
partList FILE_PARTLIST select t.* from FILE_PARTLIST t order by t.createdate desc X1780(成都) - 2020/9/3 13:55:17
DOEList FILE_MANAGE_TOTAL(DOEList, MIL, DeviationList, MIP) select t.* from FILE_MANAGE_TOTAL t where t.typeno = ‘DOEList’ order by t.createdate desc X2067(成都) - 2020/6/1 8:50:11

阶段下模块

模块 数据表 查询语句 最近数据(专案-阶段)
BOM FILE_MANAGE_TOTALS(會議記錄, BOM, 客戶重要郵件) select t.* from FILE_MANAGE_TOTALS t where t.typeno = ‘BOM’ order by t.createdate desc X1984(成都) - EVT - 2020/9/5 9:29:49
MIP FILE_MANAGE_TOTAL(DOEList, MIL, DeviationList, MIP) select t.* from FILE_MANAGE_TOTAL t where t.typeno = ‘MIP’ order by t.createdate desc X1121(成都) - 2020/8/15 13:23:16
MIL FILE_MANAGE_TOTAL(DOEList, MIL, DeviationList, MIP) select t.* from FILE_MANAGE_TOTAL t where t.typeno = ‘MIL’ order by t.createdate desc X1323(成都) - Pre-EVT - 2019/3/25 10:15:50
SOP SOPX_BASE_INFO select * from SOPX_BASE_INFO t order by t.create_time desc X1780(成都) - EVT - 2020/9/5 16:32:16
标准成型条件 SMC_BASE_INFO select * from SMC_BASE_INFO t order by t.create_time desc X1844 - MP - 2020/9/4 17:22:51
客户重要邮件 FILE_MANAGE_TOTALS(會議記錄, BOM, 客戶重要郵件) select t.* from FILE_MANAGE_TOTALS t where t.typeno = ‘客戶重要郵件’ order by t.createdate desc X1433(成都) - EVT - 2019/2/27 10:00:01
Deviation List FILE_MANAGE_TOTAL(DOEList, MIL, DeviationList, MIP) select t.* from FILE_MANAGE_TOTAL t where t.typeno = ‘DeviationList’ order by t.createdate desc D301 - Proto - 2019/3/4 11:11:03
Flowchart FL_PRCSVER, FL_FPROCESS, FL_PARTFPROCESS 1. select t.* from FL_PRCSVER t order by t.createdate desc 2. select t., t.rowid from FL_FPROCESS t where t.lordprcsid = ‘AB189897B8D56A6EE050F40A5BE755C5’ 3. select t., t.rowid from FL_PARTFPROCESS t where t.p_id = ‘AB12B2B9223CAF08E050F40A5BE72D22’ MH2 - DVT - 2020/7/23 9:23:04
程式设计 PROGRAM_DESIGN_FILE select t.* from PROGRAM_DESIGN_FILE t order by t.create_date desc X1780(成都) - 2020/9/6 9:09:04
治具图档 MD_NEW_MOULD_MAIN select t.*, t.rowid from MD_NEW_MOULD_MAIN t order by t.create_date desc X2067(成都) - P1 - 2020/9/7 9:38:21

零件下模块

模块 数据表 查询语句 最近数据(专案-阶段-零件)
产品图档 FILE_PRODUCT_DOC select t.* from FILE_PRODUCT_DOC t where t.create_date is not null order by t.create_date desc X2067(成都) - POC - DWG,DH ASSY,RIB,DPOC,X2067(組立件613-16657) - 2020/9/7 9:32:11
制程图档 FILE_INFORMATION, RELATION_FILEINFO, PHASE_PART_RELATION, FILE_OBJECT 1. select cast(t.entitycreated as date) create_date, t.* from FILE_INFORMATION t order by t.entitycreated desc 2. select t., t.rowid from RELATION_FILEINFO t where t.fileinfo_id = ‘375852’ 3. select t., t.rowid from PHASE_PART_RELATION t where t.id = ‘360910’ 4. select cast(t.upload as date) create_date, t.* from FILE_OBJECT t where t.fileinfromation_id = ‘375852’ X2067(成都) - P1 - FLOW WALL,TUNNEL(塑件818-14323) - 2020/9/4 13:16:19
DFM评估 DFM_FILE select cast(t.createtime as date) create_time, t.* from DFM_FILE t order by t.createtime desc X1780(成都) - EVT - BV,L,5SIDED,GLUE, PLASTIC(塑件818-14025) - 2020/9/5 16:59:23
FAI/CPK评估报告 INSPECT_REPORT 1. select cast(t.entitycreated as date) create_date, t.* from INSPECT_REPORT t order by t.entitycreated desc 2. select t., t.rowid from RELATION_INSPECT_REPORT_INFO t where t.inspectreport_id = ‘284845’ 3. select t., t.rowid from PHASE_PART_RELATION t where t.id = ‘278891’ X1121(成都) - MP - X1121 RC Assembly(組立件613-13536) - 2020/3/19 13:58:45
其它检验报告 INSPECT_REPORT 1. select cast(t.entitycreated as date) create_date, t.* from INSPECT_REPORT t where t.reporttype = ‘OTH’ order by t.entitycreated desc 2. select t., t.rowid from RELATION_INSPECT_REPORT_INFO t where t.inspectreport_id = ‘39028’ 3. select t., t.rowid from PHASE_PART_RELATION t where t.id = ‘38921’ MAC-MINI - POC - test1(塑件818-04166-06) - 2018/4/11 9:58:25
Issue List ISSUE_LIST 1. select cast(t.entitycreated as date) create_date, t.* from ISSUE_LIST t order by t.entitycreated desc 2. select t., t.rowid from RELATION_ISSUE_LIST_INFO t where t.part_issue_id = ‘155551’ 3. select t., t.rowid from PHASE_PART_RELATION t where t.id = ‘137747’ X1323(成都) - Pre-EVT - DH(金屬件806-20140) - 2019/1/18 10:29:46
包装规范 PS_APPLY_MAIN select t.* from PS_APPLY_MAIN t order by t.create_date desc X1780(成都) - EVT1 - ENC,THICK HSG,X1780(金屬件806-28830) - 2020/9/7 14:42:22
RoHS ROHSINSPECT_REPORT 1. select cast(t.entitycreated as date) create_date, t.* from ROHSINSPECT_REPORT t order by t.entitycreated desc 2. select t., t.rowid from RELATION_ROHS_INSPECT t where t.rohsinspect_id = ‘284686’ 3. select t., t.rowid from PHASE_PART_RELATION t where t.id = ‘278869’ X1121(成都) - MP - DWG,ASSY,REAR COVER,ABS,X1121(組立件) - 2020/3/19 13:15:07
  • 本文标题：2020-09-07-x
  • 本文作者：Xplorist
  • 创建时间：2020-09-07 13:30:13
  • 本文链接：https://xplorist.tech/2020/09/07/fd898236aef1/
  • 版权声明：本博客所有文章除特别声明外，均采用 BY-NC-SA 许可协议。转载请注明出处！
 评论