soma - 2023-06-06 06:41:50
Tables (15)
chatting_file (채팅 파일)
- id (Key) — INT — Primary key — NOT NULL
- chatting_room_id (Key2) — INT — Foreign key — NOT NULL
- message_from (발신자) — INT
- message_to (수신자) — INT
- file_url (파일 URL) — VARCHAR
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
- is_deleted (삭제유무) — BOOLEAN — NOT NULL
chatting_message (채팅 메시지)
- id (Key) — BIGINT — Primary key — NOT NULL
- chatting_room_id (채팅방 기본키) — INT — Foreign key — NOT NULL
- message_from (발신자) — INT
- message_to (수신자) — INT
- content (내용) — VARCHAR
- created_at (생성일) — TIMESTAMP — NOT NULL
- updated_at (수정일) — TIMESTAMP
- is_deleted (삭제유무) — BOOLEAN — NOT NULL
chatting_participate (채팅 참여)
- id (Key) — INT — Primary key — NOT NULL
- chatting_room_id (채팅방 기본키) — INT — Foreign key — NOT NULL
- expert_id (전문가 기본키) — INT — Foreign key — NOT NULL
- member_id (일반멤버 기본키) — INT — Foreign key — NOT NULL
- created_at (생성일) — TIMESTAMP — NOT NULL
- updated_at (수정일) — TIMESTAMP
- is_deleted (삭제유무) — BOOLEAN — NOT NULL
chatting_room (채팅방)
- id (Key) — INT — Primary key — NOT NULL
- room_name (채팅방 이름) — VARCHAR — NOT NULL
- status (상태) — VARCHAR
- created_at (생성일) — TIMESTAMP — NOT NULL
- updated_at (수정일) — TIMESTAMP
- is_deleted (삭제유무) — BOOLEAN — NOT NULL
exercise_diary (운동 일지)
- id (Key) — INT — Primary key — NOT NULL
- online_PT_id (비대면 PT 기본키) — INT — Foreign key — NOT NULL
- detail (운동일지 내용) — TEXT
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
- is_deleted (삭제유무) — BOOLEAN — NOT NULL
exercise_diary_feedback (운동 일지 피드백)
- id (Key) — INT — Primary key — NOT NULL
- exercise_diary_file_id (운동 일지 파일 기본키) — INT — Foreign key — NOT NULL
- feedback (피드백) — VARCHAR
- tiemline (피드백할 타임라인) — TIME — NOT NULL
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
- is_deleted (삭제유무) — BOOLEAN — NOT NULL
exercise_diary_file (운동 일지 파일)
- id (Key) — INT — Primary key — NOT NULL
- exercise_diary_id (운동일지 기본키) — INT — Foreign key — NOT NULL
- file_url (파일 url) — VARCHAR
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
- is_deleted (삭제유무) — BOOLEAN — NOT NULL
expert (전문가)
- id (Key) — INT — Primary key — NOT NULL
- verification_file_url (자격검증을 위한 파일) — VARCHAR
- veritied (전문가 검증) — BOOLEAN
- email (이메일) — VARCHAR — NOT NULL
- social (소셜로그인) — VARCHAR — NOT NULL
- profile_picture_url (프로필사진) — VARCHAR
- name (이름) — VARCHAR
- birthday (생년월일) — DATETIME
- nickname (닉네임) — VARCHAR
- gender (성별) — VARCHAR
- height (키) — FLOAT
- weight (몸무게) — FLOAT
- sport (주력 운동 분야) — VARCHAR
- introduce (소개글) — VARVHAR
- review_rating (리뷰 평점 평균) — FLOAT
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
- is_deleted (삭제유무) — BOOLEAN — NOT NULL
meeting (미팅)
- id (Key) — INT — Primary key — NOT NULL
- expert_id (전문가 기본키) — INT — Foreign key
- member_id (일반멤버 기본키) — INT — Foreign key
- host_type (호스트 타입) — VARCHAR — NOT NULL
- title (제목) — VARCHAR — NOT NULL
- start_time (시작 시간) — TIMESTAMP — NOT NULL
- end_time (마지막 시간) — TIMESTAMP — NOT NULL
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
- is_deleted (삭제유무) — BOOLEAN — NOT NULL
member (일반멤버)
- id (Key) — INT — Primary key — NOT NULL
- email (이메일) — VARCHAR — NOT NULL
- social (소셜로그인) — VARCHAR — NOT NULL
- profile_picture_url (프로필사진) — VARCHAR
- name (이름) — VARCHAR
- birthday (생년월일) — DATETIME
- nickname (닉네임) — VARCHAR
- gender (성별) — VARCHAR
- height (키) — FLOAT
- weight (몸무게) — FLOAT
- purpose (PT목적) — VARCHAR
- preferred_excercise (선호하는 운동) — VARCHAR
- role (권한) — VARCHAR — NOT NULL
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
- is_deleted (삭제유무) — BOOLEAN — NOT NULL
online_PT (비대면 PT)
- id (Key) — INT — Primary key — NOT NULL
- expert_id (전문가 기본키) — INT — Foreign key — NOT NULL
- member_id (일반멤버 기본키) — INT — Foreign key — NOT NULL
- contact_type (컨택 유형) — VARCHAR
- payment (결제 유무) — BOOLEAN
- review (리뷰) — VARCHAR — NOT NULL
- reveiw_rating (리뷰평점) — INT — NOT NULL
- re_review (대댓글) — VARCHAR
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
- is_deleted (삭제유무) — BOOLEAN — NOT NULL
survey (설문조사)
- id (Key) — INT — Primary key — NOT NULL
- expert_id (전문가 기본키) — INT — Foreign key — NOT NULL
- title (제목) — VARCHAR — NOT NULL
- detail (설명) — VARCHAR
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
- is_deleted (삭제유무) — BOOLEAN — NOT NULL
survey_answer (설문조사 응답)
- id (Key) — INT — Primary key — NOT NULL
- survey_question_id (설문조사 질문 기본키) — INT — Foreign key — NOT NULL
- online_PT_id (비대면 PT 기본키) — INT — Foreign key — NOT NULL
- content (응답 내용) — VARCHAR
- long_content (긴 응답 내용) — TEXT
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
- is_deleted (삭제유무) — BOOLEAN — NOT NULL
survey_question (설문조사 질문)
- id (Key) — INT — Primary key — NOT NULL
- survey_id (설문조사 기본키) — INT — Foreign key — NOT NULL
- content (질문 내용) — VARCHAR
- type (질문 유형) — VARCHAR
- order (질문 순서) — INT
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
- is_deleted (삭제유무) — BOOLEAN — NOT NULL
weekly_program (주간 프로그램)
- id (Key) — INT — Primary key — NOT NULL
- online_PT_id (비대면 PT 기본키) — INT — Foreign key — NOT NULL
- week (주차) — INT
- Field2
- Field3
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
- is_deleted (삭제유무) — BOOLEAN — NOT NULL