nextpick
Tables (17)
boards (게시판)
- id (Key) — Not Null — Primary key — NOT NULL
- member_id (회원 순번) — Not Null — Foreign key → members.id — NOT NULL
- image_id (이미지 순번) — Not Null — Foreign key → images.id — NOT NULL
- member_nickname (회원 닉네임) — Not Null
- title (제목) — Not Null
- content (내용) — Not Null
- dtype (게시판 종류) — Not Null
- view (조회수) — Not Null
- like_count (좋아요수) — Not Null
- create_at (생성 시간) — Not Null
- modified_at (수정 시간) — Not Null
comments (댓글)
- id (Key) — Not Null — Primary key — NOT NULL
- board_id (게시판 순번) — Not Null — Foreign key → boards.id — NOT NULL
- member_id (회원 순번) — Not Null — Foreign key → members.id — NOT NULL
- parent_id (부모댓글 순번) — Foreign key → comments.id — NOT NULL
- content (내용) — Not Null
- create_at (생성 시간) — Not Null
- modified_at (수정 시간) — Not Null
images (게시물 이미지)
- id (Key) — Not Null — Primary key — NOT NULL
- image_url (이미지 url) — Not Null
interview_feedbacks (면접 피드백)
- id (Key) — Not Null — Primary key — NOT NULL
- mentee (멘티) — Not Null — Foreign key → members.id — NOT NULL
- mentor (멘토) — Not Null — Foreign key → members.id — NOT NULL
- room_id (면접방 순번) — Not Null
- content (피드백 내용) — Not Null
- create_at (생성 시간) — Not Null
interview_rooms (면접방)
- id (Key) — Not Null — Primary key — NOT NULL
- member_id (멘토) — Not Null — Foreign key → members.id — NOT NULL
- title (제목) — Not Null
- uuid (방코드) — Not Null
- category (카테고리) — Not Null
interview_times (면접 시간)
- id (Key) — Not Null — Primary key — NOT NULL
- member_id (멘토) — Not Null — Foreign key → members.id — NOT NULL
- room_id (면접방 순번) — Not Null
- start_time (시작 시간) — Not Null
- end_time (종료 시간)
likes (좋아요)
- id (Key) — Not Null — Primary key — NOT NULL
- board_id (게시판 순번) — Not Null — Foreign key → boards.id — NOT NULL
- member_id (회원 순번) — Not Null — Foreign key → members.id — NOT NULL
member_roles (회원 권한)
- id (Key) — Not Null — Primary key — NOT NULL
- member_id (회원 순번) — Not Null — Foreign key → members.id — NOT NULL
- role_name (권한 이름) — Not Null
members (회원)
- id (Key) — Not Null — Primary key — NOT NULL
- name (이름) — Not Null
- gender (성별) — Not Null
- email (이메일) — Not Null
- password (비밀번호) — Not Null
- nickname (닉네임) — Not Null
- guilty_score (유죄 점수) — Not Null
- member_status (회원 상태) — Not Null
- career (경력) — Not Null
- occupation (직군) — Not Null
- create_at (생성 시간) — Not Null
- modified_at (수정 시간) — Not Null
- member_type (회원 타입) — Not Null
mentor_feedbacks (멘토 피드백)
- Key — Not Null — Primary key — NOT NULL
- mentee (멘티) — Not Null — Foreign key → members.id — NOT NULL
- mentor (멘토) — Not Null — Foreign key → members.id — NOT NULL
- content (내용) — Not Null
- create_at (생성 시간) — Not Null
- star_rating (별점) — Not Null
participants (참여자)
- id (Key) — Not Null — Primary key — NOT NULL
- room_id (면접방 순번) — Not Null — Foreign key → interview_rooms.id — NOT NULL
- member_id (참여자) — Not Null — Foreign key → members.id — NOT NULL
question_boards (면접 질문 게시판)
- board_id (Key) — Not Null — Foreign key → boards.id — NOT NULL
- category (카테고리) — Not Null
question_categories (질문 카테고리)
- id (Key) — Not Null — Primary key — NOT NULL
- name (카테고리 이름) — Not Null
question_lists (면접 질문 리스트)
- id (Key) — Not Null — Primary key — NOT NULL
- question_category_id (질문 카테고리) — Not Null — Foreign key → question_categories.id — NOT NULL
- question (질문) — Not Null
- answer (정답) — Not Null
- correct_count (맞은수) — Not Null
- wrong_count (틀린수) — Not Null
- correct_rate (정답률) — Not Null
- question_status (질문 상태) — Not Null
reports (신고)
- id (Key) — Not Null — Primary key — NOT NULL
- reporter (신고자) — Not Null — Foreign key → members.id — NOT NULL
- respondent (신고대상) — Not Null — Foreign key → members.id — NOT NULL
- content (신고 사유) — Not Null
- create_at (생성 시간) — Not Null
review_boards (면접 후기)
- board_id (Key) — Not Null — Foreign key → boards.id — NOT NULL
solves (푼 문제)
- id (Key) — Not Null — Primary key — NOT NULL
- question_list_id (면접 질문 순번) — Not Null — Foreign key → question_lists.id — NOT NULL
- member_id (회원 순번) — Not Null — Foreign key → members.id — NOT NULL
- correct (맞춤) — Not Null
- my_answer (회원 대답)
- create_at (생성 시간) — Not Null
- modified_at (수정 시간) — Not Null