baruda 1.0v
baruda_rds
Tables (17)
admin
- id — integer — Primary key — NOT NULL
- login_id — varchar(50)
- password — varchar(255)
- refresh_token — varchar(255)
- created_at — DATE
chart
- chart_id — integer — Primary key — NOT NULL
- exam_id — integer — Foreign key → self_exam.exam_id — NOT NULL — 자가진단문지표 아이디
- healing_id — integer — Foreign key → healing_category.healing_id — NOT NULL
- employee_id — integer — Foreign key → employee_info.employee_id — NOT NULL — 직원id
- uid — varchar(255) — Foreign key → users.uid — NOT NULL — 유저 고유값
- history — TEXT
- created_at — DATE
employee_info
- employee_id — integer — Primary key — NOT NULL — 직원id
- hospital_id — integer — Foreign key → hospital_info.hospital_id — NOT NULL — 병원pk
- name — varchar(100)
- login_id — varchar(100)
- password — varchar(255)
- level — integer — 1.의사 2.치료사 3.병원관계자
- phone — varchar(11)
- email — varchar(100) — 직원 이메일
- image_url — varchar(255) — NOT NULL — 직원 이미지
- refresh_token — varchar(255)
- is_deleted — boolean
- created_at — DATE
employee_schedule
- schedule_id — Primary key — NOT NULL
- employee_id — integer — Foreign key → employee_info.employee_id — NOT NULL — 직원id
- hour_duty1 — DATE
- hour_duty2 — DATE
- hour_duty3 — DATE
- hour_duty4 — DATE
- hour_duty5 — DATE
- hour_duty6 — DATE
- hour_duty7 — DATE
- created_at — DATE
healing_category
- healing_id — integer — Primary key — NOT NULL
- hospital_id — integer — Foreign key → hospital_info.hospital_id — NOT NULL — 병원pk
- title — varchar(100)
- content — varchar(100)
- created_at — DATE
hospital_image
- image_id — INTEGER — Primary key — NOT NULL
- hospital_id — integer — Foreign key → hospital_info.hospital_id — NOT NULL — 병원pk
- rep_image — varchar(255)
- image_path — varchar(255)
hospital_info
- hospital_id — integer — Primary key — NOT NULL — 병원pk
- hospital_idx — integer — Foreign key → hospital_list.id — NOT NULL
- business_no — integer — NOT NULL — 사업자번호
- ceo — varchar(20) — 사업자명
- email — varchar(100)
- license_kind — varchar(10) — 면허종류
- license_no — varchar(20) — 면허번호
- department — varchar(20)
- sns_yn — Boolean — sns계정 사용여부
- blog — varchar(255) — NOT NULL — blog주소
- instagram — varchar(255) — 인스타그램주소
- facebook — varchar(255) — 페이스북주소
- kakao_channel — varchar(255) — 병원 카카오 채널
- duty_time1 — DATE — 병원운영시간 월요일
- duty_time2 — DATE — 병원운영시간 화요일
- duty_time3 — DATE — 병원운영시간 수요일
- duty_time4 — DATE — 병원운영시간 목요일
- duty_time5 — DATE — 병원운영시간금요일
- duty_time6 — DATE — 병원운영시간토요일
- duty_time7 — DATE — 병원운영시간일요일
- created_at — DATE — 제휴병원 등록날짜
hospital_list
- id — integer — Primary key — NOT NULL
- hospital_code — varchar(32) — 병원코드
- duty_name — varchar(64) — 병원명
- duty_addr — varchar(255) — 병원주소
- duty_div_name — varchar(30)
- duty_div — varchar(10)
- duty_info — varchar(255)
- duty_etc — varchar(255)
- duty_tel1 — varchar(20)
- duty_tel3 — varchar(20)
- duty_time1 — varchar(8)
- duty_time2 — varchar(8)
- duty_time3 — varchar(8)
- duty_time4 — varchar(8)
- duty_time5 — varchar(8)
- duty_time6 — varchar(8)
- duty_time7 — varchar(8)
- duty_time8 — varchar(8)
- post_code1 — varchar(10)
- post_code2 — varchar(20)
- lat — double
- lon — double
notice
- notice_id — integer — Primary key — NOT NULL
- login_id — integer — Foreign key → admin.id — NOT NULL
- title — varchar(255)
- content — TEXT
- created_at — DATE
notice_image
- image_id — integer — Primary key — NOT NULL
- notice_id — integer — Foreign key → notice.notice_id — NOT NULL
- image_path — varchar(255)
pain_area
- pain_id — integer — Primary key — NOT NULL — 통증아이디
- exam_id — integer — Foreign key → self_exam.exam_id — NOT NULL — 자가진단문지표 아이디
- body_id — integer — 통증 신체 부위
- front_yn — Boolean — 앞 뒤 여부
- strength — integer — 통증 강도
patient_info
- patient_id — integer — Primary key — NOT NULL
- hospital_id — integer — Foreign key → hospital_info.hospital_id — NOT NULL — 병원pk
- name — varchar(50)
- phone — varchar(11) — 본인 연락처
- tel — varchar(20) — 비상연락망
- address — varchar(100)
- birth — DATE
- gender — TINYINT
- is_first — TINYINT
- master_memo — TEXT
- created_at — DATE
place_reservation_info
- id — integer — Primary key — NOT NULL
- patient_id — integer — Foreign key → patient_info.patient_id — NOT NULL
- hospital_id — integer — Foreign key → hospital_info.hospital_id — NOT NULL — 병원pk
- employee_id — integer — Foreign key → employee_info.employee_id — NOT NULL — 직원id
- reserved_at — DATE
- cancel_reason — varchar(255)
- canceled_at — DATE
- start_heal_time — DATE
- end_heal_time — DATE
- status — integer
- is_first — BOOLEAN
- reservation_memo — TEXT
- created_at — DATE
reservation_info
- reservation_id — integer — Primary key — NOT NULL — 예약 pk
- uid — varchar(255) — Foreign key → users.uid — NOT NULL — 유저 고유값
- hospital_id — integer — Foreign key → hospital_info.hospital_id — NOT NULL — 병원pk
- employee_id — integer — Foreign key → employee_info.employee_id — NOT NULL — 직원id
- reserved_at — DATE
- cancel_reason — varchar(255) — 취소 사유
- canceled_at — DATE — NOT NULL — 취소 일시
- start_heal_time — DATE — NOT NULL — 시작치료시간
- end_heal_time — DATE — NOT NULL — 종료 치료시간
- status — integer — NOT NULL — 예약상태
- is_first — Boolean — 초진 여부
- route — integer — 예약경로
- reservation_memo — TEXT
- created_at — DATE — 예약등록시간
self_exam
- exam_id — integer — Primary key — NOT NULL — 자가진단문지표 아이디
- reservation_id — integer — Foreign key → reservation_info.reservation_id — NOT NULL — 예약 pk
- description — TEXT — 상세 설명(통증에 대한)
- created_at — DATE — NOT NULL — 문진일시
terms
- term_id — integer — Primary key — NOT NULL
- login_id — integer — Foreign key → admin.id — NOT NULL
- title — varchar(255)
- content — longTEXT
- version — integer
- created_at — DATE
users
- uid — varchar(255) — Primary key — NOT NULL — 유저 고유값
- email — varchar(100) — NOT NULL — 유저 이메일
- password — varchar(255) — NOT NULL — 비밀번호
- user_name — varchar(100) — NOT NULL — 유저이름
- phone — varchar(20) — NOT NULL — 핸드폰번호
- birth — varchar(10) — NOT NULL — 생년월일
- gender — integer — NOT NULL — 성별
- sign_up_method — varchar(10) — NOT NULL — 가입유형
- fcm_token — varchar(255) — NOT NULL — 디바이스토큰
- push_allow — Boolean — NOT NULL — 앱푸시알림여부
- age — integer — NOT NULL — 유저나이
- last_access_at — DATE — NOT NULL — 최근접속일시
- created_at — DATE — NOT NULL — 회원가입날짜
- is_deleted — Boolean — NOT NULL — 유저 탈퇴여부