AYA

Tables (4)

Application Table (Untitled4)

  • Columns (Key) — Primary key — NOT NULL
  • Colums (Key2) — Foreign key → Job Table.Colums — NOT NULL
  • Columns (Key22) — Foreign key → Job Table.Columns — NOT NULL
  • Columns (Key3) — Foreign key → User Table:.Columns — NOT NULL
  • application_id (Primary Key)
  • job_id (Foreign Key referencing Job Table)
  • candidate_id (Foreign Key referencing User Table)
  • status (pending, accepted, rejected)

Company Table (Untitled3)

  • Columns (Key) — Primary key — NOT NULL
  • company_id (Primary Key)
  • name (Field2)
  • industry (Field3)
  • size (Field4)

Job Table (Untitled2)

  • Colums (Key) — Primary key — NOT NULL
  • Columns (Key2) — Foreign key → Company Table.Columns — NOT NULL
  • job_id (Primary Key)
  • title (Field2)
  • description (Field3)
  • salary (Field4)
  • location (Field5)
  • company_id (Foreign Key referencing Company Table)
  • posted_by (Foreign Key referencing User Table)

User Table: (Untitled)

  • Columns (Key) — Primary key — NOT NULL
  • user_id (Primary Key)
  • username (Field2)
  • email (Field3)
  • password (Field4)
  • role (employer or candidate)