db

Tables (4)

CeoEnterprise (기업)

  • id (ID) — bigint — Primary key — NOT NULL
  • user_id (userId) — bigint — Foreign key → User.id — NOT NULL
  • createdAt (생성시간) — Date
  • updatedAt (수정시간) — Date
  • deletedAt (삭제시간) — Date
  • name (이름) — varchar(255)
  • homepage (url) — varchar(255)
  • information (소개) — varchar(255)
  • establishment_date (설립일) — varchar(255)

Code (코드)

  • id (ID) — bigint — Primary key — NOT NULL
  • createdAt (생성시간) — Date
  • updatedAt (수정시간) — Date
  • deletedAt (삭제시간) — Date
  • name (이름) — varchar(255)
  • ord (순서) — Float
  • isUse (사용여부) — boolean

JudgeEnterprise (심사역)

  • id (ID) — bigint — Primary key — NOT NULL
  • user_id (userId) — bigint — Foreign key → User.id — NOT NULL
  • createdAt (생성시간) — Date
  • updatedAt (수정시간) — Date
  • deletedAt (삭제시간) — Date
  • name (이름) — varchar(255)
  • evidence (증빙자료) — varchar(255)
  • careerInformation (경력정보) — varchar(255)
  • industryOfInterest (관심산업) — varchar(255)
  • technologyOfInterest (관심기술) — varchar(255)
  • accountInformation (계좌정보) — varchar(255)

User (사용자)

  • id (ID) — bigint — Primary key — NOT NULL
  • createdAt (생성시간) — bigint
  • updatedAt (수정시간) — Date
  • deletedAt (삭제시간) — Date
  • email (이메일) — varchar(255)
  • auth_id (oauth response id) — varchar(255)
  • auth_type (소셜 로그인 구분) — Enum
  • information (소개) — varchar(255)
  • name (이름) — varchar(255)
  • phoneNumber (핸드폰) — varchar(255)
  • profile (프로필 이미지) — varchar(255)
  • statusr (계정 상태) — Enum
  • type (유저 타입) — Enum