케어메디
테이블 (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))