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