import 테스트
테이블 (12)
DEPARTMENT
- DEP_CODE — VARCHAR2(4)
- DEP_NAME — VARCHAR2(100) — NOT NULL
DOCTOR
- DOC_CODE — NUMBER
- DOC_NAME — VARCHAR2(50) — NOT NULL
- DEP_CODE — VARCHAR2(4) — 외래 키 → DEPARTMENT.DEP_CODE — NOT NULL
INPATIENT
- INP_CODE — NUMBER
- PAT_CODE — NUMBER — 외래 키 → PATIENT.PAT_CODE — NOT NULL
- INP_YEAR — VARCHAR2(4) — NOT NULL
- INP_DATE — VARCHAR2(4) — NOT NULL
- INP_TIME — VARCHAR2(4) — NOT NULL
PATIENT
- PAT_CODE — NUMBER
- PAT_NAME — VARCHAR2(50) — NOT NULL
- PAT_BIRTH — NUMBER(8) — NOT NULL
- PAT_GENDER — VARCHAR2(1) — NOT NULL
- PAT_TEL — VARCHAR2(11)
- PAT_POSTCODE — VARCHAR2(5)
- PAT_ADDR1 — VARCHAR2(300)
- PAT_ADDR2 — VARCHAR2(200)
TREAT
- TRT_CODE — NUMBER
- PAT_CODE — NUMBER — 외래 키 → PATIENT.PAT_CODE — NOT NULL
- TRT_YEAR — VARCHAR2(4) — NOT NULL
- TRT_DATE — VARCHAR2(4) — NOT NULL
- TRT_TIME — VARCHAR2(4) — NOT NULL
- TRT_RECEIPT — VARCHAR2(4) — NOT NULL
- DOC_CODE — NUMBER — 외래 키 → DOCTOR.DOC_CODE — NOT NULL
board
- boardno — NUMBER — 기본 키 — NOT NULL
- title — VARCHAR2(300)
- content — VARCHAR2(500)
- insert_dat — DATE
- update_dat — DATE
- hit — NUMBER
- cateno — NUMBER — 외래 키 → board_cate.cateno — NOT NULL
- userno — NUMBER — 외래 키 → userTb.userno — NOT NULL
board_cate
- cateno — NUMBER — 기본 키 — NOT NULL
- cate_name — VARCHAR2(100) — NOT NULL
- cate_dat — DATE — NOT NULL
commenttb
- commentno — NUMBER — 기본 키 — NOT NULL
- content — VARCHAR2(500)
- insert_dat — DATE
- boardno — NUMBER — 외래 키 → board.boardno — NOT NULL
- userno — NUMBER — 외래 키 → userTb.userno — NOT NULL
filetb
- fileno — NUMBER — 기본 키 — NOT NULL
- filename — VARCHAR2(100)
- filepath — VARCHAR2(100)
- filesize — NUMBER
- filetype — VARCHAR2(100)
- boardno — NUMBER — 외래 키 → board.boardno — NOT NULL
grade
- grade — NUMBER — 기본 키 — NOT NULL
- gradename — VARCHAR2(100)
report
- report — NUMBER — 기본 키 — NOT NULL
- report_dat — DATE — NOT NULL
- report_reason — VARCHAR2(500) — NOT NULL
userTb
- userno — NUMBER — 기본 키 — NOT NULL
- userid — VARCHAR2(500) — NOT NULL
- userpw — VARCHAR2(500) — NOT NULL
- gender — VARCHAR2(100)
- email — VARCHAR2(500)
- phone — VARCHAR2(500)
- grade — NUMBER — 외래 키 → grade.grade — NOT NULL
- report — NUMBER — 외래 키 → report.report — NOT NULL