AdminDB
Tables (9)
CLIENT_PROFILES (의뢰인 프로필)
- id (의뢰인 ID) — NOT NULL — Primary key — NOT NULL
- user_id (회원ID) — NOT NULL — Foreign key → USERS.id — NOT NULL
- company_name (회사명) — NOT NULL
- representative_name (대표자명) — NOT NULL
- company_type (업종) — NOT NULL
- business_number (사업자번호) — NOT NULL
- created_at (생성일시) — NOT NULL
- updated_at (수정일시) — NOT NULL
EXPERT_PROFILES (전문가 프로필)
- id (전문가 프로필 ID) — NOT NULL — Primary key — NOT NULL
- user_id (회원ID) — NOT NULL — Foreign key → USERS.id — NOT NULL
- business_name (사업자명) — NULL
- specialty (전문 분야) — NOT NULL
- experience_years (경력 연수) — NOT NULL
- portfolio_description (포트폴리오 설명) — NULL
- is_verified (인증 여부) — NOT NULL
- verified_at (인증일시) — NULL
- created_at (생성일시) — NOT NULL
- updated_at (수정일시) — NOT NULL
EXPERT_VERIFICATIONS (전문가 인증 심사)
- id (심사 ID) — NOT NULL — Primary key — NOT NULL
- expert_profile_id (전문가 ID) — NOT NULL — Foreign key → EXPERT_PROFILES.id — NOT NULL
- reviewed_by (관리자 ID) — NULL — Foreign key → USERS.id — NOT NULL
- status (심사상태) — NOT NULL
- reject_reason (반려사유) — NULL
- requested_at (신청일시) — NOT NULL
- reviewed_at (심사일시) — NULL
- created_at (생성일시) — NOT NULL
- updated_at (수정일시) — NOT NULL
JOB_POSTS (공고)
- id (공고 ID) — NOT NULL — Primary key — NOT NULL
- client_id (의뢰인 ID) — NOT NULL — Foreign key → CLIENT_PROFILES.id — NOT NULL
- title (공고제목) — NOT NULL
- category (카테고리) — NOT NULL
- license_type (필요자격증) — NULL
- work_type (근무형태) — NOT NULL
- budget (예산) — NOT NULL
- region (지역) — NULL
- description (상세설명) — NOT NULL
- bid_deadline (입찰마감일) — NOT NULL
- status (상태) — NOT NULL
- created_at (생성일시) — NOT NULL
- updated_at (수정일시) — NOT NULL
JOB_POST_ADMIN_ACTIONS (관리자 공고 제어 이력)
- id (처리 ID) — NOT NULL — Primary key — NOT NULL
- job_post_id (공고 ID) — NOT NULL — Foreign key → JOB_POSTS.id — NOT NULL
- admin_id (관리자 ID) — NOT NULL — Foreign key → USERS.id — NOT NULL
- action_type (처리유형) — NOT NULL
- reason (처리사유) — NULL
- created_at (처리일시) — NOT NULL
NOTIFICATIONS (알림)
- id (알림 ID) — NOT NULL — Primary key — NOT NULL
- user_id (수신회원 ID) — NOT NULL — Foreign key → USERS.id — NOT NULL
- sent_by (발신관리자 ID) — NOT NULL — Foreign key → USERS.id — NOT NULL
- title (제목) — NOT NULL
- message (내용) — NOT NULL
- notification_type (알림유형) — NOT NULL
- is_read (읽음여부) — NOT NULL
- read_at (읽은일시) — NULL
- created_at (생성일시) — NOT NULL
REPORTS (신고)
- id (신고 ID) — NOT NULL — Primary key — NOT NULL
- target_user_id (대상회원 ID) — NOT NULL — Foreign key → USERS.id — NOT NULL
- reporter_user_id (신고자 ID) — NOT NULL — Foreign key → USERS.id — NOT NULL
- job_post_id (공고 ID) — NOT NULL — Foreign key → USERS.id — NOT NULL
- report_type (신고유형) — NOT NULL
- content (신고내용) — NOT NULL
- status (처리상태) — NOT NULL
- reviewed_at (처리일시) — NULL
- created_at (생성일시) — NOT NULL
USERS (유저)
- id (회원ID) — NOT NULL — Primary key — NOT NULL
- role (회원역할) — NOT NULL
- email (이메일) — UNIQUE NOT NULL
- password_hash (비밀번호) — NOT NULL
- name (이름) — NOT NULL
- phone (연락처) — NOT NULL
- status (계정상태) — NOT NULL
- last_login_at (최근 로그인 일시) — NOT NULL
- created_at (생성일시) — NOT NULL
- updated_at (수정일시) — NOT NULL
USER_SANCTIONS (회원 제재 이력)
- id (제재 ID) — NOT NULL — Primary key — NOT NULL
- target_user_id (대상회원 ID) — NOT NULL — Foreign key → USERS.id — NOT NULL
- admin_id (관리자 ID) — NOT NULL — Foreign key → USERS.id — NOT NULL
- action_type (제재유형) — NOT NULL
- reason (사유) — NULL
- created_at (처리일시) — NOT NULL