TK-WORLD
Tables (21)
TB_ASSOCIATION
- ASSOCIATION_CODE — VARCHAR(5) — Primary key — NOT NULL
- COUNTRY_CODE — VARCHAR(4) — NOT NULL
- USER_ID — INT — NOT NULL
- FULL_NAME — VARCHAR(100)
- ENG_NAME — VARCHAR(100)
- ADDRESS_NAME — VARCHAR(255)
- ROAD_ADDRESS — VARCHAR(255)
- REGION_1DEPTH_NAME — VARCHAR(100)
- REGION_2DEPTH_NAME — VARCHAR(100)
- REGION_3DEPTH_NAME — VARCHAR(100) — NOT NULL
- REGION_3DEPTH_H_NAME — VARCHAR(100)
- ADDRESS_DETAIL — VARCHAR(255)
- REP_NUMBER — VARCHAR(20)
- CREATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED
- UPDATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED on update CURRENT_TIMESTAMP
TB_ASSOCI_REG_REQ
- COUNTRY_CODE — VARCHAR(50)
- BELONG_CD — INT — NOT NULL
- ASSOCI_NAME — VARCHAR(100)
- ASSOCI_PHONE_NUM — VARCHAR(100) — NOT NULL
- CHIEF_NAME — VARCHAR(100)
- MANAGER_NAME — VARCHAR(100)
- MANAGER_EMAIL — VARCHAR(100)
- NAME_CARD_URL — VARCHAR(255) — NOT NULL
- ASSOCI_CERT_URL — VARCHAR(255)
- CREATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED
- UPDATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED on update CURRENT_TIMESTAMP
TB_ATTENDANCE
- STUDENT_ID — INT — Primary key — NOT NULL
- ATTEND_DATE — DATE — Primary key — NOT NULL — DEFAULT_GENERATED
- COUNTRY_CODE — VARCHAR(4)
- DOJANG_ID — INT — NOT NULL
- IS_ATTEND — TINYINT — NOT NULL
- CREATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED
- UPDATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED on update CURRENT_TIMESTAMP
TB_ATTENDANCE2
- STUDENT_ID — INT — Primary key — NOT NULL
- ATTEND_DATE — DATE — Primary key — NOT NULL
- ATTEND_CD — VARCHAR(1) — Primary key — NOT NULL
- COUNTRY_CODE — VARCHAR(4) — NOT NULL
- DOJANG_ID — INT — NOT NULL
- IS_ATTEND — TINYINT
- CREATEDATE — TIMESTAMP — DEFAULT_GENERATED
- UPDATEDATE — TIMESTAMP — DEFAULT_GENERATED on update CURRENT_TIMESTAMP
TB_AUTH_CODE
- PHONE_NUMBER — varchar(20) — Primary key — NOT NULL
- AUTH_CODE — varchar(4) — NOT NULL
TB_BODIX
- MAC_ADDR — varchar(16) — Primary key — NOT NULL
- RECORD_NO — varchar(18) — Primary key — NOT NULL
- COUNTRY_CODE — varchar(4) — NOT NULL
- DOJANG_ID — INT — NOT NULL
- USER_ROLE_CODE — varchar(2)
- TEACHER_ID — INT
- STUDENT_ID — INT — NOT NULL
- STUDENT_ID — INT
- RECORD_YMD — varchar(8) — NOT NULL — 기록일자
- BASAL_METABOLISM — varchar(256) — NOT NULL — 신진대사량
- BODY_AGE — varchar(256) — NOT NULL — 신체나이
- BODY_FAT — varchar(256) — NOT NULL — 체지방
- BODY_FAT_RATE — varchar(256) — NOT NULL — 체지방률
- BODY_IMP_OF_L_FOOT100 — varchar(256) — NOT NULL — 왼쪽 발 저항 100?
- BODY_IMP_OF_L_FOOT20 — varchar(256) — NOT NULL — 왼쪽 발 저항 20?
- BODY_IMP_OF_L_HAND100 — varchar(256) — NOT NULL — 왼쪽 손 저항 100?
- BODY_IMP_OF_L_HAND20 — varchar(256) — NOT NULL — 왼쪽 손 저항 20?
- BODY_IMP_OF_R_FOOT100 — varchar(256) — NOT NULL — 오른 발 저항 100?
- BODY_IMP_OF_R_FOOT20 — varchar(256) — NOT NULL — 오른 발 저항 20?
- BODY_IMP_OF_R_HAND100 — varchar(256) — NOT NULL — 오른 손 저항 100?
- BODY_IMP_OF_R_HAND20 — varchar(256) — NOT NULL — 오른 손 저항 20?
- BODY_IMP_OF_TORSO100 — varchar(256) — NOT NULL — 몸통 저항 100?
- BODY_IMP_OF_TORSO20 — varchar(256) — NOT NULL — 몸통 저항 20?
- BODY_MOISTURE — varchar(256) — NOT NULL — 체수분
- BODY_TYPE — varchar(4)
- BODY_WHR — varchar(256) — NOT NULL — 허리엉덩이둘레비율
- BURN_CALORIES — varchar(10)
- EXERCISE_INTENSITY — varchar(10)
- EXTRA_CELLULAR_FLUID — varchar(10)
- FAT_ADJUST — varchar(10)
- FAT_ASSESSMENT — varchar(10)
- FATLOSS — varchar(256) — NOT NULL — 줄여야할체중?
- HEALTH_SCORE — varchar(256) — NOT NULL — 신체점수
- INTRA_CELLULAR_FLUID — varchar(10)
- L_LO_LIMB_FAT — varchar(256) — NOT NULL — (?)왼쪽 하부 사지 지방
- L_LO_LIMB_FAT_PERCENT — varchar(256) — NOT NULL — 왼쪽 하지 지방 비율
- L_LO_LIMB_MUSCLE_WEIGHT — varchar(256) — NOT NULL — 왼쪽 하지 근육 무게
- L_UP_LIMB_FAT — varchar(256) — NOT NULL — 왼쪽 사지(상부몸통) 지방
- L_UP_LIMB_FAT_PERCENT — varchar(256) — NOT NULL — 왼쪽 사지 지방(상부몸통) 비율
- L_UP_LIMB_MUSCLE_WEIGHT — varchar(256) — NOT NULL — 왼쪽 사지(상부몸통) 근육 무게
- MINERALS — varchar(10)
- MINERALS_ASSESSMENT — varchar(10)
- MUSCLE_MASS — varchar(10)
- MUSCEL_OF_EIGHT — varchar(256) — NOT NULL — 팔근육
- PERCENT_OF_TRUNK_FAT — varchar(256) — NOT NULL — 몸통 지방 비율
- PROTEIN_ASSESSMENT — varchar(10)
- PROTEINS — varchar(10)
- REPORT_IMG — varchar(10)
- R_LO_EXTREMITY_FAT — varchar(10)
- R_LO_LIMB_FAT_PERCENT — varchar(256) — NOT NULL — 오른쪽 하지 지방 비율
- R_LO_LIMB_MUSCLE_WEIGHT — varchar(256) — NOT NULL — 오른쪽 하지 근육 무게
- R_UP_LIMB_FAT — varchar(256) — NOT NULL — 오른쪽 사지(상부몸통) 지방
- R_UP_LIMB_FAT_PERCENT — varchar(256) — NOT NULL — 오른쪽 사지(상부몸통) 지방 비율
- R_UP_LIMB_MUSCLE_WEIGHT — varchar(256) — NOT NULL — 오른쪽 사지(상부몸통) 근육 무게
- RUNNING_TIME — varchar(10)
- SKELTAL_MUSCLE — varchar(256) — NOT NULL — 골격근
- SWIMMING_TIME — varchar(10)
- TORSO_MUSCLE_WEIGHT — varchar(256) — NOT NULL — 몸통 근육 무게
- TRUNK_FAT — varchar(256) — NOT NULL — 몸통 지방
- VISCERAL_FAT_GRADE — varchar(256) — NOT NULL — 내장지방레벨
- … +8
TB_BODIX_BUYER
- COUNTRY_CODE — varchar(4) — NOT NULL
- BR_NUM — varchar(255) — NOT NULL
- DOJANG_ID — INT
- CREATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED
- UPDATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED on update CURRENT_TIMESTAMP
TB_BODIX_PURCHASE_REQ
- LAST_NAME — varchar(20) — NOT NULL
- FIRST_NAME — varchar(20) — NOT NULL
- DOJANG_NAME — varchar(50) — NOT NULL
- MOBILE_NUM — varchar(50) — NOT NULL
- PHONE_NUM — varchar(50) — NOT NULL
- REQ_NUM — INT — NOT NULL
- EMAIL — varchar(100) — NOT NULL
- ADDRESS1 — varchar(255) — NOT NULL
- ADDRESS2 — varchar(255) — NOT NULL
- PROGRAM — varchar(100)
- CREATEDATE — TIMESTAMP — DEFAULT_GENERATED
TB_CAR
- CAR_ID — INT — Primary key — NOT NULL
- COUNTRY_CODE — varchar(4)
- DOJANG_ID — INT — NOT NULL
- CAR_NAME — NULL
- CAR_NUMBER — NULL
- CAR_TYPE_CODE — NULL
- NUM_SEATER — NULL
- CAR_IMG — NULL
- MEMO — NULL
- IS_DRIVING — NULL
- CREATEDATE — NULL — DEFAULT_GENERATED
- UPDATEDATE — NULL — DEFAULT_GENERATED on update CURRENT_TIMESTAMP
TB_CAR_OP
- CAR_OP_DATE — NOT — Primary key — NOT NULL
- COUNTRY_CODE — NULL
- DOJANG_ID — INT — NOT NULL
- CAR_ID — INT — NOT NULL
- CAR_OP_SEQ — NULL
- USER_ID — INT — NOT NULL
- IS_DRIVING — NULL
- CAR_LATITUDE — NULL
- CAR_LONGITUDE — NULL
- CREATEDATE — NULL — DEFAULT_GENERATED
- UPDATEDATE — NULL — DEFAULT_GENERATED on update CURRENT_TIMESTAMP
TB_CLASS
- CLASS_ID — INT — Primary key — NOT NULL
- COUNTRY_CODE — varchar(4) — NOT NULL
- DOJANG_ID — INT — NOT NULL
- TITLE — varchar(100)
- ROOM — varchar(100)
- MON_TIME — varchar(20)
- TUE_TIME — varchar(20)
- WED_TIME — varchar(20)
- THU_TIME — varchar(20)
- FRI_TIME — varchar(20)
- SAT_TIME — varchar(20)
- SUN_TIME — varchar(20)
- CREATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED
- UPDATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED on update CURRENT_TIMESTAMP
TB_CLASS_STUDENT
- COUNTRY_CODE — varchar(4) — NOT NULL
- DOJANG_ID — INT — NOT NULL
- CLASS_ID — INT — NOT NULL
- STUDENT_ID — INT — NOT NULL
- CREATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED
- UPDATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED on update CURRENT_TIMESTAMP
TB_COUNTRY_FLAG
- COUNTRY_CODE — varchar(4) — Primary key — NOT NULL
- COUNTRY_NAME — varchar(100) — NOT NULL
- FLAG_IMG — varchar(200)
- CREATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED
- UPDATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED on update CURRENT_TIMESTAMP
TB_DB_LOG
- YMD — varchar(8)
- PROC_NM — varchar(100)
- MSG — varchar(4096)
- CREATEDATE — TIMESTAMP — DEFAULT_GENERATED
TB_DOJANG
- DOJANG_ID — INT — Primary key — NOT NULL
- COUNTRY_CODE — VARCHAR(4) — NOT NULL
- DOJANG_PASSWORD — VARCHAR(255)
- DOJANG_NAME — VARCHAR(100) — NOT NULL
- PHONE_NUMBER — VARCHAR(20)
- PID — VARCHAR(255)
- ADDRESS_NAME — VARCHAR(255)
- ROAD_ADDRESS — VARCHAR(255)
- REGION_1DEPTH_NAME — VARCHAR(100)
- REGION_2DEPTH_NAME — VARCHAR(100) — NOT NULL
- REGION_3DEPTH_NAME — VARCHAR(100)
- REGION_3DEPTH_H_NAME — VARCHAR(100)
- ZIP_CODE — VARCHAR(20)
- ADDRESS_DETAIL — VARCHAR(255)
- BR_IMG — VARCHAR(255)
- BR_NUMBER — VARCHAR(255) — Business Registration Number
- SIGNATURE_IMG — VARCHAR(255)
- SIGNATURE_TYPE — VARCHAR(200) — 1 : 사각, 2 : 원형
- LOGO_IMG — VARCHAR(200)
- IS_ALIVE — TINYINT — 0:도장삭제, 1:도장생성
- PAYING_AMOUNT — DOUBLE
- PAY_GUBUN_CD — VARCHAR(2) — 결제종류 : 0:카드, 1:현금, 2:계좌이체
- PAY_METHOD — VARCHAR(2) — 결제방법 : 0:결제선생, 1:수동
- PAYMENT_NOTE — VARCHAR(255)
- DUE_DATE — INT
- DEPOSITOR_NAME — VARCHAR(255)
- OWNER_USER_ID — INT — NOT NULL
- BALANCE — DOUBLE
- PAYSSAM_YN — VARCHAR(1) — Y:결제선생 사용, N:결제선생 미사용
- IS_OPEN_PAYSSAM — TINYINT — 0:미개시, 1:개시
- PAYSSAM_STATUS — VARCHAR(4)
- EXP_YMD — VARCHAR(8) — 납부 만료일
- REP_PHONE_NUMBER — VARCHAR(20)
- IS_PREPAYMENT — TINYINT — 선결제 여부 0:선결제 안함, 1:선결제함
- PREPAYMENT_PERIOD — INT — 선결제 기간(개월수)
- CREATEDATE — TIMESTAMP — DEFAULT_GENERATED
- UPDATEDATE — TIMESTAMP — DEFAULT_GENERATED on update CURRENT_TIMESTAMP
TB_DOJANG_BILL_INFO
- COUNTRY_CODE — varchar(4)
- DOJANG_ID — INT — NOT NULL
- BILL_YM — NULL
- BILL_GUBUN_CD — NULL
- USER_ID — INT — NOT NULL
- PAID_YMD — NULL
- IS_PAID — NULL
- PAY_GUBUN_CD — NULL
- PAYING_AMOUNT — NULL
- PAYMENT_NOTE — NULL
- IS_PREPAYMENT — NULL
- PREPAYMENT_GROUP_ID — NULL
- BILL_ID — NULL
- PAYMENT_SEND_YN — NULL
- EXP_YMD — NULL
- CREATEDATE — NULL
- UPDATEDATE — NULL
TB_DOJANG_BILL_INFO_HS
- HS_YMD — NULL
- HS_GUBUN_CD — NULL
- COUNTRY_CODE — varchar(4)
- DOJANG_ID — INT — NOT NULL
- BILL_YM — NULL
- BILL_GUBUN_CD — NULL
- USER_ID — INT — NOT NULL
- PAID_YMD — NULL
- IS_PAID — NULL
- PAY_GUBUN_CD — NULL
- PAY_METHOD — NULL
- PAYING_AMOUNT — NULL
- PAYMENT_NOTE — NULL
- IS_PREPAYMENT — NULL
- PREPAYMENT_GROUP_ID — NULL
- BILL_ID — NULL
- CREATEDATE — NULL
- UPDATEDATE — NULL
TB_DOJANG_HC_DEVICE
- COUNTRY_CODE — varchar(4) — NOT NULL
- DOJANG_ID — INT — NOT NULL
- DEVICE_ID — INT — NOT NULL — auto_increment | 기기ID
- SERIAL_NO — varchar(30) — NOT NULL
- REG_DATE — TIMESTAMP — DEFAULT_GENERATED | 등록일
- DEVICE_NO — INT — SelvasDB device(device_no)
TB_DOJANG_HC_GYM
- gym_no — INT — Primary key — NOT NULL — selvasDB gym(gym_no)
- COUNTRY_CODE — varchar(4)
- DOJANG_ID — INT — NOT NULL
TB_DOJANG_HC_LOG
- DOJANG_ID — INT — NOT NULL
- GYM_NO — INT — NOT NULL
- DEVICE_NO — INT — NOT NULL
- ROUTE_PAHT — TEXT — 동작 라우터 경로
- ACTION_TYPE — varchar(100) — 동작 타입(INSERT, UPDATE, DELETE, SELECT)
- REQUEST_INFO — text — req 내용
- MESSAGE — text — 에러 메세지
- CREATEDATE — TIMESTAMP — DEFAULT_GENERATED' ) COMMENT '셀바스에 수련생, 도장, 관장, 사범 업데이트(등록, 수정, 퇴소, 삭제
TB_STUDENT
- STUDENT_ID — INT — Primary key — NOT NULL
- COUNTRY_CODE — VARCHAR(4) — NOT NULL
- DOJANG_ID — INT — NOT NULL
- USER_ID — INT — NOT NULL
- ATTEND_NUM — VARCHAR(10)
- FIRST_NAME — VARCHAR(50)
- LAST_NAME — VARCHAR(50)
- DOB — VARCHAR(8)
- SEX_CODE — VARCHAR(2) — 0:남자 1:여자
- PROFILE_IMG — VARCHAR(200)
- STUDENT_LEVEL — VARCHAR(20)
- POOMDAN_GUEB — INT
- PHONE_NUMBER — VARCHAR(20)
- DOJANG_REG_DATE — VARCHAR(8) — NOT NULL — 도장 등록일자
- ADDRESS_NAME — VARCHAR(255)
- ROAD_ADDRESS — VARCHAR(255)
- REGION_1DEPTH_NAME — VARCHAR(100)
- REGION_2DEPTH_NAME — VARCHAR(100)
- REGION_3DEPTH_NAME — VARCHAR(100)
- REGION_3DEPTH_H_NAME — VARCHAR(100)
- ADDRESS_DETAIL — VARCHAR(100)
- IS_APPROVED — TINYINT
- EMAIL — VARCHAR(100)
- SCHOOL — VARCHAR(100) — NOT NULL
- SCHOOL_GRADE — INT — 1-6: 초등, 7-9: 중등, 10-12: 고등, 12 < 성인
- REP_NAME — VARCHAR(100)
- REP_PHONE_NUMBER — VARCHAR(20)
- REP_REL — VARCHAR(20)
- REP_NAME_2 — VARCHAR(100)
- REP_PHONE_NUMBER_2 — VARCHAR(20)
- REP_REL_2 — VARCHAR(20)
- CAREER — INT — 태권도 경력
- MEMO — VARCHAR(1000)
- PAYING_AMOUNT — DOUBLE
- BILLING_TARGET_ROLE — VARCHAR(20) — 청구서보낼전화번호 'ST','PA1
- PAY_GUBUN_CD — VARCHAR(2) — 결제종류 : 0:카드, 1:현금, 2:계좌이체, 3:결제선생
- PAY_METHOD — VARCHAR(2) — 결제방법 : 0:결제선생, 1:수동 ===> 더이상 사용 안함
- PAYMENT_NOTE — VARCHAR(255) — 납부정보 참고사항
- DUE_DATE — INT — 납부일
- BALANCE — DOUBLE
- SSN — VARCHAR(50)
- LANG_CODE — VARCHAR(2)
- WEIGHT — DOUBLE — 체중
- HEIGHT — DOUBLE — 키
- JUMP_LEVEL — VARCHAR(20) — 줄넘기 급수
- JUMP_CAREER — VARCHAR(20) — 줄넘기 경력
- UNIQUE_ID — VARCHAR(330)
- LEVEL_NUMBER — VARCHAR(255)
- DEPOSITOR_NAME — VARCHAR(255)
- POOMDAN_CERTIFICATE_DATE — VARCHAR(100)
- POOMDAN_CERTIFICATE_NUMBER — VARCHAR(100)
- REST_YN — VARCHAR(1) — NOT NULL — 휴관상태
- REST_YMD — VARCHAR(8) — 휴관일
- DOJANG_DISCHG_DATE — VARCHAR(8) — 도장 퇴소일자도장 퇴소일자
- DISCHG_YN — VARCHAR(1) — NOT NULL — 도장 퇴소 여부 : Y:퇴소
- CREATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED
- UPDATEDATE — TIMESTAMP — NOT NULL — DEFAULT_GENERATED on update CURRENT_TIMESTAMP
- STUDENT_UNIQUE_ID — INT — auto_increment
- EXP_YMD — VARCHAR(8)
- Field