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