Nautilus Table Db Rel02

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Nautilus Table Db Rel02 as PDF for free.

More details

  • Words: 1,599
  • Pages: 10
NAUTILUS DATABASE

Nautilus Table DB Rel02.doc

DATABASE MASTER TABLES This manual show all tables contained in nautilus database .mdb used by the program. For each of them you’ll find the name of the table and of each field you’ll find the name, the type (dimension) and its description.

BAGS_MONITOR table It contains the data relevant to bags produced. Once the target’s reached the machine sends a record which is recorded in this table (automatically at target or manually through the machine keyboard)..

NAME BAGNUMBER ORDERCODE STYLECODE STSIZE STCOLOR STLOT PLANTCODE ROOMCODE GROUPCODE MACHCODE STARTDATE STOPDATE TARGET PIECES SHIFT CYCLE TIME IDBAG COUNT

TYPE Long CHARO(24) CHAR(24) CHAR(16) CHAR(16) CHAR(16) CHAR(30) CHAR(30) CHAR(30) LONG Date/Hour Date/Hour Long Long Long Double Precision Long Long

DESCRIPTION No. of bags for the same style Order Code Style Code Size Code Color code Lot Code Plant code Room Code Group code Machine code Date/Hour bag production start (yyyymmdd) Date/Hour bag production end (yyyymmdd) Bag Target No. of pieces done Shift Cycle Time Bag identify Counter

CYCLE_TIMES Table Contains the style cycle time running on a machine.

NAME PLANTCODE ROOMCODE GROUPCODE MACHCODE STYLECODE STSIZE STCOLOR STLOT CYCLETIME

TYPE String(30) String(30) String(30) Long integer String(16) String(16) String(16) String(16) String(16)

DESCRIPTION Plant name Room name Group name Machine number Artiche code Size code Color code Lot code Article cycle time theorically

Pagina 1 di 10

NAUTILUS DATABASE

Nautilus Table DB Rel02.doc

DEFECTS Table It contains the description of defect codes used:

NAME DEFCODE DESCRIPTION

TYPE LONG STRING (50)

DESCRIPTION Defect code from 1 to 30 Defect Description

DEFECTS_MONITOR Table Every time the operator insert a defect code on the machine with an associated number of pieces, a record is automatically sent to PC.

NAME DEFCODE DATEREC PLANTCODE ROOMCODE GROUPCODE MACHCODE TIMES ORDERCODE STYLECODE STSIZE STCOLOR STLOT SHIFT

TYPE LONG DATE/HOUR CHAR(30) CHAR(30) CHAR(50) LONG LONG CHAR(24) CHAR(24) CHAR(16) CHAR(16) CHAR(16) LONG

DESCRIPTION Defect code Date/Hour defect insertion Plant name Knitting room name Group name Machine number Associated pieces Order Code Style Code Size Code Coulour code Yarn Lot Shift

MACHINES Table It contains ‘actual’ production data from shift starting. EVERY MACHINE HAS A RECORD IN THIS TABLE WHICH IS UPDATED IN REAL TIME (just a few seconds later), at the end of the shift the information are transmitted from this table to Production Monitor table.

Pagina 2 di 10

NAUTILUS DATABASE

NAME

Nautilus Table DB Rel02.doc

TYPE

PLANTCODE ROOMCODE GROUPCODE MACHCODE MACHNUMBER

CHAR(30) CHAR(30) CHAR(30) LONG

IPADRESS GENDER

CHAR(15) CHAR(30)

SWVER EPROMVER STATE ORDERCODE STYLECODE STSIZE STCOLOR STLOT PROGRAM SIZEPR TON TOFF FUNCTIONKEY PIECES TARGETORDER SHIFTPIECES BAGPIECES BAGTARGET IDEALCYCLE LASTCYCLE LASTSTOPCODE STEP DISCARDS WORKEFFICIENTY TIMEEFFICIENTY SHIFT STOPFREQUENCY

CHAR(30) CHAR(20) LONG CHAR(24) CHAR(24) CHAR(16) CHAR(16) CHAR(16) CHAR(30) LONG LONG LONG LONG LONG LONG LONG LONG INTEROLUNGO DOUBLE PRECISION DOUBLE PRECISION INTERO LUNGO LONG LONG LONG LONG LONG CHAR (255)

