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