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