통합프로그램

테이블 (29)

alarm

  • alarmidx — bigint(20) — 기본 키 — NOT NULL
  • appusridx — bigint(20) — 기본 키 — NOT NULL
  • alarm — varchar(64)
  • checkyn — bit(1)
  • 1: — true
  • insertdate — datetime

appterm

  • termidx — int — 기본 키 — NOT NULL
  • termname — varchar(32) — NOT NULL
  • term — varchar(128) — NOT NULL
  • essentialyn — bit(1) — NOT NULL — 0: false, 1: true
  • termdate — datetime — NOT NULL

apptermagree

  • termidx — int — 기본 키 — NOT NULL
  • appusridx — bigint(20) — 기본 키 — NOT NULL
  • agreeyn — bit(1) — NOT NULL — 0: false, 1: true
  • agreedate — datetime — NOT NULL

appuser

  • appusridx — bigint(20) — 기본 키 — NOT NULL
  • usrid — varchar(64)
  • usrpw — varchar(128)
  • usrname — varchar(32)
  • usrbirth — date
  • usrphoneno — varchar(16)
  • alarmyn — bit(1) — 0: false, 1: true(default)
  • deleteflag — tinyint — 1: 사용, 0: 임시삭제, 9: 완전삭제
  • insertdate — datetime
  • updatedate — datetime

bodyanalysiscal

  • bodyanalysisidx — varchar — 기본 키 — NOT NULL
  • examidx — varchar
  • headangle — int
  • headdistance — int
  • shoulderangle — int
  • shoulderdistance — int
  • pelvisangle — int
  • pelvisdistance — int
  • kneeangle — int
  • kneedistance — int
  • bodytiltangle — int
  • bodytiltdistance — int
  • ankleangle — int
  • ankledistance — int
  • keylossdistance — int
  • shouldertiltangle — int
  • shouldertiltdistance — int
  • turtleneckangle — int
  • turtleneckdistance — int
  • turtleneckweight — int
  • pelvistiltangle — int
  • pelvistiltdistance — int
  • kneeflexionangle — int
  • kneeflexiondistance — int
  • qangleleftangle — int
  • qanglerightangle — int
  • rcspleftturndirection — varchar
  • rcspleftturnangle — int
  • rcsprightturndirection — varchar
  • rcsprightturnangle — int
  • lat — int
  • ap — int
  • total — int

bodystate

  • bodystateidx — int — 기본 키 — NOT NULL
  • bodystate — varchar(64)
  • symptom — varchar(16)
  • description — varchar(64)
  • image — varchar(16)

client

  • clientidx — int — 기본 키 — NOT NULL
  • client — varchar(16) — ( METAGYM:메타짐, EXBODY:통합프로그램)

clientversion

  • clientversionidx — int — 기본 키 — NOT NULL
  • clientidx — int — 기본 키 — NOT NULL
  • versionname — varchar(16)
  • versiontype — varchar(20) — (LATEST:최신,DEFAULT:기본,NOMAL:일반)
  • updatecontents — varchar(2048)
  • updateurl — varchar(256)
  • useyn — bit(1) — 0: false, 1: true
  • insertdate — datetime
  • updatedate — datetime

correctionex

  • correctionexidx — int — 기본 키 — NOT NULL
  • correctionexname — varchar(32)
  • foldername — varchar(32)
  • moviefile — varchar(32)
  • correctionexurl — varchar(128)
  • bodypart — tinyint — 0: 해당없음, 1: 목, 2: 어깨, 3: 골반, 4: 무릎
  • time — int — 단위: 초

file

  • _id — String — 기본 키 — NOT NULL
  • datatype — String
  • dataidx — String
  • dataidx2 — String
  • url — String
  • path — String
  • filename — String
  • size — long
  • filetype — String
  • insertdate — datetime

measurement

  • _id — string — 기본 키 — NOT NULL
  • customeridx — bigint — NOT NULL
  • measurementround — int
  • measurement — object — useyn
  • bodyanalysisinfo — object
  • bodyanalysiscal — object
  • examdate — datetime
  • examcomment — string
  • measurementyn — boolean
  • insertdate — datetime
  • updatedate — datetime
  • programidx — bigint(20) — NOT NULL

