JobCrew
Tables (3)
auth (Untitled3)
- id (기본키) — bigint — Primary key — NOT NULL
- id (유저id) — bigint — Foreign key → user.id — NOT NULL
- created_at (생성일시) — timestamp
- updated_at (수정일시) — timestamp
- email (이메일) — varchar(100)
- last_login_at (마지막 로그인시각) — timestamp
- password_hash (패스워드)
- provider (소셜로그인) — varchar(50)
- provider_user_id (소셜로그인아이디)
- refresh_token (리프레시토큰) — vharchar255
- refresh_token_expire (리프레시토큰 만료일) — timestamp
user (Untitled2)
- id (유저id) — bigint — Primary key — NOT NULL
- created_at (생성일시) — timestamp
- updated_at (수정일시) — timestamp
- active (활성화계정) — boolean
- email (사용자이메일) — varchar
- nickname (닉네임) — varchar
- role (권한) — varchar
userprofile (Untitled)
- id (유저id) — bigint — Foreign key → user.id — NOT NULL
- username (실명) — varchar(50)
- created_at (생성일시) — timestamp
- updated_at (수정일시) — timestamp
- age (나이) — int
- avatar_url (프로필사진) — varchar(255)
- carrer_type (경력/신입) — varchar
- completed (프로필완료여부) — boolean
- education_level (최종학력) — int
- gender (성별) — varchar
- interest_job (관심직무)
- interest_skills (관심스킬)
- major (전공여부)
- region (지역)
- skill (보유스킬)