수정

테이블 (54)

branch_equipment_cleaning

  • id — int — 기본 키 — NOT NULL
  • user_count — int
  • created_at — datetime
  • branch_equipment_id — int — 외래 키 → 운동 공간 내 기구.id
  • staff_id — int — 외래 키 → branch_staff.id

branch_equipment_view

  • id — INT — NOT NULL
  • sequence_id — INT
  • set_number — INT
  • time — BIGINT
  • weight — FLOAT
  • count — BIGINT
  • created_at — DATETIME
  • created_by — INT

branch_excess_record (branch_access_record)

  • id — int — 기본 키 — NOT NULL
  • enter_time — datetime
  • exit_time — datetime
  • member_id — int — 외래 키 → 회원.id
  • branch_id — int — 외래 키 → 운동공간(지점).id

branch_info

  • id — int — 기본 키 — NOT NULL
  • manager_name — varchar(255)
  • manager_number — varchar(255)
  • area — int
  • registeration_number — varchar(255)
  • type — int
  • created_at — datetime
  • branch_id — int — 외래 키 → 운동공간(지점).id

branch_management_step

  • id — int — 기본 키 — NOT NULL
  • step — int
  • created_at — datetime
  • branch_id — int — 외래 키 → 운동공간(지점).id

branch_staff

  • id — int — 기본 키 — NOT NULL
  • user_id — varchar(255)
  • password — varchar(255)
  • name — varchar(255)
  • number — varchar(255)
  • birth — varchar(255)
  • gender — varchar(255)
  • created_at — datetime
  • working_at — datetime
  • status — int
  • role — varchar(255)
  • refresh_token — varchar(255)
  • qrcode — varchar(255)
  • branch_id — int — 외래 키 → 운동공간(지점).id
  • image — int — 외래 키 → image.id

challenge

  • id — int — 기본 키 — NOT NULL
  • start_date — date — NOT NULL
  • end_date — date — NOT NULL
  • name — varchar(255) — NOT NULL
  • type — char(1) — NOT NULL
  • content — varchar(255) — NOT NULL
  • goal — varchar(255) — NOT NULL
  • goal_count — int — NOT NULL
  • capacity — int — NOT NULL
  • current_capacity — int — NOT NULL
  • check_day — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • target — char(2) — NOT NULL
  • staff_id — int — 외래 키 → branch_staff.id
  • image — int — 외래 키 → image.id

challenge_member

  • id — int — 기본 키 — NOT NULL
  • review_check — tinyint — NOT NULL
  • challenge_id — int — 외래 키 → challenge.id
  • member_id — int — 외래 키 → 회원.id

challenge_notice

  • id — int — 기본 키 — NOT NULL
  • content — text — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • read_member — varchar(255)
  • challenge_id — int — 외래 키 → challenge.id

competition_achievement

  • id — int — 기본 키 — NOT NULL
  • content — varchar(255) — NOT NULL
  • feed_back — varchar(255)
  • check_achievement — tinyint
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • feedback_created_at — datetime
  • feedback_updated_at — datetime
  • round — int — NOT NULL
  • status — tinyint — NOT NULL
  • challenge_link_id — int — 외래 키 → challenge_member.id
  • image_id — int — 외래 키 → image_link.id
  • challenge_id — int — 외래 키 → challenge.id

delete_record_sequence

  • id — int — 기본 키 — NOT NULL
  • plan_date — datetime
  • rest_time — int
  • created_at — date
  • status — int
  • member_id — int — 외래 키 → 회원.id
  • exercise_id — int — 외래 키 → exercise.id
  • branch_equipment_id — int — 외래 키 → 운동 공간 내 기구.id

delete_record_set_perform

  • id — int — 기본 키 — NOT NULL
  • set_number — int
  • time — int
  • weight — int
  • count — int
  • distance — int
  • chart — varchar(255)
  • performed_at — datetime
  • sequence_id — int — 외래 키 → delete_record_sequence.id
  • created_by — int — 외래 키 → 회원.id

delete_record_set_perform_edit

  • id — int — 기본 키 — NOT NULL
  • weight — int
  • count — int
  • distance — int
  • type — int
  • edited_at — datetime
  • perform_id — int — 외래 키 → 실제 운동 기록.id

delete_record_set_plan

  • id — int — 기본 키 — NOT NULL
  • set_number — int
  • time — int
  • weight — int
  • count — int
  • created_at — datetime
  • sequence_id — int — 외래 키 → delete_record_sequence.id
  • created_by — int — 외래 키 → 회원.id

delete_record_set_plan_edit

  • id — int — 기본 키 — NOT NULL
  • time — int
  • weight — int
  • count — int
  • type — int
  • edited_at — datetime
  • plan_id — int — 외래 키 → delete_record_set_plan.id