measurementpin

  • _id — string — 기본 키 — NOT NULL
  • measurementidx — string — 기본 키 — NOT NULL
  • programidx — bigint(20) — 기본 키 — NOT NULL
  • companyidx — bigint(20) — 기본 키 — NOT NULL
  • programidx2 — bigint(20) — 기본 키 — NOT NULL
  • t_Id — string
  • pins — Object

measurementpinsample

  • _id — string — 기본 키 — NOT NULL
  • measurementidx — string — 기본 키 — NOT NULL
  • t_Id — string
  • pins — Object

mesurementsample

  • _id — string — 기본 키 — NOT NULL
  • customeridx — bigint — NOT NULL
  • measurementround — int
  • measurement — object — useyn
  • bodyanalysisinfo — object
  • bodyanalysiscal — object
  • examdate — datetime
  • examcomment — string
  • measurementyn — boolean
  • insertdate — datetime
  • updatedate — datetime
  • programidx — bigint(20) — NOT NULL

program

  • programidx — bigint(20) — 기본 키 — NOT NULL
  • devicecode — varbinary(32) — 관리자 기본정보
  • centername — varchar(64) — 관리자 기본정보
  • ceoname — varchar(64) — 관리자 기본정보
  • number — varchar(16) — 관리자 기본정보
  • country — varchar(64) — 관리자 기본정보
  • city — varchar(64) — 관리자 기본정보
  • zipcode — varchar(16) — 관리자 기본정보
  • address — varchar(256) — 관리자 기본정보
  • installeridx — bigint
  • installdate — date
  • bizname — varchar(64) — 리포트 페이지에서 사용
  • biznumber — varchar(16) — 리포트 페이지에서 사용
  • language — varchar(32) — KR, EN, CN, JP
  • deleteflag — tinyint — 1: 사용, 0: 임시삭제, 9: 완전삭제
  • insertdate — datetime
  • updatedate — datetime
  • openinghours — varchar(50)
  • centerimage — varchar(128)
  • maxconnect — int
  • connectrestcnt — int

programanalysissetting

  • programidx — bigint(20) — 기본 키 — NOT NULL
  • automarker — bit(1)
  • shouldermidpoint — bit(1)
  • markersize — int
  • gridsize — int
  • automarkerposition — int
  • linethickness — int
  • markercolor — varchar
  • linecolor — varchar
  • squaregridsize — int
  • autoqangle — int
  • cmpxconversion — int
  • previewx — int
  • uifontsize — int
  • analysisfontsize — int
  • zoomin — bit(1)
  • camera1 — varchar
  • camera2 — varchar
  • camera3 — varchar
  • camera1index — int
  • camera2index — int
  • camera3index — int
  • camera1rotation — int
  • camera2rotation — int
  • camera3rotation — int
  • camerarecognized — int
  • camerawidth — int
  • cameralength — int
  • insertdate — datetime
  • updatedate — datetime

programcustomer

  • customeridx — bigint(20) — 기본 키 — NOT NULL
  • programidx — bigint(20) — 기본 키 — NOT NULL
  • customerno — int(11)
  • customername — varchar(64)
  • customerbirth — date
  • customerphoneno — varchar(32)
  • customergender — tinyint — 성별(1: 남, 2: 여, 3: 선택안함)
  • customerheight — float
  • customerweight — float
  • chartno — varchar(32)
  • epname — varchar(64)
  • epdepartment — varchar(64)
  • epsubdep1 — varchar(64)
  • epsubdep2 — varchar(64)
  • epsubdep3 — varchar(64)
  • subid — varchar(64)
  • examdate — datetime
  • surveysuccessyn — bit(1) — 0: false, 1:true
  • deleteflag — tinyint — 1: 사용, 0: 임시삭제, 9: 완전삭제
  • firstshooting — datetime
  • insertdate — datetime
  • updatedate — datetime

programoption

  • optionidx — bigint — 기본 키 — NOT NULL
  • programidx — bigint(20) — 기본 키 — NOT NULL
  • type — String — NOT NULL
  • insertdate — datetime
  • updatedate — datetime

