CREATE TABLE VISIT(
VISNUM NUMBER (5)CONSTRAINT VISIT_PK PRIMARY KEY,
PERSNUM NUMBER (5) REFERENCES SEQ_PER (PERSNUM),
VISTIME VARCHAR2 (5),
VISITTYPE VARCHAR2 (25),
VISDATE DATE);