File: /home/cafsindia/refimac_cafsjobs_com/refimac_old_software.html
<?xml version='1.0' encoding='ISO-8859-1' standalone='yes'?>
<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.1 plus MathML 2.0 plus SVG 1.1//EN' 'http://www.w3.org/2002/04/xhtml-math-svg/xhtml-math-svg.dtd'>
<html xmlns='http://www.w3.org/1999/xhtml' >
<head>
<title>Database documentation</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF8"/>
<style type='text/css'>
#dbs {font-family:Tahoma,Dialog,Sans-Serif;font-size:11px;background:#fff;width:80%;border-collapse:collapse;text-align:left;margin:20px;}
#dbs thead{background:#ddd;}
#dbs th{font-size:12px;font-weight:bold;color:#336;border-bottom:2px solid #336;padding:7px 8px;}
#dbs td{border-bottom:1px solid #ccc;color:#336;padding:3px 8px;white-space: pre;}
td.subpart{font-weight:bold;background:#ddd}
td.name{background:#f2f2f2}
#dbs tbody tr:hover td{color:#000;background:#fffcea;}
</style>
</head>
<body>
<svg xmlns='http://www.w3.org/2000/svg' xmlns:xlink='http://www.w3.org/1999/xlink' width='1568' height='916' viewbox='0 0 1568 916' >
<style type='text/css'>
text { text-rendering: optimizeLegibility; fill:#000000; font-family: Candara, Dialog, Arial; font-size:12px; }
text.nn { fill:#636363; }
text.colType { fill:#a9bdc6; }
text.tableTitle { fill:#111111; font-weight:bold; }
path { stroke:#4d423e; stroke-width:1.5; fill:none; }
rect.grp { opacity:0.5; stroke:#c2ab83; stroke-width:1; }
rect.table { fill:#ffffff; stroke:#495272; stroke-width:0.5; filter:url(#shadow); }
line.table { stroke:#495272; stroke-width:0.5; }
rect.callout { fill:url(#calloutGradient); stroke:#aea913; stroke-width:0.5; }
path.callout { fill:#f4f1a4; stroke:#aea913; stroke-width:0.5; }
</style>
<defs>
<radialGradient id='layoutGradient' cx='20%' cy='20%' r='25%' fx='10%' fy='0%'>
<stop offset='0%' stop-color='#ffffff' />
<stop offset='100%' stop-color='#efefef' />
</radialGradient>
<linearGradient id='tableHeaderGradient' x1='0%' y1='0%' x2='0%' y2='100%' >
<stop offset='0%' stop-color='#eff7fc' stop-opacity='1'/>
<stop offset='50%' stop-color='#d9e5f6' stop-opacity='1'/>
<stop offset='51%' stop-color='#bdd4f1' stop-opacity='1'/>
<stop offset='100%' stop-color='#d6e2f9' stop-opacity='1' />
</linearGradient>
<radialGradient id='calloutGradient' cx='20%' cy='20%' r='100%' fx='10%' fy='10%'>
<stop offset='0%' stop-color='#ffffff' />
<stop offset='100%' stop-color='#f4f1a4' />
</radialGradient>
<filter id='shadow' width='150%' height='150%'>
<feGaussianBlur in='SourceAlpha' stdDeviation='3' result='image1' />
<feOffset in='image1' result='image2' dx='3' dy='3' />
<feComposite in='SourceGraphic' in2='image2' operator='over' />
</filter>
<filter id='emboss'>
<feGaussianBlur in='SourceAlpha' stdDeviation='2' result='blur'/>
<feSpecularLighting in='blur' surfaceScale='-3' style='lighting-color:white'
specularConstant='1' specularExponent='16' result='spec' kernelUnitLength='1' >
<feDistantLight azimuth='45' elevation='45' />
</feSpecularLighting>
<feComposite in='spec' in2='SourceGraphic' operator='in' result='specOut'/>
<feComposite in='SourceGraphic' in2='specOut' operator='arithmetic' k1='0' k2='1' k3='1' k4='0' result='litPaint'/>
</filter>
<filter id='embossAndShadow' filterUnits='userSpaceOnUse' x='0' y='0' width='400' height='120'>
<feGaussianBlur in='SourceAlpha' stdDeviation='4' result='blur'/>
<feOffset in='blur' dx='4' dy='4' result='offsetBlur'/>
<feSpecularLighting in='blur' surfaceScale='5' specularConstant='.75' specularExponent='20' lighting-color='#bbbbbb' result='specOut'>
<fePointLight x='-5000' y='-10000' z='20000'/>
</feSpecularLighting>
<feComposite in='specOut' in2='SourceAlpha' operator='in' result='specOut'/>
<feComposite in='SourceGraphic' in2='specOut' operator='arithmetic' k1='0' k2='1' k3='1' k4='0' result='litPaint'/>
<feMerge>
<feMergeNode in='offsetBlur'/>
<feMergeNode in='litPaint'/>
</feMerge>
</filter>
<radialGradient id='legendGradient' fx='5%' fy='5%' r='75%' spreadMethod='pad'>
<stop offset='0%' stop-color='#6985ff' stop-opacity='1'/>
<stop offset='100%' stop-color='#1e2a5f' stop-opacity='1' />
</radialGradient>
<pattern id='hintPointerSV' patternUnits='userSpaceOnUse' x='0' y='0' width='14' height='14' viewBox='0 0 14 14' >
<path d='M 0,0 Q 7,7,0,13 Q 13,7,13,0' class='callout' />
</pattern>
<pattern id='hintPointerSE' patternUnits='userSpaceOnUse' x='0' y='0' width='14' height='14' viewBox='0 0 14 14' >
<path d='M 0,0 Q 3,7,13,13 Q 7,7,13,0' class='callout' />
</pattern>
<pattern id='hintPointerNV' patternUnits='userSpaceOnUse' x='0' y='0' width='14' height='14' viewBox='0 0 14 14' >
<path d='M 0,13 Q 7,7,0,0 Q 13,7,13,13' class='callout' />
</pattern>
<pattern id='hintPointerNE' patternUnits='userSpaceOnUse' x='0' y='0' width='14' height='14' viewBox='0 0 14 14' >
<path d='M 0,13 Q 3,7,13,0 Q 7,7,13,13' class='callout' />
</pattern>
<symbol id='pk' overflow='visible' >
<path style='fill:#e9ad16;stroke:#9c4f15;stroke-width:0.7;stroke-linecap:round;stroke-linejoin:round;filter:url(#emboss);'
d='M 9.3678877,3.5695485 C 9.1030218,3.2729386 9.0796382,2.7628519 9.3396185,2.4517097 9.5449651,2.1956495 9.9040386,2.0980533 10.199638,2.2169415 10.533525,2.3415459 10.775153,2.706942 10.750675,3.0842709 10.737029,3.3980003 10.541153,3.699122 10.258248,3.8066067 9.966649,3.9250429 9.6169668,3.8418805 9.4008073,3.6062324 9.3894892,3.5943518 9.3785264,3.582104 9.3678886,3.5695487 z M 11.226617,6.9916004 C 11.888137,6.3548946 12.293488,5.4172188 12.311087,4.442353 12.378144,2.7379364 11.248678,1.0541269 9.7322318,0.44767357 8.3887112,-0.1280313 6.7865012,0.26822889 5.8918395,1.4007929 5.080823,2.3839145 4.9336815,3.8452096 5.3635544,5.101615 L 4.3670905,5.315913 C 4.0664984,5.3682645 4.0967703,5.6316724 4.2574957,5.8208829 L 4.9124,6.5655244 4.1543436,7.2512357 3.2136002,7.2163506 3.1674775,8.5586827 2.0406832,8.5086512 1.5965306,8.9299953 1.5471661,10.179833 0.75616674,10.195223 0.2112857,10.758575 0.15354288,11.735988 0.07199052,12.765553 c 0.36440953,0.238225 0.79006967,0.195492 1.44938278,-0.02675 L 6.3033562,8.1282037 6.8217102,8.6765688 C 6.9985465,8.8799427 7.3003699,8.7497574 7.358381,8.5016252 L 7.4938877,7.5084164 c 0.8537488,0.3985387 1.8303125,0.4711541 2.6851793,0.1427713 0.393927,-0.1407258 0.746858,-0.3701772 1.04755,-0.6595873 z'/>
<path d='M 6.8014948,6.3102123 0.15369063,13.024481 0.21560535,12.141962 6.0062342,6.2683782 z'
style='fill:#ffe5a5;fill-opacity:1;stroke:#854e31;stroke-width:0.09912433;stroke-linecap:round;stroke-linejoin:round;stroke-miterlimit:4;stroke-opacity:1;stroke-dasharray:none;stroke-dashoffset:3.00300009'/>
</symbol>
<symbol id='unq' overflow='visible' >
<rect style='fill:#e07554;stroke:#7e4d31;stroke-width:0.71934468;stroke-linecap:round;stroke-linejoin:round;'
width='2.29' height='8.43' x='7.48' y='-0.76' ry='1.14' transform='matrix(0.701,0.713,-0.727,0.685,0,0)' />
<path style='fill:#ffffe2;stroke:#515151;stroke-width:0.8;stroke-linecap:round;stroke-linejoin:round;stroke-miterlimit:4;filter:url(#emboss);'
d='m 26.04,8.64 a 4.13,4.13 0 1 1 -8.26,0 4.13,4.13 0 1 1 8.26,0 z'
transform='matrix(1.025,0,0,0.987,-14.690,-3.862)' />
<text x='6' y='6.5' style='font-size:10px;'>1</text>
</symbol>
<symbol id='idx' overflow='visible' >
<rect style='fill:#e07554;stroke:#7e4d31;stroke-width:0.71934468;stroke-linecap:round;stroke-linejoin:round;'
width='2.29' height='8.43' x='7.48' y='-0.76' ry='1.14' transform='matrix(0.701,0.713,-0.727,0.685,0,0)' />
<path style='fill:#ffffe2;stroke:#515151;stroke-width:0.8;stroke-linecap:round;stroke-linejoin:round;stroke-miterlimit:4;filter:url(#emboss);'
d='m 26.04,8.64 a 4.13,4.13 0 1 1 -8.26,0 4.13,4.13 0 1 1 8.26,0 z'
transform='matrix(1.025,0,0,0.987,-14.690,-3.862)' />
</symbol>
<symbol id='fk' overflow='visible' >
<path style='fill:#69bfed;stroke:#124280;stroke-width:0.46;stroke-linecap:butt;stroke-linejoin:round;stroke-miterlimit:4;'
d='M 12.48,0.33 7.07,0.89 9.067,2.974 0.329,11.731 1.073,12.597 9.811,3.841 11.77,5.78 z' />
</symbol>
<symbol id='ref' overflow='visible' >
<path style='fill:#7eed2e;stroke:#1b6924;stroke-width:0.4;stroke-linecap:butt;stroke-linejoin:round;stroke-miterlimit:4;'
d='M 0.10,12.70 5.31,12.15 3.40,10.06 11.82,1.32 11.11,0.45 2.68,9.19 0.80,7.24 z'/>
</symbol>
<marker id='arrow' viewBox='0 0 7 7' refX='0' refY='3' markerUnits='strokeWidth' markerWidth='7' markerHeight='7' orient='auto'>
<path d='M 0,0 L 7, 3 L 0,7 z' style='fill:#776c57; stroke-width:0px;' />
</marker>
<marker id='foot' viewBox='0 0 7 7' refX='7' refY='3' markerUnits='strokeWidth' markerWidth='7' markerHeight='7' orient='auto'>
<path d='M 0,3 L 14, 3 z' style='stroke:#776c57;' />
</marker>
</defs>
<!-- ============= Desktop ============= -->
<rect x='1' y='1' width='1566' height='914' rx='7' ry='7' style='fill:url(#layoutGradient); stroke:#104576; stroke-width:0.5;' />
<text x='10' y='10' style='font-size:10px;filter:url(#embossAndShadow);color:red;'>Move the mouse over icons and columns to read the comments</text>
<!-- ============= Group 'make' ============= -->
<rect class='grp' style='fill:#ffffcc;' x='352' y='330' width='360' height='152' rx='7' ry='7'/>
<text x='362' y='340'>make</text>
<!-- ============= Group 'Unreferenced' ============= -->
<rect class='grp' style='fill:#fff8d6;' x='30' y='106' width='808' height='698' rx='7' ry='7'/>
<text x='40' y='116'>Unreferenced</text>
<!-- ============= Table 'area' ============= -->
<rect class='table' x='532' y='483' width='126' height='84' rx='7' ry='7' />
<path d='M 532.50 504.00 L 532.50 490.50 Q 532.50 483.50 539.50 483.50 L 650.50 483.50 Q 657.50 483.50 657.50 490.50 L 657.50 504.00 L532.50 504.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<line class='table' x1='532' y1='504' x2='658' y2='504'/>
<a xlink:href='#area' title='refimac_source.area' ><text x='583' y='497' class='tableTitle'>area</text></a>
<a xlink:href='#AREA_ID' title='Primary Key ( AREA_ID ) '><use id='pk' x='533' y='514' xlink:href='#pk'/></a>
<a xlink:href='#AREA_ID' title='INT not null Store the area id'><text x='546' y='525'>AREA_ID</text></a>
<a xlink:href='#AREA_NAME' title='Unique Index ( AREA_NAME ) '><use id='unq' x='533' y='528' xlink:href='#unq'/></a>
<a xlink:href='#AREA_NAME' title='VARCHAR( 100 ) not null store the area name'><text x='546' y='539'>AREA_NAME</text></a>
<a xlink:href='#AREA_NAME' title='Referred by sales ( LOCATION -> AREA_NAME ) '><use id='ref' x='644' y='528' xlink:href='#ref'/></a>
<a xlink:href='#AREA_UPDATE' title='INT not null store the area updated id'><text x='546' y='553'>AREA_UPDATE</text></a>
<!-- ============= Table 'customer' ============= -->
<rect class='table' x='266' y='483' width='210' height='196' rx='7' ry='7' />
<path d='M 266.50 504.00 L 266.50 490.50 Q 266.50 483.50 273.50 483.50 L 468.50 483.50 Q 475.50 483.50 475.50 490.50 L 475.50 504.00 L266.50 504.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<line class='table' x1='266' y1='504' x2='476' y2='504'/>
<a xlink:href='#customer' title='refimac_source.customer' ><text x='347' y='497' class='tableTitle'>customer</text></a>
<a xlink:href='#CUSTOMER_CODE' title='Primary Key ( CUSTOMER_CODE ) '><use id='pk' x='267' y='514' xlink:href='#pk'/></a>
<a xlink:href='#CUSTOMER_CODE' title='VARCHAR( 100 ) not null store the customer code'><text x='280' y='525'>CUSTOMER_CODE</text></a>
<a xlink:href='#CUSTOMER_CODE' title='Referred by sales ( CUSTOMER_CODE ) '><use id='ref' x='462' y='514' xlink:href='#ref'/></a>
<a xlink:href='#CUSTOMER_NAME' title='VARCHAR( 100 ) not null store the customer name'><text x='280' y='539'>CUSTOMER_NAME</text></a>
<a xlink:href='#CUSTOMER_ADDRESS' title='VARCHAR( 400 ) store the customer address'><text x='280' y='553' class='nn'>CUSTOMER_ADDRESS</text></a>
<a xlink:href='#CUSTOMER_AREA' title='VARCHAR( 100 ) store the area name'><text x='280' y='567' class='nn'>CUSTOMER_AREA</text></a>
<a xlink:href='#CUSTOMER_SURROUND_AREA' title='VARCHAR( 100 ) customer area name'><text x='280' y='581' class='nn'>CUSTOMER_SURROUND_AREA</text></a>
<a xlink:href='#CUSTOMER_CITY' title='VARCHAR( 100 ) customer city'><text x='280' y='595' class='nn'>CUSTOMER_CITY</text></a>
<a xlink:href='#CUSTOMER_PINCODE' title='VARCHAR( 100 ) customer pincode'><text x='280' y='609' class='nn'>CUSTOMER_PINCODE</text></a>
<a xlink:href='#CUSTOMER_PHONE' title='VARCHAR( 100 ) customer phone'><text x='280' y='623' class='nn'>CUSTOMER_PHONE</text></a>
<a xlink:href='#CUSTOMER_MOBILE' title='VARCHAR( 100 ) not null customer mobile'><text x='280' y='637'>CUSTOMER_MOBILE</text></a>
<a xlink:href='#CUSTOMER_CONTACT_PERSON' title='VARCHAR( 100 ) contact person name'><text x='280' y='651' class='nn'>CUSTOMER_CONTACT_PERSON</text></a>
<a xlink:href='#CUSTOMER_UPDATE' title='INT not null data added user name'><text x='280' y='665'>CUSTOMER_UPDATE</text></a>
<!-- ============= Table 'service_mode' ============= -->
<rect class='table' x='42' y='483' width='168' height='70' rx='7' ry='7' />
<path d='M 42.50 504.00 L 42.50 490.50 Q 42.50 483.50 49.50 483.50 L 202.50 483.50 Q 209.50 483.50 209.50 490.50 L 209.50 504.00 L42.50 504.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<line class='table' x1='42' y1='504' x2='210' y2='504'/>
<a xlink:href='#service_mode' title='refimac_source.service_mode' ><text x='90' y='497' class='tableTitle'>service_mode</text></a>
<a xlink:href='#SERVICE_MODE_ID' title='Primary Key ( SERVICE_MODE_ID ) '><use id='pk' x='43' y='514' xlink:href='#pk'/></a>
<a xlink:href='#SERVICE_MODE_ID' title='INT not null store the mode id'><text x='56' y='525'>SERVICE_MODE_ID</text></a>
<a xlink:href='#SERVICE_MODE_ID' title='Referred by sales ( SERVICEMODE_ID -> SERVICE_MODE_ID ) '><use id='ref' x='196' y='514' xlink:href='#ref'/></a>
<a xlink:href='#SERVICE_MODE_NAME' title='VARCHAR( 100 ) not null store the mode name'><text x='56' y='539'>SERVICE_MODE_NAME</text></a>
<path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)' title='FK_MAKE_ID model to make ( MAKE_ID )' d='M 490 364 L 574,364' />
<!-- ============= Table 'model' ============= -->
<rect class='table' x='364' y='343' width='126' height='112' rx='7' ry='7' />
<path d='M 364.50 364.00 L 364.50 350.50 Q 364.50 343.50 371.50 343.50 L 482.50 343.50 Q 489.50 343.50 489.50 350.50 L 489.50 364.00 L364.50 364.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<line class='table' x1='364' y1='364' x2='490' y2='364'/>
<a xlink:href='#model' title='refimac_source.model' ><text x='410' y='357' class='tableTitle'>model</text></a>
<a xlink:href='#MODEL_ID' title='Primary Key ( MODEL_ID ) '><use id='pk' x='365' y='374' xlink:href='#pk'/></a>
<a xlink:href='#MODEL_ID' title='INT not null store the model id'><text x='378' y='385'>MODEL_ID</text></a>
<a xlink:href='#MODEL_ID' title='Referred by sales ( MODEL_ID ) '><use id='ref' x='476' y='374' xlink:href='#ref'/></a>
<a xlink:href='#MODEL_CODE' title='VARCHAR( 100 ) store the model code'><text x='378' y='399' class='nn'>MODEL_CODE</text></a>
<a xlink:href='#MODEL_NAME' title='VARCHAR( 100 ) not null store the model name'><text x='378' y='413'>MODEL_NAME</text></a>
<a xlink:href='#MAKE_ID' title='INT not null store the make id'><text x='378' y='427'>MAKE_ID</text></a>
<a xlink:href='#MAKE_ID' title='References make ( MAKE_ID ) '><use id='fk' x='476' y='416' xlink:href='#fk'/></a>
<a xlink:href='#LIST_INDEX' title='INT store list index'><text x='378' y='441' class='nn'>LIST_INDEX</text></a>
<!-- ============= Table 'make' ============= -->
<rect class='table' x='588' y='343' width='112' height='84' rx='7' ry='7' />
<path d='M 588.50 364.00 L 588.50 350.50 Q 588.50 343.50 595.50 343.50 L 692.50 343.50 Q 699.50 343.50 699.50 350.50 L 699.50 364.00 L588.50 364.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<line class='table' x1='588' y1='364' x2='700' y2='364'/>
<a xlink:href='#make' title='refimac_source.make' ><text x='630' y='357' class='tableTitle'>make</text></a>
<a xlink:href='#MAKE_ID' title='Primary Key ( MAKE_ID ) '><use id='pk' x='589' y='374' xlink:href='#pk'/></a>
<a xlink:href='#MAKE_ID' title='INT not null store make id'><text x='602' y='385'>MAKE_ID</text></a>
<a xlink:href='#MAKE_ID' title='Referred by model ( MAKE_ID ) '><use id='ref' x='686' y='374' xlink:href='#ref'/></a>
<a xlink:href='#MAKE_CODE' title='VARCHAR( 10 ) store make code'><text x='602' y='399' class='nn'>MAKE_CODE</text></a>
<a xlink:href='#MAKE_NAME' title='VARCHAR( 100 ) not null make name'><text x='602' y='413'>MAKE_NAME</text></a>
<!-- ============= Table 'employee' ============= -->
<rect class='table' x='714' y='483' width='112' height='126' rx='7' ry='7' />
<path d='M 714.50 504.00 L 714.50 490.50 Q 714.50 483.50 721.50 483.50 L 818.50 483.50 Q 825.50 483.50 825.50 490.50 L 825.50 504.00 L714.50 504.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<line class='table' x1='714' y1='504' x2='826' y2='504'/>
<a xlink:href='#employee' title='refimac_source.employee' ><text x='744' y='497' class='tableTitle'>employee</text></a>
<a xlink:href='#EMP_ID' title='Primary Key ( EMP_ID ) '><use id='pk' x='715' y='514' xlink:href='#pk'/></a>
<a xlink:href='#EMP_ID' title='INT not null store the employee id'><text x='728' y='525'>EMP_ID</text></a>
<a xlink:href='#EMP_CODE' title='VARCHAR( 100 ) not null store the employee code'><text x='728' y='539'>EMP_CODE</text></a>
<a xlink:href='#EMP_NAME' title='VARCHAR( 100 ) not null store employee name'><text x='728' y='553'>EMP_NAME</text></a>
<a xlink:href='#EMP_MOBILE' title='VARCHAR( 100 ) not null store the mobile number'><text x='728' y='567'>EMP_MOBILE</text></a>
<a xlink:href='#EMP_DOJ' title='DATE not null store the doj'><text x='728' y='581'>EMP_DOJ</text></a>
<a xlink:href='#EMP_UPDATE' title='Unique Index ( EMP_UPDATE ) '><use id='unq' x='715' y='584' xlink:href='#unq'/></a>
<a xlink:href='#EMP_UPDATE' title='INT not null store the updated date and time'><text x='728' y='595'>EMP_UPDATE</text></a>
<a xlink:href='#EMP_UPDATE' title='Referred by sss_login ( LOGIN_ID -> EMP_UPDATE ) '><use id='ref' x='812' y='584' xlink:href='#ref'/></a>
<path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)' title='fk_sss_login_employee sss_login to employee ( LOGIN_ID -> EMP_UPDATE )' d='M 196 434 L 196,455 Q 196,462 203,462 L 231,462 Q 238,462 238,469 L 238,693 Q 238,700 245,700 L 497,700 Q 504,700 504,693 L 504,469 Q 504,462 511,462 L 721,462 Q 728,462 728,469 L 728,476' />
<!-- ============= Table 'sss_login' ============= -->
<rect class='table' x='70' y='329' width='140' height='98' rx='7' ry='7' />
<path d='M 70.50 350.00 L 70.50 336.50 Q 70.50 329.50 77.50 329.50 L 202.50 329.50 Q 209.50 329.50 209.50 336.50 L 209.50 350.00 L70.50 350.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<line class='table' x1='70' y1='350' x2='210' y2='350'/>
<a xlink:href='#sss_login' title='refimac_source.sss_login' ><text x='116' y='343' class='tableTitle'>sss_login</text></a>
<a xlink:href='#LOGIN_ID' title='Primary Key ( LOGIN_ID ) '><use id='pk' x='71' y='360' xlink:href='#pk'/></a>
<a xlink:href='#LOGIN_ID' title='INT not null store the login id'><text x='84' y='371'>LOGIN_ID</text></a>
<a xlink:href='#LOGIN_ID' title='References employee ( LOGIN_ID -> EMP_UPDATE ) '><use id='fk' x='196' y='360' xlink:href='#fk'/></a>
<a xlink:href='#LOGIN_USERNAME' title='VARCHAR( 100 ) not null store the username'><text x='84' y='385'>LOGIN_USERNAME</text></a>
<a xlink:href='#LOGIN_PASSWORD' title='VARCHAR( 100 ) not null store the login password'><text x='84' y='399'>LOGIN_PASSWORD</text></a>
<a xlink:href='#LOGIN_UPDATE' title='INT not null store the login update date'><text x='84' y='413'>LOGIN_UPDATE</text></a>
<!-- ============= Table 'service' ============= -->
<rect class='table' x='532' y='595' width='126' height='182' rx='7' ry='7' />
<path d='M 532.50 616.00 L 532.50 602.50 Q 532.50 595.50 539.50 595.50 L 650.50 595.50 Q 657.50 595.50 657.50 602.50 L 657.50 616.00 L532.50 616.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<line class='table' x1='532' y1='616' x2='658' y2='616'/>
<a xlink:href='#service' title='refimac_source.service' ><text x='577' y='609' class='tableTitle'>service</text></a>
<a xlink:href='#SALES_ID' title='Unique Index ( SALES_ID ) '><use id='unq' x='533' y='626' xlink:href='#unq'/></a>
<a xlink:href='#SALES_ID' title='INT not null store the sales id'><text x='546' y='637'>SALES_ID</text></a>
<a xlink:href='#SALES_ID' title='Referred by sales ( SALES_ID ) '><use id='ref' x='644' y='626' xlink:href='#ref'/></a>
<a xlink:href='#SERIALNO' title='VARCHAR( 100 ) serial number'><text x='546' y='651' class='nn'>SERIALNO</text></a>
<a xlink:href='#EMPLOYEE_ID' title='INT employee id'><text x='546' y='665' class='nn'>EMPLOYEE_ID</text></a>
<a xlink:href='#SLIPNO' title='VARCHAR( 50 ) slip number'><text x='546' y='679' class='nn'>SLIPNO</text></a>
<a xlink:href='#COMMENTS' title='VARCHAR( 200 ) comments'><text x='546' y='693' class='nn'>COMMENTS</text></a>
<a xlink:href='#DATE' title='DATE store the date'><text x='546' y='707' class='nn'>DATE</text></a>
<a xlink:href='#MONTH' title='VARCHAR( 100 ) service month'><text x='546' y='721' class='nn'>MONTH</text></a>
<a xlink:href='#YEAR' title='VARCHAR( 100 ) service year'><text x='546' y='735' class='nn'>YEAR</text></a>
<a xlink:href='#LIST_INDEX' title='INT not null service list index'><text x='546' y='749'>LIST_INDEX</text></a>
<a xlink:href='#COMPLETED' title='CHAR( 1 ) not null store completed status'><text x='546' y='763'>COMPLETED</text></a>
<path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)' title='fk_sales_service_mode sales to service_mode ( SERVICEMODE_ID -> SERVICE_MODE_ID )' d='M 210 308 L 21,308 Q 14,308 14,315 L 14,483 Q 14,490 21,490 L 28,490' />
<path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)' title='fk_sales_model sales to model ( MODEL_ID )' d='M 378 322 L 385,322 Q 392,322 392,329 L 392,336' />
<path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)' title='fk_sales_customer sales to customer ( CUSTOMER_CODE )' d='M 280 420 L 280,476' />
<path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)' title='fk_sales_service sales to service ( SALES_ID )' d='M 378 308 L 553,308 Q 560,308 560,315 L 560,441 Q 560,448 567,448 L 665,448 Q 672,448 672,455 L 672,609 Q 672,616 665,616 L 658,616' />
<path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)' title='fk_sales_area sales to area ( LOCATION -> AREA_NAME )' d='M 378 294 L 539,294 Q 546,294 546,301 L 546,476' />
<path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)' title='fk_sales_purchase sales to purchase ( INVOICE_NO -> PURCHASE_INVOICENUMBER )' d='M 378 140 L 518,140' />
<!-- ============= Table 'sales' ============= -->
<rect class='table' x='224' y='119' width='154' height='294' rx='7' ry='7' />
<path d='M 224.50 140.00 L 224.50 126.50 Q 224.50 119.50 231.50 119.50 L 370.50 119.50 Q 377.50 119.50 377.50 126.50 L 377.50 140.00 L224.50 140.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<line class='table' x1='224' y1='140' x2='378' y2='140'/>
<a xlink:href='#sales' title='refimac_source.sales' ><text x='288' y='133' class='tableTitle'>sales</text></a>
<a xlink:href='#SALES_ID' title='Primary Key ( SALES_ID ) '><use id='pk' x='225' y='150' xlink:href='#pk'/></a>
<a xlink:href='#SALES_ID' title='INT not null store the sales id'><text x='238' y='161'>SALES_ID</text></a>
<a xlink:href='#SALES_ID' title='References service ( SALES_ID ) '><use id='fk' x='364' y='150' xlink:href='#fk'/></a>
<a xlink:href='#CUSTOMER_CODE' title='VARCHAR( 100 ) not null store the customer code'><text x='238' y='175'>CUSTOMER_CODE</text></a>
<a xlink:href='#CUSTOMER_CODE' title='References customer ( CUSTOMER_CODE ) '><use id='fk' x='364' y='164' xlink:href='#fk'/></a>
<a xlink:href='#MODEL_ID' title='INT not null store the model id'><text x='238' y='189'>MODEL_ID</text></a>
<a xlink:href='#MODEL_ID' title='References model ( MODEL_ID ) '><use id='fk' x='364' y='178' xlink:href='#fk'/></a>
<a xlink:href='#SERVICEMODE_ID' title='INT not null store the service mode id'><text x='238' y='203'>SERVICEMODE_ID</text></a>
<a xlink:href='#SERVICEMODE_ID' title='References service_mode ( SERVICEMODE_ID -> SERVICE_MODE_ID ) '><use id='fk' x='364' y='192' xlink:href='#fk'/></a>
<a xlink:href='#LOCATION' title='VARCHAR( 100 ) not null store the location'><text x='238' y='217'>LOCATION</text></a>
<a xlink:href='#LOCATION' title='References area ( LOCATION -> AREA_NAME ) '><use id='fk' x='364' y='206' xlink:href='#fk'/></a>
<a xlink:href='#COMPRESSORNO' title='VARCHAR( 100 ) not null store the compressor number'><text x='238' y='231'>COMPRESSORNO</text></a>
<a xlink:href='#INSTALLATION_DATE' title='DATE not null store the installation date'><text x='238' y='245'>INSTALLATION_DATE</text></a>
<a xlink:href='#MATURITY_DATE' title='DATE not null store maturity date'><text x='238' y='259'>MATURITY_DATE</text></a>
<a xlink:href='#INVOICE_DATE' title='DATE not null store invoice date'><text x='238' y='273'>INVOICE_DATE</text></a>
<a xlink:href='#AMOUNT' title='DOUBLE not null store amount'><text x='238' y='287'>AMOUNT</text></a>
<a xlink:href='#REMARKS' title='VARCHAR( 200 ) not null store remarks'><text x='238' y='301'>REMARKS</text></a>
<a xlink:href='#INVOICE_NO' title='VARCHAR( 100 ) not null store invoice number'><text x='238' y='315'>INVOICE_NO</text></a>
<a xlink:href='#INVOICE_NO' title='References purchase ( INVOICE_NO -> PURCHASE_INVOICENUMBER ) '><use id='fk' x='364' y='304' xlink:href='#fk'/></a>
<a xlink:href='#NO_OF_SERVICES' title='INT not null store the number of services'><text x='238' y='329'>NO_OF_SERVICES</text></a>
<a xlink:href='#CAPACITY' title='VARCHAR( 100 ) not null store the capacity'><text x='238' y='343'>CAPACITY</text></a>
<a xlink:href='#WARRENTY' title='VARCHAR( 100 ) not null store the warrenty'><text x='238' y='357'>WARRENTY</text></a>
<a xlink:href='#MAKE_ID' title='INT not null store the make id'><text x='238' y='371'>MAKE_ID</text></a>
<a xlink:href='#PURCHASE_ID' title='INT not null store the purchase id'><text x='238' y='385'>PURCHASE_ID</text></a>
<a xlink:href='#COMPLETED' title='BIT status'><text x='238' y='399' class='nn'>COMPLETED</text></a>
<!-- ============= Table 'purchase' ============= -->
<rect class='table' x='532' y='119' width='196' height='126' rx='7' ry='7' />
<path d='M 532.50 140.00 L 532.50 126.50 Q 532.50 119.50 539.50 119.50 L 720.50 119.50 Q 727.50 119.50 727.50 126.50 L 727.50 140.00 L532.50 140.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<line class='table' x1='532' y1='140' x2='728' y2='140'/>
<a xlink:href='#purchase' title='refimac_source.purchase' ><text x='606' y='133' class='tableTitle'>purchase</text></a>
<a xlink:href='#PURCHASE_ID' title='Primary Key ( PURCHASE_ID ) '><use id='pk' x='533' y='150' xlink:href='#pk'/></a>
<a xlink:href='#PURCHASE_ID' title='INT not null store the purchase id'><text x='546' y='161'>PURCHASE_ID</text></a>
<a xlink:href='#PURCHASE_INVOICENUMBER' title='Unique Index ( PURCHASE_INVOICENUMBER ) '><use id='unq' x='533' y='164' xlink:href='#unq'/></a>
<a xlink:href='#PURCHASE_INVOICENUMBER' title='VARCHAR( 60 ) not null store the purchase invoice'><text x='546' y='175'>PURCHASE_INVOICENUMBER</text></a>
<a xlink:href='#PURCHASE_INVOICENUMBER' title='Referred by sales ( INVOICE_NO -> PURCHASE_INVOICENUMBER ) '><use id='ref' x='714' y='164' xlink:href='#ref'/></a>
<a xlink:href='#PURCHASE_DATE' title='VARCHAR( 60 ) not null store purchase date'><text x='546' y='189'>PURCHASE_DATE</text></a>
<a xlink:href='#PURCHASE_SERIALNUMBER' title='VARCHAR( 60 ) not null store the purchase serial number'><text x='546' y='203'>PURCHASE_SERIALNUMBER</text></a>
<a xlink:href='#PURCHASE_MODEL_ID' title='INT not null store the purchase model numer'><text x='546' y='217'>PURCHASE_MODEL_ID</text></a>
<a xlink:href='#PURCHASE_DISPLAY' title='INT default 0 purchase display status'><text x='546' y='231' class='nn'>PURCHASE_DISPLAY</text></a>
<!-- ============= Callout ============= -->
<rect class='callout' x='1106' y='42' width='434' height='115' rx='14' ry='14' />
<text x='1120' y='49'>
<tspan x='1106' dx='10' dy='14'>Usage Tips </tspan>
<tspan x='1106' dx='10' dy='14'> </tspan>
<tspan x='1106' dx='10' dy='14'> * Create layouts from the menu. They will be saved in the project file </tspan>
<tspan x='1106' dx='10' dy='14'> * One table can show in multiple layouts </tspan>
<tspan x='1106' dx='10' dy='14'> * Double-click any table, column or foreign key to edit.</tspan>
<tspan x='1106' dx='10' dy='14'> * Right-click a table to start Relational Data Browse, SQL Editor or Query Builder</tspan>
<tspan x='1106' dx='10' dy='14'> * Drop this tip from his right-click pop-up</tspan>
</text>
<g transform='translate(1288,826)'>
<rect x='10' y='10' width='240' height='45' rx='6' ry='6' style='fill:url(#legendGradient);filter:url(#embossAndShadow);'/>
<text x='25' y='24' >Layout refimac_source</text>
<text x='25' y='38' >Project MySql</text>
<a xlink:href='http://www.sribarati.com' title='Visit http://www.sribarati.com'>
<text x='165' y='47' style='fill:white' >by SBIT</text>
<line x1='165' y1='50' x2='240' y2='50' style='stroke:white;stroke-width:0.5;'/>
</a>
</g>
</svg>
<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='area'>Table area</a> <br/> </th></tr>
</thead>
<tbody>
<tr><td class='name'><a name='AREA_ID'>AREA_ID</a></td>
<td width='40%'> INT UNSIGNED NOT NULL AUTOINCREMENT </td>
<td width='60%'> Store the area id </td>
</tr>
<tr><td class='name'><a name='AREA_NAME'>AREA_NAME</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store the area name </td>
</tr>
<tr><td class='name'><a name='AREA_UPDATE'>AREA_UPDATE</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> store the area updated id </td>
</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
<tr><td class='name'>pk_area primary key</td>
<td> ( AREA_ID) </td><td> </td>
</tr>
<tr><td class='name'>pk_area_0 unique</td>
<td> ( AREA_NAME) </td><td> </td>
</tr>
</tbody>
</table>
<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='customer'>Table customer</a> <br/> </th></tr>
</thead>
<tbody>
<tr><td class='name'><a name='CUSTOMER_CODE'>CUSTOMER_CODE</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store the customer code </td>
</tr>
<tr><td class='name'><a name='CUSTOMER_NAME'>CUSTOMER_NAME</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store the customer name </td>
</tr>
<tr><td class='name'><a name='CUSTOMER_ADDRESS'>CUSTOMER_ADDRESS</a></td>
<td width='40%'> VARCHAR( 400 ) </td>
<td width='60%'> store the customer address </td>
</tr>
<tr><td class='name'><a name='CUSTOMER_AREA'>CUSTOMER_AREA</a></td>
<td width='40%'> VARCHAR( 100 ) </td>
<td width='60%'> store the area name </td>
</tr>
<tr><td class='name'><a name='CUSTOMER_SURROUND_AREA'>CUSTOMER_SURROUND_AREA</a></td>
<td width='40%'> VARCHAR( 100 ) </td>
<td width='60%'> customer area name </td>
</tr>
<tr><td class='name'><a name='CUSTOMER_CITY'>CUSTOMER_CITY</a></td>
<td width='40%'> VARCHAR( 100 ) </td>
<td width='60%'> customer city </td>
</tr>
<tr><td class='name'><a name='CUSTOMER_PINCODE'>CUSTOMER_PINCODE</a></td>
<td width='40%'> VARCHAR( 100 ) </td>
<td width='60%'> customer pincode </td>
</tr>
<tr><td class='name'><a name='CUSTOMER_PHONE'>CUSTOMER_PHONE</a></td>
<td width='40%'> VARCHAR( 100 ) </td>
<td width='60%'> customer phone </td>
</tr>
<tr><td class='name'><a name='CUSTOMER_MOBILE'>CUSTOMER_MOBILE</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> customer mobile </td>
</tr>
<tr><td class='name'><a name='CUSTOMER_CONTACT_PERSON'>CUSTOMER_CONTACT_PERSON</a></td>
<td width='40%'> VARCHAR( 100 ) </td>
<td width='60%'> contact person name </td>
</tr>
<tr><td class='name'><a name='CUSTOMER_UPDATE'>CUSTOMER_UPDATE</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> data added user name </td>
</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
<tr><td class='name'>pk_customer primary key</td>
<td> ( CUSTOMER_CODE) </td><td> </td>
</tr>
</tbody>
</table>
<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='service_mode'>Table service_mode</a> <br/> </th></tr>
</thead>
<tbody>
<tr><td class='name'><a name='SERVICE_MODE_ID'>SERVICE_MODE_ID</a></td>
<td width='40%'> INT UNSIGNED NOT NULL AUTOINCREMENT </td>
<td width='60%'> store the mode id </td>
</tr>
<tr><td class='name'><a name='SERVICE_MODE_NAME'>SERVICE_MODE_NAME</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store the mode name </td>
</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
<tr><td class='name'>pk_service_mode primary key</td>
<td> ( SERVICE_MODE_ID) </td><td> </td>
</tr>
</tbody>
</table>
<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='model'>Table model</a> <br/> </th></tr>
</thead>
<tbody>
<tr><td class='name'><a name='MODEL_ID'>MODEL_ID</a></td>
<td width='40%'> INT UNSIGNED NOT NULL AUTOINCREMENT </td>
<td width='60%'> store the model id </td>
</tr>
<tr><td class='name'><a name='MODEL_CODE'>MODEL_CODE</a></td>
<td width='40%'> VARCHAR( 100 ) </td>
<td width='60%'> store the model code </td>
</tr>
<tr><td class='name'><a name='MODEL_NAME'>MODEL_NAME</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store the model name </td>
</tr>
<tr><td class='name'><a name='MAKE_ID'>MAKE_ID</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> store the make id </td>
</tr>
<tr><td class='name'><a name='LIST_INDEX'>LIST_INDEX</a></td>
<td width='40%'> INT UNSIGNED </td>
<td width='60%'> store list index </td>
</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
<tr><td class='name'>pk_model primary key</td>
<td> ( MODEL_ID) </td><td> </td>
</tr>
<tr><td class='name'>FK_MAKE_ID </td>
<td> ( MAKE_ID) </td><td> </td>
</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
<tr>
<td class='name'>FK_MAKE_ID</td><td > ( MAKE_ID ) ref <a href='#make'>make</a> ( MAKE_ID ) </td>
<td> </td>
</tr>
</tbody>
</table>
<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='make'>Table make</a> <br/> </th></tr>
</thead>
<tbody>
<tr><td class='name'><a name='MAKE_ID'>MAKE_ID</a></td>
<td width='40%'> INT UNSIGNED NOT NULL AUTOINCREMENT </td>
<td width='60%'> store make id </td>
</tr>
<tr><td class='name'><a name='MAKE_CODE'>MAKE_CODE</a></td>
<td width='40%'> VARCHAR( 10 ) </td>
<td width='60%'> store make code </td>
</tr>
<tr><td class='name'><a name='MAKE_NAME'>MAKE_NAME</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> make name </td>
</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
<tr><td class='name'>pk_make primary key</td>
<td> ( MAKE_ID) </td><td> </td>
</tr>
</tbody>
</table>
<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='employee'>Table employee</a> <br/> </th></tr>
</thead>
<tbody>
<tr><td class='name'><a name='EMP_ID'>EMP_ID</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> store the employee id </td>
</tr>
<tr><td class='name'><a name='EMP_CODE'>EMP_CODE</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store the employee code </td>
</tr>
<tr><td class='name'><a name='EMP_NAME'>EMP_NAME</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store employee name </td>
</tr>
<tr><td class='name'><a name='EMP_MOBILE'>EMP_MOBILE</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store the mobile number </td>
</tr>
<tr><td class='name'><a name='EMP_DOJ'>EMP_DOJ</a></td>
<td width='40%'> DATE NOT NULL </td>
<td width='60%'> store the doj </td>
</tr>
<tr><td class='name'><a name='EMP_UPDATE'>EMP_UPDATE</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> store the updated date and time </td>
</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
<tr><td class='name'>pk_employee primary key</td>
<td> ( EMP_ID) </td><td> </td>
</tr>
<tr><td class='name'>pk_employee_0 unique</td>
<td> ( EMP_UPDATE) </td><td> </td>
</tr>
</tbody>
</table>
<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='sss_login'>Table sss_login</a> <br/> </th></tr>
</thead>
<tbody>
<tr><td class='name'><a name='LOGIN_ID'>LOGIN_ID</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> store the login id </td>
</tr>
<tr><td class='name'><a name='LOGIN_USERNAME'>LOGIN_USERNAME</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store the username </td>
</tr>
<tr><td class='name'><a name='LOGIN_PASSWORD'>LOGIN_PASSWORD</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store the login password </td>
</tr>
<tr><td class='name'><a name='LOGIN_UPDATE'>LOGIN_UPDATE</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> store the login update date </td>
</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
<tr><td class='name'>pk_sss_login primary key</td>
<td> ( LOGIN_ID) </td><td> </td>
</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
<tr>
<td class='name'>fk_sss_login_employee</td><td > ( LOGIN_ID ) ref <a href='#employee'>employee</a> ( EMP_UPDATE ) </td>
<td> </td>
</tr>
</tbody>
</table>
<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='service'>Table service</a> <br/> </th></tr>
</thead>
<tbody>
<tr><td class='name'><a name='SALES_ID'>SALES_ID</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> store the sales id </td>
</tr>
<tr><td class='name'><a name='SERIALNO'>SERIALNO</a></td>
<td width='40%'> VARCHAR( 100 ) </td>
<td width='60%'> serial number </td>
</tr>
<tr><td class='name'><a name='EMPLOYEE_ID'>EMPLOYEE_ID</a></td>
<td width='40%'> INT UNSIGNED </td>
<td width='60%'> employee id </td>
</tr>
<tr><td class='name'><a name='SLIPNO'>SLIPNO</a></td>
<td width='40%'> VARCHAR( 50 ) </td>
<td width='60%'> slip number </td>
</tr>
<tr><td class='name'><a name='COMMENTS'>COMMENTS</a></td>
<td width='40%'> VARCHAR( 200 ) </td>
<td width='60%'> comments </td>
</tr>
<tr><td class='name'><a name='DATE'>DATE</a></td>
<td width='40%'> DATE </td>
<td width='60%'> store the date </td>
</tr>
<tr><td class='name'><a name='MONTH'>MONTH</a></td>
<td width='40%'> VARCHAR( 100 ) </td>
<td width='60%'> service month </td>
</tr>
<tr><td class='name'><a name='YEAR'>YEAR</a></td>
<td width='40%'> VARCHAR( 100 ) </td>
<td width='60%'> service year </td>
</tr>
<tr><td class='name'><a name='LIST_INDEX'>LIST_INDEX</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> service list index </td>
</tr>
<tr><td class='name'><a name='COMPLETED'>COMPLETED</a></td>
<td width='40%'> CHAR( 1 ) NOT NULL </td>
<td width='60%'> store completed status </td>
</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
<tr><td class='name'>pk_service unique</td>
<td> ( SALES_ID) </td><td> </td>
</tr>
</tbody>
</table>
<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='sales'>Table sales</a> <br/> </th></tr>
</thead>
<tbody>
<tr><td class='name'><a name='SALES_ID'>SALES_ID</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> store the sales id </td>
</tr>
<tr><td class='name'><a name='CUSTOMER_CODE'>CUSTOMER_CODE</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store the customer code </td>
</tr>
<tr><td class='name'><a name='MODEL_ID'>MODEL_ID</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> store the model id </td>
</tr>
<tr><td class='name'><a name='SERVICEMODE_ID'>SERVICEMODE_ID</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> store the service mode id </td>
</tr>
<tr><td class='name'><a name='LOCATION'>LOCATION</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store the location </td>
</tr>
<tr><td class='name'><a name='COMPRESSORNO'>COMPRESSORNO</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store the compressor number </td>
</tr>
<tr><td class='name'><a name='INSTALLATION_DATE'>INSTALLATION_DATE</a></td>
<td width='40%'> DATE NOT NULL </td>
<td width='60%'> store the installation date </td>
</tr>
<tr><td class='name'><a name='MATURITY_DATE'>MATURITY_DATE</a></td>
<td width='40%'> DATE NOT NULL </td>
<td width='60%'> store maturity date </td>
</tr>
<tr><td class='name'><a name='INVOICE_DATE'>INVOICE_DATE</a></td>
<td width='40%'> DATE NOT NULL </td>
<td width='60%'> store invoice date </td>
</tr>
<tr><td class='name'><a name='AMOUNT'>AMOUNT</a></td>
<td width='40%'> DOUBLE NOT NULL </td>
<td width='60%'> store amount </td>
</tr>
<tr><td class='name'><a name='REMARKS'>REMARKS</a></td>
<td width='40%'> VARCHAR( 200 ) NOT NULL </td>
<td width='60%'> store remarks </td>
</tr>
<tr><td class='name'><a name='INVOICE_NO'>INVOICE_NO</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store invoice number </td>
</tr>
<tr><td class='name'><a name='NO_OF_SERVICES'>NO_OF_SERVICES</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> store the number of services </td>
</tr>
<tr><td class='name'><a name='CAPACITY'>CAPACITY</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store the capacity </td>
</tr>
<tr><td class='name'><a name='WARRENTY'>WARRENTY</a></td>
<td width='40%'> VARCHAR( 100 ) NOT NULL </td>
<td width='60%'> store the warrenty </td>
</tr>
<tr><td class='name'><a name='MAKE_ID'>MAKE_ID</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> store the make id </td>
</tr>
<tr><td class='name'><a name='PURCHASE_ID'>PURCHASE_ID</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> store the purchase id </td>
</tr>
<tr><td class='name'><a name='COMPLETED'>COMPLETED</a></td>
<td width='40%'> BIT </td>
<td width='60%'> status </td>
</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
<tr><td class='name'>pk_sales primary key</td>
<td> ( SALES_ID) </td><td> </td>
</tr>
<tr><td class='name'>idx_sales </td>
<td> ( SERVICEMODE_ID) </td><td> </td>
</tr>
<tr><td class='name'>idx_sales_0 </td>
<td> ( MODEL_ID) </td><td> </td>
</tr>
<tr><td class='name'>idx_sales_1 </td>
<td> ( CUSTOMER_CODE) </td><td> </td>
</tr>
<tr><td class='name'>idx_sales_2 </td>
<td> ( LOCATION) </td><td> </td>
</tr>
<tr><td class='name'>idx_sales_3 </td>
<td> ( INVOICE_NO) </td><td> </td>
</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
<tr>
<td class='name'>fk_sales_service_mode</td><td > ( SERVICEMODE_ID ) ref <a href='#service_mode'>service_mode</a> ( SERVICE_MODE_ID ) </td>
<td> </td>
</tr>
<tr>
<td class='name'>fk_sales_model</td><td > ( MODEL_ID ) ref <a href='#model'>model</a> ( MODEL_ID ) </td>
<td> </td>
</tr>
<tr>
<td class='name'>fk_sales_customer</td><td > ( CUSTOMER_CODE ) ref <a href='#customer'>customer</a> ( CUSTOMER_CODE ) </td>
<td> </td>
</tr>
<tr>
<td class='name'>fk_sales_service</td><td > ( SALES_ID ) ref <a href='#service'>service</a> ( SALES_ID ) </td>
<td> </td>
</tr>
<tr>
<td class='name'>fk_sales_area</td><td > ( LOCATION ) ref <a href='#area'>area</a> ( AREA_NAME ) </td>
<td> </td>
</tr>
<tr>
<td class='name'>fk_sales_purchase</td><td > ( INVOICE_NO ) ref <a href='#purchase'>purchase</a> ( PURCHASE_INVOICENUMBER ) </td>
<td> </td>
</tr>
</tbody>
</table>
<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='purchase'>Table purchase</a> <br/> </th></tr>
</thead>
<tbody>
<tr><td class='name'><a name='PURCHASE_ID'>PURCHASE_ID</a></td>
<td width='40%'> INT UNSIGNED NOT NULL AUTOINCREMENT </td>
<td width='60%'> store the purchase id </td>
</tr>
<tr><td class='name'><a name='PURCHASE_INVOICENUMBER'>PURCHASE_INVOICENUMBER</a></td>
<td width='40%'> VARCHAR( 60 ) NOT NULL </td>
<td width='60%'> store the purchase invoice </td>
</tr>
<tr><td class='name'><a name='PURCHASE_DATE'>PURCHASE_DATE</a></td>
<td width='40%'> VARCHAR( 60 ) NOT NULL </td>
<td width='60%'> store purchase date </td>
</tr>
<tr><td class='name'><a name='PURCHASE_SERIALNUMBER'>PURCHASE_SERIALNUMBER</a></td>
<td width='40%'> VARCHAR( 60 ) NOT NULL </td>
<td width='60%'> store the purchase serial number </td>
</tr>
<tr><td class='name'><a name='PURCHASE_MODEL_ID'>PURCHASE_MODEL_ID</a></td>
<td width='40%'> INT UNSIGNED NOT NULL </td>
<td width='60%'> store the purchase model numer </td>
</tr>
<tr><td class='name'><a name='PURCHASE_DISPLAY'>PURCHASE_DISPLAY</a></td>
<td width='40%'> INT UNSIGNED DEFO 0 </td>
<td width='60%'> purchase display status </td>
</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
<tr><td class='name'>pk_purchase primary key</td>
<td> ( PURCHASE_ID) </td><td> </td>
</tr>
<tr><td class='name'>pk_purchase_0 unique</td>
<td> ( PURCHASE_INVOICENUMBER) </td><td> </td>
</tr>
</tbody>
</table>
</body></html>