수정
테이블 (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