AID_0622

Tables (43)

CopyOfwork

  • date — VARCHAR(255) — Primary key — NOT NULL
  • doctor_id — VARCHAR(255) — Foreign key → doctor.doctor_id — NOT NULL
  • hospital_id — VARCHAR(255) — Foreign key → doctor.hospital_id — NOT NULL

Untitled

  • reservation_id — VARCHAR(255) — Foreign key → reservation.reservation_id — NOT NULL
  • doctor_id — VARCHAR(255) — NOT NULL
  • hospital_id — VARCHAR(255) — NOT NULL

Untitled10

    Untitled11

    • interview_seq — int(11) — Foreign key → t_nf_interview.interview_seq — NOT NULL

    Untitled12

      Untitled13

        Untitled14

          Untitled15

            Untitled16

              Untitled17

                Untitled18

                  Untitled19

                    Untitled2

                      Untitled3

                        Untitled4

                          Untitled5

                            Untitled6

                              Untitled7

                                Untitled8

                                  Untitled9

                                    doctor

                                    • doctor_id — VARCHAR(255) — Primary key — NOT NULL
                                    • hospital_id — VARCHAR(255) — Foreign key → hospital.hospital_id — NOT NULL

                                    grade

                                    • reservation_id — VARCHAR(255) — Foreign key → reservation.reservation_id — NOT NULL
                                    • Field — VARCHAR(255)
                                    • Field2 — VARCHAR(255)
                                    • doctor_id — VARCHAR(255) — NOT NULL
                                    • hospital_id — VARCHAR(255) — NOT NULL

                                    help_qna

                                    • qna_seq — int(11) — Primary key — NOT NULL
                                    • user_id — varchar(50) — NOT NULL
                                    • status — tinyint(4) — NOT NULL — 50:질문등록, 100:답변완료
                                    • title — varchar(100) — NOT NULL
                                    • question — varchar(1000) — NOT NULL
                                    • reg_date — datetime
                                    • answer — varchar(1000)
                                    • answer_date — datetime

                                    hospital

                                    • hospital_id — VARCHAR(255) — Primary key — NOT NULL

                                    payment

                                    • reservation_id — VARCHAR(255) — Primary key — NOT NULL
                                    • reservation_id2 — VARCHAR(255) — Foreign key → reservation.reservation_id — NOT NULL

                                    reservation

                                    • reservation_id — VARCHAR(255) — Primary key — NOT NULL
                                    • user_id — VARCHAR(255) — NOT NULL
                                    • doctor_id — VARCHAR(255) — NOT NULL
                                    • hospital_id — VARCHAR(255) — NOT NULL
                                    • patient_seq — int(11) — NOT NULL
                                    • user_id2 — VARCHAR(255) — NOT NULL
                                    • user_grp — VARCHAR(255) — NOT NULL

                                    server_config

                                    • config_type — enum — NOT NULL — 'GLOBAL', 'WAS'

                                    server_info

                                    • server_type — varchar(10) — Primary key — NOT NULL — 'DFS', 'WAS'
                                    • cluster — tinyint(4) — NOT NULL
                                    • psysical_name — varchar(20) — 서버가 설치된 컴퓨터의 이름
                                    • address — varchar(20) — IP 주소
                                    • host_name — varchar(50) — 도메인
                                    • port — int(11) — 포트
                                    • status — int(11) — 서버 상태. 1: ONLINE
                                    • auth_code — varchar(10)
                                    • connection_cnt — int(11)
                                    • context_cnt — int(11)
                                    • link_cnt — int(11)
                                    • read_bytes — bigint(20)
                                    • written_bytes — bigint(20)
                                    • update_date — datetime
                                    • status_pm — int(11)
                                    • update_date_pm — datetime
                                    • port_inet — int(11)

                                    server_log

                                    • err_seq — bigint(20) — Primary key — NOT NULL
                                    • status_code — varchar(10) — 상태 코드 (404, 500 etc...)
                                    • server — varchar(10) — 서버 종류 (PTMS, WAS etc...)
                                    • id — varchar(100) — 에러 발생자
                                    • method — varchar(100)
                                    • path — varchar(100)
                                    • header — text
                                    • params — text
                                    • query — text
                                    • payload — text
                                    • response — text — 에러 데이터
                                    • reg_date — datetime

                                    t_nf_help_notice

                                    • notice_seq — int(11) — Primary key — NOT NULL
                                    • title — varchar(100)
                                    • contents — text
                                    • status — tinyint(4) — 상태(1: 게시중단, 10: 기간제 게시, 11: 무제한)
                                    • start_date — date
                                    • end_date — date
                                    • reg_date — datetime

                                    t_nf_interview

                                    • interview_seq — int(11) — Primary key — NOT NULL
                                    • sort — tinyint(4) — NOT NULL
                                    • interview_type — enum — NOT NULL
                                    • question — varchar(200) — NOT NULL
                                    • reg_date — datetime

                                    t_nf_patient

                                    • patient_seq — int(11) — Primary key — NOT NULL
                                    • user_id — VARCHAR(255) — Foreign key → t_user.user_id — NOT NULL
                                    • user_grp — VARCHAR(255) — Foreign key → t_user.user_grp — NOT NULL
                                    • first_name — varchar(50) — NOT NULL
                                    • last_name — varchar(50) — NOT NULL
                                    • birthday — date — NOT NULL
                                    • height — varchar(5) — NOT NULL — 40~44 라면 40, 45~49 라면 45 처럼 앞을 저장
                                    • weight — varchar(5) — NOT NULL — 40~44 라면 40, 45~49 라면 45 처럼 앞을 저장
                                    • lg_code — char(3) — NOT NULL
                                    • sex — enum('M', 'F') — NOT NULL
                                    • glasses — tinyint(4) — NOT NULL
                                    • relationship — enum('Me', 'Mother', 'Father') — NOT NULL
                                    • reg_date — datetime — NOT NULL

                                    t_nf_patient_add

                                    • patient_seq — int(11) — Foreign key → t_nf_patient.patient_seq — NOT NULL
                                    • user_id — VARCHAR(255) — Foreign key → t_nf_patient.user_id — NOT NULL
                                    • medicine — varchar(300) — NOT NULL
                                    • disease — varchar(200) — NOT NULL
                                    • surgery — varchar(50) — NOT NULL
                                    • allergy — varchar(400) — NOT NULL

                                    t_nf_smart

                                    • smart_seq — int(11) — Primary key — NOT NULL
                                    • question — varchar(200)
                                    • question_type — enum('YESNO','LIST','TEXT','MULTI_LIST')
                                    • root_key — varchar(10)
                                    • reg_date — datetime

                                    t_nf_smart_answer

                                    • answer_seq — int(11) — Primary key — NOT NULL
                                    • smart_seq2 — int(11) — Foreign key → t_nf_smart.smart_seq — NOT NULL
                                    • smart_seq — int(11) — NOT NULL
                                    • answer — varchar(200) — NOT NULL
                                    • sort — tinyint(4) — NOT NULL
                                    • next_type — enum('SMART', 'RESULT') — NOT NULL — 다음 페이지의 종류
                                    • next_key — int(11)
                                    • weight — double

                                    t_nf_statistic

                                    • sta_date — date — Primary key — NOT NULL
                                    • cnt — int(11) — NOT NULL

                                    t_user

                                    • user_id — VARCHAR(255) — Primary key — NOT NULL
                                    • user_grp — VARCHAR(255) — Foreign key → t_user_grp.user_grp — NOT NULL

                                    t_user_grp

                                    • user_grp — VARCHAR(255) — Primary key — NOT NULL

                                    t_user_grp_auth

                                    • user_grp — VARCHAR(255) — Foreign key → t_user_grp.user_grp — NOT NULL
                                    • grp_auth — VARCHAR(255)

                                    user_alarm

                                    • seq — VARCHAR(255) — Primary key — NOT NULL
                                    • user_id — VARCHAR(255) — NOT NULL
                                    • Field — VARCHAR(255)
                                    • Field2 — VARCHAR(255)
                                    • Field3 — VARCHAR(255)

                                    user_login

                                    • login_id — VARCHAR(255)
                                    • datetime — VARCHAR(255)
                                    • user_id — VARCHAR(255) — NOT NULL

                                    user_session

                                    • user_id — VARCHAR(255) — NOT NULL
                                    • login_type — VARCHAR(255)
                                    • device_info — VARCHAR(255)
                                    • Field — VARCHAR(255)
                                    • Field2 — VARCHAR(255)

                                    work

                                    • Key — VARCHAR(255) — Primary key — NOT NULL
                                    • doctor_id — VARCHAR(255) — Foreign key → doctor.doctor_id — NOT NULL
                                    • hospital_id — VARCHAR(255) — Foreign key → doctor.hospital_id — NOT NULL