equipment

  • id — int — 기본 키 — NOT NULL
  • name — varchar(255)
  • tracker_type — varchar(255)
  • img_url — varchar(255)

exercise

  • id — int — 기본 키 — NOT NULL
  • name_kr — varchar(255)
  • name_en — varchar(255)
  • part — varchar(255)
  • type — int
  • website_url — varchar(255)
  • gif_url — varchar(255)
  • img_url — varchar(255)
  • youtube_url — varchar(255)
  • level — int

exercise_equipment

  • id — int — 기본 키 — NOT NULL
  • equipment_id — int — 외래 키 → equipment.id
  • exercise_id — int — 외래 키 → exercise.id

exercise_part

  • id — int — 기본 키 — NOT NULL
  • name_kr — int
  • exercise_name — int — 외래 키 → exercise.id

fixed_review

  • id — int — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • staff_id — int — 외래 키 → branch_staff.id
  • fixed_review_id — int — 외래 키 → fixed_review_content.id

fixed_review_content

  • id — int — 기본 키 — NOT NULL
  • content — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

image

  • id — int — 기본 키 — NOT NULL
  • file_name — varchar(255)
  • file_path — varchar(255) — NOT NULL
  • mime_type — varchar(255)
  • file_size — int
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • image_link_id — int — 외래 키 → image_link.id

image_link

  • id — int — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime

immersive_achievement

  • id — int — 기본 키 — NOT NULL
  • content — varchar(255) — NOT NULL
  • feed_back — varchar(255)
  • check_achievement — tinyint
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • feedback_created_at — datetime
  • feedback_updated_at — datetime
  • round — int — NOT NULL
  • status — tinyint — NOT NULL
  • challenge_link_id — int — 외래 키 → challenge_member.id
  • image_id — int — 외래 키 → image_link.id
  • challenge_id — int — 외래 키 → challenge.id

lite_achievement

  • id — int — 기본 키 — NOT NULL
  • content — varchar(255) — NOT NULL
  • feed_back — varchar(255)
  • check_achievement — tinyint
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • feedback_created_at — datetime
  • feedback_updated_at — datetime
  • round — int — NOT NULL
  • status — tinyint — NOT NULL
  • challenge_link_id — int — 외래 키 → challenge_member.id
  • image_id — int — 외래 키 → image_link.id
  • challenge_id — int — 외래 키 → challenge.id

member_pro

  • id — int — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime
  • member_id — int — 외래 키 → 회원.id
  • pro_code_id — int — 외래 키 → member_pro_code.id

member_pro_code

  • id — int — 기본 키 — NOT NULL
  • code — varchar(255) — NOT NULL
  • created_at — date — NOT NULL
  • expired_date — date — NOT NULL

member_withdrawal

  • id — int — 기본 키 — NOT NULL
  • nick_name — varchar(255)
  • user_id — varchar(255)
  • password — varchar(255)
  • birth — datetime
  • gender — varchar(255)
  • created_at — datetime
  • deleted_at — datetime
  • reason — varchar(255)
  • branch_id — int — 외래 키 → 운동공간(지점).id

notice

  • id — int — 기본 키 — NOT NULL
  • title — varchar(255)
  • contents — varchar(255)
  • created_at — datetime
  • updated_at — datetime
  • staff_id — int — 외래 키 → branch_staff.id

notice_read_member_view

  • notice_id — INT — NOT NULL
  • challenge_id — INT
  • should_read — TEXT
  • read_member — VARCHAR(1)

recommend_exercise

  • id — int — 기본 키 — NOT NULL
  • type — int
  • created_at — datetime
  • exercise_id — int — 외래 키 → exercise.id

recommend_routine

  • id — int — 기본 키 — NOT NULL
  • type — int
  • created_at — datetime
  • routine_id — int — 외래 키 → routine.id

record_set_perform_view

  • id — INT — NOT NULL
  • sequence_id — INT
  • set_number — INT
  • time — INT
  • weight — FLOAT
  • count — BIGINT
  • distance — FLOAT
  • performed_at — DATETIME
  • chart — VARCHAR(1)
  • created_by — INT

record_set_plan_view

  • id — INT — NOT NULL
  • sequence_id — INT
  • set_number — INT
  • time — BIGINT
  • weight — FLOAT
  • count — BIGINT
  • created_at — DATETIME
  • created_by — INT

record_start_time

  • id — int — 기본 키 — NOT NULL
  • start_at — datetime
  • created_at — datetime
  • member_id — int — 외래 키 → 회원.id

routine

  • id — int — 기본 키 — NOT NULL
  • name — varchar(255)
  • description — varchar(255)
  • type — varchar(255)
  • member_id — int — 외래 키 → 회원.id
  • status — tinyint
  • created_at — datetime
  • img_url — varchar(255)
  • is_deleted — tinyint — NOT NULL

