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