케어메디

테이블 (18)

ws_admin

  • admingroupid — bigint — 권한
  • createdat — timestamp(6)
  • createdby — bigint
  • id — bigint
  • profileimageid — bigint — 프로필
  • statusmodifiedat — timestamp(6) — 상태
  • statusmodifiedby — bigint — 상태
  • teamcategoryid — bigint — 부서
  • mobile — varchar(20) — 휴대폰번호
  • loginid — varchar(255) — NOT NULL — 로그인
  • name — varchar(30) — NOT NULL — 이름
  • approvalauthority — varchar(255) — 승인권한
  • N::character — varying)::text))
  • email — varchar(255) — 이메일
  • googlechatnotificationenabled — varchar(255) — 구글
  • N::character — varying)::text))
  • password — varchar(255) — 비밀번호
  • role — varchar(255) — 권한
  • MANAGER::character — varying
  • ADMIN::character — varying)::text))
  • snstype — varchar(255) — 회원가입
  • GOOGLE::character — varying
  • KAKAO::character — varying
  • NAVER::character — varying
  • APPLE::character — varying)::text))
  • status — varchar(255) — 상태
  • PENDING_APPROVAL::character — varying
  • INACTIVE::character — varying
  • REJECT::character — varying)::text))
  • worktype — varchar(255) — 구분
  • WORKER::character — varying)::text))
  • modifiedat — timestamp(6)
  • modifiedby — bigint
  • pwdcnt — bigint
  • lastloginat — timestamp

ws_admin_group

  • createdat — timestamp(6)
  • createdby — bigint
  • id — bigint
  • modifiedat — timestamp(6)
  • modifiedby — bigint
  • name — varchar(255) — 그룹명
  • privacypermission — varchar(255) — 개인정보
  • N::character — varying)::text))
  • status — varchar(255) — 상태
  • INACTIVE::character — varying
  • DELETED::character — varying)::text))

ws_admin_menu

  • depth — integer — NOT NULL — 뎁스
  • menuorder — integer — NOT NULL — 순서
  • createdat — timestamp(6)
  • id — bigint
  • modifiedat — timestamp(6)
  • parentmenuid — bigint — 부모
  • actualurl — varchar(255) — 접속
  • name — varchar(255) — 메뉴명
  • status — varchar(255) — 상태
  • INACTIVE::character — varying
  • DELETED::character — varying)::text))
  • mappingurl — varchar(255)

ws_cs_category_sub

  • categoryid — bigint — 카테고리
  • createdat — timestamp(6)
  • createdby — bigint
  • id — bigint
  • modifiedat — timestamp(6)
  • modifiedby — bigint
  • status — varchar(255) — 노출여부
  • INACTIVE::character — varying
  • DELETED::character — varying)::text))
  • subname — varchar(255) — 하위분류명
  • sort — integer

ws_cs_rel

  • id — bigint
  • createdat — timestamp(6)
  • modifiedat — timestamp(6)
  • createdby — bigint
  • modifiedby — bigint
  • csno1 — varchar(255) — 현재
  • csno2 — varchar(255) — 연계된
  • status — varchar(255) — 노출설정
  • (INACTIVE::character — varying)::text
  • (DELETED::character — varying)::text))

ws_cs_temp

  • id — bigint
  • createdat — timestamp(6)
  • modifiedat — timestamp(6)
  • createdby — bigint
  • modifiedby — bigint
  • accountinfo_id — bigint — 회원
  • answer — text — 문의답변
  • attachfiles — text — 첨부파일
  • complaintid — bigint — 컴플레인
  • completedat — timestamp(6) — 처리일시
  • content — text — 문의상세
  • cscategoryid — bigint — 문의구분
  • cscategorysubid — bigint — 문의
  • csdivision — varchar(255) — 문의분류
  • NORMAL::character — varying)::text))
  • csinout — varchar(255) — 문의
  • OUT::character — varying)::text))
  • csmanagerid — bigint — CS
  • csno — varchar(255) — CS
  • csstatus — varchar(255) — 처리상태
  • TRANSFER::character — varying
  • COMPLETE::character — varying
  • REPORTING::character — varying)::text))
  • deptid — bigint — 관련분서
  • managerid — bigint — 관련
  • memo — text — 비고
  • pathid — bigint — 문의경로
  • receivedat — timestamp(6) — 접수일시
  • relationcs — text — 연결된
  • status — varchar(255) — 노출설정
  • INACTIVE::character — varying
  • DELETED::character — varying)::text))
  • subject — varchar(255) — 문의제목

