BumaView
Tables (7)
ApplicationForm (자소서)
- applicationform_id (Key) — bigint — Primary key — NOT NULL
- path (Field) — varchar(255)
- original_file_name (Field3)
- content_type (Field2) — varchar(255)
- company_occupation (Key2) — bigint — Foreign key → CompanyOccupation.company_occupation — NOT NULL
- company_id (Key3) — bigint — Foreign key → Company.company_id — NOT NULL
- user_id (Key4) — bigint — Foreign key → User.user_id — NOT NULL
Company (회사)
- company_id (Key) — bigint — Primary key — NOT NULL
- company_name (Field)
- company_description (Field2)
- company_type (Field3)
CompanyOccupation (회사 직종)
- company_occupation (Key) — bigint — Primary key — NOT NULL
- occupation_id (Key2) — bigint — Foreign key → Occupation.occupation_id — NOT NULL
- company_id (Key3) — Foreign key → Company.company_id — NOT NULL
InterViewType (면접 종류)
- InterViewType_id (Key) — bigint — Primary key — NOT NULL
- InterView_Type (Field) — enum
Interview (면접)
- interview_id (Key) — bigint — Primary key — NOT NULL
- question_at (Field2) — timestamp
- question (Field3) — TEXT
- answer (Field) — TEXT
- occupation_id (Key4) — bigint — Foreign key → Occupation.occupation_id — NOT NULL
- user_id (Key3) — bigint — Foreign key → User.user_id — NOT NULL
- company_id (Key2) — bigint — Foreign key → Company.company_id — NOT NULL
- InterViewType_id (Key5) — bigint — Foreign key → InterViewType.InterViewType_id — NOT NULL
Occupation (직종)
- occupation_id (Key) — bigint — Primary key — NOT NULL
- occupation_name (Field) — varchar(255)
User (유저)
- user_id (Key) — bigint — Primary key — NOT NULL
- user_name (Field) — varchar(255)
- user_age (Field2)
- company_id (Key2) — Foreign key → Company.company_id — NOT NULL