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 (보유스킬)