PostgreSQL | DB2 | |
---|---|---|
•\‚Ìì¬ | "CreateSampleTables.sql" | "CreateSampleTables.db2.sql" |
ƒf[ƒ^‚Ì‘}“ü | "InsertSampleData.sql" | "InsertSampleData.db2.sql" |
ƒf[ƒ^”‚̃`ƒFƒbƒN | "CheckSampleData.sql" | "CheckSampleData.db2.sql" |
PK | psales_no | INTEGER | ”„ãNO |
psales_date | DATE | ”„ã“ú•t | |
FK1 | emp_id | INTEGER | ’S“–ŽÒID |
FK2 | cust_id | INTEGER | ŒÚ‹qID |
cust_address | VARCHAR(40) | “Í‚¯æZŠ | |
cust_tel | VARCHAR(20) | “Í‚¯æ“d˜b”Ô† | |
delivery_date | DATE | “Í‚¯—\’è“ú | |
delivery_time | TIME | “Í‚¯—\’莞 | |
total | NUMERIC(9,2) | ”„㇌v‹àŠz | |
carriage | NUMERIC(9,2) | ‘——¿ | |
excise | NUMERIC(9,2) | Á”ïÅŠz |
psales_no | psales_date | emp_id | cust_id | cust_address | cust_tel | delivery_date | delivery_time | total | carriage | excise |
1 | 1994-7-13 | 1 | 1 | ˜a‰ÌŽRŒ§˜a‰ÌŽRŽs | 073-123-XXXX | 1994-7-18 | 10:00 | 60000 | 100 | 3000 |
2 | 1994-7-14 | 1 | 2 | ‘åã•{‘åãŽs | 06-6123-XXXX | 34534 | 10:00 | 60000 | 100 | 1000 |
3 | 1994-7-18 | 2 | 3 | “Œ‹ž“s`‹æÔâ2’š–Ú | 03-3123-XXXX | 34535 | 10:00 | 85000 | 0 | 4250 |
4 | 1994-8-18 | 2 | 4 | “Œ‹ž“s’†‰›‹æ‹âÀ3’š–Ú | 03-3123-XXXX | 34567 | 10:00 | 120000 | 0 | 3000 |
5 | 1994-8-18 | 3 | 5 | “Œ‹ž“sç‘ã“c‹æ‘åŽè’¬ | 03-3123-XXXX | 34568 | 10:00 | 25000 | 0 | 1250 |
6 | 1994-8-18 | 3 | 6 | “Œ‹ž“s•iì‹æ¼ŒÜ”½“cXXX-XX | 03-3123-XXXX | 34569 | 10:00 | 30000 | 0 | 1500 |
7 | 1994-9-18 | 4 | 7 | “Œ‹ž“s‘ä“Œ‹æ‰º’JX-X-X | 03-3123-XXXX | 34601 | 10:00 | 60000 | 0 | 2000 |
8 | 1994-9-18 | 4 | 8 | ‘åãŽs‘å—„‹æ‘å—„“ì | 06-6123-XXXX | 34602 | 10:00 | 10000 | 100 | 500 |
9 | 1994-9-18 | 5 | 9 | “Œ‹ž“sa’J‹æL”öXX-X | 03-3123-XXXX | 34603 | 10:00 | 45000 | 0 | 2250 |
10 | 1994-9-18 | 5 | 10 | “Œ‹ž“s’†‰›‹æ“ú–{‹´ | 03-3123-XXXX | 34604 | 10:00 | 24000 | 0 | 300 |
111 | 1994-10-13 | 1 | 1 | ˜a‰ÌŽRŒ§˜a‰ÌŽRŽs | 073-123-XXXX | 34625 | 10:00 | 60000 | 100 | 3000 |
112 | 1994-10-14 | 1 | 2 | ‘åã•{‘åãŽs | 06-6123-XXXX | 34626 | 10:00 | 20000 | 100 | 1000 |
113 | 1994-11-18 | 2 | 3 | “Œ‹ž“s`‹æÔâ2’š–Ú | 03-3123-XXXX | 34658 | 10:00 | 85000 | 0 | 4250 |
114 | 1994-11-18 | 2 | 4 | “Œ‹ž“s’†‰›‹æ‹âÀ3’š–Ú | 03-3123-XXXX | 34659 | 10:00 | 60000 | 0 | 3000 |
115 | 1994-12-18 | 3 | 5 | “Œ‹ž“sç‘ã“c‹æ‘åŽè’¬ | 03-3123-XXXX | 34690 | 10:00 | 25000 | 0 | 1250 |
116 | 1994-12-18 | 3 | 6 | “Œ‹ž“s•iì‹æ¼ŒÜ”½“cXXX-XX | 03-3123-XXXX | 34691 | 10:00 | 30000 | 0 | 1500 |
217 | 1995-1-18 | 4 | 7 | “Œ‹ž“s‘ä“Œ‹æ‰º’JX-X-X | 03-3123-XXXX | 34723 | 10:00 | 40000 | 0 | 2000 |
218 | 1995-1-18 | 4 | 8 | ‘åãŽs‘å—„‹æ‘å—„“ì | 06-6123-XXXX | 34724 | 10:00 | 10000 | 100 | 500 |
219 | 1995-4-18 | 5 | 9 | “Œ‹ž“sa’J‹æL”öXX-X | 03-3123-XXXX | 34815 | 10:00 | 60000 | 0 | 2250 |
220 | 1995-4-18 | 5 | 10 | “Œ‹ž“s’†‰›‹æ“ú–{‹´ | 03-3123-XXXX | 34816 | 10:00 | 6000 | 0 | 300 |
221 | 1995-9-13 | 1 | 1 | ˜a‰ÌŽRŒ§˜a‰ÌŽRŽs | 073-123-XXXX | 34960 | 10:00 | 60000 | 100 | 3000 |
222 | 1995-9-14 | 1 | 2 | ‘åã•{‘åãŽs | 06-6123-XXXX | 34961 | 10:00 | 20000 | 100 | 1000 |
223 | 1995-12-18 | 2 | 3 | “Œ‹ž“s`‹æÔâ2’š–Ú | 03-3123-XXXX | 35053 | 10:00 | 85000 | 0 | 4250 |
224 | 1995-12-18 | 2 | 4 | “Œ‹ž“s’†‰›‹æ‹âÀ3’š–Ú | 03-3123-XXXX | 35054 | 10:00 | 120000 | 0 | 3000 |
325 | 1996-3-18 | 3 | 5 | “Œ‹ž“sç‘ã“c‹æ‘åŽè’¬ | 03-3123-XXXX | 35146 | 10:00 | 25000 | 0 | 1250 |
326 | 1996-3-18 | 3 | 6 | “Œ‹ž“s•iì‹æ¼ŒÜ”½“cXXX-XX | 03-3123-XXXX | 35147 | 10:00 | 30000 | 0 | 1500 |
327 | 1996-7-18 | 4 | 7 | “Œ‹ž“s‘ä“Œ‹æ‰º’JX-X-X | 03-3123-XXXX | 35270 | 10:00 | 40000 | 0 | 2000 |
328 | 1996-7-18 | 4 | 8 | ‘åãŽs‘å—„‹æ‘å—„“ì | 06-6123-XXXX | 35271 | 10:00 | 10000 | 100 | 500 |
329 | 1996-10-18 | 5 | 9 | “Œ‹ž“sa’J‹æL”öXX-X | 03-3123-XXXX | 35364 | 10:00 | 45000 | 0 | 2250 |
330 | 1996-10-18 | 5 | 10 | “Œ‹ž“s’†‰›‹æ“ú–{‹´ | 03-3123-XXXX | 35365 | 10:00 | 6000 | 0 | 300 |
431 | 1997-2-13 | 1 | 1 | ˜a‰ÌŽRŒ§˜a‰ÌŽRŽs | 073-123-XXXX | 35479 | 10:00 | 60000 | 100 | 3000 |
432 | 1997-2-14 | 1 | 2 | ‘åã•{‘åãŽs | 06-6123-XXXX | 35480 | 10:00 | 20000 | 100 | 1000 |
433 | 1997-5-18 | 2 | 3 | “Œ‹ž“s`‹æÔâ2’š–Ú | 03-3123-XXXX | 35570 | 10:00 | 115000 | 0 | 4250 |
434 | 1997-5-18 | 2 | 4 | “Œ‹ž“s’†‰›‹æ‹âÀ3’š–Ú | 03-3123-XXXX | 35571 | 10:00 | 60000 | 0 | 3000 |
435 | 1997-8-18 | 3 | 5 | “Œ‹ž“sç‘ã“c‹æ‘åŽè’¬ | 03-3123-XXXX | 35664 | 10:00 | 25000 | 0 | 1250 |
436 | 1997-8-18 | 3 | 6 | “Œ‹ž“s•iì‹æ¼ŒÜ”½“cXXX-XX | 03-3123-XXXX | 35665 | 10:00 | 30000 | 0 | 1500 |
437 | 1997-11-18 | 4 | 7 | “Œ‹ž“s‘ä“Œ‹æ‰º’JX-X-X | 03-3123-XXXX | 35758 | 10:00 | 40000 | 0 | 2000 |
438 | 1997-11-18 | 4 | 8 | ‘åãŽs‘å—„‹æ‘å—„“ì | 06-6123-XXXX | 35759 | 10:00 | 10000 | 100 | 500 |
541 | 1998-3-13 | 1 | 1 | ˜a‰ÌŽRŒ§˜a‰ÌŽRŽs | 073-123-XXXX | 35872 | 10:00 | 120000 | 100 | 3000 |
542 | 1998-3-14 | 1 | 2 | ‘åã•{‘åãŽs | 06-6123-XXXX | 35873 | 10:00 | 20000 | 100 | 1000 |
543 | 1998-7-18 | 2 | 3 | “Œ‹ž“s`‹æÔâ2’š–Ú | 03-3123-XXXX | 35996 | 10:00 | 85000 | 0 | 4250 |
544 | 1998-7-18 | 2 | 4 | “Œ‹ž“s’†‰›‹æ‹âÀ3’š–Ú | 03-3123-XXXX | 35997 | 10:00 | 60000 | 0 | 3000 |
545 | 1998-7-18 | 3 | 5 | “Œ‹ž“sç‘ã“c‹æ‘åŽè’¬ | 03-3123-XXXX | 35998 | 10:00 | 25000 | 0 | 1250 |
547 | 1998-10-18 | 4 | 7 | “Œ‹ž“s‘ä“Œ‹æ‰º’JX-X-X | 03-3123-XXXX | 36092 | 10:00 | 40000 | 0 | 2000 |
548 | 1998-10-18 | 4 | 8 | ‘åãŽs‘å—„‹æ‘å—„“ì | 06-6123-XXXX | 36093 | 10:00 | 10000 | 100 | 500 |
653 | 1999-3-18 | 2 | 3 | “Œ‹ž“s`‹æÔâ2’š–Ú | 03-3123-XXXX | 36239 | 10:00 | 85000 | 0 | 4250 |
654 | 1999-3-18 | 2 | 4 | “Œ‹ž“s’†‰›‹æ‹âÀ3’š–Ú | 03-3123-XXXX | 36240 | 10:00 | 60000 | 0 | 3000 |
655 | 1999-3-18 | 3 | 5 | “Œ‹ž“sç‘ã“c‹æ‘åŽè’¬ | 03-3123-XXXX | 36241 | 10:00 | 75000 | 0 | 1250 |
656 | 1999-6-18 | 3 | 6 | “Œ‹ž“s•iì‹æ¼ŒÜ”½“cXXX-XX | 03-3123-XXXX | 36334 | 10:00 | 30000 | 0 | 1500 |
657 | 1999-6-18 | 4 | 7 | “Œ‹ž“s‘ä“Œ‹æ‰º’JX-X-X | 03-3123-XXXX | 36335 | 10:00 | 40000 | 0 | 2000 |
658 | 1999-9-18 | 4 | 8 | ‘åãŽs‘å—„‹æ‘å—„“ì | 06-6123-XXXX | 36428 | 10:00 | 10000 | 100 | 500 |
659 | 1999-9-18 | 5 | 9 | “Œ‹ž“sa’J‹æL”öXX-X | 03-3123-XXXX | 36429 | 10:00 | 45000 | 0 | 2250 |
660 | 1999-9-18 | 5 | 10 | “Œ‹ž“s’†‰›‹æ“ú–{‹´ | 03-3123-XXXX | 36430 | 10:00 | 6000 | 0 | 300 |
771 | 2000-1-13 | 1 | 1 | ˜a‰ÌŽRŒ§˜a‰ÌŽRŽs | 073-123-XXXX | 36543 | 10:00 | 90000 | 100 | 3000 |
772 | 2000-1-14 | 1 | 2 | ‘åã•{‘åãŽs | 06-6123-XXXX | 36544 | 10:00 | 20000 | 100 | 1000 |
773 | 2000-1-18 | 2 | 3 | “Œ‹ž“s`‹æÔâ2’š–Ú | 03-3123-XXXX | 36545 | 10:00 | 85000 | 0 | 4250 |
774 | 2000-5-18 | 2 | 4 | “Œ‹ž“s’†‰›‹æ‹âÀ3’š–Ú | 03-3123-XXXX | 36667 | 10:00 | 60000 | 0 | 3000 |
775 | 2000-5-18 | 3 | 5 | “Œ‹ž“sç‘ã“c‹æ‘åŽè’¬ | 03-3123-XXXX | 36668 | 10:00 | 25000 | 0 | 1250 |
776 | 2000-7-18 | 3 | 6 | “Œ‹ž“s•iì‹æ¼ŒÜ”½“cXXX-XX | 03-3123-XXXX | 36730 | 10:00 | 30000 | 0 | 1500 |
777 | 2000-7-18 | 4 | 7 | “Œ‹ž“s‘ä“Œ‹æ‰º’JX-X-X | 03-3123-XXXX | 36731 | 10:00 | 40000 | 0 | 2000 |
778 | 2000-9-18 | 4 | 8 | ‘åãŽs‘å—„‹æ‘å—„“ì | 06-6123-XXXX | 36794 | 10:00 | 10000 | 100 | 500 |
779 | 2000-9-18 | 5 | 9 | “Œ‹ž“sa’J‹æL”öXX-X | 03-3123-XXXX | 36795 | 10:00 | 45000 | 0 | 2250 |
780 | 2000-9-18 | 5 | 10 | “Œ‹ž“s’†‰›‹æ“ú–{‹´ | 03-3123-XXXX | 36796 | 10:00 | 30000 | 0 | 300 |
781 | 2000-12-13 | 1 | 1 | ˜a‰ÌŽRŒ§˜a‰ÌŽRŽs | 073-123-XXXX | 36878 | 10:00 | 60000 | 100 | 3000 |
782 | 2000-12-14 | 1 | 2 | ‘åã•{‘åãŽs | 06-6123-XXXX | 36879 | 10:00 | 20000 | 100 | 1000 |
883 | 2001-1-18 | 2 | 3 | “Œ‹ž“s`‹æÔâ2’š–Ú | 03-3123-XXXX | 36911 | 10:00 | 85000 | 0 | 4250 |
884 | 2001-1-18 | 2 | 4 | “Œ‹ž“s’†‰›‹æ‹âÀ3’š–Ú | 03-3123-XXXX | 36912 | 10:00 | 60000 | 0 | 3000 |
885 | 2001-3-18 | 3 | 5 | “Œ‹ž“sç‘ã“c‹æ‘åŽè’¬ | 03-3123-XXXX | 36972 | 10:00 | 50000 | 0 | 1250 |
886 | 2001-3-18 | 3 | 6 | “Œ‹ž“s•iì‹æ¼ŒÜ”½“cXXX-XX | 03-3123-XXXX | 36973 | 10:00 | 30000 | 0 | 1500 |
887 | 2001-5-18 | 4 | 7 | “Œ‹ž“s‘ä“Œ‹æ‰º’JX-X-X | 03-3123-XXXX | 37035 | 10:00 | 40000 | 0 | 2000 |
888 | 2001-5-18 | 4 | 8 | ‘åãŽs‘å—„‹æ‘å—„“ì | 06-6123-XXXX | 37036 | 10:00 | 10000 | 100 | 500 |
889 | 2001-5-18 | 5 | 9 | “Œ‹ž“sa’J‹æL”öXX-X | 03-3123-XXXX | 37037 | 10:00 | 45000 | 0 | 2250 |
890 | 2001-5-18 | 5 | 10 | “Œ‹ž“s’†‰›‹æ“ú–{‹´ | 03-3123-XXXX | 37038 | 10:00 | 6000 | 0 | 300 |
1001 | 2001-7-13 | 1 | 1 | ˜a‰ÌŽRŒ§˜a‰ÌŽRŽs | 073-123-XXXX | 37090 | 10:00 | 90000 | 100 | 3000 |
1002 | 2001-7-14 | 1 | 2 | ‘åã•{‘åãŽs | 06-6123-XXXX | 37091 | 10:00 | 20000 | 100 | 1000 |
1003 | 2001-7-18 | 2 | 3 | “Œ‹ž“s`‹æÔâ2’š–Ú | 03-3123-XXXX | 37092 | 10:00 | 85000 | 0 | 4250 |
1004 | 2001-7-18 | 2 | 4 | “Œ‹ž“s’†‰›‹æ‹âÀ3’š–Ú | 03-3123-XXXX | 37093 | 10:00 | 180000 | 0 | 3000 |
1005 | 2001-7-18 | 3 | 5 | “Œ‹ž“sç‘ã“c‹æ‘åŽè’¬ | 03-3123-XXXX | 37094 | 10:00 | 25000 | 0 | 1250 |
1006 | 2001-7-18 | 3 | 6 | “Œ‹ž“s•iì‹æ¼ŒÜ”½“cXXX-XX | 03-3123-XXXX | 37095 | 10:00 | 30000 | 0 | 1500 |
1007 | 2001-7-18 | 4 | 7 | “Œ‹ž“s‘ä“Œ‹æ‰º’JX-X-X | 03-3123-XXXX | 37096 | 10:00 | 40000 | 0 | 2000 |
1008 | 2001-7-18 | 4 | 8 | ‘åãŽs‘å—„‹æ‘å—„“ì | 06-6123-XXXX | 37097 | 10:00 | 10000 | 100 | 500 |
1009 | 2001-7-18 | 5 | 9 | “Œ‹ž“sa’J‹æL”öXX-X | 03-3123-XXXX | 37098 | 10:00 | 45000 | 0 | 2250 |
1010 | 2001-7-18 | 5 | 10 | “Œ‹ž“s’†‰›‹æ“ú–{‹´ | 03-3123-XXXX | 37099 | 10:00 | 6000 | 0 | 300 |
PK | sales_no | INTEGER | ”„ã–¾×NO |
PK,FK1 | psales_no | INTEGER | ”„ãNO |
FK2 | prod_id | INTEGER | ¤•iID |
quantity | NUMERIC(9,2) | ”—Ê | |
price | NUMERIC(9,2) | ”„‰¿ |
sales_no | psales_no | prod_id | quantity | price |
1 | 1 | 101 | 1 | 30000 |
2 | 1 | 103 | 1 | 30000 |
1 | 2 | 102 | 3 | 20000 |
1 | 3 | 103 | 1 | 30000 |
2 | 3 | 105 | 1 | 25000 |
3 | 3 | 106 | 1 | 30000 |
1 | 4 | 104 | 2 | 60000 |
1 | 5 | 105 | 1 | 25000 |
1 | 6 | 106 | 1 | 30000 |
1 | 7 | 102 | 1 | 20000 |
2 | 7 | 106 | 2 | 20000 |
1 | 8 | 108 | 1 | 10000 |
1 | 9 | 106 | 1 | 30000 |
2 | 9 | 109 | 1 | 15000 |
1 | 10 | 110 | 4 | 6000 |
1 | 111 | 101 | 1 | 30000 |
2 | 111 | 103 | 1 | 30000 |
1 | 112 | 102 | 1 | 20000 |
1 | 113 | 103 | 1 | 30000 |
2 | 113 | 105 | 1 | 25000 |
3 | 113 | 106 | 1 | 30000 |
1 | 114 | 104 | 1 | 60000 |
1 | 115 | 105 | 1 | 25000 |
1 | 116 | 106 | 1 | 30000 |
1 | 217 | 102 | 1 | 20000 |
2 | 217 | 106 | 1 | 20000 |
1 | 218 | 108 | 1 | 10000 |
1 | 219 | 106 | 1 | 30000 |
2 | 219 | 109 | 2 | 15000 |
1 | 220 | 110 | 1 | 6000 |
1 | 221 | 101 | 1 | 30000 |
2 | 221 | 103 | 1 | 30000 |
1 | 222 | 102 | 1 | 20000 |
1 | 223 | 103 | 1 | 30000 |
2 | 223 | 105 | 1 | 25000 |
3 | 223 | 106 | 1 | 30000 |
1 | 224 | 104 | 2 | 60000 |
1 | 325 | 105 | 1 | 25000 |
1 | 326 | 106 | 1 | 30000 |
1 | 327 | 102 | 1 | 20000 |
2 | 327 | 106 | 1 | 20000 |
1 | 328 | 108 | 1 | 10000 |
1 | 329 | 106 | 1 | 30000 |
2 | 329 | 109 | 1 | 15000 |
1 | 330 | 110 | 1 | 6000 |
1 | 431 | 101 | 1 | 30000 |
2 | 431 | 103 | 1 | 30000 |
1 | 432 | 102 | 1 | 20000 |
1 | 433 | 103 | 1 | 30000 |
2 | 433 | 105 | 1 | 25000 |
3 | 433 | 106 | 2 | 30000 |
1 | 434 | 104 | 1 | 60000 |
1 | 435 | 105 | 1 | 25000 |
1 | 436 | 106 | 1 | 30000 |
1 | 437 | 102 | 1 | 20000 |
2 | 437 | 106 | 1 | 20000 |
1 | 438 | 108 | 1 | 10000 |
1 | 541 | 101 | 1 | 30000 |
2 | 541 | 103 | 3 | 30000 |
1 | 542 | 102 | 1 | 20000 |
1 | 543 | 103 | 1 | 30000 |
2 | 543 | 105 | 1 | 25000 |
3 | 543 | 106 | 1 | 30000 |
1 | 544 | 104 | 1 | 60000 |
1 | 545 | 105 | 1 | 25000 |
1 | 547 | 102 | 1 | 20000 |
2 | 547 | 106 | 1 | 20000 |
1 | 548 | 108 | 1 | 10000 |
1 | 653 | 103 | 1 | 30000 |
2 | 653 | 105 | 1 | 25000 |
3 | 653 | 106 | 1 | 30000 |
1 | 654 | 104 | 1 | 60000 |
1 | 655 | 105 | 3 | 25000 |
1 | 656 | 106 | 1 | 30000 |
1 | 657 | 102 | 1 | 20000 |
2 | 657 | 106 | 1 | 20000 |
1 | 658 | 108 | 1 | 10000 |
1 | 659 | 106 | 1 | 30000 |
2 | 659 | 109 | 1 | 15000 |
1 | 660 | 110 | 1 | 6000 |
1 | 771 | 101 | 2 | 30000 |
2 | 771 | 103 | 1 | 30000 |
1 | 772 | 102 | 1 | 20000 |
1 | 773 | 103 | 1 | 30000 |
2 | 773 | 105 | 1 | 25000 |
3 | 773 | 106 | 1 | 30000 |
1 | 774 | 104 | 1 | 60000 |
1 | 775 | 105 | 1 | 25000 |
1 | 776 | 106 | 1 | 30000 |
1 | 777 | 102 | 1 | 20000 |
2 | 777 | 106 | 1 | 20000 |
1 | 778 | 108 | 1 | 10000 |
1 | 779 | 106 | 1 | 30000 |
2 | 779 | 109 | 1 | 15000 |
1 | 780 | 110 | 5 | 6000 |
1 | 781 | 101 | 1 | 30000 |
2 | 781 | 103 | 1 | 30000 |
1 | 782 | 102 | 1 | 20000 |
1 | 883 | 103 | 1 | 30000 |
2 | 883 | 105 | 1 | 25000 |
3 | 883 | 106 | 1 | 30000 |
1 | 884 | 104 | 1 | 60000 |
1 | 885 | 105 | 2 | 25000 |
1 | 886 | 106 | 1 | 30000 |
1 | 887 | 102 | 1 | 20000 |
2 | 887 | 106 | 1 | 20000 |
1 | 888 | 108 | 1 | 10000 |
1 | 889 | 106 | 1 | 30000 |
2 | 889 | 109 | 1 | 15000 |
1 | 890 | 110 | 1 | 6000 |
1 | 1001 | 101 | 2 | 30000 |
2 | 1001 | 103 | 1 | 30000 |
1 | 1002 | 102 | 1 | 20000 |
1 | 1003 | 103 | 1 | 30000 |
2 | 1003 | 105 | 1 | 25000 |
3 | 1003 | 106 | 1 | 30000 |
1 | 1004 | 104 | 3 | 60000 |
1 | 1005 | 105 | 1 | 25000 |
1 | 1006 | 106 | 1 | 30000 |
1 | 1007 | 102 | 1 | 20000 |
2 | 1007 | 106 | 1 | 20000 |
1 | 1008 | 108 | 1 | 10000 |
1 | 1009 | 106 | 1 | 30000 |
2 | 1009 | 109 | 1 | 15000 |
1 | 1010 | 110 | 1 | 6000 |
PK | cust_id | INTEGER | ŒÚ‹qID |
cust_name | VARCHAR(20) | ŒÚ‹q–¼ | |
address | VARCHAR(40) | ZŠ | |
tel | VARCHAR(20) | “d˜b”Ô† | |
fax | VARCHAR(20) | FAX”Ô† |
cust_id | cust_name | address | tel | fax |
1 | ãã “O | ˜a‰ÌŽRŒ§˜a‰ÌŽRŽs | 073-123-XXXX | 073-123-XXXX |
2 | ¼â G | “Œ‹ž“sç‘ã“c‹æ | 03-3158-XXXX | 03-3258-XXXX |
3 | –k“‡ _“ñ | ‘åã•{‘åãŽs–k‹æ | 06-1234-XXXX | 06-1234-XXXX |
4 | ‰iˆä Œõ•v | “Œ‹ž“sa’J‹æ | 03-3124-XXXX | 03-0124-XXXX |
5 | ŠÖª Cˆê | ‘åã•{ò²–ìŽs | 0724-99-XXXX | 0724-99-XXXX |
6 | –Ø“c ’¼”ü | “Œ‹ž“s’†‰›‹æ | 03-3333-XXXX | NULL |
7 | •Ð‹Ë ¸ | “Œ‹ž“sVh‹æ | 03-1111-XXXX | 03-1111-XXXX |
8 | “c’† ³•q | “Œ‹ž“s•iì‹æ | 03-2222-XXXX | 03-2222-XXXX |
9 | ¼Œû ˜a•v | “Œ‹ž“s–Ú•‹æ‰º–Ú• | 03-3333-XXXX | 03-3333-XXXX |
10 | ŽRŒû Ž–¤ | “Œ‹ž“s‘å“c‹æ | 03-4444-XXXX | 03-4444-XXXX |
11 | ‰Á“¡ º•v | _“Þ쌧ìèŽs | 044-505-XXXX | 044-505-XXXX |
12 | ΋´ Œ’‘¾˜Y | ŽD–yŽs’†‰›‹æ | 011-555-XXXX | NULL |
13 | •Ä“c Œb”üŽq | “Œ‹ž“s`‹æŒÕƒm–å | 03-3987-XXXX | 03-3987-XXXX |
14 | ¼“c ƒˆê | “Œ‹ž“sç‘ã“c‹æ‘åŽè’¬ | 03-3975-XXXX | 03-3975-XXXX |
15 | ¼‰º °•F | “Œ‹ž“s”‹´‹æ | 03-3123-XXXX | 03-3123-XXXX |
16 | ˆÀˆä ˜a‹` | ˆ¤’mŒ§“ŒŠCŽs | 0560-448-XXXX | 0560-448-XXXX |
17 | ‚‘ò ç‰Ä | ‘åã•{‘åãŽs‘å—„‹æ | 06-6777-XXXX | 06-6777-XXXX |
18 | “‡“c —ÇŽq | “Œ‹ž“sa’J‹æ | 03-3698-XXXX | NULL |
19 | ‹g“c ³–ç | _“Þ쌧ìèŽs | 044-888-XXXX | 044-888-XXXX |
20 | “¡“c Š²•v | “Œ‹ž“s’†‰›‹æ | 03-3578-XXXX | NULL |
PK | prod_id | INTEGER | ¤•iID |
prod_name | VARCHAR(20) | ¤•i–¼ | |
model_no | VARCHAR(20) | Œ^”Ô | |
cost | NUMERIC(9,2) | •W€’P‰¿ | |
discount | NUMERIC(9,2) | ŒÀŠEŠ„ˆø—¦ |
prod_id | prod_name | model_no | cost | discount |
101 | ƒeƒŒƒr | A1111 | 25000 | 0.7 |
102 | ƒrƒfƒI | B2222 | 12000 | 0.8 |
103 | MDƒvƒŒ[ƒ„[ | C3333 | 23500 | 0.8 |
104 | ƒXƒeƒŒƒI | D4444 | 56000 | 0.7 |
105 | ƒfƒWƒ^ƒ‹ƒJƒƒ‰ | E5555 | 18600 | 0.8 |
106 | ƒvƒŠƒ“ƒ^ | F6666 | 23500 | 0.8 |
107 | “d‹CƒVƒF[ƒo[ | G7777 | 13800 | NULL |
108 | ƒzƒC[ƒ‹ƒ}ƒEƒX | H8888 | 8500 | NULL |
109 | ƒAƒCƒƒ“ | I9999 | 10000 | 0.8 |
110 | ƒŠƒ‚ƒRƒ“ | J0000 | 5800 | NULL |