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)