no_name

Tables (22)

ALARM

  • ALARM_NO — NUMBER — Primary key
  • CONTENT_CODE — VARCHAR2(20 BYTE)
  • CHECK_CODE — CHAR(1 BYTE)
  • ALARM_DATE — DATE
  • PREFIX — VARCHAR2(200 BYTE)
  • RESERVE_NO — NUMBER
  • PHARMACY_SELECTNO — NUMBER
  • USER_ID — VARCHAR2(50 BYTE) — Foreign key → USERTABLE.USER_ID

ATTACHMENT

  • FILE_NO — NUMBER — Primary key
  • FILE_NAME — VARCHAR2(500 BYTE)
  • COMMUNITY_NO — NUMBER — Foreign key → COMMUNITY.COMMUNITY_NO
  • QNA_NO — NUMBER — Foreign key → QNA.QNA_NO
  • HOSPITAL_ID (HOSPITAL_ID2) — VARCHAR2(50 BYTE) — Foreign key
  • NOTICE_NO — NUMBER — Foreign key → NOTICE.NOTICE_NO

CHALLENGE

  • CHALLENGE_NO — NUMBER — Primary key
  • CHALLENGE_DATE — DATE
  • CHALLENGE_CONTENT — VARCHAR2(1000 BYTE)
  • SUCCESS — VARCHAR2(4 BYTE)
  • USER_ID — VARCHAR2(50 BYTE) — Foreign key → USERTABLE.USER_ID

CLINIC

  • CLINIC_NO — NUMBER — Primary key
  • CLINIC_SYMPTOM — VARCHAR2(300 BYTE)
  • SPECIFICITY — VARCHAR2(300 BYTE)
  • PAY_YN — CHAR(1 BYTE)
  • PERSCRIPTION_YN — CHAR(1 BYTE)
  • CLINIC_DATE — DATE
  • PATIENT_NO — NUMBER — Foreign key → PATIENT.PATIENT_NO
  • RESERVE_NO — NUMBER — Foreign key → RESERVATION.RESERVE_NO
  • PAYMENT_NO — NUMBER — Foreign key → PAYMENT.PAYMENT_NO
  • DOCTOR_NO — VARCHAR2(50 BYTE) — Foreign key → DOCTOR.DOCTOR_NO

COMMUNITY

  • COMMUNITY_NO — NUMBER — Primary key
  • TITLE — VARCHAR2(50 BYTE)
  • CONTENT — VARCHAR2(1000 BYTE)
  • WDATE — DATE
  • IMG — VARCHAR2(60 BYTE)
  • UDATE — DATE
  • USER_ID — VARCHAR2(50 BYTE) — Foreign key → USERTABLE.USER_ID

DETAILCODE

  • DETAIL_CODE — VARCHAR2(3 BYTE)
  • CODE_NAME — VARCHAR2(60 BYTE)
  • CODE_COMMENT — VARCHAR2(30 BYTE)
  • MAIN_CODE — CHAR(2 BYTE) — Foreign key → MAINCODE.MAIN_CODE
  • CATEGORY — VARCHAR2(255 CHAR)

DOCTOR

  • DOCTOR_NO — VARCHAR2(50 BYTE) — Primary key
  • SUBJECT — VARCHAR2(30 BYTE)
  • DOCTOR_NAME — VARCHAR2(100 BYTE)
  • DOCTOR_LICENSE — VARCHAR2(40 BYTE)
  • HOLIDAY — VARCHAR2(100 BYTE)
  • HOSPITAL_ID — VARCHAR2(50 BYTE) — Foreign key → HOSPITAL.HOSPITAL_ID
  • HOSPITAL_ID (HOSPITAL_ID2) — VARCHAR2(50 BYTE) — Foreign key → HOSPITAL.HOSPITAL_ID

