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 — 유저 탈퇴여부