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