통합프로그램
테이블 (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