2323

Tables (7)

agency_profiles

  • id — bigint
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • company_name — varchar(100) — NOT NULL — 기업명
  • business_registration_number — varchar(20) — NOT NULL — 사업자등록번호
  • representative_name — varchar(50) — NOT NULL — 대표자명
  • registration_document_url — varchar(255) — 사업자등록증 이미지 또는 PDF 경로
  • verification_status — varchar(20) — NOT NULL — PENDING(대기), APPROVED(승인), REJECTED(반려)
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • deleted_at — datetime

refresh_tokens

  • id — bigint
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • device_id — varchar(100) — NOT NULL
  • token_hash — varchar(64) — NOT NULL
  • expires_at — datetime — NOT NULL
  • is_revoked — tinyint(1) — NOT NULL
  • revoked_at — datetime
  • last_used_at — datetime
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • deleted_at — datetime

social_accounts

  • id — bigint — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • provider — varchar(20) — NOT NULL — kakao, naver, google, apple 등
  • provider_id — varchar(255) — NOT NULL — SNS 측 고유 식별자 값 (Sub)
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • deleted_at — datetime

user_agreements

  • id — bigint — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • is_privacy_agreed — tinyint(1) — NOT NULL
  • is_legal_representative_agreed — tinyint(1) — NOT NULL — 미성년자 법정대리인 동의
  • agreed_at — datetime — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • deleted_at — datetime

user_identities

  • id — bigint — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • is_identity_verified — tinyint(1) — NOT NULL — 본인인증 완료 여부
  • ci — varchar(255) — 본인인증 고유 식별자 (Connecting Information). 스펙 변경 대비해서 255
  • di — varchar(255) — 중복 가입 확인용 식별자 (Duplication Information)
  • verified_at — datetime — 인증 완료 일시
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • deleted_at — datetime

user_profiles

  • id — bigint — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • name — varchar(50) — NOT NULL
  • cell_phone — varchar(20) — NOT NULL — unique Index ex: (+82-2-1234-5678 ext 201)
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • deleted_at — datetime

users

  • id — bigint
  • public_id — char(26) — NOT NULL — unique, secondary, ULID(26 byte 고정 길이)
  • email — varchar(255) — NOT NULL — unique Index (중복 가입 방지)
  • password — varchar(255) — NOT NULL — (not null), SNS (null)
  • status — varchar(20) — NOT NULL — ACTIVE, DORMANT, BANNED, WAITING_VERIFICATION
  • role — varchar(20) — NOT NULL — USER(구직자)/ADMIN(관리자)/AGENCY(기획사)
  • last_login_at — datetime
  • password_changed_at — datetime
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • deleted_at — datetime