ROOM_FIT

Tables (5)

ROUTINE_MODEL (운동모델)

  • MODEL_ID (모델_ID) — BIGINT — Primary key — NOT NULL
  • TOTAL_POSE_CNT (총 자세 개수) — INT
  • TOTAL_TIME (총 시간) — INT

ROUTINE_MODEL_POSE (운동모델자세)

  • POSE_ID (운동모델자세_ID) — BIGINT — Primary key — NOT NULL
  • MODEL_ID (모델_ID) — BIGINT — Foreign key → ROUTINE_MODEL.MODEL_ID — NOT NULL
  • SEQ_NUM (순서번호) — INT
  • POSE_DUR (자세 시간) — INT
  • FILE_SOURCE (대표사진/영상) — VARCHAR

USER (사용자)

  • USER_ID (사용자_ID) — BIGINT — Primary key — NOT NULL
  • PASSWORD (비밀번호) — VARCHAR

USER_LOG (사용자 이력)

  • USER_LOG_ID (사용자_이력_ID) — BIGINT — Primary key — NOT NULL
  • START_TIME (운동시작시간) — DATETIME
  • END_TIME (운동종료시간) — DATETIME
  • USER_ID (사용자_ID) — BIGINT — Foreign key → USER.USER_ID — NOT NULL

USER_ROUTINE_MODEL (사용자 운동모델)

  • USER_MODEL_ID (사용자_운동모델_ID) — BIGINT — Primary key — NOT NULL
  • USER_ID (사용자_ID) — BIGINT — Foreign key → USER.USER_ID — NOT NULL
  • MODEL_ID (모델_ID2) — BIGINT — Foreign key → ROUTINE_MODEL.MODEL_ID — NOT NULL