test__P222

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_ADMIN

  • H_ADMIN_ID — VARCHAR2(20) — Primary key — NOT NULL
  • H_ID — VARCHAR2(20) — Foreign key → HOSPITAL_DETAILS_INFO.H_ID — 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 NUMBER(1) CHECK (is_active IN (0, 1))
  • H_ADMIN_TEL — VARCHAR2(20)

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_ID — 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 NUMBER(1) CHECK (is_active IN (0, 1))
  • H_DETAILS_ROOM_NUM — NUMBER(4)
  • H_DETAILS_BED_NUM — NUMBER(5)
  • H_DETAILS_AREA — NUMBER(10, 2)

HOSPITAL_RATING

  • PATIENT_ID — VARCHAR2(20) — Foreign key → PATIENT.PATIENT_ID — NOT NULL
  • H_ID — VARCHAR2(20) — Foreign key → HOSPITAL_DETAILS_INFO.H_ID — NOT NULL
  • H_RATING_ID — VARCHAR2(20)
  • H_RATING_SCORE — NUMBER(2, 1) — NOT NULL
  • H_RATING_CONTENT — CLOB
  • H_RATING_DATE — DATE — NOT NULL

HOSPITAL_SCHEDULE

  • H_ID — VARCHAR2(100) — Foreign key → HOSPITAL_DETAILS_INFO.H_ID — 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 NUMBER(1) CHECK (is_active IN (0, 1))
  • H_RESERVATION — NUMBER(1, 0) — NOT NULL

HOSPITAL_STAFF

  • H_ID — VARCHAR2(20) — Foreign key → HOSPITAL_DETAILS_INFO.H_ID — NOT NULL
  • 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 NUMBER(1) CHECK (is_active IN (0, 1))

MEM_FEEDBACK

  • FB_ID — VARCHAR2(50) — Primary key — NOT NULL
  • PATIENT_ID — VARCHAR2(20) — Foreign key → PATIENT.PATIENT_ID — NOT NULL
  • RESERV_ID — VARCHAR2(50) — Foreign key → RESERVATION_HISTORY.RESERV_ID — NOT NULL
  • FB_TITLE — VARCHAR2(100)
  • FB_CONT — VARCHAR2(1000)
  • FB_TYPE — VARCHAR2(10)
  • FB_DATE — DATE
  • FB_STATE — NUMBER(1) — is_active NUMBER(1) CHECK (is_active IN (0, 1))
  • FB_PROCESS_DATE — DATE

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 NUMBER(1) CHECK (is_active IN (0, 1))

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 NUMBER(1) CHECK (is_active IN (0, 1))
  • PATIENT_BLOOD — VARCHAR2(3)
  • PATIENT_DISEASE — VARCHAR2(30)
  • PATIENT_ALLERGY — VARCHAR2(20)
  • PATIENT_MEDICATION — VARCHAR2(30)

PAYMENT_STATUS

  • RESERV_ID — VARCHAR2(50) — Foreign key → RESERVATION_HISTORY.RESERV_ID — NOT NULL
  • PATIENT_ID — VARCHAR2(20) — Foreign key → RESERVATION_HISTORY.PATIENT_ID — NOT NULL
  • H_ID — VARCHAR2(20) — Foreign key → HOSPITAL_STAFF.H_ID — NOT NULL
  • CHECK_ID — VARCHAR2(20)
  • DOCTOR_ID — VARCHAR2(20) — Foreign key → HOSPITAL_STAFF.DOCTOR_ID
  • CHECK_RECORD — VARCHAR2(200) — NOT NULL
  • CHECK_DATE — DATE — NOT NULL
  • CHECK_INFOR — VARCHAR2(200) — NOT NULL

PREMEDICAL_FORM

  • BM_ID — VARCHAR2(50) — Primary key — NOT NULL
  • PATIENT_ID — VARCHAR2(20) — Foreign key → PATIENT.PATIENT_ID — NOT NULL
  • BM_SYMPTOM — VARCHAR2(500)
  • BM_RECORD — DATE
  • BM_TRAVEL — VARCHAR2(50)
  • BM_FAMILY — VARCHAR2(50)
  • BM_PREGNANCY — NUMBER(1)
  • BM_VACCINE — VARCHAR2(50)
  • BM_PRECAUTIONS — VARCHAR2(200)

RESERVATION_HISTORY

  • RESERV_ID — VARCHAR2(50) — Primary key — NOT NULL
  • PATIENT_ID — VARCHAR2(20) — Foreign key → PATIENT.PATIENT_ID — NOT NULL
  • RESERV_DATE — DATE
  • RESERV_TIME — DATE
  • RESERV_STATE — NUMBER(1) — is_active NUMBER(1) CHECK (is_active IN (0, 1))
  • RESERV_PROCESS_DATE — DATE
  • RESERV_CANCEL_DATE — DATE
  • RESERV_CANCEL_REASON — VARCHAR2(100)

SOCIAL_LOGIN

  • SOCIAL_ID — VARCHAR2(15) — Primary key — NOT NULL — 내부
  • PATIENT_ID — VARCHAR2(20) — Foreign key → PATIENT.PATIENT_ID — NOT NULL
  • SOCIAL_PROVIDER — VARCHAR2(30) — 소셜
  • SOCIAL_NICK — VARCHAR2(100) — NOT NULL — 소셜에서
  • SOCIAL_PROFILE_JSON — CLOB — 소셜에서
  • SOCIAL_CREATED_AT — DATE — 해당

SYSTEM_LOG

  • LOG_ID — VARCHAR2(20) — Primary key — NOT NULL
  • PATIENT_ID — VARCHAR2(20) — Foreign key → PATIENT.PATIENT_ID — NOT NULL
  • LOG_DATE — DATE
  • LOG_STATUS — VARCHAR2(10)
  • LOG_IP — VARCHAR2(50)
  • LOG_INFO — VARCHAR2(50)

SYSTEM_USAGE_STATS

  • LOG_ID — VARCHAR2(20) — Foreign key → SYSTEM_LOG.LOG_ID — NOT NULL
  • PATIENT_ID — VARCHAR2(20) — Foreign key → SYSTEM_LOG.PATIENT_ID — NOT NULL
  • ACT_LOGIN_COUNT — VARCHAR2(10)
  • ACT_LAST_DATE — DATE
  • ACT_SEARCH — VARCHAR2(100)
  • ACT_ACCOUNT_YN — VARCHAR2(50)