routine_connection

  • id — int — 기본 키 — NOT NULL

routine_sequence

  • id — int — 기본 키 — NOT NULL
  • exercise_id — int — 외래 키 → exercise.id
  • routine_id — int — 외래 키 → routine.id
  • rest_time — int
  • status — tinyint

routine_set

  • id — int — 기본 키 — NOT NULL
  • routine_sequence_id — int — 외래 키 → routine_sequence.id
  • set_number — int
  • time — int
  • weight — int
  • count — int

staff_review

  • id — int — 기본 키 — NOT NULL
  • contents — varchar(255)
  • created_at — datetime
  • updated_at — datetime
  • staff_id — int — 외래 키 → branch_staff.id

suggestions

  • id — int — 기본 키 — NOT NULL
  • contents — varchar(255)
  • created_at — datetime
  • member_id — int — 외래 키 → 회원.id

tracker

  • id — int — 기본 키 — NOT NULL
  • type — varchar(255)
  • name — varchar(255)
  • uuid — varchar(255)
  • rxchar — varchar(255)
  • txchar — varchar(255)
  • sku — varchar(255)
  • manufacturer — varchar(255)
  • created_at — datetime
  • manager — int

typeorm_metadata

  • type — varchar(255) — NOT NULL
  • database — varchar(255)
  • schema — varchar(255)
  • table — varchar(255)
  • name — varchar(255)
  • value — text

기구 운용 상태 기록 (branch_equipment_info)

  • id — int — 기본 키 — NOT NULL
  • start_time — datetime
  • end_time — datetime
  • status — int
  • branch_equipment_id — int — 외래 키 → 운동 공간 내 기구.id
  • member_id — int — 외래 키 → 회원.id
  • staff_id — int — 외래 키 → branch_staff.id

실제 운동 기록 (record_set_perform)

  • id — int — 기본 키 — NOT NULL
  • set_number — int
  • time — int
  • weight — float
  • count — int
  • distance — float
  • chart — varchar(255)
  • performed_at — datetime
  • sequence_id — int — 외래 키 → 운동 시간 계획.id
  • created_by — int — 외래 키 → 회원.id

실제 운동 기록 수정 이력 (record_set_perform_edit)

  • id — int — 기본 키 — NOT NULL
  • weight — float
  • count — int
  • distance — float
  • type — int
  • edited_at — datetime
  • perform_id — int — 외래 키 → 실제 운동 기록.id

앱 버전 (app_version)

  • id — int — 기본 키 — NOT NULL
  • app_id — int
  • version_code — int
  • version_name — varchar(255)
  • is_essential — tinyint
  • updatea_at — datetime

운동 계획 (record_set_plan)

  • id — int — 기본 키 — NOT NULL
  • set_number — int
  • time — int
  • weight — float
  • count — int
  • created_at — datetime
  • sequence_id — int — 외래 키 → 운동 시간 계획.id
  • created_by — int — 외래 키 → 회원.id

운동 계획 수정 이력 (record_set_plan_edit)

  • id — int — 기본 키 — NOT NULL
  • time — int
  • weight — float
  • count — int
  • type — int
  • edited_at — datetime
  • plan_id — int — 외래 키 → 운동 계획.id

운동 공간 내 기구 (branch_equipment)

  • id — int — 기본 키 — NOT NULL
  • branch_id — int — 외래 키 → 운동공간(지점).id
  • equipment_id — int — 외래 키 → equipment.id
  • tracker_id — int — 외래 키 → tracker.id
  • type — int

운동 시간 계획 (record_sequence)

  • id — int — 기본 키 — NOT NULL
  • plan_date — date
  • rest_time — int
  • created_at — datetime
  • status — int
  • member_id — int — 외래 키 → 회원.id
  • exercise_id — int — 외래 키 → exercise.id
  • branch_equipment_id — int — 외래 키 → 운동 공간 내 기구.id

운동공간(지점) (branch)

  • id — int — 기본 키 — NOT NULL
  • name — varchar(255)
  • address — varchar(255)
  • number — varchar(255)
  • type — int
  • img_url — varchar(255)
  • url — varchar(255)
  • business_hours — varchar(255)
  • member_id — int — 외래 키 → 회원.id

회원 (member)

  • id — int — 기본 키 — NOT NULL
  • nick_name — varchar(255)
  • user_id — varchar(255)
  • password — varchar(255)
  • birth — date
  • gender — varchar(255)
  • created_at — datetime
  • refresh_token — varchar(255)
  • branch_id — int — 외래 키 → 운동공간(지점).id

회원 신체 정보 (member_physical_information)

  • id — int — 기본 키 — NOT NULL
  • 키 (height) — double
  • weight — double
  • muscle — double
  • fat — double
  • created_at — datetime
  • member_id — int — 외래 키 → 회원.id