ENS

Tables (7)

Career (경력사항)

  • id (경력id) — string — Primary key — NOT NULL
  • id (산업id) — uuid — Foreign key → industry.id — NOT NULL
  • id (유저id) — uuid — Foreign key → User.id — NOT NULL
  • id (직무구분id) — string — Foreign key → positionCategory.id — NOT NULL
  • company (회사명) — string
  • postion (담당직무) — string
  • startDate (입사년월) — date
  • endDate (퇴사년월) — date
  • isCurrent (재직중) — bool
  • adminOnly (운영진만 보기) — bool
  • createdAt (Field)
  • updatedAt (Field2)

Major (전공)

  • id (전공id) — string — Primary key — NOT NULL
  • name (전공명) — string
  • isCustom (사용자입력구분) — string

User (유저)

  • id (유저id) — uuid — Primary key — NOT NULL
  • name (Field) — string
  • password (Field2) — string
  • generation (기수) — number
  • entrance (학번) — number
  • imageUrl (이미지_url) — string
  • phone (전화번호) — number
  • email (이메일) — string
  • linkedin (링크드인 주소) — string
  • nocoffeechat (커피챗 여부) — bool
  • abroad (해외거주여부) — bool
  • memo (메모) — string
  • createdAt (Field3)
  • updatedAt (Field4)
  • deletedAt (Field5)

User_Major (유저_전공 연결)

  • id (전공id) — uuid — Foreign key → Major.id — NOT NULL
  • id (유저id) — uuid — Foreign key → User.id — NOT NULL
  • isPrimary (주전공) — bool

board (자유게시판)

  • id (게시글id) — uuid — Primary key — NOT NULL
  • id (유저id) — uuid — Foreign key → User.id — NOT NULL
  • title (제목) — string
  • category (카테고리) — string
  • content (내용) — string
  • imageUrl (이미지url) — string
  • createdAt (Field)
  • updatedAt (Field2)
  • deletedAt (Field3)

industry (산업군)

  • id (산업id) — number — Primary key — NOT NULL
  • name (산업이름) — string
  • isCustom (사용자입력 구분) — bool
  • createdAt (Field)

positionCategory (직무구분)

  • id (직무구분id) — string — Primary key — NOT NULL
  • name (직무구분이름) — string
  • isCustom (사용자입력 구분) — string
  • createdAt (Field)
  • updatedAt (Field2)
  • deletedAt (Field3)