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 (생성 시간)