ImageVerifierCode 换一换
格式:PDF , 页数:2 ,大小:53.55KB ,
资源ID:536306      下载积分:5000 积分
快捷下载
登录下载
邮箱/手机:
温馨提示:
如需开发票,请勿充值!快捷下载时,用户名和密码都是您填写的邮箱或者手机号,方便查询和重复下载(系统自动生成)。
如填写123,账号就是123,密码也是123。
特别说明:
请自助下载,系统不会自动发送文件的哦; 如果您已付费,想二次下载,请登录后访问:我的下载记录
支付方式: 支付宝扫码支付 微信扫码支付   
注意:如需开发票,请勿充值!
验证码:   换一换

加入VIP,免费下载
 

温馨提示:由于个人手机设置不同,如果发现不能下载,请复制以下地址【http://www.mydoc123.com/d-536306.html】到电脑端继续下载(重复下载不扣费)。

已注册用户请登录:
账号:
密码:
验证码:   换一换
  忘记密码?
三方登录: 微信登录  

下载须知

1: 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。
2: 试题试卷类文档,如果标题没有明确说明有答案则都视为没有答案,请知晓。
3: 文件的所有权益归上传用户所有。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 本站仅提供交流平台,并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

版权提示 | 免责声明

本文(ASTM F2017-2015 Standard Guide for Database Structure of Electronic Data Interchange Between Ship Owner and Shipyard for Contract Administration《合同监督用船主与造船厂之间电子数据交换的数据库结构标准》.pdf)为本站会员(brainfellow396)主动上传,麦多课文库仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对上载内容本身不做任何修改或编辑。 若此文所含内容侵犯了您的版权或隐私,请立即通知麦多课文库(发送邮件至master@mydoc123.com或直接QQ联系客服),我们立即给予删除!

ASTM F2017-2015 Standard Guide for Database Structure of Electronic Data Interchange Between Ship Owner and Shipyard for Contract Administration《合同监督用船主与造船厂之间电子数据交换的数据库结构标准》.pdf

1、Designation: F2017 15 An American National StandardStandard Guide forDatabase Structure of Electronic Data Interchange BetweenShip Owner and Shipyard for Contract Administration1This standard is issued under the fixed designation F2017; the number immediately following the designation indicates the

2、year oforiginal adoption or, in the case of revision, the year of last revision. A number in parentheses indicates the year of last reapproval. Asuperscript epsilon () indicates an editorial change since the last revision or reapproval.1. Scope1.1 This guide provides the database structure of electr

3、onicdata interchange (EDI) information between ship owner and ashipyard for contract administration. Ship owners (hereinafterreferred to as owners) and shipyards may each have uniquesoftware programs to manage their respective portions of a shiprepair period. There is information that must be exchan

4、gedbetween the parties during the contract period. This guide hasbeen developed to establish common field lengths, names, andtypes such that the exchanged information can be used directlyby the respective software programs without scanning, typing,or redundant keying of information.2. Terminology2.1

5、 Definitions of Terms Specific to This Standard:2.1.1 BLOBshort for binary large object, a collection ofbinary data stored as a single entity in a database managementsystems (DBMS). BLOBs are used primarily to hold multime-dia objects such as images, videos, and sound, though they canalso be used to

6、 store programs or even fragments of code. Notall DBMSs support BLOBs.2.1.2 CHAR(XX)character data, alphanumeric where XXrepresents the maximum number of characters permitted andSQL fills the remaining spaces with blanks if fewer than themaximum are entered.2.1.3 Condition Found Report (CFR)a report

7、 generatedby the shipyard to inform the owner of conditions found,deficiencies with the specification, or any other pertinentinformation regarding a particular work item.2.1.4 Condition Found Report Responsethe owners re-sponse back to the shipyards Condition Found Report. It maybe a simple acknowle

8、dgement of receipt or a lengthy responseand reference to a Request for Proposal.2.1.5 DATEstores the year, month, and day values of adate. The length of a DATE is ten positions, as in 01/31/2000(for 31 Jan 2000).2.1.6 INTEGERa number that has no fractional part andits precision (maximum number of di

9、gits) depends on thespecific SQL implementation.2.1.7 ownerin this case, the recognized authority forcontracting ship repair work.2.1.8 Request for Proposalan owner-generated documentasking the shipyard to add, modify, or delete work to theexisting package. It may or may not be related to a shipyard

10、initiated CFR.2.1.9 shipyardin this case, the principal party to a contractwith a ship owner.2.1.10 SQL compliantan industry standard datasublanguage, specifically designed to create, manipulate, andcontrol relational databases.2.1.11 tests and trial agendathe agenda provided by theshipyard, which d

11、etails the planning schedule for all testingevents to be conducted during a dock or sea trial.3. Significance and Use3.1 Intended UseCompliance with this guide will allowthe sharing of electronic data between contracting parties thatis normally done by hard copy. This can only be used whenboth parti

12、es use a database-derived software package to man-age their contracts. Specifically, it will:3.1.1 Eliminate the duplication of manual entry of data intoeach partys contract administration software package and3.1.2 Allow for wide access of the data to all authorizedparties.4. Database Structure4.1 A

