test__P
Tables (18)
Admin
- ADMIN_ID — VARCHAR2(20) — Primary key — NOT NULL
- ADMIN_LOGIN_ID — VARCHAR2(20)
- ADMIN_PW — VARCHAR2(20)
- ADMIN_NAME — VARCHAR2(10)
- ADMIN_ROLE — VARCHAR2(20)
- ADMIN_CREATE — DATE
- ADMIN_UPDATE — DATE
BOARD
- PATIENT_ID — VARCHAR2(20) — Foreign key → PATIENT.PATIENT_ID — NOT NULL
- BOARD_NO — NUMBER(38)
- BOARD_TITLE — VARCHAR2(200) — NOT NULL
- BOARD_CONTENT — VARCHAR2(4000) — NOT NULL
- BOARD_PWD — VARCHAR2(100) — NOT NULL
- BOARD_VIEWS — NUMBER(38)
- BOARD_REF — NUMBER(38)
- BOARD_STEP — NUMBER(38)
- BOARD_DATE — DATE
COORDINATE
- H_ID — VARCHAR2(20) — Foreign key → HOSPITAL_BASIC_INFO.H_ID — NOT NULL
- FIELD_X — NUMBER(10, 7)
- FIELD_Y — NUMBER(10, 7)
HOSPITAL_BASIC_INFO
- H_ID — VARCHAR2(20) — Primary key — NOT NULL
- H_BASIC_NAME — VARCHAR2(100) — NOT NULL
- H_BASIC_ADDR — VARCHAR2(200)
- H_BASIC_TEL — VARCHAR2(20)
HOSPITAL_DETAILS_INFO
- H_IA — VARCHAR2(20) — Foreign key → HOSPITAL_BASIC_INFO.H_ID — NOT NULL
- H_DETAILS_NAME — VARCHAR2(100)
- H_DETAILS_AREA_CODE — VARCHAR2(10)
- H_DETAILS_ADDR — VARCHAR2(200)
- H_DETAILS_TEL — VARCHAR2(20)
- H_DETAILS_TYPE — VARCHAR2(50)
- H_DETAILS_DEPARTMENT — VARCHAR2(100)
- H_DETAILS_DESCRIPTION — CLOB
- H_DETAILS_AUTHORIZATION — DATE
- H_DETAILS_NIGHT_SERVICE_YN — VARCHAR2(1)
- H_DETAILS_WHEELCHAIR_YN — VARCHAR2(1)
- H_DETAILS_UPDATE — DATE
- H_DETAILS_STAFF_NUM — NUMBER(5)
- H_DETAILS_STATE — NUMBER(1) — is_active
- H_DETAILS_ROOM_NUM — NUMBER(4)
- H_DETAILS_BED_NUM — NUMBER(5)
- H_DETAILS_AREA — NUMBER(10, 2)
HOSPITAL_RATING
- H_RATING_ID — VARCHAR2(20)
- H_RATING_SCORE — NUMBER(2, 1) — NOT NULL
- H_RATING_CONTENT — CLOB
- H_RATING_DATE — DATE — NOT NULL
- PATIENT_ID — VARCHAR2(20) — NOT NULL
- H_ID — VARCHAR2(20) — NOT NULL
- RESERV_ID — VARCHAR2(50) — Foreign key → Reservation_History.RESERV_ID — NOT NULL
HOSPITAL_SCHEDULE
- H_ID — VARCHAR2(100) — Foreign key → HOSPITAL_DETAILS_INFO.H_IA — NOT NULL
- H_SCHEDULE_TIME — VARCHAR2(20)
- H_OPEN_TIME — VARCHAR2(5) — NOT NULL
- H_END_TIME — VARCHAR2(5) — NOT NULL
- H_WEEKEND_YN — VARCHAR2(1)
- H_HOLIDAY_OF_OPEN — NUMBER(1) — is_active
- H_RESERVATION — NUMBER(1,0) — NOT NULL
HOSPITAL_STAFF
- DOCTOR_ID — VARCHAR2(20)
- DOCTOR_NAME — VARCHAR2(15) — NOT NULL
- DOCTOR_GENDER — VARCHAR2(1)
- DOCTOR_DEPARTMENT — VARCHAR2(100) — NOT NULL
- DOCTOR_SPECIALTY — VARCHAR2(100)
- DOCTOR_DESCRIPTION — CLOB
- DOCTOR_MORNING_SCHEDULE — VARCHAR2(1)
- DOCTOR_AFTERNOON_SCHEDULE — VARCHAR2(1)
- DOCTOR_PROFILE — VARCHAR(255)
- DOCTOR_SCHEDULE — DATE
- DOCTOR_STATE — NUMBER(1) — is_active
- H_ID — VARCHAR2(20) — NOT NULL
Hospital_Admin
- H_ADMIN_ID — VARCHAR2(20) — Primary key — NOT NULL
- H_ADMIN_LOGIN_ID — VARCHAR2(20)
- H_ADMIN_PW — VARCHAR2(20)
- H_ADMIN_NAME — VARCHAR2(10)
- H_ADMIN_ROLE — VARCHAR2(20)
- H_ADMIN_CREATE — DATE
- H_ADMIN_UPDATE — DATE
- H_ADMIN_STATE — NUMBER(1) — is_active
- H_ADMIN_TEL — VARCHAR2(20)
- H_ID — VARCHAR2(20) — NOT NULL
Mem_Feedback
- FB_ID — VARCHAR2(50) — Primary key — NOT NULL
- FB_TITLE — VARCHAR2(100)
- FB_CONT — VARCHAR2(1000)
- FB_TYPE — VARCHAR2(10)
- FB_DATE — DATE
- FB_STATE — NUMBER(1) — is_active
- FB_PROCESS_DATE — DATE
- PATIENT_ID — VARCHAR2(20) — NOT NULL
- H_ID — VARCHAR2(20) — NOT NULL
- RESERV_ID — VARCHAR2(50) — NOT NULL
NOTICE
- ADMIN_ID — VARCHAR2(20) — Foreign key → Admin.ADMIN_ID — NOT NULL
- NOTICE_NO — NUMBER(38)
- NOTICE_TITLE — VARCHAR2(200) — NOT NULL
- NOTICE_CONTENT — VARCHAR2(4000) — NOT NULL
- NOTICE_VIEWS — NUMBER(38)
- NOTICE_DATE — DATE
- NOTICE_PIN — NUMBER(1) — is_active
PATIENT
- PATIENT_ID — VARCHAR2(20) — Primary key — NOT NULL
- PATIENT_LOGIN_ID — VARCHAR2(20)
- PATIENT_PW — VARCHAR2(32)
- PATIENT_NAME — VARCHAR2(15)
- PATIENT_BIR — DATE
- PATIENT_GENDER — VARCHAR2(1)
- PATIENT_REGNO1 — CHAR(6)
- PATIENT_REGNO2 — VARCHAR2(100)
- PATIENT_ZIP — CHAR(5)
- PATIENT_ADDR1 — VARCHAR2(100)
- PATIENT_ADDR2 — VARCHAR2(100)
- PATIENT_HP — VARCHAR2(15)
- PATIENT_MAIL — VARCHAR2(50)
- PATIENT_JOB — VARCHAR2(30)
- PATIENT_STATE — NUMBER(1) — is_active
- PATIENT_BLOOD — VARCHAR2(3)
- PATIENT_DISEASE — VARCHAR2(30)
- PATIENT_ALLERGY — VARCHAR2(20)
- PATIENT_MEDICATION — VARCHAR2(30)
PAYMENT_STATUS
- CHECK_ID — VARCHAR2(20)
- CHECK_RECORD — VARCHAR2(200) — NOT NULL
- CHECK_DATE — DATE — NOT NULL
- CHECK_INFOR — VARCHAR2(200) — NOT NULL
- PATIENT_ID — VARCHAR2(20) — NOT NULL
- RESERV_ID — VARCHAR2(50) — NOT NULL
- DOCTOR_ID — VARCHAR2(20)
PreMedical_Form
- BM_ID — VARCHAR2(50) — Primary key — NOT NULL
- BM_SYMPTOM — VARCHAR2(500)
- BM_TRAVEL — VARCHAR2(50)
- BM_RECORD — DATE
- BM_PRECAUTIONS — VARCHAR2(200)
- PATIENT_ID — VARCHAR2(20) — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
Reservation_History
- RESERV_ID — VARCHAR2(50) — Primary key — NOT NULL
- RESERV_DATE — DATE
- RESERV_TIME — VARCHAR2(10)
- RESERV_STATE — NUMBER(1) — is_active
- RESERV_PROCESS_DATE — DATE
- RESERV_CANCEL_DATE — DATE
- RESERV_CANCEL_REASON — VARCHAR2(100)
- PATIENT_ID — VARCHAR2(20) — NOT NULL
SOCIAL_LOGIN
- SOCIAL_ID — VARCHAR2(15) — Primary key — NOT NULL — 내부
- SOCIAL_PROVIDER — VARCHAR2(30) — 소셜
- SOCIAL_NICK — VARCHAR2(100) — NOT NULL — 소셜에서
- SOCIAL_PROFILE_JSON — CLOB — 소셜에서
- SOCIAL_CREATED_AT — DATE — 해당
- PATIENT_ID — VARCHAR2(20) — NOT NULL
System_Log
- LOG_ID — VARCHAR2(20) — Primary key — NOT NULL
- LOG_DATE — DATE
- LOG_STATUS — VARCHAR2(10)
- LOG_IP — VARCHAR2(50)
- LOG_INFO — VARCHAR2(50)
- PATIENT_ID — VARCHAR2(20) — NOT NULL
System_Usage_Stats
- LOG_ID — VARCHAR2(20) — Foreign key → System_Log.LOG_ID — NOT NULL
- ACT_LOGIN_COUNT — VARCHAR2(10)
- ACT_LAST_DATE — DATE
- ACT_SEARCH — VARCHAR2(100)
- ACT_ACCOUNT_YN — VARCHAR2(50)
- PATIENT_ID — VARCHAR2(20) — NOT NULL