DOCTOR_TIME

  • DOCTOR_TIMENO — NUMBER — Primary key
  • DAY — VARCHAR2(2 BYTE)
  • DOCTOR_NO — VARCHAR2(50 BYTE) — Foreign key → DOCTOR.DOCTOR_NO
  • TIME — VARCHAR2(2 BYTE)
  • REGISTER_DATE — DATE
  • HOSPITAL_ID (HOSPITAL_ID2) — VARCHAR2(50 BYTE) — Foreign key → DOCTOR.HOSPITAL_ID
  • DOCTOR_NO (DOCTOR_NO2) — VARCHAR2(50 BYTE) — Foreign key → DOCTOR.DOCTOR_NO

HOSPITAL

  • HOSPITAL_ID — VARCHAR2(50 BYTE) — Primary key
  • HOSPITAL_PW — VARCHAR2(512 BYTE)
  • HOSPITAL_NAME — VARCHAR2(50 BYTE)
  • ADDRESS — VARCHAR2(100 BYTE)
  • PHONE — VARCHAR2(15 BYTE)
  • HOSPITAL_IMG — VARCHAR2(1500 BYTE)
  • MAIN_SUBJECT — VARCHAR2(30 BYTE)
  • DIRECTOR_NAME — VARCHAR2(10 BYTE)
  • DIRECTOR_PHONE — VARCHAR2(15 BYTE)
  • DIRECTOR_LICENSE — VARCHAR2(15 BYTE)
  • HOSPITAL_STATUS — VARCHAR2(4 BYTE)
  • HOLIDAY — VARCHAR2(20 BYTE)
  • OPENTIME — VARCHAR2(6 BYTE)
  • CLOSETIME — VARCHAR2(6 BYTE)
  • JOINDATE — DATE
  • DIVISION — VARCHAR2(10 BYTE)
  • USER_STATUS — VARCHAR2(4 BYTE)

MAINCODE

  • MAIN_CODE — CHAR(2 BYTE)
  • CODE_NAME — VARCHAR2(30 BYTE)
  • CODE_COMMENT — VARCHAR2(30 BYTE)

MEDICINE

  • MEDICINE_NO — NUMBER — Primary key
  • MEDICINE_NAME — VARCHAR2(100 BYTE)
  • ENTP_NAME — VARCHAR2(100 BYTE)

NOTICE

  • NOTICE_NO — NUMBER — Primary key
  • TITLE — VARCHAR2(50 BYTE)
  • WDATE — DATE
  • CONTENT — VARCHAR2(1000 BYTE)
  • UDATE — DATE
  • HOSPITAL_ID — VARCHAR2(50 BYTE) — Foreign key → HOSPITAL.HOSPITAL_ID

PATIENT

  • PATIENT_NO — NUMBER — Primary key
  • CURRENT_DATE — DATE
  • USER_ID — VARCHAR2(50 BYTE) — Foreign key → USERTABLE.USER_ID

PAYMENT

  • PAYMENT_NO — NUMBER — Primary key
  • ORDER_NUM — VARCHAR2(50 BYTE)
  • AMOUNT — NUMBER
  • PAYMENT_DATE — DATE
  • PAYMENT_METHOD — VARCHAR2(50 BYTE)
  • USER_ID — VARCHAR2(50 BYTE) — Foreign key → USERTABLE.USER_ID

PERSCRIPTION

  • PERSCRIPTION_NO — NUMBER — Primary key
  • DOSAGE — NUMBER
  • DOSE_CNT — NUMBER
  • DOSE_DAY — NUMBER
  • CLINIC_NO — NUMBER — Foreign key → CLINIC.CLINIC_NO
  • PERSCRIPTION_DATE — DATE
  • MEDICINE_NO — NUMBER — Foreign key → MEDICINE.MEDICINE_NO