ws_file

  • createdat — timestamp(6)
  • id — bigint — 아이디
  • modifiedat — timestamp(6)
  • size — bigint — NOT NULL — 사이즈
  • ext — varchar(10) — NOT NULL — 확장자
  • division — varchar(50) — NOT NULL — 구분
  • cloudyn — varchar(255) — 클라우드여부
  • N::character — varying)::text))
  • foldername — varchar(255) — NOT NULL — 폴더명
  • originalname — varchar(255) — NOT NULL — 원본파일명
  • savename — varchar(255) — NOT NULL — 저장파일명
  • thumbnail — text — 썸네일

ws_log_admin_history

  • createdat — timestamp(6)
  • createdby — bigint
  • id — bigint — 아이디
  • content — text — 변경내역
  • ip — varchar(255) — IP
  • description — varchar(255)
  • logtype — varchar(255)
  • UPDATE::character — varying
  • DELETE::character — varying
  • LIST::character — varying
  • VIEW::character — varying
  • DOWNLOAD::character — varying)::text))
  • tablename — varchar(255)
  • targetid — bigint

ws_log_admin_login

  • adminid — bigint — 관리자
  • createdat — timestamp(6)
  • id — bigint — 아이디
  • modifiedat — timestamp(6)
  • ip — varchar(30) — NOT NULL — IP
  • address — varchar(255) — 주소
  • agent — varchar(255) — 접속
  • browser — varchar(255) — 브라우저
  • device — varchar(255) — 디바이스
  • os — varchar(255) — OS
  • status — varchar(255) — 로그인
  • FAILURE::character — varying)::text))

ws_log_send

  • id — bigint
  • createdat — timestamp(6)
  • modifiedat — timestamp(6)
  • createdby — bigint
  • modifiedby — bigint
  • accountinfo_id — bigint — 사용자
  • autoyn — varchar(255) — 자동발송
  • N::character — varying)::text))
  • code — varchar(255) — 템플릿코드
  • content — text — 내용
  • refkey — varchar(255) — 발송키
  • result — varchar(255) — 발송상태
  • SUCCESS::character — varying
  • FAIL::character — varying)::text))
  • subject — varchar(255) — 제목
  • templatestype — varchar(255) — 템플릿
  • PUSH::character — varying
  • EMAIL::character — varying
  • KAKAO::character — varying)::text))
  • recver — varchar(255)
  • apiresult — text

ws_medical_institution

  • bi — bigint — 의료기관
  • createdat — timestamp(6)
  • createdby — bigint
  • id — bigint
  • levelid — bigint — 의료기관레벨
  • modifiedat — timestamp(6)
  • modifiedby — bigint
  • address — varchar(255) — 주소
  • address2 — varchar(255) — 상세주소
  • code — varchar(255) — 의료기관코드
  • domain — varchar(255) — 도메인파라미터주소
  • name — varchar(255) — 의료기관명
  • status — varchar(255) — 노출설정
  • INACTIVE::character — varying
  • DELETED::character — varying)::text))
  • zipcode — varchar(255) — 우편번호
  • targetid — bigint

ws_medical_institution_sub

  • createdat — timestamp(6)
  • createdby — bigint
  • id — bigint
  • medicalinstitutionid — bigint — 의료기관
  • modifiedat — timestamp(6)
  • modifiedby — bigint
  • status — varchar(255) — 노출여부
  • INACTIVE::character — varying
  • DELETED::character — varying)::text))
  • subname — varchar(255) — 하위부서명
  • sort — bigint

ws_otp

  • createdat — timestamp(6)
  • createdby — bigint
  • id — bigint — 아이디
  • modifiedat — timestamp(6)
  • modifiedby — bigint
  • otpcode — varchar(255) — OTP
  • useyn — varchar(255) — 2차인증
  • N::character — varying)::text))
  • minute — bigint
  • sessionyn — varchar(255) — 관리자

ws_patch

  • id — bigint
  • createdat — timestamp(6)
  • modifiedat — timestamp(6)
  • createdby — bigint
  • modifiedby — bigint
  • address — varchar(255) — Address
  • battery — varchar(255) — Battery
  • buzzer — varchar(255) — Buzzer
  • date — varchar(255) — Date
  • lotno — varchar(255) — Lot
  • productcode — varchar(255) — Product
  • pumpcode — varchar(255) — Pump
  • pumppressuregap — varchar(255) — Pump
  • qrcode — varchar(255) — QR
  • result — varchar(255) — Result
  • rssi — varchar(255) — RSSI
  • status — varchar(255) — 노출설정
  • INACTIVE::character — varying
  • DELETED::character — varying)::text))
  • swver — varchar(255) — S/W
  • tester — varchar(255) — Tester

