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)