13、 shipyard contract management database, or an ownercontract management database, may contain hundreds of tablesand fields and thousands of records. Much of the data isbusiness-sensitive and must remain under the control of theparty. However, there is data that is shared and common to bothparties in

14、a ship repair contract.1This guide is under the jurisdiction of ASTM Committee F25 on Ships andMarine Technology and is the direct responsibility of Subcommittee F25.05 onComputer Applications.Current edition approved May 1, 2015. Published May 2015. Originallyapproved in 2000. Last previous edition

15、 approved in 2006 as F2017 00 (2006)which was withdrawn January 2015 and reinstated in May 2015. DOI: 10.1520/F2017-15.Copyright ASTM International, 100 Barr Harbor Drive, PO Box C700, West Conshohocken, PA 19428-2959. United States14.2 Condition Found ReportA Condition Found Report,generated by the

16、 shipyard and forwarded to the owner, will bestructured as follows:NameRequiredFieldType SizeDataElementOwnerCondition Found Report ID Y CHAR 10 shipyardContract number Y CHAR 16 ownerWork item number Y CHAR 7 ownerEquipment ID number N Integer 12 ownerShip name N CHAR 30 ownerDate Condition Found R

17、eportGeneratedYDATEMM/DD/YYYY10 shipyardShipyard POC Y CHAR 30 shipyardCondition Y memo BLOB shipyardRecommendation N Memo BLOB shipyard4.3 Condition Found Report ResponseA Condition FoundReport Response, generated by the owner and forwarded to theshipyard, will be structured as follows:NameRequired

18、FieldType SizeDataElementOwnerCondition Found Report ID Y CHAR 10 shipyardContract number Y CHAR 16 shipyardShip name N CHAR 30 ownerResponse date Y DATEMM/DD/YYYY10 ownerOwner POC Y CHAR 30 ownerResponse N memo BLOB owner4.4 Request for ProposalA Request for Proposal, gener-ated by the owner and fo

19、rwarded to the shipyard, will bestructured as follows:NameRequiredFieldType SizeDataElementOwnerRFP ID Y INTEGER 4 ownerCondition Found Report ID Y CHAR 10 shipyardOwner contract number Y CHAR 16 ownerShipyard contract number Y CHAR 16 shipyardShip name N CHAR 30 ownerRFP date Y DATE(MM/DD/YYYY)10 o

20、wnerOwner POC Y CHAR 30 ownerStatement of work Y memo BLOB owner4.5 ProposalA Proposal, in response to an RFP andgenerated by the shipyard and forwarded to the owner, will bestructured as follows:NameRequiredFieldType SizeDataElementOwnerProposal ID Y CHAR 10 shipyardOwner contract number Y CHAR 16

21、ownerShipyard contract number Y CHAR 16 shipyardShip name N CHAR 30 ownerRFP ID N INTEGER 4 ownerProposal date Y DATE(MM/DD/YYYY)8 shipyardShipyard POC Y CHAR 30 shipyardSOW comments N memo BLOB shipyardShipyard proposal N Currency($#,#,#.#)$M shipyard4.6 Test and Trial AgendaA TTA, generated by the

22、 ship-yard and forwarded to the owner, will be structured as follows:NameRequiredFieldType SizeDataElementOwnerTTA ID Number (Long) 4Owner contract number Y CHAR 16 ownerShipyard contract number Y CHAR 16 shipyardShip name N CHAR 30 ownerAgenda date Y DATE(MM/DD/YYYY)8 shipyardShipyard POC Y CHAR 30

23、 shipyardEvent tableAY memo BLOB shipyardAThe event table will include the test name, equipment name, start time, andrequired attendees (witnesses).5. Keywords5.1 contract administration; database; electronic; owner;shipyardASTM International takes no position respecting the validity of any patent r

24、ights asserted in connection with any item mentionedin this standard. Users of this standard are expressly advised that determination of the validity of any such patent rights, and the riskof infringement of such rights, are entirely their own responsibility.This standard is subject to revision at a

25、ny time by the responsible technical committee and must be reviewed every five years andif not revised, either reapproved or withdrawn. Your comments are invited either for revision of this standard or for additional standardsand should be addressed to ASTM International Headquarters. Your comments

26、will receive careful consideration at a meeting of theresponsible technical committee, which you may attend. If you feel that your comments have not received a fair hearing you shouldmake your views known to the ASTM Committee on Standards, at the address shown below.This standard is copyrighted by

27、ASTM International, 100 Barr Harbor Drive, PO Box C700, West Conshohocken, PA 19428-2959,United States. Individual reprints (single or multiple copies) of this standard may be obtained by contacting ASTM at the aboveaddress or at 610-832-9585 (phone), 610-832-9555 (fax), or serviceastm.org (e-mail); or through the ASTM website(www.astm.org). Permission rights to photocopy the standard may also be secured from the Copyright Clearance Center, 222Rosewood Drive, Danvers, MA 01923, Tel: (978) 646-2600; http:/ 152

copyright@ 2008-2019 麦多课文库(www.mydoc123.com)网站版权所有
备案/许可证编号:苏ICP备17064731号-1