test

Tables (12)

RoomRoleMapping (테스트룸 유저)

  • room_role_mapping_id (ID) — Primary key — NOT NULL
  • testRoom_id (ID2) — Foreign key → testRoom.testRoom_id — NOT NULL
  • lobby_id (Field) — Foreign key → lobby.lobby_id
  • user_id
  • user_status (유저 상태)
  • user_role (유저 권한)
  • joined_at (참여 시간)
  • invited_at (초대 시간)

lobby (Untitled9)

  • lobby_id (Field) — Primary key
  • lobby_name (Field2)
  • creator (Field3)
  • created_at (Field4)

lobby_testRoom_join (Untitled12)

  • id (Field) — Primary key
  • testRoom_id (ID) — Foreign key → testRoom.testRoom_id — NOT NULL
  • lobby_id (Field2) — Foreign key → lobby.lobby_id

participant_answer (정답)

  • participant_answer_ID (ID) — Primary key — NOT NULL
  • testQuestion_id (테스트 문제 ID) — Foreign key → testQuestion.testQuestion_id — NOT NULL
  • testroom_id (테스트 룸 ID) — Foreign key → testRoom.testRoom_id — NOT NULL
  • submitter_id (제출 아이디)
  • participant_answer (제출 정답)
  • submitted_at (제출 시간)

question_hint (힌트 항목)

  • question_hint_id (ID) — Primary key — NOT NULL
  • testQuestion_id (테스트문제 ID) — Foreign key → testQuestion.testQuestion_id — NOT NULL
  • question_id (question ID)
  • registration_id (사용자 ID)
  • hint_order (힌트 순서)
  • registration_at (등록 시간)

testQuestion (테스트 문제)

  • testQuestion_id (테스트 문제 ID) — Primary key — NOT NULL
  • creator (만든 사람)
  • correct_answer (정답)
  • testQuestion_content (문제 내용)
  • testQuestion_sources (테스트 문제 출처)
  • created_at (만든 시간)

testQuestion_file (Untitled5)

  • file_id (Field) — Primary key
  • file_content (Field2)

testQuestion_file_join (Untitled10)

  • joinId (Key) — Primary key — NOT NULL
  • testQuestion_id (테스트 문제 ID) — Foreign key → testQuestion.testQuestion_id — NOT NULL
  • file_id (Field) — Foreign key → testQuestion_file.file_id

testRoom (테스트룸)

  • testRoom_id (ID) — Primary key — NOT NULL
  • room_name (룸 이름)
  • creator (만든 사람)
  • end_time (마감 시간)
  • start_time (시작 시간)
  • created_at (개설 시간)

testRoom_ message_visibility (Untitled11)

  • message_id (답변 ID) — Foreign key → testRoom_message.message_id
  • user_id (Field)

testRoom_message (테스트룸 메세지)

  • message_id (답변 ID) — Primary key
  • testRoom_id (테스트룸 ID) — Foreign key → testRoom.testRoom_id — NOT NULL
  • testQuestion_id (테스트 문제 ID) — Foreign key → testQuestion.testQuestion_id — NOT NULL
  • reply_id (답변 ID2) — Foreign key → testRoom_message.message_id
  • message_content (답변 내용)
  • sender_id (작성자)
  • answer_type (답변 타입)
  • is_public (Field)

testRoom_question_join (테스트룸 문제 관계)

  • testRoom_question_id (ID) — Primary key — NOT NULL
  • testRoom_id (테스트 룸 ID) — Foreign key → testRoom.testRoom_id — NOT NULL
  • testQuestion_id (테스트 문제 ID) — Foreign key → testQuestion.testQuestion_id — NOT NULL
  • question_order (문제순서)
  • created_at (생성 시간)