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