Unnamed

CREATE TABLE ASTH
(ASTH_ID CHAR (5) NOT NULL, ASTH_NAME CHAR (30), DIAG_ID CHAR (5) NOT NULL, ISTORIKO CHAR (30), AR_EISAG NUMERIC, KLIN_ID CHAR (5) NOT NULL, DATE_COME DATETIME, DATE_EXIT DATETIME, COST NUMERIC);



INSERT INTO ASTH VALUE ('40001', 'NIKOLAOY', '50001', '', 5, '10001', 10-5-07, 15-5-07, 400);
INSERT INTO ASTH VALUE ('40002', 'IOANNOY', '50005', '', 5, '10003', 20-8-07, 5-9-07, 300);
INSERT INTO ASTH VALUE ('40003', 'BASILIOY', '50004', '', 5, '10005', 10-6-07, 11-6-07, 50);
INSERT INTO ASTH VALUE ('40004', 'PAPAKOSTAS', '50003', '', 5, '10001', 15-9-07, 15-9-07, 400);
INSERT INTO ASTH VALUE ('40005', 'ZHSHS', '50002', '', 5, '10002', 22-12-07, 23-12-07, 400);
INSERT INTO ASTH VALUE ('40006', 'KARAKOSTAS', '50004', '', 5, '10005', 10-2-07, 10-2-07, 400);
INSERT INTO ASTH VALUE ('40007', 'PAPAIOANNOY', '50001', '', 5, '10006', 15-4-07, 10-5-07, 400);
INSERT INTO ASTH VALUE ('40008', 'XATZHS', '50006', '', 5, '10004', 5-5-07, 9-5-07, 400);
INSERT INTO ASTH VALUE ('40009', 'ANASTASIADHS', '50005', '', 5, '10006', 8-12-07, 9-12-07, 400);
INSERT INTO ASTH VALUE ('40010', 'PAPADATHS', '50004', '', 5, '10005', 10-1-07, 14-1-07, 400);
INSERT INTO ASTH VALUE ('40011', 'NTALLAS', '50003', '', 5, '10001', 22-2-07, 4-3-07, 400);
INSERT INTO ASTH VALUE ('40012', 'ROYPAS', '50006', '', 5, '10002', 9-8-07, 10-8-07, 400);
INSERT INTO ASTH VALUE ('40013', 'GALATOS', '50005', '', 5, '10002', 8-9-07, 8-9-07, 400);
INSERT INTO ASTH VALUE ('40014', 'PORTOKALOGLOY', '50002', '', 5, '10006', 13-7-07, 15-7-07, 400);
INSERT INTO ASTH VALUE ('40015', 'MPOYGAS', '50003', '', 5, '10001', 20-8-07, 22-8-07, 400);
INSERT INTO ASTH VALUE ('40015', 'MANTAS', '50001', '', 5, '10002', 7-9-07, 10-9-07, 400);
INSERT INTO ASTH VALUE ('40015', 'TSALIKIS', '50004', '', 5, '10003', 6-4-07, 10-4-07, 400);
INSERT INTO ASTH VALUE ('40015', 'ROYBAS', '50001', '', 5, '10002', 7-9-07, 10-9-07, 400);
INSERT INTO ASTH VALUE ('40015', 'BANDH', '50003', '', 5, '10004', 15-3-07, 10-6-07, 400);