PHARMACY

  • PHARMACY_ID — VARCHAR2(50 BYTE) — Primary key
  • PHARMACY_PW — VARCHAR2(512 BYTE)
  • PHARMACY_NAME — VARCHAR2(50 BYTE)
  • ADDRESS — VARCHAR2(80 BYTE)
  • PHARMACY_PHONE — VARCHAR2(15 BYTE)
  • PHARMACY_FAX — VARCHAR2(15 BYTE)
  • PHARMACY_IMG — VARCHAR2(100 BYTE)
  • CEO_NAME — VARCHAR2(10 BYTE)
  • CEO_PHONE — VARCHAR2(15 BYTE)
  • CEO_LICENSE — VARCHAR2(15 BYTE)
  • PHARMACY_STATUS — VARCHAR2(5 BYTE)
  • HOLIDAY — VARCHAR2(20 BYTE)
  • OPENTIME — VARCHAR2(6 BYTE)
  • CLOSETIME — VARCHAR2(6 BYTE)
  • JOINDATE — DATE
  • DIVISION — VARCHAR2(10 BYTE)
  • USER_STATUS — VARCHAR2(4 BYTE)

PHARMACY_SELECT

  • PHARMACY_SELECTNO — NUMBER — Primary key
  • PRODUCE_STATUS — VARCHAR2(2 BYTE)
  • REJECTION — VARCHAR2(200 BYTE)
  • SEND_STATUS — VARCHAR2(3 BYTE)
  • PRINT_STATUS — VARCHAR2(12 BYTE)
  • SELECT_PHARMACYID — VARCHAR2(20 BYTE)
  • PHARMACY_ID — VARCHAR2(50 BYTE) — Foreign key → PHARMACY.PHARMACY_ID
  • CLINIC_NO — NUMBER — Foreign key → CLINIC.CLINIC_NO

QNA

  • QNA_NO — NUMBER — Primary key
  • TITLE — VARCHAR2(100 BYTE)
  • WDATE — DATE
  • HOSPITAL_ID — VARCHAR2(50 BYTE) — Foreign key → HOSPITAL.HOSPITAL_ID
  • CATEGORY_STATUS — VARCHAR2(5 BYTE)
  • CONTENT — VARCHAR2(1000 BYTE)
  • ANS_CODE — NUMBER
  • UDATE — DATE
  • ANS_STATUS — VARCHAR2(2 BYTE)

REPLY

  • REPLY_NO — NUMBER — Primary key
  • CONTENT — VARCHAR2(1000 BYTE)
  • WDATE — DATE
  • COMMUNITY_NO — NUMBER — Foreign key → COMMUNITY.COMMUNITY_NO

RESERVATION

  • RESERVE_NO — NUMBER — Primary key
  • RESERVE_YEAR — VARCHAR2(8 BYTE)
  • RESERVE_TIME — VARCHAR2(6 BYTE)
  • BOOKING_DATE — DATE
  • RESERVE_MONTH — VARCHAR2(4 BYTE)
  • RESERVE_DAY — VARCHAR2(4 BYTE)
  • SYMPTOM — VARCHAR2(1000 BYTE)
  • RESERVE_KINDSTATUS — VARCHAR2(3 BYTE)
  • RESERVE_STATUS — VARCHAR2(4 BYTE)
  • PATIENT_NO — NUMBER — Foreign key → PATIENT.PATIENT_NO

REVIEW

  • REVIEW_NO — NUMBER — Primary key
  • TITLE — VARCHAR2(50 BYTE)
  • CONTENT — VARCHAR2(1000 BYTE)
  • WDATE — DATE
  • DOCTOR_NO — VARCHAR2(50 BYTE) — Foreign key → DOCTOR.DOCTOR_NO

USERTABLE

  • USER_ID — VARCHAR2(50 BYTE) — Primary key
  • USER_PW — VARCHAR2(512 BYTE)
  • USER_NAME — VARCHAR2(20 BYTE)
  • PHONE — VARCHAR2(15 BYTE)
  • BIRTHDAY — DATE
  • GENDER — CHAR(1 BYTE)
  • IDENTIFICATION — VARCHAR2(100 BYTE)
  • USER_STATUS — VARCHAR2(4 BYTE)
  • JOINDATE — DATE
  • GRADE — VARCHAR2(20 BYTE)