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
Untitled11
- interview_seq — int(11) — Foreign key → t_nf_interview.interview_seq — NOT NULL
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