x-fit
Tables (14)
box
- id — int — Primary key — NOT NULL — Auto Increment
- name — char(20) — NOT NULL
- address — varchar(255)
- phone — varchar(20)
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- description — varchar(255)
exercise
- id — int — Primary key — NOT NULL — Auto Increment
- id2 — int — Foreign key → part_of_body.id — NOT NULL
- name — varchar(20)
- detail_description — varchar(255)
- Field — VARCHAR(255)
notice
- id — int — Primary key — NOT NULL — Auto Increment
- notice_category_id — int — Foreign key → notice_category.id — NOT NULL
- box_id — int — Foreign key → box.id — NOT NULL
- created_by — int — Foreign key → user.사용자 id — NOT NULL
- id2 — int — Foreign key → user.wod_level_id — NOT NULL — Auto Increment
- title — varchar(255)
- content — varchar(255)
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- is_exposed — boolean
- the_top — boolean
notice_category
- id — int — Primary key — NOT NULL — Auto Increment
- id2 — int — Foreign key → box.id — NOT NULL
- created_by — int — Foreign key → user.사용자 id — NOT NULL
- id22 — int — Foreign key → user.wod_level_id — NOT NULL — Auto Increment
- name — varchar(255)
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
part_of_body
- id — int — Primary key — NOT NULL — Auto Increment
- name — varchar(20)
user
- 사용자 id (id) — int — Primary key — NOT NULL — Auto Increment
- 유저 등급 id (user_grade_id) — int — Foreign key → user_grade.아이디 — NOT NULL
- wod_level_id — int — Foreign key → wod_level.id — NOT NULL — Auto Increment
- nickname — VARCHAR(255) — NOT NULL — UNIQUE
- hashed_pw — VARCHAR(255) — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- box_id — int — NOT NULL — Auto Increment
- email — varchar(50) — UNIQUE
- cellphone — varchar(20) — UNIQUE
- join_type — varchar(7)
- null — char(20)
- gender — char(15) — 타입은 ENUM("M", "W")
- birth_year — int
- height — int
- weight — int
- is_deleted — bool
user_grade
- 아이디 (id) — int — Primary key — NOT NULL — Auto Increment
- 등급 (name) — char(20)
- 등급 설명 (description) — varchar(255)
- 생성일 (created_at) — datetime(6)
- 수정일 (updated_at) — datetime(6)
wod
- id — int — Primary key — NOT NULL — Auto Increment
- box_id — int — Foreign key → box.id — NOT NULL
- created_by — int — Foreign key → user.사용자 id — NOT NULL
- id2 — int — Foreign key → user.wod_level_id — NOT NULL — Auto Increment
- wod_date — datetime(6)
- title — varchar(255)
- explanation — varchar(1023)
- deleted_at — datetime(6)
- created_at — datetime(6)
- updated_at — datetime(6)
- is_exposed — boolean
- 와드게시자 — VARCHAR(255)
wod_by_level
- id — int — Primary key — NOT NULL — Auto Increment
- wod_id — int — Foreign key → wod.id — NOT NULL
- id2 — int — Foreign key → wod.id2 — NOT NULL — Auto Increment
- wod_level_id — int — Foreign key → wod_level.id — NOT NULL
- content — varchar(2048)
- rocord_form_uid — varchar(255) — mongo db와 연결하기기 위한 uid
- ranking_algorithm_uid — varchar(255) — mongo db와 연결하기 위한 uid
wod_instant_team
- id — int — Primary key — NOT NULL — Auto Increment
- user_id — int — Foreign key → user.사용자 id — NOT NULL
- id2 — int — Foreign key → user.wod_level_id — NOT NULL — Auto Increment
- wod_record_id — int — Foreign key → wod_record.id — NOT NULL
wod_level
- id — int — Primary key — NOT NULL — Auto Increment
- id2 — int — Foreign key → box.id — NOT NULL
- name — varchar(255)
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- level_no — int — 작을 수록 잘하는 등급
- created_by — VARCHAR(255)
wod_ranking_staticstics
- id — int — Primary key — NOT NULL — Auto Icrement
- wod_id — int — Foreign key → wod.id — NOT NULL
- id2 — int — Foreign key → wod.id2 — NOT NULL — Auto Increment
- wod_record_id — int — Foreign key → wod_record.id — NOT NULL
- ranking_no — int — UNIQUE
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
wod_record
- id — int — Primary key — NOT NULL — Auto Increment
- wod_id — int — Foreign key → wod.id — NOT NULL
- id2 — int — Foreign key → wod.id2 — NOT NULL — Auto Increment
- register — int
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- mongo_record_uid — varchar(255) — mongo db 와 연결하기 위한 uid
- 속성 — 아님` — back_populates = True
x_rm_record
- id — int — Primary key — NOT NULL — Auto Increment
- exercise_id — int — Foreign key → exercise.id — NOT NULL
- user_id — int — Foreign key → user.사용자 id — NOT NULL
- id2 — int — Foreign key → user.wod_level_id — NOT NULL — Auto Increment
- repetition — int
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- excuted_at — datetime(6)
- maximum_weight — int