programoptioncheck

  • _id — String — 기본 키 — NOT NULL
  • type — String
  • product — int
  • devicemodel — int
  • check — ArrayList<Integer>

programoptioncode

  • _id — String — 기본 키 — NOT NULL
  • programoptionlist — Object

programsetting

  • programidx — bigint(20) — 기본 키 — NOT NULL
  • salesoption — int — 0: NONE, 1: 판매, 2: 구독, 3: 임대, 4: 협찬
  • expiredyn — Boolean
  • expireddate — Date
  • warrantyyn — Boolean
  • warranty — Date
  • product — int — 연구용, 양방용, 한방용, 검진센터, 피트니스, 필라테스, 일반(키오스크)
  • devicemodel — int — 9100,6100,ga,7202H,OK880,770,670,610,570,370,Untact990,GA(일반용),Gait Fit, 스포츠 동작 분석, 기타(input type)
  • devicemodeletc — String
  • insertdate — datetime
  • updatedate — datetime
  • sampleyn — Bit — 0: 샘플값 x, 1: 샘플값 0

programversion

  • programidx — bigint(20) — 기본 키 — NOT NULL
  • version — String — NOT NULL
  • autoupdateyn — Bollean — NOT NULL
  • updateversionidx — int
  • updateversion — String — NOT NULL
  • lastautoupdatedate — Datetime — NOT NULL
  • mobileyn — Boolean — NOT NULL
  • internetyn — Boolean — NOT NULL
  • insertdate — datetime
  • updatedate — datetime

shootinginfo

  • measurementidx — string — 기본 키 — NOT NULL
  • t_Id — int
  • t_Type — int
  • shootingyn — boolean
  • shootinginfo.attachmentname — string
  • shootinginfo.attachment — string
  • shootinginfo.capturenames — string
  • shootinginfo.captures — string
  • shootinginfo.jsonfilenames — string
  • shootinginfo.jsonfiles — string

survey

  • _id — String — 기본 키 — NOT NULL
  • customeridx — bigint — NOT NULL
  • survey — object — 번호, 질문, 답변, 추가질문, 추가답변
  • programidx — bigint(20) — NOT NULL

term

  • termidx — int(11) — 기본 키 — NOT NULL
  • termname — varchar(32) — NOT NULL
  • term — varchar(128) — NOT NULL
  • essentialyn — bit(1) — NOT NULL — 0: false, 1: true
  • termdate — datetime — NOT NULL

termagree

  • agreetermidx — bigint(20) — 기본 키 — NOT NULL
  • termidx — int(11) — 기본 키 — NOT NULL
  • customeridx — bigint(20) — 기본 키 — NOT NULL
  • programidx — bigint(20) — 기본 키 — NOT NULL
  • agreeyn — bit(1) — NOT NULL — 0: false, 1: true
  • agreedate — datetime — NOT NULL

user

  • usridx — BIGINT — 기본 키 — NOT NULL
  • uid — varchar(50)
  • devicecode — varbinary(16)
  • usrid — varchar(64)
  • usrpw — varchar(128)
  • usrname — varchar(64)
  • mainaccountyn — bit(1) — 0: 사용자계정, 1: 메인계정
  • adminconfigyn — bit(1) — 0: false, 1: true
  • accountconfigyn — bit(1) — 0: false, 1: true
  • optionconfigyn — bit(1) — 0: false, 1: true
  • deleteflag — tinyint — 1: 사용, 0: 임시삭제, 9: 완전삭제
  • adminyn — bit(1)
  • lastlogindate — datetime
  • insertdate — datetime
  • updatedate — datetime

userauthtoken

  • usrtokenidx — bigint(20) — 기본 키 — NOT NULL
  • usridx2 — BIGINT — NOT NULL
  • roles — varchar(30)
  • logindate — datetime
  • expireddate — datetime
  • logoutdate — datetime
  • refreshdate — datetime
  • refreshtoken — varchar
  • insertdate — datetime — NOT NULL
  • updatedate — datetime

usrconnectlog

  • connectidx — bigint — 기본 키 — NOT NULL
  • usridx — bigint
  • ip — varchar(50)
  • ip2 — varchar(60)
  • pagetype — varchar(10)
  • insertdate — Datetime — NOT NULL