interview

Tables (11)

User (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • email (Field) — String
  • user_id (Field2) — String
  • password (Field3) — String
  • role (Field4) — String
  • birth (Field5) — date

answer (Untitled7)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • interview_id (Key3) — Long — Foreign key → interview.id — NOT NULL
  • answer (Field) — String
  • private (Field2) — boolean
  • like (Field3) — boolean

bookmark (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • interview_id (Key3) — Long — Foreign key → interview.id — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • is_bookmark (Field) — boolean

category (Untitled9)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String

company (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • link (Field2) — String

favorite (Untitled10)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String

group (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • name (Field) — String

group_interview (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • interview_id (Key2) — Long — Foreign key → interview.id — NOT NULL
  • group_id (Key3) — Long — Foreign key → group.id — NOT NULL

interview (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • company_id (Key2) — Long — Foreign key → company.id — NOT NULL
  • user_id (Key3) — Long — Foreign key → User.id — NOT NULL
  • question (Field) — String
  • question_at (Field4) — int

interview_category (Untitled8)

  • id (Key) — Long — Primary key — NOT NULL
  • interview_id (Key2) — Long — Foreign key → interview.id — NOT NULL
  • category_id (Key3) — Long — Foreign key → category.id — NOT NULL

user_favorite (Untitled11)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • favorite_id (Key3) — Long — Foreign key → favorite.id — NOT NULL