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