DESCRIPTION Plant code Room code Group code Machine number Maybe it will be used in future to identify a single machine Machine IP adress Type of Machine, knitting machine, sewing machine, seamless, sock machine, pantyhose machine Software version Eprom custom version Bitmap that rappresent the machine status Order Code Style Code Style Size Coulour code Yarn Lot Program chain running in the machine Artiche Size active Total Time on in seconds Total Time off in seconds Function Key pressed ( F1, F2, and so on Pieces produced up now Target assigned to the order Shift production Produced pieces per bag Bag Target Theoric cycle time Cycle time last piece Stop code last machine stop Step or time from the start of the piece Second Choices Counter Work efficiency Time Efficiency Shift Stop frequency

.

ORDERS Table It contains all production orders.

NAME ORDERCODE DESCRIPTION STYLECODE STSIZE STCOLOR STLOT TARGET PRIORITY

TYPE CHAR(24) CHAR (50) CHAR (24) CHAR (16) CHAR (16) CHAR (16) LONG LONG

DESCRIPTION Order code Order description Style code Style size Style coulour Yarn lot Production Target Order default priority

Pagina 3 di 10

NAUTILUS DATABASE

Nautilus Table DB Rel02.doc

STYLES Table It contains all production style.

NOME STYLECODE DESCRIPTION STSIZE STCOLOR STLOT BAGTARGET IDEALCYCLE CHAINPATH

TIPO CHAR (24) CHAR (50) CHAR (16) CHAR (16) CHAR (16) LONG DOUBLE PRECISION CHAR (128)

DESCRIZIONE Style code Style Description Size Color Yarn Lot Bag target Theorical Cycle Time Program chain directory

PRODUCTION_MONITOR Table Contains all production data.

NAME

TYPE

DATAREG PLANTCODE ROOMCODE GROUPCODE MACHCODE ORDERCODE STYLECODE STSIZE STCOLOR STLOT TON TOFF PIECES

Date/Hour CHAR(30) CHAR(30) CHAR(30) CHAR(24) LONG CHAR(24) CHAR(16) CHAR(16) CHAR(16) LONG LONG LONG

ORDERPIECES TARGETPIECES DISCARDS CYCLE CONDITION SHIFT RESPO CODE REASON

LONG LONG LONG LONG LONG CHAR(30) LONG

DESCRIPTION Recording Date/hour (yyyymmdd) Plant code Room code Group code Order Code Machine number Style Code Style Size Colour Code Yarn Lot Total time on Total time off Production made compared to previous record Order Production Target Pieces Pieces discard Cycle time in seconds F5, F6 and so on Shift Responsible Recording reason (Eg.: style change, responsable change, shift change, cycle time change)

RESPONSABLES Table It containes all data for responsables.

Pagina 4 di 10

NAUTILUS DATABASE

Nautilus Table DB Rel02.doc

NAME

TYPE

RESPOCODE FIRSTNAME LASTNAME TYPE

CHAR(30) CHAR(20) CHAR(20) LONG

USEDBY

Long

DESCRIPTION Responsable code Responsable name Responsable surname Responsable type (Machine group, knitting room, plant) Used by programmer

Pagina 5 di 10

NAUTILUS DATABASE

Nautilus Table DB Rel02.doc

SHIFT Table Contains the information about the shift model. Note: For each model is automatically created a table.

NAME

TYPE

STARTHOUR ENDHOUR SHIFT RESPOCODE

DATE/HOUR DATE/HOUR LONG CHAR (30)

DESCRIPTION Start hour shift Enf hour shift shift Responsable code

SHIFT_CALENDAR Table It contains a record for each day of the year and it is associated to each day the shift model to be used.

NAME SHIFTTABLENAME DAYOFYEAR

TYPE TESTO (30) INTERO LUNGO

DESCRIPTION Shift model Day of the year

SPARE_PARTS Table It contains the description of spare parts codes used. .

NAME SPAREPARTCODE DESCRIPTION

TYPE LONG CHAR (50)

DESCRIPTION Range 1-30 Spare part description

SPARE_PARTS_MONITOR Table Every time the operator insert on machine board a spare part code with number of pieces the machine sends a record to the PC.

NAME SPAREPARTCODE DATEREC PLANTCODE ROOMCODE GROUPCODE MACHCODE TIMES ORDERCODE STYLECODE STSIZE STCOLOR STLOT SHIFT

TYPE SHORT DATE/HOUR CHAR(30) CHAR(30) CHAR(30) LONG LONG CHAR(24) CHAR(24) CHAR(16) CHAR(16) CHAR(16) LONG

DESCRIPTION Stop type Date Plant code Room code Group code Manchine code Spare part quantity Order code Style code Style size Style coulour Yarn Lot shift

Pagina 6 di 10

NAUTILUS DATABASE

Nautilus Table DB Rel02.doc

STOPS Table It contains the stop codes coming from machines with stop description

NAME STOPCODE DESCRIPTION

TYPE LONG TEXT (255)

DESCRIPTION Error code Error code description

STOPS_MONITOR Table It contains all stops/re-starts of machines.

NAME STOP CODE DATEREC PLANTCODE ROOMCODE GROUPCODE MACHCODE CYCLEPOS ORDERCODE STYLECODE STSIZE STCOLOR STLOT SHIFT

TYPE SHORT DATE/HOUR CHAR(30) CHAR(30) CHAR(30) LONG LONG CHAR(24) CHAR(24) CHAR(16) CHAR(16) CHAR(16) LONG

DESCRIPTION Stop type date Palnt code Room code Group code Machine code Step or time from the start of the piece Order Code Style Code Style Size Style Coulour Yarn lot shift

The following tables represent the tree structure of the plant (plant-knitting room-group-machine). ENTERPRISE Table It contains the description of plant data.

NAME ENTERPRISECODE PLANTCODE RESPOCODE

TYPE CHAR (30) CHAR (30) CHAR (30)

DESCRIPTION Name of the company Plant Code Responsible Code

PLANT Table It contains the description of groups associated to plant.

NAME PLANTPATH ROOMPATH PLANTCODE ROOMCODE RESPOCODE

TYPE CHAR(128) CHAR(128) CHAR(30) CHAR(30) CHAR(30)

DESCRIPTION Path of the plant Path of the room Plant code Room code Responsable code

Pagina 7 di 10

NAUTILUS DATABASE

Nautilus Table DB Rel02.doc

ROOMS Table It conatins groups associated to rooms.

NAME ROOMPATH GROUPPATH ROOMCODE GROUPCODE RESPOCODE

TYPE CHAR(128) CHAR(128) CHAR(30) CHAR(30) CHAR(30)

DESCRIPTION Room path Group path Room code Group code Responsabile code

GROUPS Table It contains the description of machines associated to a certain group.

NAME GROUPPATH MACHPATH GROUPCODE MACHCODE RESPOCODE

TYPE CHAR (128) CHAR (128) CHAR (30) LONG CHAR (30)

DESCRIPTION Path of the group Path of the machine Group code Machine code Responsabile code

Pagina 8 di 10

NAUTILUS DATABASE

Nautilus Table DB Rel02.doc

Database tables dbsystem.mdb description. Here below you’ll find a description of all tables included in dbsystem.mdb database used by the program. For every table you’ll find table name and for every field name, type (dimension) and possible description. Tables described as follows do not contain production data. Those tables are used by the software.

FOLDERS_PATH Table Contains all events coming from the machines.

NAME PATH

TYPE TEXT (120)

DESCRIPTION Events folder Path

GROUPS_PATHS Table Contains the information concerning the group.

NAME

TYPE

IDGROUP

TEXT (120)

PATH CONNECTION STRING

TEXT (120) TEXT (120)

DESCRIPTION Identify the group inside the plant (Plant_knitting room_Group) Database path of the group Connection string to the database (ADO used by code)

NAUTILUS_PATHS Table Contains path chosen by the user to map the database

NAME PATH

TYPE TEXT (120)

DESCRIPTION Mapping path of database

PC_CLIENT table It contains connection status to Client database.

NAME NAME STATE

TYPE TEXT (128) LONG

DESCRIPTION Name PC Client Connection status

PC_SERVER Table Contains connection status to Server database.

NAME NAME STATE

TYPE TEXT (128) LONG

DESCRIPTION PC Server name Connection status

Pagina 9 di 10

NAUTILUS DATABASE

Nautilus Table DB Rel02.doc

SEMAPHORE Table Contains flag for database working permission from clients.

NAME VALUE

TYPE LONG

DESCRIPTION Flag for database access from Client

SHIFTS_MODEL Table Contains names of shift models set by user.

NAME NAMETABLEMODEL

TYPE TEXT (30)

DESCRIPTION Name of created model

CALENDAR_MODEL Table Contains names of shift calendar set by user.

NOME NAMECALENDARMODEL

TIPO CHAR (30)

DESCRIZIONE Name of created model

Pagina 10 di 10

Related Documents

Nautilus Table Db Rel02
November 2019 7
Db And Table Creation.docx
December 2019 17
Pacific Nautilus
July 2020 8
Db
November 2019 66
Db
June 2020 25
Db
October 2019 60