ws_siteinfo

  • bi — bigint — 사이트
  • createdat — timestamp(6)
  • createdby — bigint
  • id — bigint — 아이디
  • modifiedat — timestamp(6)
  • modifiedby — bigint
  • address — varchar(255) — 주소
  • address2 — varchar(255) — 상세주소
  • businessitem — varchar(255) — 업종
  • businessnumber — varchar(255) — 사업자번호
  • businessstatus — varchar(255) — 업태
  • ceo — varchar(255) — 대표자이름
  • companyname — varchar(255) — 상호(회사명)
  • email — varchar(255) — 대표이메일
  • fax — varchar(255) — 대표팩스번호
  • manager — varchar(255) — 개인정보보호책임자
  • registrationnumber — varchar(255) — 통신팬매신고번호
  • sitename — varchar(255) — 사이트명
  • sitetype — varchar(255) — 사이트
  • CARELEVO_FOLLOWER::character — varying
  • CARELEVO_PRO::character — varying
  • HOMEPAGE::character — varying)::text))
  • tel — varchar(255) — 대표전화번호
  • zipcode — varchar(255) — 우편번호

ws_templates

  • createdat — timestamp(6)
  • createdby — bigint
  • id — bigint
  • modifiedat — timestamp(6)
  • modifiedby — bigint
  • code — varchar(255) — 템플릿코드
  • content — text — 내용
  • status — varchar(255) — 사용여부
  • INACTIVE::character — varying
  • DELETED::character — varying)::text))
  • subject — varchar(255) — 제목
  • templatestype — varchar(255) — 템플릿
  • PUSH::character — varying
  • EMAIL::character — varying)::text))

ws_voc

  • id — bigint
  • createdat — timestamp(6)
  • modifiedat — timestamp(6)
  • createdby — bigint
  • modifiedby — bigint
  • accident — varchar(255) — 의료사고
  • N::character — varying)::text))
  • actions — text — 조치사항
  • address — varchar(255) — 주소
  • address2 — varchar(255) — 상세주소
  • attachfiles — text — 첨부파일
  • causeanalysis — text — 원인분석
  • complainant — varchar(255) — 불만제기자
  • complaintdetails — text — 불만
  • completedat — timestamp(6) — 완료일
  • csid — bigint — CS
  • csmanagerid — bigint — CS
  • dept1 — varchar(255) — IT
  • N::character — varying)::text))
  • dept2 — varchar(255) — 임베디드
  • N::character — varying)::text))
  • dept3 — varchar(255) — 기구
  • N::character — varying)::text))
  • dept4 — varchar(255) — HW
  • N::character — varying)::text))
  • dept5 — varchar(255) — 펌프
  • N::character — varying)::text))
  • dept6 — varchar(255) — 생산기술
  • N::character — varying)::text))
  • managerid — bigint — 관련
  • patchissueat — timestamp(6) — 문제
  • patchorderat — timestamp(6) — 제품
  • patchstartat — timestamp(6) — 패치
  • qty — varchar(255) — 수량
  • reason — varchar(255) — 문제원인
  • REASON2::character — varying
  • REASON3::character — varying
  • REASON4::character — varying)::text))
  • reasondetail — varchar(255) — 문제
  • DETAIL2::character — varying
  • DETAIL3::character — varying
  • DETAIL4::character — varying
  • DETAIL5::character — varying
  • DETAIL6::character — varying
  • DETAIL7::character — varying
  • DETAIL8::character — varying
  • DETAIL9::character — varying
  • DETAIL10::character — varying
  • DETAIL11::character — varying
  • DETAIL12::character — varying
  • DETAIL13::character — varying
  • DETAIL14::character — varying
  • DETAIL15::character — varying
  • DETAIL16::character — varying
  • DETAIL17::character — varying)::text))
  • receivedat — timestamp(6) — 접수일
  • report1 — varchar(255) — 관계당국
  • N::character — varying)::text))
  • report2 — varchar(255) — 시정
  • N::character — varying)::text))
  • … +15

ws_worked_hospital

  • id — bigint
  • createdat — timestamp(6)
  • modifiedat — timestamp(6)
  • createdby — bigint
  • modifiedby — bigint
  • accountinfo_id — bigint — 회원
  • medicalinstitutioncode — varchar(255) — 요양기관번호
  • medicallicensenumber — varchar(255) — 의사번호
  • startdate — varchar(255) — 근무
  • status — varchar(255) — 노출설정
  • INACTIVE::character — varying
  • DELETED::character — varying)::text))